In this exercise, you will create logical data models from
schemas in a physical data model. Logical data models are not specific
to a database and describe the data used with Optim™ data management services and processes.
An Optim logical data model
is a logical data model that includes a data access plan, which contains
policies that determine the data to copy or transform from a source
logical data model used in an Optim data
management service or process.
To transform schemas in a physical data model to an Optim logical data model:
- In the Data Project Explorer, expand the Data
Models folder, and expand the Optim Sample physical data model to to display
the OPTIMUSER and OPTIMUSER2 schemas.
- Right-click the OPTIMUSER schema, and click Transform
to Optim Logical Data Model. The Transform
to Optim Logical Data Model
wizard opens.
- On the Select Transformation Options page, select Create
new model and use the default value for the Optim
Data Source, Optim Sample
Database. Click Next.
- On the Enter Model Name and Project Folder page, type OPTIMUSER in Name.
Click Next.
- On the Transformation Results page, review the results
of the transformation, and click Finish. The new logical data model, OPTIMUSER.ldm, will appear
under the Data Models folder.
- From the Optim Sample
physical data model, right-click the OPTIMUSER2 schema, and click Transform
to Optim Logical Data Model. The Transform
to Optim Logical Data Model
wizard opens.
- On the Select Transformation Options page, select Create
new model. Click Next.
- On the Enter Model Name and Project Folder page, type OPTIMUSER2 in Name.
Click Next.
- On the Transformation Results page, review the results
of the transformation, and click Finish. The new logical data
model, OPTIMUSER2.ldm, will appear under the Data Models folder.
You have created two new Optim logical
data models, OPTIMUSER and OPTIMUSER2.