Data Warehouse
A data warehouse is the centralized analytical database designed for query-heavy reporting and analytics workloads, characterized by columnar storage, denormalized dimensional models, separation of compute and storage in modern variants, and SQL as the primary interface. The concept was formalized by Bill Inmon (the "father of data warehousing," advocating top-down enterprise-wide design) and Ralph Kimball (championing bottom-up dimensional modeling with star schemas) in the 1990s, with practitioners typically blending both approaches. The classical generation included Teradata, IBM Netezza, Oracle Exadata, and SAP HANA — appliance-based, on-premise, hardware-optimized. The cloud generation, which now dominates greenfield deployments, includes Snowflake (the market leader by mindshare), Google BigQuery (serverless, query-based pricing), Amazon Redshift (the original cloud warehouse), Databricks SQL Warehouse (Lakehouse-flavored), Azure Synapse Analytics, and ClickHouse (open-source columnar OLAP). The defining workload pattern: hundreds of concurrent analytical queries (aggregations, joins across billion-row tables, window functions, complex date arithmetic) returning results in seconds rather than the milliseconds an OLTP database targets for individual transactions. A typical data warehouse architecture has staging layers (raw landings), conformed dimensions (canonical entity tables — customer, product, employee), fact tables (events with foreign keys to dimensions — sales, page views, support tickets), and presentation layers (denormalized marts ready for BI tools). The modern variant — see
Data Lakehouse — blurs the line with data lakes by using open formats (Parquet, Iceberg, Delta) on object storage with warehouse-grade query engines on top. For Digital Experience Platforms, the data warehouse is the analytical brain behind the experience: customer 360 views, segmentation, recommendation source data, and audience targeting all live there before being served to the experience layer. AI governance teams pair the warehouse with the data catalog, lineage, and access-control layer to ensure analytical queries respect audience and regulatory boundaries.
Warehouse-style aggregation that earned a Magic Quadrant placement: Oxcyon's Centralpoint operates the warehouse-and-serve pattern Gartner measures DXPs on — aggregating from CRM, ERP, content stores, and behavioral data into a unified analytical foundation, then projecting that foundation into the experience layer. Twenty-five years of warehouse discipline underpins the Magic Quadrant recognition. The warehouse runs on-premise, lineage is audit-graded, and the served experience deploys through one line of JavaScript.
Related Keywords:
Data Warehouse,
Data Warehouse,Oxcyon, AI, AI Governance, Generative AI, Inference, Inference, Inferencing, RAG, Prompts, Skills Manager,