This tutorial teaches you how to transform a logical
data model into a physical data model, using different transformation options
for denormalization.
This workbench functionality satisfies the following enterprise
data modeling requirements:
- Transforming an abstract entity model to a concrete database model
- Enforcing data type consistency and naming standards by using a reusable
domain model
- Consolidating the subtasks of modeling in a team environment
- Merging and managing incremental changes
Learning objectives
When
you complete the exercises, you will know how to do the following tasks:
- Import a sample data design project that contains a domain model and a
logical data model
- Associate the domain model with the data design project to use it as the
standard for the project
- Transform the logical data model to a physical data model
- Modify logical data model properties by using a diagram and the Properties
view
- Transform the logical data model to a new physical data model and observe
how your changes affect the physical model
- Modify a physical data model to add an index and generate a DDL script
to capture your changes
This tutorial should take approximately 60 minutes to finish.
If you explore other concepts related to this tutorial, it could take longer
to complete.
Skill level
Advanced
Audience
Data modelers
System requirements
This tutorial can
be completed in the workbench environment and does not require any additional
system requirements.
Prerequisites
In order to complete this tutorial,
you should be familiar with the following concepts:
- Database design
- Logical data modeling
- Physical data modeling