Fundamentals of Data Warehousing Quiz

A data warehouse is a collection of corporate information derived from operational systems and external data sources, stored in a relational database management system designed for transaction processing and providing transformed and summarized data.

The steps involved in the functioning of a data warehouse are: Collect, Store, Analyze, and Consume.

The evolution of data warehousing dates back to the 1960s with the development of the terms dimensions and facts. It further progressed through the introduction of dimensional data marts for retail sales in the 1970s, and the introduction of a database management system specifically for decision support by Tera Data Corporation in 1983. Data warehousing as we know it today started in the late 1980s with the development of the Business Data Warehouse by IBM workers Paul Murphy and Barry Devlin, and further advancements were made by Inmon Bill, considered the father of data warehousing, who wrote extensively on building, using, and maintaining the warehouse and the Corporate Information Factory.

<p>The features of a data warehouse include being subject-oriented, integrated, time-variant, nonvolatile, and summarized.</p> Signup and view all the answers

<p>The types of data warehouse include: 1. - (the text does not provide a specific answer for this question)</p> Signup and view all the answers