Entity Relational Modeling
vs.
Dimensional Modeling

Relational (OLTP) Data Modeling

• Relational Data Model is a data model that views the real world as entities and relationships.
  
  
• Entities are associated with each other by relationship and attributes are properties of entities.
  
  
• Business rules would determine the relationship between each of entities in a data model
  
  
• helps to automate the normalization of physical data structures
  
  
• Seeks to eliminate Data Redundancy
  
  
• The goal of relational data model is to normalize (avoid redundancy)data and to present it in a good normal form. While working with relational data modeling, a data modeler has to understand 1st normal form thru 5th normal form to design a good data model.
  
  
• look for one-to-many or many-to-many relationship among data elements, and separate the data elements into distinct tables joined by keys
  
  
• Microscopic Relationships among Data Elements
  
  
• Spider Webs of Joins
  
  
• 100’s of Logical Entities
  
  
• Highest Transactional Performance
  
  
• Also used in data staging Area
  
  
• helping to automate the normalization of physical data structures
  
  
• do not contribute to the users' ability to query the data
  

Back to Entity Relational Modeling   vs.  Dimensional Modeling Index