---
Aliases: []
Tags: [incubating]
publish: true
---
Data Modeling is the process of mapping out an information system and how multiple parts are connected. Data models are typically illustrated in an entity-relationship diagram for relational databases like the picture below.
![[Assets/data_model_example.png|500]]
## Benefits of data modeling
Data modeling makes it easier for developers and other stakeholders to view and understand the relationships between data in a database or data warehouse. A good data model can also have the following benefits:
- Reduce errors in software and database development.
- Increase consistency in documentation and system design across the enterprise.
- Improve application and database performance.
- Ease data mapping throughout the organization.
- Improve communication between developers and business intelligence teams.
- Ease and speed the process of database design at the conceptual, logical and physical levels.
## Schema Design Patterns
[Star Schema](https://en.wikipedia.org/wiki/Star_schema)
[Snowflake Schema](https://en.wikipedia.org/wiki/Snowflake_schema)
[Data Vault](https://en.wikipedia.org/wiki/Data_vault_modeling)
[[One Big Table]]
[[Dimensional Data Modeling|Dimensional Modeling]]
[[Data Vault Modeling]]
![[Learning Resources#Data Modeling Learning Resources]]
%% wiki footer: Please don't edit anything below this line %%
## This note in GitHub
<span class="git-footer">[Edit In GitHub](https://github.dev/data-engineering-community/data-engineering-wiki/blob/main/Concepts/Data%20Modeling.md "git-hub-edit-note") | [Copy this note](https://raw.githubusercontent.com/data-engineering-community/data-engineering-wiki/main/Concepts/Data%20Modeling.md "git-hub-copy-note") </span>