학술논문

Integrated data warehousing for telecommunication industries
Document Type
Conference
Source
2009 12th International Conference on Computers and Information Technology Computers and Information Technology, 2009. ICCIT '09. 12th International Conference on. :657-662 Dec, 2009
Subject
Communication, Networking and Broadcast Technologies
Computing and Processing
General Topics for Engineers
Bioengineering
Warehousing
Communication industry
Data mining
Data warehouses
Telecommunications
Data engineering
Reliability engineering
Information analysis
Data analysis
Companies
Data Warehousing
Dimensional modeling
CDR
ETL
OLAP
Language
Abstract
Data warehousing provides an excellent opportunity in transforming operational data into useful and reliable information to support the decision making process in any organization. Data Warehouse (DW) generalizes and consolidates multidimensional (MD) data. Hence, DW has become an important platform for Online Analytical Processing (OLAP) which is based on a MD data model. In this paper, we propose an integrated data warehouse system for the telecommunication companies in Bangladesh .Our integrated DW provides a common framework based on temporal data from different telecommunication operators rendering their services. We develop a dimensional model architecture, data extraction methodology, transformation and loading techniques which provides analytical options with the implementation of relational OLAP.