Implemented Database Models (Logical)


1 hour

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.

For Sales and Corporate: 1-301-249-1142

Whitemarsh Information Systems Corporation

2008 Althea Lane Bowie, Maryland 20716 USA

Copyright 1981 - 2016, Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved