Data Warehousing - Data Warehousing Definitions and Concepts
6 important questions on Data Warehousing - Data Warehousing Definitions and Concepts
What caused the need for data warehouses?
- complicated mainframe file structures (1970s)
- islands of data produced by minicomputers and personal computers (1980s)
What are the fundamental characteristics of a data warehouse?
- Subject-oriented: data in a data warehouse are organized by subject
- Integrated: data from different sources are stored in a consistent format
- Time-variant: historical data are maintained
- Nonvolatile: data stored in a data warehouse cannot be changed
What are the three main types of data warehouses?
- Data marts
- Operational data stores
- Enterprise data warehouse
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is an operational data store?
What is an enterprise data warehouse?
What types of metadata does the pattern view discriminate?
- Structural
- Syntactic
- Semantic
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding