Video : ER/Studio Data Architect

Design New Databases. Part 2: Build Logical Data Models

Logical data modeling is the second of the three stages of data modeling and one of three types of the data model.

One uses the three data models (that is, conceptual, logical and physical) in concert to help teams capture the concepts and structure of new databases and systems. Each stage of modeling adds more detail to the models constructed in the previous stage. Logical models form the link between conceptual and physical data models. In a logical data model, the details outlined in a conceptual model take shape.

Effective data modeling enables organizations to turn business objectives into viable database designs. A linear approach to progressing through the stages of data modeling is an integral best practice for modern organizations to follow. It enables organizations to start with abstract business goals and refine their representation until one can implement them using a specific database platform. Created by data architects and business analysts, the model is less abstract than a conceptual model and helps teams understand the details of the data and the logistics of building and implementing a new system. As with conceptual models, they are platform-independent and one can, therefore, create them without committing to an implementation path.

This provides organizations with the opportunity to evaluate their current state and decide whether they need to invest in new technologies to target the desired future state. It may also become apparent that the ideal future state is out of scope, and that objectives need to be revised.

Learn the steps on how to use IDERA’s ER/Studio Data Architect to design a new database in this video series.

Watch the other videos from this series, Designing A New Database:

Topics : Data Modeling,

Products : ER/Studio Data Architect,

ER/Studio Data Architect provides numerous modeling capabilities including naming standards, business data objects, and flexible macros that help data professionals create and document their data models. With an extensive feature set, ER/Studio Data Architect offers superior data modeling for single- and multi-platform environments.

Contact IDERA: