Near real-time call detail record ETL flows (industrial paper)

Munir Cochinwala, Euthimios Panagos

Research output: Chapter in Book/Report/Conference proceedingConference contribution

2 Scopus citations

Abstract

Telecommunication companies face significant business challenges as they strive to reduce subscriber churn and increase average revenue per user (ARPU) by offering new services and incorporating new functionality into existing services. The increased number of service offerings and available functionality result in an ever growing volume of call detail records (CDRs). For many services (e.g., pre-paid), CDRs need to be processed and analyzed in near real-time for several reasons, including charging, on-line subscriber access to their accounts, and analytics for predicting subscriber usage and preventing fraudulent activity. In this paper, we describe the challenges associated with near real-time extract, transform, and load (ETL) of CDR data warehouse flows for supporting both the operational and business intelligence needs of telecommunication services, and we present our approach to addressing these challenges.

Original languageEnglish (US)
Title of host publicationEnabling Real-Time Business Intelligence - Third International Workshop, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009, Revised Selected Papers
PublisherSpringer Verlag
Pages142-154
Number of pages13
ISBN (Print)3642145582, 9783642145582
DOIs
StatePublished - Jan 1 2010
Externally publishedYes
Event3rd International Workshop Enabling Real-Time Business Intelligence, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009 - Lyon, France
Duration: Aug 24 2009Aug 24 2009

Publication series

NameLecture Notes in Business Information Processing
Volume41 LNBI
ISSN (Print)1865-1348

Other

Other3rd International Workshop Enabling Real-Time Business Intelligence, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009
Country/TerritoryFrance
CityLyon
Period8/24/098/24/09

All Science Journal Classification (ASJC) codes

  • Management Information Systems
  • Control and Systems Engineering
  • Business and International Management
  • Information Systems
  • Modeling and Simulation
  • Information Systems and Management

Keywords

  • Real-time business intelligence
  • real-time ETL

Fingerprint

Dive into the research topics of 'Near real-time call detail record ETL flows (industrial paper)'. Together they form a unique fingerprint.

Cite this