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

2 Customizing the Oracle Communications Data Model

This chapter provides an overview of how you customize Oracle Communications Data Model and provides an example of modifying the logical model. It contains the following topics:

See also:

Business use cases in Oracle Communication Data Model Reference.

Overview: Customization Steps

Customizing Oracle Communications Data Model involves the following tasks:

  1. Perform fit-gap analysis as described in "Performing Fit-Gap Analysis".

  2. In a development environment, install an Oracle Communications Data Model instance.

  3. Working in the copy you created in Step 2 and following the documentation you created when performing your fit-gap analysis, customize Oracle Communications Data Model by making changes to its components. Document all of your changes. Make the changes in the following order:

    1. Logical model

    2. Logical to physical mappings

    3. Physical model. To determine which changes to make and the order in which to make these changes, determine dependences among objects by using the Metadata Browser.

    4. Intra-ETL. Keep in mind the issues discussed in Chapter 3, "Populating an Oracle Communications Data Model Warehouse".

  4. In a test environment, make a copy of your customized version of Oracle Communications Data Model.

  5. In the test environment, following the documentation you created in Step 3, test the customized version of Oracle Communications Data Model.

  6. Roll the final customized version of Oracle Communications Data Model out into production.

Performing Fit-Gap Analysis

Fit-gap analysis is where you compare your information needs and communication business requirements with the structure that is available "out of the box" with Oracle Communications Data Model. You identify any required functionality that is not included in the default schema, as well as other modifications that are necessary to meet your requirements.

The result of your fit-gap analysis is a customization report which is a brief explanation of the adaptations and adjustments required to customize Oracle Communications Data Model to fit your communication environment.

Note:

Fit-gap analysis is a major undertaking, and normally requires a team performing multiple evaluations.

To perform the actual analysis your evaluation team takes the following steps:

  1. If previous evaluations have been performed, review the documentation from the previous phases, and if necessary add team members with the needed business and technical expertise.

  2. Meet to review the data and map it into Oracle Communications Data Model's schema. In other words, perform a comprehensive analysis of all of the source data in your OLTP systems and then compare your business with the Oracle Communications Data Model logical model to see how it maps to the Oracle Communications Data Model base and derived layer.

  3. Produce a list of what people are going to try to do with the system (examples rather than models), and create use cases for appraising the functionality of Oracle Communications Data Model.

    Procedures are written based on the use cases. Keep in mind that deviations from the procedure can be useful, provided that functionality is not skipped.

  4. Map your business procedures against Oracle Communications Data Model functions, noting which processes are not available in Oracle Communications Data Model, or work differently in it. Be sure to check security requirements.

  5. Determine the differences between your needs and Oracle Communications Data Model's schema. Answer the following questions:

    • Which differences can you live with, and which must be reconciled?

    • What can you do about the differences you can't live with?

  6. Based on the preceding steps, update the business process models, activity flow diagrams, entity object model, and object life cycle models to reflect the customized system.

  7. Write the customization report, detailing what changes will be required to make Oracle Communications Data Model's schema match your business needs. This includes any interfaces to existing systems, and additions and changes to Oracle Communications Data Model.

  8. Based on the customization report, update the Project Plan, and complete a phase section for the Logical Design phase.

Discovering the Oracle Communications Data Model Metadata

To customize the Oracle Communications Data Model model, you need to understand the dependency between each Oracle Communications Data Model component -- especially how the report KPIs are mapped to the physical tables and columns.

Oracle Communications Data Model provided a tool called "Metadata Browser" that helps you discover this. The metadata browser is delivered as one Dashboard in Oracle Business Intelligence Suite Enterprise Edition.

There are four tabs in the Oracle Business Intelligence Suite Enterprise Edition report that is the Oracle Communications Data Model Metadata Browser:

Measure-Entity tab

As shown below, on the Measure-Entity tab you can see the business areas (relational, OLAP, mining), the measures description, corresponding formula, responsible entities, and attributes for the measure.

Description of mb1.gif follows
Description of the illustration mb1.gif

To browse the data, select the business area and measure description that you are interested in.

Entity-Measure tab

Using the Entity-Measure tab of the Metadata Browser, you can discover the mappings between entities, attributes, supported measures, and calculations of the measures. You can discover information about particular entities and attributes.

For example, you take the following steps to learn more about COST ORIGINAL MONTH AGGR:

  1. Select the entity COST ORIGINAL MONTH AGGR.

  2. Click GO.

    The following information is displayed.

    Description of mb2.gif follows
    Description of the illustration mb2.gif

Program-Table tab

Using the Program-Table tab you can browse for information on the intra-ETL mappings and report information. Take the following steps:

  1. Select prompt program type (that is, Intra-ETL or report) and program name for sowing particular report or intra_ETL information.

  2. Select GO.

For example, if you select a program type of Report for program named 2-Months of service, the following information is displayed.

Description of mb3.gif follows
Description of the illustration mb3.gif

For example, if you select a Program type of Intra-ETL Mapping for DWD_ACCT_DEBT_DAY__MAP, the following information is displayed.

Description of mb4.gif follows
Description of the illustration mb4.gif

Table-Program tab

Table-Program:By default when you go to the Table-Program tab you see all tables used for all the reports.To discover what reports use a particular table, you must move a particular table from the right pane to the left (Selected) pane.

For example, to see the reports that use the DWA_CALL_CENTR_CALL_MO table, take the following steps:

  1. In the right pane of the Table-Program tab, select DWA_CALL_CENTR_CALL_MO.

  2. Move it to the Selected list on the left by clicking on <, and click OK.

    The following information is displayed.

    Description of mb5.gif follows
    Description of the illustration mb5.gif

  3. Select GO and the reports for DWA_CALL_CENTR_CALLMO table are displayed.

    Description of mb6.gif follows
    Description of the illustration mb6.gif

Example: Modifying the Logical Model Based on Fit-Gap Analysis

Application stores are the latest battleground for mobile phone companies seeking to differentiate their products in an increasingly crowded and competitive marketplace. Users will be able to find the applications by searching using keywords or by browsing through categories and top downloads - so they can see what everyone else is downloading - in addition to the front page, which will showcase a selection of featured applications. The 'App World' can be accessed directly through the handset, enabling users to download applications and software on the go. Some applications will be free, others will cost a small fee.

Now, as an example, let's take a look how Oracle Communications Data Model supports the application store business, what a sample customer might discover during fit-gap analysis, and how that customer might extend Oracle Communications Data Model to fit the discovered gaps.

See also:

Business use cases in Oracle Communication Data Model Reference for other examples.

The supplied entities that support application stores

The entities provided with the logical model of Oracle Communications Data Model that support the Application stores are:

The differences discovered during fit-gap analysis

Assume that during the fit-gap analysis, you discover the following needs that are not supported by the logical model delivered with Oracle Communications Data Model:

Extending the logical model to support the differences

To support the differences, you need to extend the logical model in the following ways:

Steps: Extending the Logical Model to Support Multiple Levels for CONTENT

Take the following steps in Oracle SQL Developer Data Modeler to extend the logical model to support multiple levels for CONTENT:

  1. Open the Oracle Communications Data Model in SQL Developer Data Modeler.

  2. Create the CONTENT SUBTYPE entity by taking the following steps:

    1. In the right-hand pane (the main area) of the SQL Developer Data Modeler window, select the Logical tab.

    2. Click the New Entity icon.

    3. Click in the logical model pane and draw an entity box.

      The Entity Properties window is displayed.

    4. In the left-hand pane of Entity Properties, select General. For Name, specify, CONTENT SUBTYPE. (Note the value of Entity_xxx where xxx is the number for Long Name and Single Table for FWD Engineer Strategy.)

    5. In the left-hand pane, select Attributes. Using the Add (+) icon, add the following attributes, one at a time.:

      CONTENT SUBTYPE CODE with a data type of CODE.

      CONTENT SUBTYPE NAME with a data type of NAME.

      CONTENT SUBTYPE DESC with a data type of DESCRIPTION.

    6. In the left-hand pane, select Unique Identifiers. Using the Add (+) icon, add a unique, primary key to CONTENT SUBTYPE.

    7. Select key_1 (which represents the unique, primary key), and use Properties icon to add the properties to the key.

    8. In the left-hand pane of Key Properties, select General. For key properties, specify CST_PK for Name and Primary Key for State. (Note that the Long Name is CONTENT SUBTYPE.CST_PK.

    9. Select Attributes and Relations, and then select the column for the primary key (that is, CONTENT SUBTYPE CODE).

    10. Click Apply. The entity CONTENT SUBTYPE is created.

  3. Add a CONTENT SUBTYPE CODE column to the CONTENT entity by taking the following steps:

    1. Select the CONTENT entity.

    2. Right click and select Properties.

    3. In the left-hand pane, click Attributes.

    4. Use the Add (+) icon to add an attribute with the Name of CONTENT SUBTYPE CODE and a Data type of CODE.

  4. Add a relationship between CONTENT and CONTENT SUBTYPE by taking the following steps:

    1. Select the New 1: N Relation icon.

    2. Select the CONTENT SUBTYPE entity.

    3. Drag the CONTENT SUBTYPE entity over to the CONTENT entity and drop the cursor.

Steps: Modifying the Logical Model

Take the following steps in Oracle SQL Developer Data Modeler to extend the logical model to support maintaining a history of Customers who purchased which application:

  1. Open Oracle Communications Data Model in SQL Developer Data Modeler.

  2. Create an APPLICATION SUBSCRIPTION entity by taking the following steps:

    1. In the right-hand pane (main area) of the SQL Developer Data Modeler window, select the Logical tab.

    2. Click the New Entity icon.

    3. Click in the logical model pane in the main area; and in the Logical pane press, diagonally drag, and release the mouse button to draw an entity box.

      The Entity Properties window is displayed.

    4. In the left-hand pane of Entity Properties, select General. Specify APPLICATION SUBSCRIPTION for Name, and SUBSCRIPTION for Super Type. (Note that the value of FWD Engineer Strategy is Single Table.)

    5. In the left-hand pane, select Attributes. Using the Add (+) icon, add the following

      Attribute APPLICATION SUBSCRIPTION CODE and datatype is CODE. As APPLICATION SUBSCRIPTION entity is of SUBSCRIPTION, attributes are inherited from SUBSCRIPTION entity.

    6. In the left-hand pane, select Unique Identifiers. Use the Add (+) icon to add the Primary Key

    7. Select Attributes and Relations, and then select the column for the unique, primary key.

    8. Click Apply. The APPLICATION SUBSCRIPTION entity will be created.

  3. Add APPLICATION SUBSCRIPTION CODE to CONTENT by taking the following steps:

    1. Select the CONTENT entity. Right click and select Properties.

    2. In the left-hand pane, select Attributes. Use the Add (+) icon to add attributes, one at a time.

  4. Add a relationship to CONTENT with APPLICATION SUBSCRIPTION by taking the following steps:

    1. Select the New 1: N Relation icon.

    2. Select the APPLICATION SUBSCRIPTION entity.

    3. Drag the APPLICATION SUBSCRIPTION entity over to the CONTENT entity and drop the cursor.