Physical data models

A physical data model is a database-specific model that represents relational data objects (for example, tables, columns, primary and foreign keys) and their relationships. A physical data model can be used to generate DDL statements which can then be deployed to a database server.
Using the workbench, you can create a physical data model in several ways:
A typical task flow for physical data modeling is:
  1. Create a physical data model using one of the methods that were listed previously in this document.
  2. Add storage objects, indexes, and views as needed.
  3. Generate a DDL script for the physical data model.
  4. Run the DDL script to create the corresponding data objects on a server.