Prev Next

Working with Data Model Types

Enterprise Architect provides a number of features to assist in the process of creating models of information, including the ability to develop conceptual, logical and physical models and to be able to trace the underlying concepts between the models. The physical models can be developed for a wide range of database systems, and forward and reverse engineering allows these models to be synchronized with live databases.

Data Models

Type

Description

See also

Conceptual Data Models

Conceptual data models, also called Domain models, establish the basic concepts and semantics of a given domain and help to communicate these to a wide audience of stakeholders.

Conceptual models also serve as a common vocabulary during the analysis stages of a project; they can be created in Enterprise Architect using Entity-Relationship or UML Class models.

Conceptual Data Model Entity Relationship Diagrams (ERDs)

Logical Data Models

Logical data models add further detail to conceptual model elements and refine the structure of the domain; they can be defined using Entity-Relationship or UML Class models.

One benefit of a Logical data model is that it provides a foundation on which to base the Physical model and subsequent database implementation.

Entity-relationship modeling is an abstract and conceptual database modeling method, used to produce a schema or semantic data model of, for example, a relational database and its requirements, visualized in Entity-Relationship Diagrams (ERDs).

ERDs assist you in building conceptual data models through to generating Data Definition Language (DDL) for the target DBMS.

A Logical model can be transformed to a Physical data model using a DDL Transformation.

Logical Data Model Entity Relationship Diagrams (ERDs) DDL Transformation

Physical Data Models

Physical data models in Enterprise Architect help you visualize your database structure and automatically derive the corresponding database schema; you use Enterprise Architect's UML Profile for Data Modeling specifically for this purpose.

The profile provides useful extensions of the UML standard that map database concepts of Tables and relationships onto the UML concepts of Classes and Associations; you can also model database columns, keys, constraints, indexes, triggers, referential integrity and other relational database features.

Because Enterprise Architect helps you visualize each type of data model in the same repository, you can easily manage dependencies between each level of abstraction to maximize traceability and verify completeness of system implementation.

Physical Data Models Database Modeling