Data Warehouse Design: Modern Principles and Methodologies

Data Warehouse Design: Modern Principles and Methodologies

3.87 (16 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?


Foreword by Mark Stephen LaRow, Vice President of Products, MicroStrategy "A unique and authoritative book that blends recent research developments with industry-level practices for researchers, students, and industry practitioners." Il-Yeol Song, Professor, College of Information Science and Technology, Drexel Universityshow more

Product details

  • Paperback | 480 pages
  • 185.42 x 228.6 x 25.4mm | 793.78g
  • McGraw-Hill Education - Europe
  • MCGRAW-HILL Professional
  • New York, NY, United States
  • English
  • w. figs.
  • 0071610391
  • 9780071610391
  • 263,645

About Mattaeo Golfarelli

Matteo Golfarelli is an associate professor of Computer Science and Technology at the University of Bologna, Italy, where he teaches courses in information systems, databases, and data mining. Stefano Rizzi is a full professor of Computer Science and Technology at the University of Bologna, Italy, where he teaches courses in advanced information systems and software more

Back cover copy

Plan, Design, and Document High-Performance Data Warehouses Set up a reliable, secure decision-support infrastructure using the cuttingedge techniques contained in this comprehensive volume. Data Warehouse Design: Modern Principles and Methodologies presents a practical design approach based on solid software engineering principles. Find out how to interview end users, construct expressive conceptual schemata and translate them into relational schemata, and design state-of-the-art ETL procedures. You will also learn how to integrate heterogeneous data sources, implement star and snowflake schemata, manage dynamic and irregular hierarchies, and fine-tune performance by materializing and fragmenting views. Work with data- and requirement-driven methodological approachesCreate a reconciled database to boost data mart architectureCapture and expressively represent end-user requirementsBuild a conceptual data mart schema using the Dimensional Fact ModelEstimate data mart volume and workloadImprove performance using advanced logical modeling techniquesExtract, transform, cleanse, and load data from operational sourcesUse sophisticated indexing techniques to optimize query execution plansComprehensively document data warehouse projectsDiscover innovative business intelligence techniquesshow more

Table of contents

Chapter 1. Introduction to Data Warehousing Chapter 2. Data Warehouse System Lifecycle Chapter 3. Analysis and Reconciliation of Data Sources Chapter 4. User Requirement Analysis Chapter 5. Conceptual Modeling Chapter 6. Conceptual Design Chapter 7. Workload and Data Volume Chapter 8. Logical Modeling Chapter 9. Logical Design Chapter 10. Data-staging Design Chapter 11. Indexes for the Data Warehouse Chapter 12. Physical Design Chapter 13. Data Warehouse Project Documentation Chapter 14. A Case Study Chapter 15. Business Intelligence: Beyond the Data Warehouse Glossary Bibliography Indexshow more

Rating details

16 ratings
3.87 out of 5 stars
5 31% (5)
4 44% (7)
3 12% (2)
2 6% (1)
1 6% (1)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X