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:
See Also:
- Webcast: 10 ER/Studio Productivity Tips to Help You Love Your Data Models
- Webcast: Making Connections: Enhance Data Models with ER/Studio 2016+
- Video: Agile Change Management in ER/Studio Data Architect Professional
- Video: Data Modeling for Hadoop Hive with ER/Studio Data Architect
- Video: Data Modeling for MongoDB with ER/Studio Data Architect
- Video: Data Modeling Techniques for Teradata Users
- Video: Document a Database As Part of a Broader Data Modeling Initiative with ER/Studio
- Video: Why Should A Data Modeler Care About Business Processes?
- Datasheet: Model Hadoop Hive for the Hortonworks Data Platform (HDP)
- Solution Brief: MongoDB Data Modeling with ER/Studio
- Solution Brief: Enterprise Data Modeling: 7 Mistakes You Can’t Afford to Make
- Solution Brief: Importing ER/Studio Data Models into WhereScape 3D
- Case Study: Global Financial Services Organization Turns to ER/Studio for High-Performance Data Modeling
- Case Study: Microsoft Deploys ER/Studio to Establish an Enterprise Data Model
- Case Study: Newmont Mining Standardized their Data Modeling Practices with ER/Studio
Topics : Data Modeling,
Products : ER/Studio Data Architect,
