A data warehouse is a central repository of integrated data collected from multiple sources, designed for analysis, reporting, and decision-making.

Explanation:

• Data warehouses store historical and current data for business intelligence.
• Unlike transactional databases, they focus on query performance and analytics.
• They use ETL (Extract, Transform, Load) processes to collect and organize data.

Example Architecture:

• Sources: Databases, applications, logs.
• ETL Process: Extract data, transform it, and load into the warehouse.
• Data Warehouse: Stores cleaned, structured data.
• BI Tools: Used for reporting and analysis.