In this exercise, you will create a physical data model
for the Optim™ sample database.
Physical data models are database-specific models that represent 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.
Use physical data models to create Optim 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:
- On the Data Project Explorer view, right-click the Data
Models folder and click . The New Physical Data Model wizard opens.
- In the Model File page, do the following:
- In File Name, type Optim
Sample.
- From the Database list, select
the DBMS that contains the Optim sample
database.
- From the Version list, select
the version of the DBMS.
- Select Create from reverse engineering.
- Click Next.
- On the Source page, select Database.
- On the Select Connection page, from the Connections area,
select the connection for the Optim sample
database. Click Next.
- On the Select Objects page, from the Select
objects area, select the schema name for the Optim sample database. Click Finish.
The new physical data model, Optim Sample.dbm,
will appear under the Data Models folder.
