Previous | Page 4 of 4 | Next

The OCDM Platform

What Does OCDM Deliver?

Predefined, Communications-Specific Models

OCDM is a pre-built, pre-tested solution designed by industry experts to help telecom organizations maximize the value of their Oracle DW.

For example, a partial view of the Subject Billing area Entity Relationship Diagram (ERD) is shown below.

Using sophisticated trending and data mining capabilities based on Oracle's OLAP and data mining technology. Organizations in the Cable Services, Internet & Data Services, Broadband , and 3G/GSM/CDMA Wireless segments now have the data analysis capabilities to develop insights that are relevant, actionable, and can improve both top-line and bottom-line results.

With OCDM, you can jump-start the design and implementation of a communications data warehouse to quickly achieve a positive ROI for your data warehousing and business intelligence project with a predictable implementation effort.

Naming Convention for Tables

When examining the predefined tables, keep in mind the naming convention using DW (Data Warehouse) prefixes to identify the types of tables:

• DWR_ : Reference data tables
• DWL_ : Lookup tables
• DWB_ : Base transaction data (3NF) tables
• DWD_ : Derived (data mining) tables
• DWA_ : Aggregate (ROLAP and MOLAP) tables

Previous | Page 4 of 4 | Next