Data Warehousing

Want to read the rest of this paper? Join Essayworld today to view this entire essay and over 50,000 other term papers

analyse information that the company has gathered for a single purpose, to make more intelligent business decisions. Whether to increase customer value, identify new markets or improve the management of the firm's assets, the data warehouse promises to deliver the information necessary to accomplish these tasks quickly and efficiently.

This report entails various aspects of Data Warehousing, ranging from a clear and concise definition of its working system through to its operational environment. It discusses its implications and effects on internal and external interaction. I have presented my finding with the backing of some actual case studies and elaborated upon the evolution, the current state and what the future holds for Data Warehousing.
The report is summarised by a final conclusion.


2.0 “What is a Data Warehouse”

Data warehouse is the center of the architecture for information systems in the 1990s. Data warehouse supports informational processing by ...

Get instant access to over 50,000 essays. Write better papers. Get better grades. Already a member? Login

systems are organised around.

For example if an operational world was designed around applications and functions such as loans, savings, bank card and trust for a financial institution. The data warehouse world would be organised around major subjects such as customer, vendor, product and activity. The alignment around subject areas affects the design and implementation of the data found in the data warehouse. Most importantly, the major subject areas influence the most important part of the key structure.

The application world is concerned both with database design and process design. The data warehouse world focuses on data modelling and database design exclusively. ...

Succeed in your coursework without stepping into a library. Get access to a growing library of notes, book reports, and research papers in 2 minutes or less.

CITE THIS PAGE: