Learn free, at your own pace.

61

API / SERVICE DATA MODELLING

API / Service Data Modelling is the practice of designing the data contracts and structures that define how information is exchanged between services, applic…

62

TEMPORAL DATA MODELLING

Temporal Data Modelling is the practice of structuring data so that changes over time are explicitly captured and preserved. Instead of storing only the curr…

63

3NF DATA MODELLING(BILL INMON)

3NF Data Modelling, championed by Bill Inmon, organizes enterprise data in a normalized structure, typically Third Normal Form (3NF), to build a centralized…

64

DIMENSIONAL DATA MODELLING

Dimensional Data Modelling is an analytical modelling approach that structures data into facts (quantitative measures) and dimensions (descriptive attributes…

65

WHAT IS A FACT Table?

A Fact is the central table in dimensional data modelling that stores the measurable outcomes of a business process. These measures are typically numeric and…

66

WHAT IS A DIMENSION Table?

A Dimension is a descriptive table in dimensional modelling that provides context to fact tables. While facts record measurable events, dimensions explain th…

67

STAR SCHEMA

The Star Schema is a dimensional modelling design in which a central fact table connects directly to multiple surrounding dimension tables, forming a star-li…

68

SNOWFLAKE SCHEMA

The Snowflake Schema is a dimensional modelling design in which one or more dimension tables are normalized into related sub-dimensions, forming a snowflake-…

69

Data Vault MOdelling

Data Vault Data Modelling belongs to the family of Ensemble Data Modelling. In discussions about modern data warehousing, terms like Data Vault (DV), Busines…

70

Focal Point Data Modelling

Just like Data Vault, Focal Point Data Modelling also belongs to the family of Ensemble Data Modelling. The modelling process in the Focal methodology is org…