< Previous | Next >

Creating a physical data model based on reverse engineering

In this exercise, you will create a physical data model. Physical data models are database-specific models that represents relational data objects (for example, tables, columns, primary keys, and foreign keys) and their relationships. A physical data model based on reverse engineering is created using the metadata in a source database.

You use physical data models to create logical data models, which describe the data used with Optim™ data management services and processes.

To create a physical data model based on reverse engineering:

  1. In the Data Source Explorer view, right-click the Data Models folder and click New > Physical Data Model. The New Physical Data Model wizard opens.
  2. On the Model File page, do the following:
    1. In File Name, type Optim Sample.
    2. From the Database list, select Derby.
    3. From the Version list, select 10.1.
    4. Select Create from reverse engineering.
    5. Click Next.
    New Physical Data Model wizard
  3. In the Select Connection page, from the Connections area, select Optim Sample Database. Click Next.
  4. In the Select Objects page, from the Select objects area, select OPTIMUSER and OPTIMUSER2. Click Finish.

The new physical data model, Optim Sample.dbm, will appear under the Data Models folder. The model will include the OPTIMUSER and OPTIMUSER2 schemas from the Optim Sample database.

Optim Samle physical model

< Previous | Next >