Data Warehouse is a large collection of organized data gathered from different sources. It is used to store, manage, and analyze data for making better decisions.
Key features of a data warehouse are
Subject-Oriented: Data is grouped by important topics like customers, products, or sales. It focuses on helping decision-makers, not daily operations.
Integrated: Combines data from many sources, like databases, files, and transaction records, into one place.
Time-Variant: Stores data for a long time (e.g., 5-10 years) to show trends over time, unlike regular databases that only show current data.
Non-Volatile: Data is stored permanently and doesn’t change. It is ready for analysis without affecting the original data.