This chapter describes how to transform the conceptual data model into an implementation representation of the database. Data structure design is the design of a relational database using CA Gen. The data structure is the physical version of the data model. This version does not violate the intent of the data model but does allow customization for performance and specifically targeted databases.
The following illustration shows the overall approach to creating a 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(s) (single location or distributed). Some further conversion procedures or external action blocks to interface to database management systems not supported by CA Gen's toolsets may be needed. Early planning for these transition and associated implementation issues makes the entire process much easier.
|
Copyright © 2013 CA.
All rights reserved.
|
|