Skip Headers
Oracle® Communications Data Model Operations Guide
11g Release 1 (11.2)

Part Number E15883-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

1 Introduction to Oracle Communications Data Model

This chapter introduces the Oracle Communications Data Model, which is a start-up kit for implementing a Oracle Communications Data Model data warehouse solution:

What is Oracle Communications Data Model?

You use Oracle Communications Data Model to jump-start the design and implementation of a Oracle Communications Data Model data warehouse to quickly achieve a positive ROI for your data warehousing and business intelligence project with a predictable implementation effort.

The Oracle Communications Data Model consists of logical and physical data models, intra-ETL that map data from the Oracle Communications Data Model 3NF level to the aggregate level, sample reports, and the Oracle Interactive Dashboard using features of Oracle Business Intelligence Suite Enterprise Edition.

As illustrated in Figure 1-1, Oracle Communications Data Model includes the following components:

Figure 1-1 Oracle Communications Data Model

Description of Figure 1-1 follows
Description of "Figure 1-1 Oracle Communications Data Model"

Oracle Communications Data Model Logical and Physical Models

The logical and physical models of Oracle Communications Data Model have the following characteristics:

Logical Model

Oracle Communications Data Model provides a predefined logical model. The logical data model defines the business entities and their relationships in order provide a clear understanding of the business and data requirements for the data warehouse.

The logical data model is described in detail in Oracle Communication Data Model Reference.

Physical Model

Oracle Communications Data Model provides a predefined physical data model.

The physical data model includes the following types of tables and views:

The physical data model is described in detail in Oracle Communication Data Model Reference.

Notes:

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

DWR_ : Reference data tables

DWL_ : Lookup tables

DWB_ : Base transaction data (3NF) tables

DWD_ : Derived (data mining) tables

DWA_ : Aggregate tables

DWC_: Control tables

CB$: Cube materialized views

_VIEW : View

Oracle Products That Make Up Oracle Communications Data Model

Several Oracle technologies are involved in building the infrastructure for communication business intelligence:

Oracle Database with OLAP, Data Mining and Partitioning Option

Oracle Communications Data Model utilizes a complete Oracle technical stack. It leverages the following data warehousing features of the Oracle database: SQL model, compression, partitioning, advanced statistical functions, materialized views, data mining, and online analytical processing (OLAP).

Tip:

To save some money, you can consider using RAC and commodity hardware.

Oracle Development Tools

The following Oracle tools can be used to customize the predefined logical and physical models provided with Oracle Communications Data Model, or to populate the target relational tables and materialized cube views.

Table 1-1 Oracle Development Tools Used with Oracle Communications Data Model

Name Use

Oracle SQL Data Modeler

To modify, customize, and extend the logical model

SQL Developer or SQL*Plus

To modify, customize, and extend database objects

Oracle Warehouse Builder

For the process control of the intra ETL process

Analytic Workspace Manager

To view, create, develop, and manage OLAP dimensional objects.


Oracle BI EE Presentation Tools

Oracle Business Intelligence Suite Enterprise Edition is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. You can use Oracle BI EE Answers and Dashboard presentation tools to customize the predefined sample dashboard reports that are provided with Oracle Communications Data Model.

Where Oracle Communications Data Model Fits in a Data Warehousing Project

Oracle Communications Data Model provides much of the data modeling work that you must do for a communication business intelligence solution. The Base Layer provides a solid foundation for a communication data warehouse. The Derived and Aggregate Layers provide the infrastructure for creating business intelligence reports.

Each communication operator is unique, and therefore the structure of the data warehouse will need to be different in order to match the needs of that unique communication environments. Oracle Communications Data Model comes with a generic schema that requires modification. These modifications include, adding, deleting, modifying, or renaming tables and columns; or altering foreign keys, constraints, or indexes.

After the data warehouse is populated, you populate the derived and aggregate layers to support the reporting requirements. Oracle Communications Data Model includes a solid infrastructure for a range of reports.

Prerequisite Knowledge for Customizers

As discussed in "Oracle Products That Make Up Oracle Communications Data Model", Oracle Communications Data Model uses much of the Oracle stack. Consequently, to successfully customize Oracle Communications Data Model, you need: