5 Questions
What is a data warehouse?
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.
What are the steps involved in the functioning of a data warehouse?
The steps involved in the functioning of a data warehouse are: Collect, Store, Analyze, and Consume.
What is the evolution of data warehousing?
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.
What are the features of a data warehouse?
The features of a data warehouse include being subject-oriented, integrated, time-variant, nonvolatile, and summarized.
What are the types of data warehouse?
The types of data warehouse include: 1. - (the text does not provide a specific answer for this question)
Test your knowledge of data warehousing with this quiz on the fundamentals of management data warehousing and data warehouse. Explore topics such as the collection of corporate information, relational database management systems, and the steps on how a data warehouse functions.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
