Fundamentals of Data Warehouses

Data warehouses have captured the attention of practitioners and researchers alike. But the design and optimization of data warehouses remains an art rather than a science. This book presents the first comparative review of the state of the art and best current practice of data warehouses. It covers source and data integration, multidimensional aggregation, query optimization, update propagation, metadata management, quality assessment, and design optimization. Also, based on results of the European Data Warehouse Quality project, it offers a conceptual framework by which the architecture and quality of data warehouse efforts can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modeling, and artificial intelligence. For researchers and database professionals in academia and industry, the book offers an excellent introduction to the issues of quality and metadata usage in the context of data warehouses.

In-depth review of data warehousing state of the art and practice Includes challenging list of research topics for researchers Excellent introduction to the issues of quality and metadata usage in data warehousing In this 2nd edition the state of the practice is brought up-to-date and a new chapter on the development method of DWQ included

Inhalt
1 Data Warehouse Practice: An Overview.- 2 Data Warehouse Research: Issues and Projects.- 3 Source Integration.- 4 Data Warehouse Refreshment.- 5 Multidimensional Data Models and Aggregation.- 6 Query Processing and Optimization.- 7 Metadata and Data Warehouse Quality.- 8 Quality-Driven Data Warehouse Design.- Appendix A. ISO Standards Information Quality.- Appendix B. Glossary.