TY - GEN
T1 - Near real-time call detail record ETL flows (industrial paper)
AU - Cochinwala, Munir
AU - Panagos, Euthimios
PY - 2010
Y1 - 2010
N2 - 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.
AB - 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.
KW - Real-time business intelligence
KW - real-time ETL
UR - http://www.scopus.com/inward/record.url?scp=77955593114&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=77955593114&partnerID=8YFLogxK
U2 - 10.1007/978-3-642-14559-9_9
DO - 10.1007/978-3-642-14559-9_9
M3 - Conference contribution
AN - SCOPUS:77955593114
SN - 3642145582
SN - 9783642145582
T3 - Lecture Notes in Business Information Processing
SP - 142
EP - 154
BT - Enabling Real-Time Business Intelligence - Third International Workshop, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009, Revised Selected Papers
PB - Springer Verlag
T2 - 3rd International Workshop Enabling Real-Time Business Intelligence, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009
Y2 - 24 August 2009 through 24 August 2009
ER -