Data Warehouse Systems

Data Warehouse Systems

4.11 - 1251 ratings - Source

With this textbook, Vaisman and ZimAinyi deliver excellent coverage of data warehousing and business intelligence technologies ranging from the most basic principles to recent findings and applications. To this end, their work is structured into three parts. Part I describes a€œFundamental Conceptsa€ including multi-dimensional models; conceptual and logical data warehouse design and MDX and SQL/OLAP. Subsequently, Part II details a€œImplementation and Deployment, a€ which includes physical data warehouse design; data extraction, transformation, and loading (ETL) and data analytics. Lastly, Part III covers a€œAdvanced Topicsa€ such as spatial data warehouses; trajectory data warehouses; semantic technologies in data warehouses and novel technologies like Map Reduce, column-store databases and in-memory databases. As a key characteristic of the book, most of the topics are presented and illustrated using application tools. Specifically, a case study based on the well-known Northwind database illustrates how the concepts presented in the book can be implemented using Microsoft Analysis Services and Pentaho Business Analytics. All chapters are summarized using review questions and exercises to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available at, including electronic versions of the figures, solutions to all exercises, and a set of slides accompanying each chapter. Overall, students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style.157a€“166 A. Gupta, I.S. Mumick, Maintenance of materialized views: Problems, techniques, and applications. ... (Morgan Kaufmann, 2011) V. Harinarayan, A. Rajaraman, J.D. Ullman, Implementing data cubes efficiently, in Proceedings of the 1996 ACM ... R.M. Bruckner, Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX (Wrox, 2012) D. Hecksel, B. Wheeler, P. Boyd-Bowman, anbsp;...

Title:Data Warehouse Systems
Author:Alejandro Vaisman, Esteban Zimányi
Publisher:Springer - 2014-09-10


You Must CONTINUE and create a free account to access unlimited downloads & streaming