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?

For decision-making, data needs to be aggregated and turned into information, but these data were locked up, either in
  • 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
Discover Study Smart

What is an operational data store?

A database in which data from different sources are integrated (with limited history), aimed at supporting short-term decision-making

What is an enterprise data warehouse?

A large-scale data warehouse that is used throughout the entire organization for decision support

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
Remember faster, study better. Scientifically proven.
Trustpilot Logo