Data Warehouse Systems

More about the book

Vaisman and Zimányi provide comprehensive coverage of data warehousing and business intelligence technologies, from fundamental principles to recent applications. The textbook is organized into three parts. Part I focuses on “Fundamental Concepts,” discussing multi-dimensional models, data warehouse design, and MDX and SQL/OLAP. Part II addresses “Implementation and Deployment,” covering physical data warehouse design, ETL processes, and data analytics. Part III explores “Advanced Topics,” including spatial and trajectory data warehouses, semantic technologies, and innovative solutions like Map Reduce, column-store databases, and in-memory databases. A notable feature is the use of application tools to illustrate topics, with a case study based on the Northwind database demonstrating implementation through Microsoft Analysis Services and Pentaho Business Analytics. Each chapter concludes with review questions and exercises to enhance student learning. Instructors can access supplemental materials at http://cs.ulb.ac.be/DWSDIbook/, which includes electronic figures, exercise solutions, and chapter slides. This textbook serves as a valuable reference for students, practitioners, and researchers, presenting key topics in a clear and educational manner.