| Home >Tutorial > Entity Relational Modeling vs. Dimensional Modeling > Relational (OLTP) Data Modeling |
|
| 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
|
| |
|
