Data Modeling

Learning Path - Data Modeling

We have taken a few of the fundamental articles of our website and ordered them in such a way so that it helps a newcomer or a learner to grasp the concept from beginning. Please check below

Updated 29 Jul, 2021

ER Model

An entity-relationship model is a systematic way of describing and defining a business process. The process is modeled as components (entities) that are linked with each other by relationships that express the dependencies and requirements between them. Entities may have various properties (attributes) that characterize them. Diagrams created to represent these entities, attributes, and relationships graphically are called entity–relationship diagrams.

Dimensional Model

Dimensional modeling is the name of a set of techniques and concepts used in data warehouse design to support end-user queries in a data warehouse. It is oriented around understandability and performance. Dimensional modeling always uses the concepts of facts (measures), and dimensions (context). Facts are typically (but not always) numeric values that can be aggregated, and dimensions are groups of hierarchies and descriptors that define the facts.

Data Warehouse Design Pattern

Software design patterns help us build best practices into our data warehousing framework. A robust data warehousing architecture requires solid design pattern to start with. In this section we discuss various design patterns used in Data Warehouse designs.