What is a Data Warehouse?
A data warehouse is a data repository that captures important data about the business. Modern usage of the term data warehouse includes several key features.
A data warehouse is a database that is:
- Separate from operational applications
- Organized by subject and usually in a traditional database schema form
- Integrated and federated such that inbound data is transformed to meet structured warehouse data standards
- “Immutable” in that no data is overwritten allowing for “time travel”