Examples
Worked examples
- Is an instance
A university research-analytics data warehouse aggregating CRIS publications, HR employment, and finance grants for institutional dashboards.
- Is an instance
A national funder's data warehouse of award spend and outputs.
Counter-examples
Looks similar, but isn't
- Not an instance
A raw S3 bucket of files is a data lake, not a data warehouse.
- Not an instance
An OLTP transactional database is not a data warehouse.
Editorial commentary
Data warehousing dates to the 1980s and 1990s (Inmon, Kimball) and remains the dominant pattern for organisational reporting. In research-information contexts, a data warehouse may aggregate CRIS, HR, finance, and student-system data to support institutional analytics; OECD and national funders maintain warehouses of research-spend data. Modern cloud data warehouses (Snowflake, BigQuery, Redshift, Synapse) blur the lake/warehouse distinction by combining cheap storage with on-demand SQL compute.
References
- I
- n
- m
- o
- n
- W
- .
- H
- .
- ,
- ‘
- B
- u
- i
- l
- d
- i
- n
- g
- t
- h
- e
- D
- a
- t
- a
- W
- a
- r
- e
- h
- o
- u
- s
- e
- ‘
- ,
- W
- i
- l
- e
- y
- ,
- 4
- t
- h
- e
- d
- i
- t
- i
- o
- n
- ,
- 2
- 0
- 0
- 5
- .
- K
- i
- m
- b
- a
- l
- l
- R
- .
- ,
- R
- o
- s
- s
- M
- .
- ,
- ‘
- T
- h
- e
- D
- a
- t
- a
- W
- a
- r
- e
- h
- o
- u
- s
- e
- T
- o
- o
- l
- k
- i
- t
- ‘
- ,
- W
- i
- l
- e
- y
- ,
- 3
- r
- d
- e
- d
- i
- t
- i
- o
- n
- ,
- 2
- 0
- 1
- 3
- .
Also known as
DW · Enterprise data warehouse
Machine-readable encodings
Use in your systems
<role vocab="credit"
vocab-identifier="https://casrai.org/dictionary/"
vocab-term="Data warehouse"
vocab-term-identifier="https://casrai.org/dictionary/term/data-warehouse" />{
"@context": "https://schema.org",
"@type": "DefinedTerm",
"name": "Data warehouse",
"identifier": "https://casrai.org/dictionary/term/data-warehouse",
"description": "A central repository of structured data, integrated from multiple operational sources, modelled for analytical querying (typically with a star or snowflake schema), and optimised for read-heavy workloads supporting reporting and decision-making.",
"inDefinedTermSet": "https://casrai.org/dictionary/domain/research-data-infrastructure/",
"url": "https://casrai.org/dictionary/term/data-warehouse",
"sameAs": [
"DW",
"Enterprise data warehouse"
],
"license": "https://creativecommons.org/licenses/by/4.0/"
}
