國立虎尾科技大學 |

Data Warehouse Systems = Design and Implementation /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Data Warehouse Systems/ by Alejandro Vaisman, Esteban Zimányi.
Reminder of title:	Design and Implementation /
Author:	Vaisman, Alejandro.
other author:	Zimányi, Esteban.
Description:	XXVI, 696 p.online resource. :
Contained By:	Springer Nature eBook
Subject:	Computer Application in Administrative Data Processing. -
Online resource:	https://doi.org/10.1007/978-3-662-65167-4
ISBN:	9783662651674

Data Warehouse Systems = Design and Implementation /
Vaisman, Alejandro.

Data Warehouse SystemsDesign and Implementation /[electronic resource] :by Alejandro Vaisman, Esteban Zimányi. - 2nd ed. 2022. - XXVI, 696 p.online resource. - Data-Centric Systems and Applications,2197-974X. - Data-Centric Systems and Applications,.

Part I: Fundamental Concepts -- 1. Introduction -- 2. Database Concepts -- 3. Data Warehouse Concepts -- 4. Conceptual Data Warehouse Design -- 5. Logical Data Warehouse Design -- 6. Data Analysis in Data Warehouses -- 7. Data Analysis in the Northwind Data Warehouse -- Part II: Implementation and Deployment -- 9. Physical Data Warehouse Design -- 9. Extraction, Transformation, and Loading -- 10. A Method for Data Warehouse Design -- Part III: Advanced Topics -- 11. Temporal and Multiversion Data Warehouses -- 12. Spatial and Mobility Data Warehouses -- 13. Graph Data Warehouses -- 14. Semantic Web Data Warehouses -- 15. Recent Developments in Big Data Warehouses.

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 conceptual and logical data warehouse design, as well as querying using MDX, DAX and SQL/OLAP. This part also covers data analytics using Power BI and Analysis Services. Part II details “Implementation and Deployment,” including physical design, ETL and data warehouse design methodologies. Part III covers “Advanced Topics” and it is almost completely new in this second edition. This part includes chapters with an in-depth coverage of temporal, spatial, and mobility data warehousing. Graph data warehouses are also covered in detail using Neo4j. The last chapter extensively studies big data management and the usage of Hadoop, Spark, distributed, in-memory, columnar, NoSQL and NewSQL database systems, and data lakes in the context of analytical data processing. 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 Power BI. All chapters have been revised and updated to the latest versions of the software tools used. KPIs and Dashboards are now also developed using DAX and Power BI, and the chapter on ETL has been expanded with the implementation of ETL processes in PostgreSQL. Review questions and exercises complement each chapter to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available online and includes 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. “I can only invite you to dive into the contents of the book, feeling certain that once you have completed its reading (or maybe, targeted parts of it), you will join me in expressing our gratitude to Alejandro and Esteban, for providing such a comprehensive textbook for the field of data warehousing in the first place, and for keeping it up to date with the recent developments, in this current second edition.” From the foreword by Panos Vassiliadis, University of Ioannina, Greece.

ISBN: 9783662651674

Standard No.: 10.1007/978-3-662-65167-4doiSubjects--Topical Terms:

1365952
Computer Application in Administrative Data Processing.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Data Warehouse Systems = Design and Implementation /
LDR:04723nam a22004095i 4500 001 1088607
003 DE-He213
005 20220715200004.0
007 cr nn 008mamaa
008 221228s2022 gw | s |||| 0|eng d
020 $a 9783662651674 $9 978-3-662-65167-4
024 7 $a 10.1007/978-3-662-65167-4 $2 doi
035 $a 978-3-662-65167-4
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Vaisman, Alejandro. $e author. $0 (orcid)0000-0002-3945-4187 $1 https://orcid.org/0000-0002-3945-4187 $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1395806
245 1 0 $a Data Warehouse Systems $h [electronic resource] : $b Design and Implementation / $c by Alejandro Vaisman, Esteban Zimányi.
250 $a 2nd ed. 2022.
264 1 $a Berlin, Heidelberg : $b Springer Berlin Heidelberg : $b Imprint: Springer, $c 2022.
300 $a XXVI, 696 p. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
490 1 $a Data-Centric Systems and Applications, $x 2197-974X
505 0 $a Part I: Fundamental Concepts -- 1. Introduction -- 2. Database Concepts -- 3. Data Warehouse Concepts -- 4. Conceptual Data Warehouse Design -- 5. Logical Data Warehouse Design -- 6. Data Analysis in Data Warehouses -- 7. Data Analysis in the Northwind Data Warehouse -- Part II: Implementation and Deployment -- 9. Physical Data Warehouse Design -- 9. Extraction, Transformation, and Loading -- 10. A Method for Data Warehouse Design -- Part III: Advanced Topics -- 11. Temporal and Multiversion Data Warehouses -- 12. Spatial and Mobility Data Warehouses -- 13. Graph Data Warehouses -- 14. Semantic Web Data Warehouses -- 15. Recent Developments in Big Data Warehouses.
520 $a 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 conceptual and logical data warehouse design, as well as querying using MDX, DAX and SQL/OLAP. This part also covers data analytics using Power BI and Analysis Services. Part II details “Implementation and Deployment,” including physical design, ETL and data warehouse design methodologies. Part III covers “Advanced Topics” and it is almost completely new in this second edition. This part includes chapters with an in-depth coverage of temporal, spatial, and mobility data warehousing. Graph data warehouses are also covered in detail using Neo4j. The last chapter extensively studies big data management and the usage of Hadoop, Spark, distributed, in-memory, columnar, NoSQL and NewSQL database systems, and data lakes in the context of analytical data processing. 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 Power BI. All chapters have been revised and updated to the latest versions of the software tools used. KPIs and Dashboards are now also developed using DAX and Power BI, and the chapter on ETL has been expanded with the implementation of ETL processes in PostgreSQL. Review questions and exercises complement each chapter to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available online and includes 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. “I can only invite you to dive into the contents of the book, feeling certain that once you have completed its reading (or maybe, targeted parts of it), you will join me in expressing our gratitude to Alejandro and Esteban, for providing such a comprehensive textbook for the field of data warehousing in the first place, and for keeping it up to date with the recent developments, in this current second edition.” From the foreword by Panos Vassiliadis, University of Ioannina, Greece.
650 2 4 $a Computer Application in Administrative Data Processing. $3 1365952
650 2 4 $a Business IT Infrastructure. $3 1070169
650 2 4 $a Information Storage and Retrieval. $3 593926
650 1 4 $a Database Management. $3 669820
650 0 $a Information technology—Management. $3 1365950
650 0 $a Information storage and retrieval systems. $3 561170
650 0 $a Database management. $3 557799
700 1 $a Zimányi, Esteban. $e editor. $1 https://orcid.org/0000-0003-1843-5099 $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1261064
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9783662651667
776 0 8 $i Printed edition: $z 9783662651681
776 0 8 $i Printed edition: $z 9783662651698
830 0 $a Data-Centric Systems and Applications, $x 2197-9723 $3 1253989
856 4 0 $u https://doi.org/10.1007/978-3-662-65167-4
912 $a ZDB-2-SCS
912 $a ZDB-2-SXCS
950 $a Computer Science (SpringerNature-11645)
950 $a Computer Science (R0) (SpringerNature-43710)