Data warehouse: Data warehouse is a consolidated database maintained separately from an organization’s production system database. Many organizations have multiple databases. A data warehouse is organized around informational subjects rather than specific business processes. Data held in data warehouses are time dependent, historical data may also be aggregated.