Journal's Facebook pageUDC 004.622, DOI: 10.2298/csis0902087C
A Call Detail Records Data Mart: Data Modelling and OLAP Analysis
- Faculty of Entrepreneurial Management
Modene 5, 21000 Novi Sad, Serbia
gagona@EUnet.rs - Faculty of Organizational Sciences, University of Belgrade
Jove Ilica 154, 11000 Belgrade, Serbia
becejski-vujaklija.dragana@fon.rs - Faculty of Transport and Traffic Engineering, University of Belgrade
Vojvode Stepe 305, 11000 Belgrade, Serbia
n.gospic@sf.bg.ac.yu
Abstract
In order to succeed in the market, telecommunications companies are not competing solely on price. They have to expand their services based on their knowledge of customers’ needs gained through the use of call detail records (CDR) and customer demographics. All the data should be stored together in the CDR data mart. The paper covers the topic of its design and development in detail and especially focuses on the conceptual/logical/physical trilogy. Some other design problems are also discussed. An important area is the problem involving time. This is why the implication of time in data warehousing is carefully considered. The CDR data mart provides the platform for Online Analytical Processing (OLAP) analysis. As it is presented in this paper, an OLAP system can help the telecommunications company to get better insight into its customers’ behaviour and improve its marketing campaigns and pricing strategies.
Key words
Data Warehousing, Data Modelling, Call Detail Records, OLAP
Digital Object Identifier (DOI)
https://doi.org/10.2298/csis0902087C
Publication information
Volume 6, Issue 2 (December 2009)
Year of Publication: 2009
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium
Full text
Available in PDF
Portable Document Format
How to cite
Camilovic, D., Becejski-Vujaklija, D., Gospic, N.: A Call Detail Records Data Mart: Data Modelling and OLAP Analysis. Computer Science and Information Systems, Vol. 6, No. 2, 87-110. (2009), https://doi.org/10.2298/csis0902087C
