Introduction
Background and related works
Big Data and Hadoop
Big Data in telecommunication
Root cause analysis (RCA) in telecommunication
Methods
System architecture
Parameter | Value |
---|---|
Computer1 Processor | Intel Core i7 (4 Processors) |
Computer1 Memory | 16 GB (8 GB used for the VM) |
Computer1 storage | 1 Terabytes HDD |
Computer1 IP | 198.168.68.1 |
VM processor | Hosted on VMware in Computer1 (4 processors) |
VM memory | 8 GB |
VM storage | 64 GB HDD |
VM IP | 198.168.68.128 |
Field name | Description | Example |
---|---|---|
Service | The types of services | Browsing |
Subscriber | The subscriber ID (based on the IMSI) | ******13992 |
Handset | The device type (based on the TAC) | 35195507 |
Cell | The cell-ID | ******467 |
Events | The number of events for every aggregation | 3 |
sec_dl | The active second on the downlink | 148 |
retransbytes_dl | The bytes retransmission on the downlink | 655594 |
bytes_dl | The bytes transmitted on the downlink | 2451800 |
dns_successful | The number of success full DNS transaction | 80 |
dns_failure | The number of failed full DNS transaction | 0 |
latency_dl | The latency on the downlink | 518 |
Quadri-dimensional approach
SQM-tree construction
Results and discussion
Cloudera vs MySQL performance comparison
Test | MySQL execution time (s) | Cloudera impala execution time (s) |
---|---|---|
Query1 | 2.2 | 0.7 |
Query2 | 6.1 | 2.3 |