Skip Headers
Oracle® Communications Data Model Adapters and Analytics Installation Guide
Release 11.3.2

E37744-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

H License Information

Product Subproduct Licensing Description
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 includes the following:

  • Communications industry specific data model conformance certified with TM Forum's Information Framework (SID).

  • Physical implementation of the data model consisting of a foundation layer in third-normal-form schema, as well as dimensional models leveraging star schemas and OLAP cubes.

  • Automatic data movement (intra-ETL) to populate the dimensional models based on data from the foundation layer.

  • Pre-defined data mining models for churn prediction, churn factors, customer segmentation, customer sentiment, and others.

  • Pre-built sample reports and dashboards.

Prerequisites: Oracle Communications Data Model requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Oracle Communications Data Model - Application Adapters Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model The Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (NCC Adapter) extracts data from an Oracle Communications Prepaid Charging application and loads and transforms that data into an Oracle Communications Data Model environment.

The NCC Adapter supports two options for data loading:

  • Standard - where data is loaded to Oracle Communications Data Model in customer defined intervals.

  • Real-Time - where data is loaded to Oracle Communications Data Model staging in near-real-time intervals as transactions occur in NCC.

Prerequisites: NCC Adapter requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Oracle Communications Data Model - Application Adapters Oracle Communications Billing and Revenue Management Adapter for Oracle Communications Data Model The Oracle Communications Billing and Revenue Management Adapter for Oracle Communications Data Model (BRM Adapter) extracts data from an Oracle Communications Billing and Revenue Management application and loads and transforms that data into an Oracle Communications Data Model environment.

The BRM Adapter supports two options for data loading:

  • Standard - where data is loaded to Oracle Communications Data Model in customer defined intervals.

  • Real-Time - where data is loaded to Oracle Communications Data Model staging in near-real-time intervals as transactions occur in BRM.

Prerequisites: BRM Adapter requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Oracle Communications Data Model - Application Adapters Oracle Communications Policy Management Adapter for Oracle Communications Data Model The Oracle Communications Policy Management Adapter for Oracle Communications Data Model (Policy Management Adapter) interfaces with an Oracle Communications Policy Management application using the Policy Event Records Distribution option to accept policy event records (PER) as well as policy reference data (PRD) and loads the data into an Oracle Communications Data Model environment. The Policy Management Adapter is developed using Java.

Prerequisites: Policy Management Adapter requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Restricted Use: The included Java Runtime Environment (JRE) is restricted to use solely to run the Oracle Communications Policy Management Adapter for Oracle Communications Data Model as provided by Oracle.

Oracle Communications Data Model - Analytic Applications Oracle Communications Billing Analytics Oracle Communications Billing Analytics is a separately licensed add-on option to Oracle Communications Data Model. Billing Analytics provides a set of reports and dashboards built using Oracle Business Intelligence Enterprise Edition. The reports and dashboards cover the following categories:
  • Billed Revenue - Revenue related metrics such as total revenue, ARPU, adjustments, collections, and so on.; viewable across various parameters

  • Billing Efficiency - Based on TM Forum's business metrics, these reports are centered on a billing operations efficiency such as payments by payment method, % e-bills issued, % of bills adjusted, and so on.

  • Customer Metrics - Customer acquisition and churn metrics viewable across various parameters

  • Prepaid Metrics - Prepaid specific metrics such as total, average recharges, disturbed recharge cycles, and so on.; across various parameters

  • Usage Metrics - Usage specific metrics such as total minutes of usage, number of calls, top users (voice, data, SMS), across various parameters

Prerequisites: Billing Analytics requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Oracle Communications Data Model - Analytic Applications Oracle Communications Social Network Analytics Social Network Analytics uses call detail records (CDRs) to identify the communities that exist based on the social interactions between users (for example. calls, texts, mms). Oracle Advanced Analytics (Data Mining) determines the following:
  • Social relationship communities

  • Subscriber roles

  • Influence scores

  • Churn pressure

  • Community and subscriber value

  • Value at risk

Results are stored in output tables, and displayed using Oracle Business Intelligence reports and dashboards. Customers can leverage this valuable information and use it for viral marketing campaigns as well as customer retention initiatives.

Prerequisites: Social Network Analytics requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Oracle Communications Data Model - Analytic Applications Oracle Communications Policy and Charging Analytics Policy and Charging Analytics leverages policy event records (PER) and policy reference data (PRD), and optionally charging data that has been loaded into the appropriate Oracle Communications Data Model tables. It performs aggregation and calculation of various metrics using this data. Results are displayed in Oracle Business Intelligence reports and dashboards. The dashboards fall under the following categories:
  • Policy Execution

  • Quota Usage

  • Customer Metrics

The information can be leveraged by operations teams in order to improve policy operations, as well as by marketing to aid in developing new offers.

Prerequisites: Policy and Charging Analytics requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.