1 Data Model – Getting Started

OBCL Data Model

This document describes the reverse engineering methodology to get the OBCL Data Model for a given business purpose. A given business purpose could vary from report generation to data extraction to extending OBCL application functionality. This topic has the following sub-topics:

1.1 Why Reverse Engineering

This topic describes the reverse engineering importance.

As the complete ER diagram of OBCL application would be huge, the business application developers need to re-engineer with required filtered portion of OBCL to get specific portion of data model. Example: There is a business requirement to add additional fields to customer personal information.

The business developer could filter the Customer specific entities from OBCL Database schema and generate the ER diagram. This ER diagram further can be used to understand the OBCL and can be foundation for further business development requirement.

Parent topic: Data Model – Getting Started

1.2 OBCL Data model schema

This topic describes the steps to get the Oracle OBCL Data model schema.

  • Identify the new Oracle Database schema for data model purpose.
  • Create the OBCL database tables by running all the DDL scripts in below folder at the schema identified.
    • OBCL_14.4.0.1.0\MAIN\DATABASE\HOST\CONSOL\DDL\TABLE
    • OBCL_14.4.0.1.0\MAIN\DATABASE\BRANCH\CONSOL\DDL\TABLE
  • Create Foreign Keys in schema using following scripts at the schema identified.
    • OBCL_14.4.0.1.0\MAIN\DATABASE\DATAMODEL\HOST\CONSOL\FKR
  • Create column comments using below scripts at the schema identified.
    • OBCL_14.4.0.1.0\MAIN\DATABASE\DATAMODEL\HOST\CONSOL\CMT

    Note:

    The Database environment used for this data model cannot be used for other testing/production purpose.

Parent topic: Data Model – Getting Started

1.3 Oracle SQL Developer Data Modeler

This topic describes the Oracle SQL Developer Data Modeler.

Ensure you have installed the Oracle SQL Developer Data model in your local system. Refer further Oracle documentation for download and install instructions, http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Parent topic: Data Model – Getting Started

1.4 Creating Data Model and ER diagram

This document describes the steps to create data model and ER diagram

  1. Open the Oracle SQL Developer Data modeler.
    Description of image_1.png follows
    Description of the illustration image_1.png
    Description of image_2.png follows
    Description of the illustration image_2.png
  2. Click on File → Import → Data dictionary.
    Description of image_3.png follows
    Description of the illustration image_3.png
  3. Click Add.
    Description of image_4.png follows
    Description of the illustration image_4.png
  4. Provide the database connectivity.
    Description of image_5.png follows
    Description of the illustration image_5.png
  5. Click Test Connection and ensure it is successful. If connection fails, verify and repeat step4.
    Description of image_6.png follows
    Description of the illustration image_6.png
  6. Click database connection row.
    Description of image_7.png follows
    Description of the illustration image_7.png
  7. Select the database schema name.
    Description of image_8.png follows
    Description of the illustration image_8.png
  8. Select the entities( tables ) that are to be used in ER diagram.
    Description of image_9.png follows
    Description of the illustration image_9.png
    Description of image_10.png follows
    Description of the illustration image_10.png
  9. Click Next.
    Description of image_11.png follows
    Description of the illustration image_11.png
  10. Click Finish.
    Description of image_12.png follows
    Description of the illustration image_12.png
    Description of image_13.png follows
    Description of the illustration image_13.png
    Description of image_14.png follows
    Description of the illustration image_14.png
  11. The ER diagram can be saved as .dmd file if required.
    Description of image_15.png follows
    Description of the illustration image_15.png
    Description of image_16.png follows
    Description of the illustration image_16.png
    dmd file

Parent topic: Data Model – Getting Started