Turkcell İletişim Hizmetleri Uses Engineered System to Analyze 10 Billion Daily, Call-Data Records and Service Logs and to Generate 100,000 Monthly Reports
 
 

Turkcell İletişim Hizmetleri Uses Engineered System to Analyze 10 Billion Daily, Call-Data Records and Service Logs and to Generate 100,000 Monthly Reports

Printer View Printer View

Turkcell İletişim Hizmetleri A.Ş. (Turkcell) is a leading provider of mobile communications in Turkey, with more than 34 million subscribers. Established in 1994, Turkcell created the first global system for a mobile communications network in Turkey, and it was the first Turkish company to be listed on the New York Stock Exchange.

Turkcell needed to process up to 10 billion daily, call-data records (CDRs) and value-added service logs for billing and to ensure continuously accelerated development of 4,000 distinct reports containing critical business data. The company combined two Oracle Exadata Database Machine X2-2 HP Full Racks to reduce the size of the company’s data warehouse from 600 TB compressed to 60 TB and enable more than 500 data warehouse users to generate more than 100,000 reports per month—twice as many reports as with the deployment on its previous, single Exadata machine. Turkcell also shortened project execution times substantially and future-proofed its storage capabilities, thanks to Oracle Exadata Database Machine’s effortless scalability.

Working with Oracle Consulting, Turkcell implemented 16 nodes on two Oracle Exadata Database Machine X2-2 HP Full Racks in just five days, without any interface changes.

 
 

 
 

Challenges

A word from Turkcell İletişim Hizmetleri A.Ş.

  • “Oracle Exadata was not a choice for us, but a necessity. How do you process 10 billion daily, call-data records and logs of value-added services to extract valuable information? With Oracle Exadata Database Machine, queries are so fast that we can continuously increase the number of data warehouse users to extract more value-added service information from vast volumes of data.” – Ferhat Şengönül, Data Warehouse Specialist, Turkcell İletişim Hizmetleri A.Ş.

  • Manage one petabyte of uncompressed telecommunication data, including CDRs and value-added service logs, in an enterprise data warehouse that includes more than 500 Oracle databases, online transaction processing, and a data warehouse
  • Ensure continuous, accelerated development of 4,000 distinct reports containing critical business data, such as regulatory and management financial reports, with 100,000 monthly report runs requested by hundreds of data warehouse users
  • Support analysis of up to 10 billion daily, call-data records and logs of value-added services, records that are needed to bill for services—such as subscriptions for weather and sport services, and more
  • Ensure scalability and business continuity in the telecommunication sector where data volumes double annually

Solutions

Oracle Product and Services

  • Combined two Oracle Exadata Database Machine X2-2 HP Full Racks (16 nodes) to simplify system architecture and reduce the size of the company’s data warehouse from 600 TB compressed to 60 TB
  • Enabled Turkcell, with Oracle Exadata’s unmatched data warehouse performance, to double the number to more than 500 data warehouse users who extract new information from the wealth of data collected by the company to offer the best telecommunication products and services to its customer base and to generate more than 100,000 reports per month—twice as many reports as with the deployment on its previous single Exadata machine
  • Enabled Turkcell to thoroughly analyze up to 10 billion daily, call-data records and value-added service logs—such as for subscriptions to news services, stock market updates, and more—to offer the appropriate products and services ahead of the competition
  • Improved and shortened the design of reporting projects substantially—such as for management’s revenue reporting or data mining for churn analysis— as Oracle Exadata makes it possible to access raw data without summarized tables, processes queries faster than any other machine, and consequently optimizes and shortens the design phase for each project
  • Future-proofed the company’s storage capabilities, thanks to the effortless scalability of Oracle Exadata Database Machine, enabling the company to scale linearly by simply adding racks
  • Worked with Oracle Consulting to implement 16 nodes on two Oracle Exadata Database Machines X2-2 HP Full Rack in just five days, without any interface changes
  • Moved 40 terabytes of data from an Oracle Exadata Database Machine V2 to SATA storage to keep infrequently used data available at a low cost

Why Oracle

“We did not ask any other vendor for a proof of concept because it would require them to work on a migration project that would last one or two years, and it is difficult to see the end for such a project. With Oracle Exadata, we migrated without any design change or development change, simply plugging in the new technology,” said Ferhat Şengönül, data warehouse specialist, Turkcell İletişim Hizmetleri A.Ş.

Implementation Process

“With assistance from Oracle Consulting, we implemented 16 nodes of two Oracle Exadata Database Machines X2-2 HP Full Rack in just five days, without any interface changes,” Şengönül said. “Oracle Consulting was also very fast in resolving issues that we faced during the post-implementation phase. With the excellent support from Oracle Consulting, all issues were resolved quickly.”

Resources