Analytical data processes

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.

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.

ELT (Extract, Load, Transform) is a data automation process that is used to extract data from various sources, load it into a database, and transform it into a more useful format. It is a popular method for data integration and data warehousing, and is often used in combination with ETL (Extract, Transform, Load).

ETL (Extract, transform, and load) is a method for getting data from one system and putting it into another. This can apply to transactions, events, data from analytical tools, or IoT data.

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.

Semantic modeling is a type of database model which is used to represent the relationships between business data and process within an organization. It is used to create a semantic layer that links the existing data and business process in an intuitive and meaningful way.