Data Architecture

19. Dimensional Warehouses from Enterprise Models

Dimensional Databases from Enterprise Data Models

Data warehousing is currently one of the most important applications of database technology and practice. A significant proportion of IT budgets in most organizations may be devoted to data warehousing applications. Although there is a high failure rate, high levels of user satisfaction and ROI have been reported about such applications. One of the most important issues in data warehouse is how to design appropriate database structures to support end-user queries.

Existing approaches to data warehousing design advocate an axiomatic approach where the structure of the data warehouse is derived directly from user query requirements. This chapter discusses ...