Data warehouses are a special type of database that are built for the specific purpose of getting information out rather than putting data in, which is the purpose of most application databases.
The emphasis is on supporting questions of a strategic nature, to assist the managers of organizations in planning for the future.
A data warehouse is:
Dimensional analysis is a technique used in identifying the requirements of a data warehouse and this is often depicted using a star schema. The star schema identifies the facts and the dimensions of analysis. A fact is an attribute, such as sales value, or call duration, which is analyzed across dimensions. Dimensions are things like customers ...