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.

About the Author

Sparx Systems

Sparx Systems

Sparx Systems specializes in high performance and scalable visual modeling tools for the planning, design and construction of software intensive systems. A Contributing Member of the Object Management Group (OMG), Sparx Systems is committed to realizing the potential of model-driven development based on open standards. The company’s flagship product, Enterprise Architect, has received numerous accolades since its commercial release in August, 2000. Enterprise Architect is the design tool of choice for over 300,000 registered users world-wide.