Enterprise Data Warehousing using the Vault modelling method: method, illustrated by Chinook database

Organisations face the challenge of having to analyse ever-increasing volumes of data flexibly and efficiently in order to identify trends and risks critical to their success in a timely manner and respond to them. Enterprise data warehouses provide a technical solution to this challenge. This thesis examines the modelling methods suitable for the development of an enterprise data warehouse, with the aim of identifying the advantages and disadvantages of these methods and deriving practical recommendations from this analysis. To this end, the classical modelling approaches are systematically compared with the relatively new Data Vault modelling method, using a sample database. The comparison is based on predefined criteria. Firstly, the different requirements and framework conditions of the various approaches are discussed. Subsequently, the example database is modelled and implemented in parallel using both the traditional method and Data Vault. Finally, the insights gained in the process are evaluated against the criteria defined at the outset. A conclusion and an outlook on aspects to be considered in the future round off this topic.