Advantages of Data Warehouse :
1.To Store Large Volumes of
Historical Detail Data from Mission Critical Applications.
2.Better business
intelligence for end-users.
3.Data Security - To prevent unauthorized access to
sensitive data.
4.Replacement of older, less-responsive decision support
systems.
5.Reduction in time to locate, access, and analyze information.
6.For the purpose of doing analysis and to take the decision.
7.High query performance.
8.Queries not visible outside warehouse.
9.Can operate when sources unavailable.
10.Can query data not stored in a DBMS.
11.Extra information at warehouse
12.Modify, summarize (store aggregates).
13.Add historical information 6. Improves the quality and accessibility of data.
14.Reduce the requirements of users to access operational data.
15.Allows new reports and studies to be introduced without disrupting operational systems.
16.Increases the amount of information available to users.
6.For the purpose of doing analysis and to take the decision.
7.High query performance.
8.Queries not visible outside warehouse.
9.Can operate when sources unavailable.
10.Can query data not stored in a DBMS.
11.Extra information at warehouse
12.Modify, summarize (store aggregates).
13.Add historical information 6. Improves the quality and accessibility of data.
14.Reduce the requirements of users to access operational data.
15.Allows new reports and studies to be introduced without disrupting operational systems.
16.Increases the amount of information available to users.
