Post by raselbd114 on Dec 5, 2023 14:21:12 GMT 5.5
Data warehouse attributes according to Inmon's definition Next to Inmon a key figure in the data warehousing area is Ralph Kimball born in. Unlike Inmona's definition of a data warehouse where the focus is on the features of a data warehouse Kimball focuses on its purpose: A data warehouse is a system that obtains data from source systems transforms it and loads it into multidimensional structures and then provides queries and analyzes to support decision making. Purpose of a data warehouse according to Kimball's definition Fig. Purpose of a data warehouse according to Kimball's definition.
The author of the third approach to the subject of data warehousing called Data Vault is Dan Linstedt. Data Vault is the result of years of research by Linstedt to ensure consistency flexibility and scalability of the warehouse. The first fruit of his research in this area can be considered as five articles published in Email Marketing List on this topic. Bill Inmon Ralph Kimball and Dan Linstedt have authored hundreds of publications presenting their approach to data modeling. The fullest reflection of their perspectives on data warehousing can be found in the books they authored. However I will try to briefly compare the approach of each of the three visionaries in the following paragraphs. Books about data warehousing Fig.
First editions of books devoted to designing data warehouses according to various approaches One version of Bill Inmon's truth According to Inmon a data warehouse in the physical implementation aspect is a central relational database in the third normal form on the basis of which data marts intended for individual units departments divisions of the organization are built. Inmon's approach is based directly on source data so the construction of the warehouse can be started a priori without specifying user requirements. Inmon's architecture assumes the use of all operating system databases so it excludes the possibility of selective data acquisition.
The author of the third approach to the subject of data warehousing called Data Vault is Dan Linstedt. Data Vault is the result of years of research by Linstedt to ensure consistency flexibility and scalability of the warehouse. The first fruit of his research in this area can be considered as five articles published in Email Marketing List on this topic. Bill Inmon Ralph Kimball and Dan Linstedt have authored hundreds of publications presenting their approach to data modeling. The fullest reflection of their perspectives on data warehousing can be found in the books they authored. However I will try to briefly compare the approach of each of the three visionaries in the following paragraphs. Books about data warehousing Fig.
First editions of books devoted to designing data warehouses according to various approaches One version of Bill Inmon's truth According to Inmon a data warehouse in the physical implementation aspect is a central relational database in the third normal form on the basis of which data marts intended for individual units departments divisions of the organization are built. Inmon's approach is based directly on source data so the construction of the warehouse can be started a priori without specifying user requirements. Inmon's architecture assumes the use of all operating system databases so it excludes the possibility of selective data acquisition.