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:
- In the Data Source Explorer view, right-click the Data
Models folder and click . The New Physical Data Model wizard opens.
- On the Model File page, do the following:
- In File Name, type Optim
Sample.
- From the Database list, select Derby.
- From the Version list, select 10.1.
- Select Create from reverse engineering.
- Click Next.
- In the Select Connection page, from the Connections area,
select Optim Sample Database. Click Next.
- 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.
