The focus of the Implemented Database Models (Logical) presentation is the description of the process of defining a database that is independent of DBMS (e.g., Oracle or DB-2). Hence is is commonly called "Logical." The strategy here is bi-directional. That is, the Implemented Database Model can be manufactured by importing an entire or partial data model from the Operational Database Model, or by importing standardized data structures from one or more Specified Data Model data structures. The topics of this presentation include:
- Creation of database schemas
- Creation of database schema tables
- Creating one or more schema table columns
- Assignment of semantic and data use modifiers to schema table columns
- Automatic generation of standardized names and definitions
- Standardizing schema table column definitions
- Importing standardized data structures or data structure subsets from one or more Specified Data Models
- Importing SQL DDL to create an Implemented Database Model
- Exporting an Implemented Database Model into SQL DDL
- Promotion of an Implemented Database Model or subset to be a Specified Data Model
- Promotion of a schema table column to be a business data element
- Re-engineering Implemented Database Model components from an as-is to a to-be design
There are a number of demonstrations supporting this presentation.
|