Data warehouse and lakehouse

A separate, integrated store of historical business data for reporting and analytics, splitting analysis from transaction systems.

Data, cloud & securitySoftware
  1. 1988

    First version

    Barry Devlin and Paul Murphy (IBM); popularised by Bill Inmon and Ralph Kimball

    Image: Patrick Finnegan · CC BY 2.0 · Wikimedia Commons
  2. 1992

    Inmon's enterprise data warehouse

    'Building the Data Warehouse' sets normalised, subject-oriented warehouse design.

    Image: Prism Solutions, Inc. · Unclear; no licence stated (company log… · Wayback Machine capture (30 Jun 1997) of prisms…
  3. 1996

    Kimball dimensional modelling

    Star schemas and data marts make warehouses practical for business users.

    Image: Ralph Kimball Associates · Unclear; no licence stated (company log… · rkimball.com site logo file rka.gif, Wayback Ma…
  4. 2010
    Cloud warehouses: BigQuery

    Cloud warehouses: BigQuery

    Google's serverless SQL analytics over huge datasets; Redshift (2012), Snowflake follow.

    Image: Tabler (https://github.com/tabler / https://web.archive.org/web/20230424163711/… · MIT · Wikimedia Commons
  5. 2021

    Lakehouse

    Warehouse features on open files in object storage (Delta Lake, Iceberg).

    Image: Agrawroh · CC BY-SA 4.0 · Wikimedia Commons

Contested: Bill Inmon is widely called the 'father of data warehousing', though IBM's Devlin and Murphy published the architecture in 1988.

See it on the timeline