Algar Telecom Gains 50% in Compression and 85% Faster Access to Data Warehouse Data with New Storage Solution
 
 

Algar Telecom Gains 50% in Compression and 85% Faster Access to Data Warehouse Data with New Storage Solution

  • Oracle Customer:  Algar Telecom
    Location:  Minas Gerais, Brazil
    Industry:  Communications
    Employees:  1,581
    Annual Revenue:  $1 to $5 Billion

Printer View Printer View

Algar Telecom is a Brazilian telecommunications company that has been present in the market for 56 years and has been listed on the stock exchange since 2007. The company belongs to Grupo Algar (Algar Group) and offers landline phone, cell phone, broadband internet [3G and asymmetric digital subscriber line (ADSL)], data communication, television, and code 12 services for domestic and international long distance calls.

Algar divides its wide range of products and services into two segments: retail under the CTBC brand, and companies under the Algar Telecom brand. Algar has more than 1.6 million customers—including approximately 700,000 landline phone, 500,000 cell phone, and 235,000 broadband customers—and operates in major Brazilian states including Minas Gerais, São Paulo, the Federal District, Rio de Janeiro, Mato Grosso do Sul, Goiás, and Paraná.

Algar’s data warehouse revitalization project focused on upgrading a system that was more than 10 years old. To do so, Algar adopted Oracle’s Exadata Database Machine X2-2, along with software and support. The new solution accelerated access to historical and management data, which helped the company offer quick and complete information to its internal business team.

 
 

 
 

Challenges

A word from Algar Telecom

  • “By adding Oracle’s Exadata Database Machine X2-2 storage solution, we updated our data warehouse environment with the most appropriate solution available on the market. With Exadata, we were able to reduce access and processing time by 85% for the management and historical data used by our internal business team, enabling us to serve then with faster and more reliable information.” – Eduardo Rabboni, Chief Information Officer, Algar Telecom

  • Restructure the operator and provider’s database infrastructure to ensure competitiveness and a high standard of service for its 1.6 million landline, cell phone, and internet customers
  • Achieve quicker processing in order to deliver management information extracted from the data warehouse environment to the sales and retail departments
  • Speed up access to the telephone company’s historical data in order to quickly respond to requests from the business support area

Solutions

Oracle Product and Services

  • Worked with Oracle Consulting and the Oracle Advanced Customer Support Services team to develop Exadata Database Machine X2-2 HC Quarter Rack in less than two months and achieved up to 85% faster processing in the data warehouse environment
  • Reduced from 12 hours to 3.5 hours the execution time of the 2,000 daily loads that provide strategic data to support the performance and decisions of the sales and retail team, such as client loss, default, and product performance data
  • Compacted by 50%, 8 terabytes with more than 1.000 tables that company already had, freeing up space to expand historical data in the data warehouse for the next five years instead of just two years online, as it had been limited to previously
  • Sped up the recovery of historical information from 10 days to as little as five hours to meet requests of the business support area, which generally cover more than two years
  • Simplified the data warehouse environment’s management and freed the IT team to focus on other duties, since Oracle provides the entire solution—the server, database, operating system, and support
  • Reduced backup time—including download of data to disc and transfer to tape—from 26 hours to 6 hours, thanks to Oracle Recovery Manager, ensuring data integrity and reducing the system’s unavailability window
  • Began to extract reports, such as those regarding billing and new business generation, in just 18 seconds using the business intelligence tool, instead of two hours, as it had previously taken

Implementation Process

“We were surprised because the implementation, though complex, was faster and easier than expected. In addition, the IT team quickly adapted to the new system. The migration process involved eight people—a full-time Oracle consultant, another consultant for specific issues, and six Algar professionals,” said Eduardo Rabboni, chief information officer, Algar Telecom.

Resources

Algar Telecom obtém mais eficiência e performance com EBS R12