DATA WAREHOUSING

Data warehouses can be used for many purposes. Mostly they are used with e-commerce sites that need 24x7 support.

Others use them as well. When moving offices a data warehouse may provide a method of keeping services available during the move.

Data warehouses also offer additional services: backups ; load balancing ; t1 - greater bandwidth and monitoring ; 24x7 on-call support ; etc.

A datawarehouse is an abstraction or summary of the details residing in your database.

It can be used to simplify reporting by aggregating disparate data. This makes the job of the reporting analyst easier, and it also helps provide consistent results.

It can also provide a security function by eliminating access to the underlying data (i.e. the datawarehouse acts like a giant view).

A Datawarehouse has the following potential uses
(i) the integration and organisation of data from disparate data sources to enable management perform decision analysis, identify new opportunities and make decisions of a strategic or operational nature.

(ii) facilitate the use of Decision support tools - data mining, OLAP and possibly even Business Intelligence applications (depending upon the complexity of management information requirements)

Cheers

Historical trend analysis of financial, customer, operational, system, and etc. data for current decision making, future strategic planning and as a catalyst for
reengineering efforts.

This question was auto closed due to inactivity