UDC 004.622, DOI: 10.2298/csis0902087C

A Call Detail Records Data Mart: Data Modelling and OLAP Analysis

Dragana Camilovic1, Dragana Becejski-Vujaklija2 and Natasa Gospic3

  1. Faculty of Entrepreneurial Management
    Modene 5, 21000 Novi Sad, Serbia
    gagona@EUnet.rs
  2. Faculty of Organizational Sciences, University of Belgrade
    Jove Ilica 154, 11000 Belgrade, Serbia
    becejski-vujaklija.dragana@fon.rs
  3. 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: 1820-0214 (Print) 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable 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)