Previous Topic: Designing the Data StructureNext Topic: Prerequisites


Create a Relational Database Definition

The following illustration shows the overall approach to creating a relational database definition.

Create Relational Database Definition

Each database defined using CA Gen contains its own Data Structure List and Data Store List. These two lists represent the physical database definition that forms the basis for the generation of the Data Definition Language (DDL). DDL generation yields the Structured Query Language (SQL) statements required to define a database to a relational database management system (DBMS).

Also consider the means of converting data to the new database (single location or distributed). Some further conversion procedures or external action blocks to interface to database management systems not supported by CA Gen Toolsets may be needed. Early planning for these transition and associated implementation issues makes the entire process much easier.