A call detail records data mart: Data modeling and OLAP analysis

Camilovic, Dragana; Becejski-Vujaklija, Dragana; Gospic, Natasa

doi:10.2298/csis0902087c

Cited by 8 publications

(3 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…To survive in the telecommunication market, the telecom companies are not only competing depending on the price but they are also expanding their services based on the customer's needs through the use of CDR. This work presents that an Online Analytical Processing (OLAP) system will be useful for telecommunication companies to get better insight of its customer's behavior and therefore can improve its marketing campaigns and pricing strategies [12]. A method to prevent VoIP attacks through the analysis of call logs has been delivered.…”

Section: International Journal Of Computer Applications (0975 -8887) mentioning

confidence: 99%

Data Analysis and Summarization to Detect Illegal VOIP Traffic with Call Detail Records

Anwar¹,

Shabbir²,

Ali³

2014

IJCA

View full text Add to dashboard Cite

Voice over Internet Protocol (VoIP) is an advanced area for researchers. Many different methods are used to send voice over IP networks. With the development of modern telecommunications equipments and softwares telecommunication's malpractices are growing rapidly. Hence there is always a need for monitoring communications and guarantee both security and proper usage. This underlined research work stresses on the analysis of IP traffic and proposes an algorithm for detection mechanisms to control and limit VoIP's grey traffic. The algorithm emphasizes primarily on Session Initiation Protocol (SIP) but it can be modified and used for all VoIP protocols like H.323 and InterAsterisk eXchange protocol (IAX2). The suggested method is based on analyzing the pcap files. These files are used to filter VoIP traffic from network's total IP traffic by reading the header of each packet. The algorithm then extracts different parameters for generating call logs. VoIP packets of the same call are correlated to produce a Call Detail Record (CDR).The produced CDR contains the IP addresses of source and destination that make the calls. For identification of grey traffic these IP addresses are used. If the source IP address in the CDR is of a legal registered operator the user/call is declared as legal, otherwise the user/call is illegal.

show abstract

Section: International Journal Of Computer Applications (0975 -8887) mentioning

confidence: 99%

Data Analysis and Summarization to Detect Illegal VOIP Traffic with Call Detail Records

Anwar¹,

Shabbir²,

Ali³

2014

IJCA

View full text Add to dashboard Cite

show abstract

“…Therefore, OLAP is a natural extension of the data warehouse. The results from OLAP analysis can be presented visually, which enables improved comprehension [3]. The data mart is a part of data storage, but usually contains summarized data [4].…”

Section: Introductionmentioning

confidence: 99%

A direct approach to physical Data Vault design

Krneta

Jovanovic

Marjanovic³

2014

COMSIS J

View full text Add to dashboard Cite

The paper presents a novel agile approach to large scale design of enterprise data warehouses based on a Data Vault model. An original, simple and direct algorithm is defined for the incremental design of physical Data Vault type enterprise data warehouses, using source data meta-model and rules, and used in developing a prototype case tool for Data Vault design. This approach solves primary requirements for a system of record, that is, preservation of all source information, and fully addresses flexibility and scalability expectations. Our approach benefits from Data Vault dependencies minimizations and rapid loads opportunities enabling greatly simplified ETL transformations in a way not possible with traditional (i.e. non data vault based) data warehouse designs. The approach is illustrated using a realistic example from the healthcare domain.

show abstract

“…Call event star schema from[18] The CDR data mart STAR schema from[15] The CDR combined with CRM STAR schema from[16] …”

mentioning

confidence: 99%

Integrating Telecom CDR and Customer Data from Different Operational databases and Data warehouses into a Central Data Warehouse for Business Analysis

Mandal¹,

Maji²

2016

IJERT

View full text Add to dashboard Cite

Mining operational telecom data has given many interesting insights about customer behavior, mobility, social interaction etc and has great business value. But to have truly unbiased analysis over a defined geographic region, we need to first consolidate all telecom data from many different operators present within the region and then analyze them. This necessitates an integration architecture that will allows to integrate, consolidate and store different type of operational telecom data such as call detail record (CDR), customer relationship management (CRM) data, network data etc into a central data warehouse (DW). Though almost all operator stores semantically same type of data but in a little different form and format. Again these operators are separate business entities so integrating data from their operational databases and data marts needs to be independent of each other and flexible in fetching data for extract, transform and loading processes. In this paper we shall review a few existing DW schemas used to consolidate CDR and CRM data and propose a generic model DW schema with indentified facts and dimensions for the central DW. Next we propose integration architecture to collect data and consolidate in the central DW from many different operational databases of different telecom operators. Web services (WS) has been proposed as a mode of communication between central DW and other operational databases.

show abstract

A call detail records data mart: Data modeling and OLAP analysis

Cited by 8 publications

References 1 publication

Data Analysis and Summarization to Detect Illegal VOIP Traffic with Call Detail Records

Data Analysis and Summarization to Detect Illegal VOIP Traffic with Call Detail Records

A direct approach to physical Data Vault design

Integrating Telecom CDR and Customer Data from Different Operational databases and Data warehouses into a Central Data Warehouse for Business Analysis

Contact Info

Product

Resources

About