newerLogo3

Promote Implemented Database Model

Some or all of an Implemented can also be “promoted” to be a Specified Data Model. This would be appropriate if there is a Reverse Engineering strategy that starts with operational databases, imports them into the Operational Database Model Metabase System module, then inductively promotes collections of subject-similar DBMS Tables into Implemented Database Models that, in turn can be mined to ultimately build Specified Data Models and Data Element Models.

This road to an Enterprise Data Architecture is efficient, effective and able to be accomplished iteratively over time. The promotion scenarios are:

  • Promote the Implemented Data Model
  • Promote an Implemented Data Model Table
  • Promote an Implemented Data Model Table Column
  • Promote an Implemented Data Model Table Column to Data Element

The process to accomplish Implemented Database Model promotion include the following scenarios:

  • Start the Implemented Database Model Metabase System Module
  • Select the DBMS
  • Enter User Name and Password
  • Select the Menu Item, ReEngineering, then the subordinate menu item, Promote Implemented Data Model to Specified Data Model
    • Select a source Schema (this auto creates a same named subject)
    • Press, Promote Implemented Database Model.
  • Or, Select the Menu Item, ReEngineering, then the subordinate menu item, Promote Implemented Data Model Table to Specified Data Model
    • Select a source Schema
    • Select the target Subject (it must already exist)
    • Select the root Table upon which to build a tree
    • Press the Promote Implemented Database Model Table
  • Or, Select the Menu Item, ReEngineering, then the subordinate menu item, Promote Implemented Database Model Table Column(s) to Specified Data Model Entity
    • Select a source Schema
    • Select a source Table
    • Select and tag one or more Columns
    • Select a target Subject (it must already exist)
    • Select an Entity that will host the promoted Columns
    • Press, Promote Implemented Database Model Columns
  • Or, Select the Menu Item, ReEngineering, then the subordinate menu item, Promote Column to Data Element
    • Select source Schema
    • Select a source table
    • Select an appropriate column
    • Select Data Element Concept Structure Type
    • Select the appropriate Data Element Concept
    • Press the Promote button to create a new Data Element

For Sales and Corporate: 1-301-249-1142 Whitemarsh@Wiscorp.com

Whitemarsh Information Systems Corporation

2008 Althea Lane Bowie, Maryland 20716 USA

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