< Previous | Next >
WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Lesson 1.2: Creating a physical data model

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:

  1. In the Data Project Explorer, right-click the Tutorial folder and select New > Physical Data Model.

    The New Physical Data Model wizard opens.

  2. In the File name field, delete the default value of Database Model and type First Model.
  3. In the Database field, select Classic Integration.
  4. In the Version field, select V9.
  5. 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
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.



Feedback

Update icon Last updated: 2007-07-11


< Previous | Next >