Solutions
Data Warehouse
CDRlive provides a massively scalable, high-performance DW architecture that is unmatched anywhere in the world. The core DW makes use of LGR’s proprietary high-performance data model for the storage of data, and is specifically designed to facilitate simultaneous real-time loading and query. It is engineered using Oracle 10g/11g, including key Oracle components such as Real Application Clusters (RAC), Partitioning and Parallel Query.
Customers are provided with guarantees over DW performance, giving them confidence in a system that will never falter in terms of growth or performance. By way of example, the world’s largest production CDRlive system has the following characteristics:
| Indicator | Notes |
|---|---|
| Loading Speeds | Loads 46,500 rows per second average; 157,000 rows per second peak |
| DW Size | 2 x 310 TB physically separate sites; 1.2 PB total DW storage |
| DW Velocity | Cycles 270 TB every 90 days |
| DW Users | Up to 2,500 concurrent; 200+ Super Users (PL/SQL, SAS Data Mining) |
| Support Team | 2 DBAs, 3 Application Support (LGR provided) |
Enterprise Data Warehouse
An end-to-end CDRlive implementation rapidly becomes the most trusted and used data source across the enterprise. Customers often point to a few key points that are crucial in turning this IT investment into a bridge to business success:
- Census-level data: The business is guaranteed of a 100% complete and correct data set for every event on every network by every device used by every subscriber.
- Highly granular: The business is provided with deep dive views right down to network node level, subscriber level or even raw records etc.
- Highly accurate: The business has the assurance that data quality is guaranteed by CDRlive through automated, real-time monitoring and full audit trails.
The CDRlive data model allows for rapid expansion to a true EDW model with the incorporation of multiple feeds from other enterprise systems, including:
- Billing
- HLR and Provisioning
- Customer Data
- Device Data
- Enterprise Apps (e.g. ERP, CRM)
- Other OSS/BSS
The CDRlive system also integrates seamlessly with the Oracle Communications Data Model (OCDM) using pre-built, highly configurable schemas. This allows network operators to take advantage of CDRlive’s rapid time-to-value while leveraging pre-existing Oracle investments.