Data Warehouse Systems : Design and Implementation / by Alejandro Vaisman, Esteban Zimányi.

Format:

Book

Author/Creator:

Vaisman, Alejandro, author.

Zimányi, Esteban, author.

Contributor:

SpringerLink (Online service)

Series:

Computer Science (Springer-11645)

Data-centric systems and applications 2197-9723

Data-Centric Systems and Applications, 2197-9723

Language:

English

Subjects (All):

Database management.

Information storage and retrieval.

Management information systems.

Application software.

Database Management.

Information Storage and Retrieval.

Business IT Infrastructure.

Computer Appl. in Administrative Data Processing.

Local Subjects:

Database Management.

Information Storage and Retrieval.

Business IT Infrastructure.

Computer Appl. in Administrative Data Processing.

Physical Description:

1 online resource (XVI, 625 pages) : 133 illustrations.

Edition:

First edition 2014.

Contained In:

Springer eBooks

Place of Publication:

Berlin, Heidelberg : Springer Berlin Heidelberg : Imprint: Springer, 2014.

System Details:

text file PDF

Summary:

With this textbook, Vaisman and Zimányi 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 "Fundamental Concepts" including multi-dimensional models; conceptual and logical data warehouse design; and MDX and SQL/OLAP. Subsequently, Part II details "Implementation and Deployment," which includes physical data warehouse design; data extraction, transformation, and loading (ETL); and data analytics. Lastly, Part III covers "Advanced Topics" such as spatial data warehouses; trajectory data warehouses; semantic technologies in data warehouses; and novel technologies like MapReduce, 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 http://cs.ulb.ac.be/DWSDIbook/, 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.

Contents:

Part I Fundamental Concepts

1 Introduction

2 Database Concepts

3 Data Warehouse Concepts

4 Conceptual Data Warehouse Design

5 Logical Data Warehouse Design

6 Querying Data Warehouses

Part II Implementation and Deployment

7 Physical Data Warehouse Design

8 Extraction, Transformation and Loading

9 Data Analytics: Exploiting the Data Warehouse

10 A Method for Data Warehouse Design

Part III Advanced Topics

11 Spatial Data Warehouses

12 Trajectory Data Warehouses

13 New Data Warehouse Technologies

14 Data Warehouses and the Semantic Web

15 Conclusion.

Other Format:

Printed edition:

ISBN:

978-3-642-54655-6

9783642546556

Access Restriction:

Restricted for use by site license.