1 Introducing Oracle Communications Data Model

What is Oracle Communications Data Model?

Oracle Communications Data Model is a standards-based, pre-built approach to communications data warehousing enabling a communications company to realize the power of insight more quickly. Oracle Communications Data Model reduces costs for both immediate and on-going operations by leveraging out-of-box Oracle based Data Warehouse and Business Intelligence solutions, making world-class database and business intelligence technology solutions available with a communications specific data model.

Oracle Communications Data Model offers a single-vendor solution package that is tightly integrated with the business intelligence platform. With pre-built data mining, Oracle Online Analytical Processing (Oracle OLAP) and dimensional models, Oracle Communications Data Model provides you with industry-specific metrics and insights that you can act on immediately to improve your bottom line. These business intelligence solution offerings take advantage of Oracle's scalability and reliability, using Oracle's familiar optimization, parallelism, and performance engineering within the database.

Oracle Communications Data Model can be used in any application environment and is easily extendable.

Oracle Communications Data Model includes an exhaustive set of embedded advanced analytics, using Oracle's OLAP and data mining technology. You can take advantage of pre-built and pre-tested solution sets designed by industry experts that deliver relevant insights, are actionable, and aimed at improving both top-line and bottom-line results. You can see summarized, aggregated information or quickly navigate to drill-down transaction details to better understand business issues.

For example, with Oracle Communications Data Model's out-of-the-box sample reports, you can generate reports for network analysis and churn analysis. Network analysis provides air-time, subscription, roaming, load@busy hour, under utilization and patterns reports. With churn analysis you can gain improved insight into churning that provides switching and termination trends, payment and recharging patterns, subscribers life cycle and profiling. You can add your own reports as well. Oracle Communications Data Model, combined with Oracle technology, provides all of the components required for a complete and extendable Communications Data Warehouse and Business Intelligence framework to eliminate complex and costly integration requirements, all designed to reduce your total cost of ownership.

New Features in Oracle Communications Data Model

Oracle Communications Data Model provides the following new features:

• Oracle Communications Data Model is conformance certified with TM Forum's Information Framework (SID) version 8.1. For more information, see "TM Forum Information Framework (SID) Conformance".

What Are the Benefits of Using Oracle Communications Data Model?

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

Oracle Communications Data Model provides the following features:

• Query and Reporting for information: provides extraction of detailed and summary data.

• OLAP for data analysis: provides summaries, trends, and forecasts.

• Data Mining for insight and prediction: provides knowledge discovery of hidden patterns and insights.

• Oracle Communications Data Model is conformance certified with TM Forum's Information Framework (SID) version 8.1. For more information, see "TM Forum Information Framework (SID) Conformance".

Oracle Communications Data Model provides an off-the-shelf data warehouse framework that is both adaptable and extendable. Alignment with communications industry standards ensures interoperability with other systems. The pre-built, pretuned data model with intelligent insight into detailed communications and market data, allows you to quickly gain value from your data warehousing effort, supports diverse analytical requirements, and assists in building future analytical applications. Fast, easy and predictable implementation reduces risks and enables you to achieve strategic value more rapidly by eliminating deployment delays and expenses associated with built-from-scratch or proprietary data warehouse solutions.

What Are the Components of Oracle Communications Data Model?

Oracle Communications Data Model includes the following components:

• Logical Model Foundation

  Chapter 2, "Logical Data Model Foundation" describes the logical data model.

• Logical Model Dimensions

  Chapter 3, "Logical Data Model Dimensions" describes the dimensions.

• Physical Model

  Chapter 4, "Oracle Communications Data Model Physical Data Model" describes the physical data model. The logical to physical mapping is detailed in Chapter 5, "Oracle Communications Data Model Logical to Physical Mapping".

• Intra-ETL database packages and SQL scripts to extract, transform, and load (ETL) data from one layer of Oracle Communications Data Model to another.

  The intra-ETL packages and SQL scripts are described in detail in Chapter 7, "Oracle Communications Data Model Intra-ETL".

• OLAP Models for Oracle Communications Data Model

  Chapter 8, "Oracle Communications Data Model OLAP Model Dimensions" and Chapter 9, "Oracle Communications Data Model OLAP Model Cubes" describe the OLAP Models.

• Pre-defined Data Mining Models

  These models are described in detail in Chapter 10, "Oracle Communications Data Model Data Mining Models".

• Utility Scripts

  The utility scripts are described in Chapter 11, "Oracle Communications Data Model Utility Scripts".

• Sample reports and sample dashboards

  Chapter 12, "Oracle Communications Data Model Sample Reports" shows sample reports.

• Installation scripts

  For more information on installation, refer to the Oracle Communications Data Model Installation Guide.

Oracle Products That Make Up Oracle Communications Data Model

Several Oracle technologies are involved in building the infrastructure for telecommunications 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).

Oracle Development Tools

Use the Oracle tools shown in Table 1-1 to customize the predefined logical and physical models provided with Oracle Communications Data Model, or to populate the target relational tables, materialized views, or OLAP cubes.

Oracle Business Intelligence Suite Enterprise Edition Presentation Tools

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

TM Forum Information Framework (SID) Conformance

Oracle Communications Data Model is conformance certified with TM Forum's Information Framework (SID) version 8.1. The TM Forum is the world's leading industry association focused on enabling best-in-class IT for service providers in the communications, media, and cloud service markets. The TM Forum provides business-critical industry standards and expertise to enable the creation, delivery, and monetization of digital services. For more information on TM Forum, see

http://www.tmforum.org/

The TM Forum's Information Framework (SID) provides a common reference model for enterprise information in the communications industry. The SID model does the following:

• Attempts to cover all information required in a Service Provider's operations.

• Provides an information reference model and a common vocabulary.

• Consists of business entities and their associated attribute definitions. Business entities describe items of interest to the business. For example, customer order, product offering, service specification, and so on. The attributes are facts that describe a business entity.

The Oracle Communications Data Model conformance certification with TM Forum's Information Framework (SID) version 8.1 does the following:

• Provides an independent review and audit of the self-assessment conducted by Oracle of Oracle Communications Data Model conformance to TM Forum's Information Framework (SID).

• Specifies that a TMF representative has conducted a detailed review of the assessment documents and determined a conformance level: SID provides seven levels of conformance.

  The assessment documents provide a detailed attribute by attribute mapping between Oracle Communications Data Model and SID. The assessment documents are available to Oracle Communications Data Model customers by request. These documents facilitate ETL script development between Oracle Communications Data Model and other SID conformant applications.

For more information on conformance certification with TM Forum's Information Framework (SID) and for detailed certification results, see

http://www.tmforum.org/BestPracticesStandards/CertifiedConformant/7629/Home.html#sid

Oracle Communications Data Model achieved level 7 conformance for all Aggregate Business Entities (ABE)s that were certified in Customer, Product, Market_Sales, Service, Resource, and Common Business Entities domains. For more detailed information on the ABEs certified, refer to the TM Forum Web site.