Data Modelling

Data management design paradigm and methodologies

ER Model Tutorial
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, such as: one building may be divided into zero or more apartments, but one apartment can only be located in one building. 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 Tutorial
Dimensional modeling (DM) is the name of a set of techniques and concepts used in data warehouse design. According to data warehousing consultant Ralph Kimball, DM is a design technique for databases intended 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 Tutorial
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.