Data Warehousing

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.

The basic character of data warehouse are :
Organized by business dimension or subject. Data organized by subject and contain information relevant for decision support and data analysis.
Consistent. Data in different database may be encoded differently.all data must be encoded in a consistent manner.
Historical. The data are kept for many years can be used for identifying trends, forecasting, and making comparisons over the time.
Nonvolatile. Data are not updated after they are entered inro dat warehouse.
Use only online analytical processing. Organization data base are oriented toward handling transaction using online transaction processing(OLTP)
Multidimensional. A common representation for this multidimensional structure is the data cube.
Relationship with relational database.

1. Inmon, W.H. Tech Topic: What is a Data Warehouse? Prism Solutions. Volume 1. 1995.
2. Yang, Jun. WareHouse Information Prototype at Stanford (WHIPS). Stanford University. July 7, 1998.
3. R. Kelly Rainer Jr. efraim turban. Introduction to information systems 2nd edition. Asia. John Wiley & Son Inc
4. Data mart. Wikipedia the free encyclopedia. Available at http://en.wikipedia.org/wiki/Data_warehouse