Defining Physical Databases › Separating Logical and Physical Database Definitions

Separating Logical and Physical Database Definitions

Under CA IDMS/DB, you create a logical database definition (a schema) that contains no reference to how the data is physically stored and accessed at runtime. The physical database definition contains that information.

Advantages

The advantages of separating the logical database definition from its physical implementation are the following:

• You do not have to modify your schemas because of changes made to the physical description of a database.
• One logical database definition can have multiple physical implementations.