Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Mastering Data Warehouse Design: Relational and Dimensional Techniques

At last, a balanced approach to data warehousing that leverages the techniques pioneered by Ralph Kimball and Bill Inmon

Since its groundbreaking inception, the approach to understanding data warehousing has been split into two mindsets: Ralph Kimball, who pioneered the use of dimensional modeling techniques for building the data warehouse, and Bill Inmon, who introduced the Corporate Information Factory and leads those who believe in using relational modeling techniques for the data warehouse. Mastering Data Warehouse Design successfully merges Inmon’s data ware- house design philosophies with Kimball’s data mart design philosophies to provide you with a compelling and complete overview of exactly what is involved in designing and building a sustainable and extensible data warehouse.

Most data warehouse managers, designers, and developers are familiar with the open letter written by Ralph Kimball in 2001 to the data warehouse community in which he challenged those in the Inmon camp to answer some tough questions about the effectiveness of the relational approach. Cowritten by one of the best-known experts of the Inmon approach, Claudia Imhoff, this team of authors addresses head-on the challenging questions raised by Kimball in his letter and offers a how-to guide on the appropriate use of both relational and dimensional modeling in a comprehensive business intelligence environment. In addition, you’ll learn the authors’ take on issues such as:

  • Which approach has been found most successful in data warehouse environments at companies spanning virtually all major industrial sectors
  • The pros and cons of relational vs. dimensional modeling techniques so developers can decide on the best approach for their projects
  • Why the architecture should include a data warehouse built on relational data modeling concepts
  • The construction and utilization of keys, the historical nature of the data warehouse, hierarchies, and transactional data
  • Technical issues needed to ensure that the data warehouse design meets appropriate performance expectations
  • Relational modeling techniques for ensuring optimum data warehouse performance and handling changes to data over time
About the Author
CLAUDIA IMHOFF (CImhoff@Intelsols.com) is President and Founder of Intelligent Solutions, a leading consultancy on analytic CRM and BI technologies and strategies. She is a popular speaker, an internationally recognized expert, and coauthor of five books.

NICHOLAS GALEMMO (ngalemmo@yahoo.com) was Information Architect at Nestlé USA. He has twenty-seven years’ experience as a practitioner and consultant involved in all aspects of application systems design and development. He is currently an independent consultant.

JONATHAN G. GEIGER (JGeiger@IntelSols.com) is Executive Vice President at Intelligent Solutions, Inc. In his thirty years as a practitioner and consultant, he has managed or performed work in virtually every aspect of information management.

(HTML tags aren't allowed.)

Getting Started with NativeScript
Getting Started with NativeScript

Explore the possibility of building truly native, cross-platform mobile applications using your JavaScript skill―NativeScript!

About This Book

  • Save your marketing time by building for iOS, Android, and Windows Mobile platforms simultaneously
  • Be an ace at utilizing the features of...
Scientific Methods in Mobile Robotics: Quantitative Analysis of Agent Behaviour
Scientific Methods in Mobile Robotics: Quantitative Analysis of Agent Behaviour
Mobile robots are widely applied in a range of applications from transportation, surveillance through to health care. In all these applications it is clearly important to be able to analyse and control the performance of the mobile robot and it is therefore surprising that formalised methods to achieve this are not readily available. This book...
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition

No previous background in database design is necessary to read this book. The reason you have this book in your hands is to learn how to design a database properly. If you're just getting into database management and you're thinking about developing your own databases, this book will be very valuable to you. It's better that...

Micromechanics of Fracture in Generalized Spaces
Micromechanics of Fracture in Generalized Spaces

By the detailed analysis of the modern development of the mechanics of deformable media can be found the deep internal contradiction. From the one hand it is declared that the deformation and fracture are the hierarchical processes which are linked and unite several structural and scale levels. From the other hand the sequential investigation of...

Machining Technology: Machine Tools and Operations
Machining Technology: Machine Tools and Operations
Offering complete coverage of the technologies, machine tools, and operations of a wide range of machining processes, Machining Technology presents the fundamental principles of machining and examines traditional and nontraditional machining methods. After a brief historical overview, the book explores design considerations and...
Cryptography and Coding: 13th IMA International Conference, IMACC 2011, Oxford, UK, December 2011
Cryptography and Coding: 13th IMA International Conference, IMACC 2011, Oxford, UK, December 2011

The 13th IMA Conference on Cryptography and Coding was held at the Lady Margaret Hall, University of Oxford, UK, during December 12–15, 2011. This event was a 25th anniversary celebration of the very successful biennial IMA conference series. Traditionally, the conference has taken place at the Royal Agricultural College,...

©2017 LearnIT (support@pdfchm.net) - Privacy Policy