data warehouse

A database built for analysing large amounts of historical data with big scanning queries, separate from the live operational database.

In more detail

Running heavy reports on the operational database slows the application; a warehouse such as Amazon Redshift takes that load instead. Data is usually copied into the warehouse on a schedule or as a stream.

Related terms

Taught in

References

Certification courses