A Data warehouse is a database used for Reporting. A data warehouse is a Subject Oriented, Integrated, Non-volatile and Time-variant collection of data in support of management's decision making process.
Subject Oriented :- A data ware housing can be used to analyze subject area. This leads to the gathering of information around these subjects rather than around the applications or process.
For Example :Sales, Finance, HR... These are the different subject areas in organization.
Integrated :- A data warehouse integrates data is scattered around different tables, databases or even servers but the data is integrated consistently in the values of variables, naming conventions and physical data definations.
Non-volatile :- The data in the data warehouses should not be changed or updated - once its loaded from operational system.
Time-variant :- The value of operational data changes on the basis of time. The data warehouse kept the data historical. and we can retrive the data months wise,year wise.
For Example :Sales, Finance, HR... These are the different subject areas in organization.
Integrated :- A data warehouse integrates data is scattered around different tables, databases or even servers but the data is integrated consistently in the values of variables, naming conventions and physical data definations.
Non-volatile :- The data in the data warehouses should not be changed or updated - once its loaded from operational system.
Time-variant :- The value of operational data changes on the basis of time. The data warehouse kept the data historical. and we can retrive the data months wise,year wise.
No comments:
Post a Comment