Türk Telekom Significantly Improves Performance with Turkey’s First Asynchronous, Real-Time Archiving Solution
 
 

Türk Telekom Significantly Improves Performance with Turkey’s First Asynchronous, Real-Time Archiving Solution

Türk Telekom, a leading communication and convergence technology company in Turkey and the country’s most valuable brand for the last four years according to Brand Finance, provides fixed line communications and broadband internet services. The company, which was founded in 1994 by separating from Posta ve Telgraf Teşkilatı, the national post and telegraph directorate of Turkey, owns more than 14.5 million fixed access lines—nearly all fixed access lines in Turkey—and 7 million asymmetric, digital subscriber lines.

Türk Telekom required faster development of telecommunications operation, sales, and marketing reports to be derived from approximately 20 terabytes of data collected from mission-critical applications, like billing and customer relationship management (CRM) systems. The company also needed to ensure replication in a hybrid environment with source systems and target systems from different manufacturers in two geographical locations. To meet these goals, Türk Telekom established the first and only asynchronous, real-time archiving solution in Turkey with Oracle GoldenGate to facilitate real-time data warehousing with hybrid online replication from 16 different source systems to one target data warehouse with near-zero latency. Thanks to the new solution, the company was able to eliminate 30 hours of database downtime, reduce costs, and save approximately US$22 million.

 
 

 
 

Challenges

A word from Türk Telekom

  • “By using Oracle GoldenGate 11g, we have drastically improved performance and access to real-time data and eliminated many downtime hours. With almost zero-downtime migrations reaching the desired high availability ratios and flexible online replication, we reduced operational costs and saved approximately US$22 million.” – Serkan Karatas, Database Division Manager, Türk Telekom

  • Enable faster reporting on approximately 20 terabytes of data collected from mission-critical applications, such as billing and CRM systems, to support management decision-making
  • Reduce source system overhead, development and maintenance costs, and transaction time with an alternate approach to the company’s extract-transform-load process—to move data from online transaction processing (OLTP) systems to online analytical processing systems
  • Facilitate replication in a hybrid environment with source and target systems from different manufacturers located 450 kilometers apart

Solutions

  • Established the first asynchronous, real-time archiving solution in Turkey with Oracle GoldenGate, which moves 250 gigabytes of daily modified data in real-time from a huge OLTP database to an archive database, achieving an important increase of OLTP query performance to enable fast operational, sales, and marketing reports
  • Facilitated real-time data warehousing with hybrid online replication from 16 different source systems to one target data warehouse with Oracle GoldenGate, achieving online replication with near-zero latency and enabling the company to handle data operations in shrinking batch windows
  • Supported key applications—such as business analytics, campaign management, and churn prevention—and facilitated live reporting from a dozen source systems located in Ankara to four target reporting platforms located in Istanbul without requiring any source systems modifications
  • Reduced overhead costs on central processing units (CPUs) and source systems, as Oracle GoldenGate captures data from transaction logs (not the database itself) and does not interfere with source data
  • Used Oracle GoldenGate for bidirectional (active-active) migrations and upgrades of three database platforms, with almost no-downtime eliminating 30 hours of previous downtime and saving approximately US$22 million
  • Minimized risks by backing up all data from the new site to the old site with Oracle GoldenGate’s reverse direction replication to achieve zero downtime rollback if the new system should fail
  • Archived historical data to save valuable disk space, decrease storage and backup costs, and lower management and maintenance costs of the production OLTP database
  • Ensured the right data is sent to target systems in all archiving, migration, and replication projects by comparing the source data with the replicated target data quickly and easily with Oracle GoldenGate Veridata

Why Oracle

“When we decided to find a replication tool, we evaluated some competing products. When we saw the results delivered by Oracle GoldenGate, our choice was clear,” said Serkan Karatas, database division manager, Türk Telekom. “Oracle GoldenGate offers more advanced replication features, lower maintenance costs, and more flexible configuration options than its competitors. In addition, Oracle GoldenGate produces much less overhead for source systems.”

Partner

Türk Telekom acquired GoldenGate licenses from Asseco SEE, which was GoldenGate’s distributor in Turkey. The implementation was performed by Türk Telekom’s internal teams while Asseco SEE provided consultancy services to resolve operational issues that needed specialized experience.