Telecom datawarehouse prototype for bandwidth and network throughput monitoring and analysis

Summary form only given. Telecommunication companies have developed very large, heterogeneous and complex technical infrastructures to support the variety of services they offer like landline calls, mobile calls, ADSL, and WiMax. Efficient monitoring and maintenance of operational stability of these infrastructures are critical for delivering high quality services to the end users. The management of the data generated by the various components is key for understanding the systems behaviors, for detailed analysis of observed deficiencies, for preventing failures and for keeping high operational performances. To help addressing these challenges, we will use dimensional modeling to build the Telecom datawarehouse prototype. Our main emphasis will be on monitoring bandwidth and network availability. We will also work on the spatial representation of the factual data so that the end users or analysts can intuitively and efficiently navigate, drill down or drill across the maps displaying the infrastructure systems. The datawarehouse we propose encompasses two key performance indicators of the telecom infrastructure, namely the bandwidth and the network availability. The analysis will be projected on dimensions like types of services, region and time. We also identify the necessary data sources, the integration stages, the data marts and the spatial analytical processing. To validate our prototype, we have built a data test generator to produce data for our use cases experiments. The artificial data is constructed according to specific business and functional constraints and can be delivered in various formats like text, tabular or XML. Talend has been chosen as the ETL tool for implementing and running the integration processes. The basic queries we have defined to run against the datawarehouse concern the spatial monitoring analysis for the bandwidth and the network throughput key performance indicators. Results can be displayed per region or town, and service. The Arc- iew ESRI tool is used as the front end application for the users and the analysts to generate and visualize intuitive interactive maps and generate reports.