Data warehouse

A Data Warehouse (DW) is the central, integrated repository for historical and current data, optimized exclusively for reporting, business intelligence (BI), and analytical querying.

A Data Warehouse is the foundational system for enterprise analytics, consolidating data from disparate operational sources (OLTP systems) into a single, structured source of truth. Data is prepared via Extract, Transform, Load (ETL) or ELT processes, ensuring it is clean, consistent, and time-variant before storage. Unlike transactional databases, the DW is optimized for complex, high-volume analytical queries (OLAP) using columnar storage and Massively Parallel Processing (MPP) architectures. Modern cloud platforms like Snowflake, Amazon Redshift, and Google BigQuery exemplify this technology, offering elastic scalability and pay-as-you-go models for fast, data-driven decision-making across the organization.

https://en.wikipedia.org/wiki/Data_warehouse