Data modeling techniques

During the 1990s, as data warehouses rapidly integrated into numerous enterprises and businesses, Bill Inmon, Ralph Kimball, and Daniel Linstedt developed methodologies with architectures for constructing data warehouses.

Each of these methods has its own associated data model. While other methods or possible combinations exist, the three main forms discussed in the following subsections are the most common.

Bill Inmon and relational modeling

In 1992, William (Bill) Inmon published Building the Data Warehouse (https://www.wiley.com/en-us/Building+the+Data+Warehouse,+4th+Edition-p-9780764599446). For this work, he is recognized as one of the fathers of the data warehouse.

Inmon’s methodology for data warehouse architecture highlights the importance of a unified data storage system structured according to the third normal form (3NF), which will be described in depth in the next section. He asserts that robust relational modeling contributes...