Centralized data management

A data lake is a storage repository that holds a vast amount of raw data in its native format from various sources, including structured, semi-structured, and unstructured data.

A data lakehouse is a data warehouse that combines the scalability and cost-effectiveness of a data lake with the performance and governance of a data warehouse.

The data vault modeling approach was invented by Dan Linstedt in 1990, and is used to model the enterprise data warehouse core layer. This approach is suitable for multi-source environments needing a fast adaptation to changes.

Data warehousing is a process of collecting, organizing, and managing data from multiple sources into a single, unified system for easy access and analysis.

Dimensional modeling, also known as the Star Schema approach, is a set of techniques and concepts used in data warehouse design proposed by Ralph Kimball.

Relational data modeling is usually used for operational systems (OLTP systems) that store their data on relational databases, and also used for structured analytical data solutions.