E Upgrading Oracle Communications Data Model

Preparing to Upgrade Oracle Communications Data Model

Oracle has product roadmap and lifecycle management. Also, the Oracle Communications Data Model product and engineering team oversees the specific industry trends, progress, and best practices in order to bring these features into Oracle Communications Data Model.

With the next release of Oracle Communications Data Model, identify the components in Oracle Communications Data Model that must be upgraded and analyze the impact that the upgrade will have on your existing data warehouse architecture and applications. The Oracle Communications Data Model upgrade focuses on Oracle Communications Data Model itself -- it does not include considerations of upgrading a hardware platform or related software.

When you acquire an Oracle Communications Data Model upgrade package, take the following steps to upgrade:

1. Understand upgrade purpose and process, analysis impact on your existing data warehouse system then decide whether to accept it, if accept then proceed to next steps.

2. Check the related environment requirements, such as software version requirement.

3. Backup current schemas.

4. If you previously customized Oracle Communications Data Model, prepare the archived original Oracle Communications Data Model schema; otherwise, skip this step.

5. Follow the specific upgrade path guide "Upgrade Paths for Oracle Communications Data Model".

6. List the additional upgrade tasks after Oracle upgrade scripts.

7. Make those addition changes after Oracle upgrade scripts as patch scripts.

Upgrade Paths for Oracle Communications Data Model

There ares two different path to upgrade Oracle Communications Data Model , it depends on whether Oracle Communications Data Model has been customized.

Upgrade Path A: Based on an Earlier Default Oracle Communications Data Model

Take the following steps to upgrade Oracle Communications Data Model based on an earlier default Oracle Communications Data Model:

1. Confirm to meet the requirements of upgrade scripts.

2. Execute the upgrade scripts.

3. Migrate data if necessary.

4. Additions, if necessary, to modify the:

   • Derived , aggregate layer

   • Source-ETL and intra-ETL mapping

   • Workflow

   • Business intelligence applications

   • Metadata Repository

Upgrade Path B: Based on a Customized Oracle Communications Data Model

Take the following steps to upgrade your Oracle Communications Data Model based on a customized Oracle Communications Data Model:

1. Confirm to meet the requirement of upgrade scripts.

2. Restore the original Oracle Communications Data Model before upgrade.

3. Execute the Oracle upgrade scripts based on original Oracle Communications Data Model.

4. Review your customization patch and upgrade it if necessary.

5. Execute the (new) customization patch.

6. Migrate the data.

7. Additions, if necessary, to modify the:

   • Derived , aggregate layer

   • Source-ETL and intra-ETL mapping

   • Workflow

   • Business intelligence applications

   • Metadata Repository

Regression Testing for Oracle Communications Data Model

After you upgrade Oracle Communications Data Model, perform regression testing. The major tasks to perform are:

• Create a test plan.

• Execute a test case.

• Test error handling.

• Create a final report.