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
- relational database — A database that stores data in tables and links rows in one table to rows in another through shared key values.
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
Taught in
- Seven Ways To Leave A Rack — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Cloud Concepts Sprint: Twelve Cards — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- The Test Server Nobody Could Rebuild — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- One Database Doing Five Jobs — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Ten Terabytes Nobody Reads — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Nine Wishes On The Backlog — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Database Performance: Caches, Proxies And Capacity Units — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Network Performance: Peering, Transit Gateway And The Edge — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Ingest And Transform: Streams, Lakes And Partitions — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Cost Governance: Tags, Budgets And Reports That Speak Up — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Full Mock And Your Review Plan — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- When to Pick Which Database — Cloud Infrastructure & Hyperscaler Architecture