Turkcell Technology Research & Development Inc. Achieves Substantial Savings with Fault Prevention
 
 

Turkcell Technology Research & Development Inc. Achieves Substantial Savings with Fault Prevention

Turkcell Technology Research & Development Inc., with 17 years of development experience, offers solutions that have been proven by leading telecommunications network operators in 14 countries. The company helps network operators with a variety of efforts, from network resource operation, to business-oriented intelligence

 
 

 
 

Challenges

A word from Turkcell Technology Research & Development Inc.

  • “We combined Oracle Data Integrator and Oracle Database with Real Application Clusters to achieve a level of query performance and integration of databases and applications from various vendors that is truly unique in the industry.” – Gürcan Orhan, Software Architect and Senior Developer, Network & Enterprise Management Systems, Turkcell Technology Research & Development Inc.

  • Reduce network operation costs by preventing network faults, such as telecommunications equipment or node failures
  • Forecast network problems to avoid outages and improve customer satisfaction
  • Achieve fast detection of alarm locations, as alarms can originate from more than 200,000 network locations, be related to equipment from various vendors, and produce 50 different alarm types
  • Implement network optimization by analyzing alarm trends

Solutions

  • Leveraged Oracle Data Integrator to implement a location-determining algorithm to find the correct location, based on a column in a table of 200,000 records of unstructured alarm records pertaining to 135,000 network nodes in 30 different source systems, converting unstructured data into valuable information, and achieving in-depth analysis of alarm trends to optimize network operation
  • Implemented a methodology to load many files into Oracle Data Integrator via an external table algorithm, achieving faster file uploads to the database with parallel execution and decreasing operational maintenance costs in the process
  • Prevented network faults by forecasting potential network problems, achieved substantial savings in network operation costs, and improved customer satisfaction
  • Leveraged the new features of Oracle Database, Enterprise Edition 11g  Release 2, including composite and virtual partitioning, partitioned indexing, table compression, and index compression to reduce storage requirements and increase query information
  • Obtained high system availability and further increased query performance with Oracle Real Application Clusters 11g, running two data integrator agents in load-balancing mode
  • Customized Oracle Data Integrator to decrease data extraction time, extracting tables through a database link without any limitations