What is Data Warehouse?
A data warehouse (DWH) is a repository of an organization’s electronically stored data, extracted from operational systems and made available for ad-hoc queries and scheduled reporting. The data in a data warehouse comes in handy for business analysis and decision-making purposes.
Data warehousing involves extracting, transforming, and loading data from various sources into the data warehouse. This practice typically revolves around hardware, software, and best practices to ensure that the data is accurate, consistent, and accessible to those who need it.
Difference between Data Warehouses and Databases
Data Warehouse Architecture
- Single-tier Architecture
- Two-tier Architecture
- Three-tier Architecture
Enlisting the Features
Subject Oriented
It provides information catered to a specific subject area instead of the entire organization’s ongoing operations. Examples of subjects include product information, sales data, customer and supplier details, etc.
Integrated
Time-Variant
