Question

In early-generation data warehouses, architects and planners would typically need to make design compromises because of technology limitations. Which of the following was NOT a common design compromise found in early data warehouses?

a) Data Compression
b) Aggregation Limitations
c) Indexing Advancements
d) Query Performance

Answer 1

Indexing Advancements were not a common design compromise in early data warehouses but an enhancement to improve data retrieval operations. Other compromises due to technology limitations included Data Compression, Aggregation Limitations, and Query Performance issues.

Step-by-step explanation:

In early-generation data warehouses, architects and planners would often have to make several design compromises due to technological limitations. Compromises typically included Data Compression, which involved reducing the size of stored data to save on storage costs and improve I/O efficiency; Aggregation Limitations, which pertained to the pre-calculation and storage of summary data to improve query performance but at the cost of flexibility and detail; and Query Performance, which often suffered as a result of hardware and software constraints.

However, Indexing Advancements were not a compromise but rather an enhancement that arose to improve performance and access speed in data retrieval operations. Early data warehouses saw significant indexing improvements to deal with the volume and complexity of the data stored.