Alejandro A. Vaisman and Esteban Zimányi

Data Warehouse Systems:
Design and Implementation


Series: Data-Centric Systems and Applications
Springer, 2014, ISBN: 978-3-642-54654-9


Book Reviews
Lecture Slides
Figures in PDF
Figures in Encapsulated PDF
Figures in PNG
Answer to Exercises
Sample Databases


Book Reviews


I think it is quite simply the most comprehensive textbook about data warehousing on the market. The book is very well suited for one or more DW courses, ranging from the most basic to the most advanced. It has all the features that are necessary to make a good textbook. First, a running case study, based on the Northwind database known from Microsoft's tools, is used to illustrate all aspects using many detailed figures and examples. Second, key terms and concepts are highlighted in the text for better reading and understanding. Third, review questions are provided at the end of each chapter so students can quickly check their understanding. Fourth, the many detailed exercises for each chapter put the presented knowledge into action, yielding deep learning, and taking students through all the steps needed to develop a data warehouses. Finally, the book shows how to implement data warehouses using leading industrial and open source tools, concretely Microsoft's and Pentaho's suites of data warehouse tools, giving students the essential hands-on experience that enables them to put the knowledge into practice.

Professor Torben Bach Pedersen
Co-director of the Center for Data-Intensive Systems (Daisy)
Aalborg Universiteit
Denmark


Download access


To obtain access to the material below, please fill the request form. A username and password will be sent to you once we verify your academic credentials.

Please notice that this material is subject to change without further notice. We are regularly updating this material in order to improve it.

Last update on June 18, 2015.


Lecture Slides
(in PDF, zipped by chapter)


Chapter 1. Introduction
Chapter 2. Database Concepts
Chapter 3. Data Warehouse Concepts
Chapter 4. Conceptual Data Warehouse Design
Chapter 5. Logical Data Warehouse Design
Chapter 6. Querying Data Warehouses
Chapter 7. Physical Data Warehouse Design
Chapter 8. Extraction, Transformation, and Loading
Chapter 9. Data Analytics: Exploiting the Data Warehouse
Chapter 10. A Method for Data Warehouse Design
Chapter 11. Spatial Data Warehouses
Chapter 12. Trajectory Data Warehouses
Chapter 13. New Data Warehouse Technologies
Chapter 14. Data Warehouses and the Semantic Web
Chapter 15. Conclusion


Figures in PDF
(zipped by chapter)


Chapter 2. Database Concepts
Chapter 3. Data Warehouse Concepts
Chapter 4. Conceptual Data Warehouse Design
Chapter 5. Logical Data Warehouse Design
Chapter 6. Querying Data Warehouses
Chapter 7. Physical Data Warehouse Design
Chapter 8. Extraction, Transformation, and Loading
Chapter 9. Data Analytics: Exploiting the Data Warehouse
Chapter 10. A Method for Data Warehouse Design
Chapter 11. Spatial Data Warehouses
Chapter 12. Trajectory Data Warehouses
Chapter 13. New Data Warehouse Technologies
Chapter 14. Data Warehouses and the Semantic Web
Appendix. Graphical Notation


Figures in Encapsulated PDF
(zipped by chapter)


Chapter 2. Database Concepts
Chapter 3. Data Warehouse Concepts
Chapter 4. Conceptual Data Warehouse Design
Chapter 5. Logical Data Warehouse Design
Chapter 6. Querying Data Warehouses
Chapter 7. Physical Data Warehouse Design
Chapter 8. Extraction, Transformation, and Loading
Chapter 9. Data Analytics: Exploiting the Data Warehouse
Chapter 10. A Method for Data Warehouse Design
Chapter 11. Spatial Data Warehouses
Chapter 12. Trajectory Data Warehouses
Chapter 13. New Data Warehouse Technologies
Chapter 14. Data Warehouses and the Semantic Web
Appendix. Graphical Notation


Figures in PNG
(zipped by chapter)


Chapter 2. Database Concepts
Chapter 3. Data Warehouse Concepts
Chapter 4. Conceptual Data Warehouse Design
Chapter 5. Logical Data Warehouse Design
Chapter 6. Querying Data Warehouses
Chapter 7. Physical Data Warehouse Design
Chapter 8. Extraction, Transformation, and Loading
Chapter 9. Data Analytics: Exploiting the Data Warehouse
Chapter 10. A Method for Data Warehouse Design
Chapter 11. Spatial Data Warehouses
Chapter 12. Trajectory Data Warehouses
Chapter 13. New Data Warehouse Technologies
Chapter 14. Data Warehouses and the Semantic Web
Appendix. Graphical Notation


Answers to Exercises
(in PDF, zipped by chapter)


Chapter 2. Database Concepts
Chapter 3. Data Warehouse Concepts
Chapter 4. Conceptual Data Warehouse Design
Chapter 5. Logical Data Warehouse Design
Chapter 6. Querying Data Warehouses
Chapter 7. Physical Data Warehouse Design
Chapter 8. Extraction, Transformation, and Loading
Chapter 9. Data Analytics: Exploiting the Data Warehouse
Chapter 10. A Method for Data Warehouse Design
Chapter 11. Spatial Data Warehouses
Chapter 12. Trajectory Data Warehouses
Chapter 13. New Data Warehouse Technologies
Chapter 14. Data Warehouses and the Semantic Web


Sample Databases


Nortwind
Northwind database for SQL Server (zipped backup file)
Northwind data warehouse for SQL Server (zipped backup file)
Northwind data warehouse for PostgreSQL (zipped backup file)
Northwind data warehouse for Analysis Services (zipped backup file)
Northwind data warehouse project for SQL Server Data Tools (zip file)
Northwind ETL project for SQL Server Data Tools (zip file)
Auxiliary files for the Northwind ETL process (zip file)
Northwind data warehouse in QB4OLAP vocabulary:
Schema, R2RML mapping, and triples (zip file)

Foodmart
Foodmart data warehouse for SQL Server (zipped backup file)
Foodmart data warehouse for PostgreSQL (zipped backup file)
Foodmart data warehouse for Analysis Services (zipped backup file)
Foodmart data warehouse project for SQL Server Data Tools (zip file)
Foodmart R2RML mappings for QB4OLAP vocabulary (zip file)
Foodmart triples in QB4OLAP vocabulary (zip file)
GeoNorthwind
GeoNorthwind data warehouse for PostGIS (zipped backup file)
Instructions to restore the database
AirCarrier
AirCarrier database for SQL Server (zipped backup file)
AirCarrier data warehouse for SQL Server (zipped backup file)
AirCarrier data warehouse project for SQL Server Data Tools (zip file)
AirCarrier ETL project for SQL Server Data Tools (zip file)