A physical data model is a collection of schemas that contain the
tables that you create to map to the data in your data sources. Schemas can
also contain views on tables and stored procedures that you might want to
use to perform operations on the result sets for queries.
To create a physical data model:
- In the Data Project Explorer, right-click the Tutorial folder
and select New > Physical Data Model.
The New Physical Data Model wizard opens.
- In the File name field, delete the default
value of Database Model and type First Model.
- In the Database field, select Classic
Integration.
- In the Version field, select V9.
- Click Finish.
The new physical data model appears in the
Data Models folder
of the
Tutorial project.
Figure 1. The First Model
physical data model in the Tutorial project
Notice that several objects appear in the Data Project Explorer:
- New objects in the Data Models folder
- First Model.dbm
- This object represents the model.
- New Database
- A physical data model is like a database because it is a collection of
tables, views, and stored procedures.
- SQL Statements folder
- This folder contains the SQL statements that you create with the SQL builder
or SQL editor. Later in the tutorial, you will create a SELECT statement and
then base a view on this statement.
- Schema
- This object is analogous to a schema or owner in a relational database.
It is a name under which a group of objects are collected. You can rename
the schema. For example, you can rename the schema to the ID of the user who
creates the tables that are grouped under the schema. This tutorial uses the
default name.
- Diagrams folder
- You can ignore this folder. Diagrams are a feature that is part of Eclipse,
the development environment on which Classic Data Architect is based.
- Diagram1
- You can ignore this object.
- New folders in the Tutorial project
- These folders contain the data definitions that you base your tables on.
- COBOL Copybooks
- For CA-Datacom, CICS® VSAM, IMS™, VSAM, and sequential data sources. This
folder contains COBOL copybooks.
- CA-IDMS References
- For CA-IDMS databases. This folder contains schema and subschema files.
- IMS References
- For IMS databases.
This folder contains database definition (DBD) files.
In this tutorial, you will import a copybook into the COBOL
Copybooks folder. Notice that these folders are not a part of
the physical data model. They are located at a higher level than the models.
You can use the files that you import into these folders for any physical
data model that you create within any data design project in a single workspace.