Skip to main content

Short note: Warehouse and query manager

Short answer

The warehouse manager checks consistency, transforms and merges data, creates indexes and views, generates aggregations, archives, backs up, and updates metadata. The query manager directs queries to the right tables, schedules and balances them, generates query profiles, controls access, and returns results. Together they prepare and serve warehouse data.

Write a short note on the roles of warehouse manager and query manager in DW.

Warehouse manager

The warehouse manager is the component that manages the data once it is in the warehouse. Its roles:

  • Analyse data for consistency and referential integrity.
  • Transform and merge source data from temporary storage into the warehouse tables.
  • Create indexes and views on base tables.
  • Generate denormalisations and aggregations (summary tables).
  • Archive data and take backups.
  • Update metadata.

Query manager

The query manager handles all user queries and directs them to the right data. Its roles:

  • Direct each query to the proper table (detailed or summary).
  • Schedule and balance the execution of queries.
  • Generate query profiles so the warehouse manager knows which aggregations to build.
  • Control access and security, and return results to the user tool.
  • Maintain the query log and statistics for tuning.

Together, the warehouse manager prepares data and the query manager serves it.

✓ Answer checked by Claude Opus 5.5 (high effort)

Related questions

All Data Mining chapter 1 questions →