What is Data Modeling

Definition

Data modeling is the practice of designing how data is structured and related, producing conceptual, logical, and physical models that define entities, attributes, and relationships so that data is organised consistently, efficiently, and in line with business meaning.

« Back to Glossary Index

Aligns data structure with business concepts and rules
Reduces redundancy and inconsistency through deliberate design
Improves query performance and integrity through well-chosen relationships
Provides a shared blueprint that guides database and pipeline development

Real World Example

Before building a sales warehouse, an architect models the business as fact and dimension tables, defining how orders relate to customers, products, and time, so the resulting schema supports intuitive, efficient analysis.

FAQs

What are the levels of data modeling?

Conceptual models capture high-level entities and relationships, logical models add detail and structure, and physical models define actual storage.

Why is data modeling important?

It ensures data is organised to reflect business meaning, minimise redundancy, and support efficient, reliable querying.

What is dimensional modeling?

A modeling technique using fact and dimension tables, common in warehouses, that makes analytical queries intuitive and performant.