March 2022
Intermediate to advanced
682 pages
22h 58m
English
There are three competing methodologies for developing data warehouses, called top-down, bottom-up, and data vault. The latter is a hybrid that was created to leverage advantages and mitigate disadvantages of the other two methods.
W. H. Inmon described his method of building a data warehouse as a top-down method, one that starts with a general solution that is gradually refined. He called for building an enterprise-wide data warehouse as the centerpiece for a Corporate Information Factory, which is a delivery framework for business intelligence. Because the data warehouse must support unanticipated queries and reports, it is impossible to determine all the system requirements in advance. ...