Displaying items by tag: forward engineering,

Monday, 22 August 2011 00:00

Data Modeling - From Conceptual Model to DBMS

Enterprise Architect supports comprehensive functionality for modeling database structures. This paper covers the core features for data modeling over the full lifecycle of an application.

The initial development of a system typically involves numerous levels of abstraction.  Database modeling traditionally includes a well established three tiered approach:

  1. Conceptual Model
  2. Logical Model
  3. Physical Model

This paper covers creating these models, interconnecting models on these levels, using MDA transforms for generating the Physical model from the Logical model, along with generating schema scripts for loading to your DBMS. It also covers the features for remodeling legacy systems including Reverse Engineering an existing DBMS structure.

Published in White Papers