SUMMARY
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:
Subject Oriented
Non Volatile
Integrated
Time Variant
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 ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
