Data Warehouse Design: Modern Principles and Methodologies [Paperback]

Matteo Golfarelli (Author), Stefano Rizzi (Author)

Book Description

Publication Date: May 26, 2009 | ISBN-10: 0071610391 | ISBN-13: 978-0071610391 | Edition: 1

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 University

Editorial Reviews

From the Back Cover

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 approaches
• Create a reconciled database to boost data mart architecture
• Capture and expressively represent end-user requirements
• Build a conceptual data mart schema using the Dimensional Fact Model
• Estimate data mart volume and workload
• Improve performance using advanced logical modeling techniques
• Extract, transform, cleanse, and load data from operational sources
• Use sophisticated indexing techniques to optimize query execution plans
• Comprehensively document data warehouse projects
• Discover innovative business intelligence techniques

About the Author

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 engineering.

Product Details

• Paperback: 480 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 26, 2009)
• Language: English
• ISBN-10: 0071610391
• ISBN-13: 978-0071610391
• Product Dimensions: 9 x 7.3 x 1.1 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #175,851 in Books (See Top 100 in Books)
  • #68 in Books > Computers & Technology > Databases > Data Warehousing

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

0 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent Book, September 19, 2011

By 

S. Dharmadhikari "CoolandCalm" (Maryland , USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Data Warehouse Design: Modern Principles and Methodologies (Paperback)

This is a good book for beginners as well as more experienced designers. I highly recommend this book to anyone who wants to design EDW.

1 of 46 people found the following review helpful:

5.0 out of 5 stars Data Warehouse Design textbook, April 14, 2010

By 

Tulin Girgin "Tulin Girgin" (Australia, Sydney) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Data Warehouse Design: Modern Principles and Methodologies (Paperback)

The book was in excellent condition and arrived way before I thought it would! Great service, great postage and was exactly as described! I definitely advise others to purchase from here :)