Dimensional Data Modeling

Dimensional Data Modeling comprises of one or more dimension tables and fact tables. Good examples of dimensions are location, product, time, promotion, organization etc. Dimension tables store records related to that particular dimension and no facts (measures) are stored in these tables. For example, Product dimension table will store information about products (Product Category, Product…

Read More

Relational Data Modeling Tutorial

Relational (OLTP) Data Modeling: Relational Data Model is a data model that views the real world as entities and relationships. Entities are concepts, real or abstract about which information is collected. Entities are associated with each other by relationship and attributes are properties of entities. Business rules would determine the relationship between each of entities…

Read More

Physical Data Modeling Tutorial

Physical Data Modeling: Physical data model includes all required tables, columns, relationships, database properties for the physical implementation of databases. Database performance, indexing strategy, physical storage and de-normalization are important parameters of a physical model. Logical data model is approved by functional team and there-after development of physical data model work gets started. Once physical data…

Read More

Enterprise Data Modeling Tutorial

Enterprise Data Modeling: The development of a common consistent view and understanding of data elements and their relationships across the enterprise is referred to as Enterprise Data Modeling. This type of data modeling provides access to information scattered throughout an enterprise under the control of different divisions or departments with different databases and data models….

Read More

Conceptual Data Modeling Tutorial

Conceptual Data Modeling: Conceptual data model includes all major entities and relationships and does not contain much detailed level of information about attributes and is often used in the INITIAL PLANNING PHASE. Conceptual data model is created by gathering business requirements from various sources like business documents, discussion with functional teams, business analysts, smart management experts…

Read More
error: Content is protected !!