Data Warehouse
A data warehouse contains a snapshot of the DB which is periodically refreshed from the TP DB
All queries run on the data warehouse
All update transactions run on the TP DB
Queries don’t get absolutely up-to-date data
How to refresh the data warehouse?
- Stop processing transactions and copy the TP DB to the data warehouse. Possibly run queries while refreshing
- Treat the warehouse as a DB replica and use a replication technique