Technical Design and Performance Analysis of Centralized Product Catalog Management in Large Scale Telecommunication Systems: Turkcell CPCM Case


Goksu E. S., Muslu O., Bulca S., Icen G., Zumbul B., Gonulal S., ...Daha Fazla

9th International Artificial Intelligence and Data Processing Symposium, IDAP 2025, Malatya, Türkiye, 6 - 07 Eylül 2025, (Tam Metin Bildiri) identifier

  • Yayın Türü: Bildiri / Tam Metin Bildiri
  • Doi Numarası: 10.1109/idap68205.2025.11222358
  • Basıldığı Şehir: Malatya
  • Basıldığı Ülke: Türkiye
  • Anahtar Kelimeler: Centralized Product Catalog Management, Modular Software Architecture, Oracle Telecommunication Database Management, Performance Optimization
  • Marmara Üniversitesi Adresli: Evet

Özet

This paper comprehensively analyzes the technical design, architecture and performance dynamics of Turkcell's Central Product Catalog Management System (CPCM) and its React-based front-end RAF. CPCM has an important position in Turkcell's CRM ecosystem by providing integrated management of customer offers, prices, campaigns and product information in a central catalog. The study investigates the system's Java8 based backend architecture (EJB 3.1, JAX-WS, Hibernate), cache mechanisms powered by Oracle Coherence, Weblogic application server infrastructure and the user-centric design of the React-based RAF front-end. The performance analysis was performed over 1.46 million web service calls per day (CatalogServiceLite) and a 230 GB Oracle 19c database, evaluating the system's capacity to support high volumes of transactions. The findings demonstrate that effective cache management and modular architecture significantly improve system performance, but they also point out the necessity of optimization for complex entity searches and expensive logging procedures (100 GB log tables). Additionally, RAF's dynamic interface, which is supported by UseState/UseEffect plugins and React Router, enhances the user experience while pointing up possible areas for improvement in REST integrations and page load times. In addition to offering an industry reference model, this cutting-edge analysis offers crucial technical insights on how product catalog architecture should be organized in largescale telecom systems, particularly with regard to cache methods, version control, and data consistency.