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

Final Cut Pro HD for Dummies
Final Cut Pro HD for Dummies

Welcome to Final Cut Pro HD For Dummies! The Final Cut Pro digital video editing program lets you capture raw video and audio (such as dialogue, sound, and music) on your Macintosh and assemble these elements into polished productions that are ready for the Internet, a CD-ROM, a DVD, television, and even the big screen.


Net Crimes & Misdemeanors: Outmaneuvering Web Spammers, Stalkers, and Con Artists
Net Crimes & Misdemeanors: Outmaneuvering Web Spammers, Stalkers, and Con Artists
If you are reading this book or thinking about acquiring it, you have taken an important step toward increasing your awareness of the ways in which the Internet may be abused. J. A. Hitchcock has prepared a second edition of her popular book, Net Crimes and Misdemeanors, reflecting new ways in which you may encounter the dark side of global...
Knowledge Discovery in Bioinformatics: Techniques, Methods, and Applications (Wiley Series in Bioinformatics)
Knowledge Discovery in Bioinformatics: Techniques, Methods, and Applications (Wiley Series in Bioinformatics)
Wiley Series on Bioinformatics: Computational Techniques and Engineering

Discover how data mining is fueling new discoveries in bioinformatics

As the field of bioinformatics continues to flourish, producing enormous amounts of new data, the need for sophisticated methods of data mining to better manage and extract meaning from...

iPod & iTunes For Dummies, 3rd Edition
iPod & iTunes For Dummies, 3rd Edition
Import music, create playlists, burn CDs, and more

Power up your iPod, fill it with tunes, even use it to manage your life

Nothing since the Walkman® has changed the music world like the iPod. But did you know your iPod can also keep your calendar, store photos, and wake you in time for...

IBM Lotus Quickr 8.5 for Domino Administration
IBM Lotus Quickr 8.5 for Domino Administration

When the IT strategy calls for maximizing the value of social software for building effective teams, neither social networking nor team collaboration are sufficient on their own. IBM Lotus Quickr team collaboration software delivers the promise of social software, but ensuring that a business's social networking site is compliant, can be...

Design, Simulation and Applications of Inductors and Transformers for Si RF ICs
Design, Simulation and Applications of Inductors and Transformers for Si RF ICs
The modern wireless communication industry has put great demands on circuit designers for smaller, cheaper transceivers in the gigahertz frequency range. One tool which has assisted designers in satisfying these requirements is the use of on-chip inductive elements (inductors and transformers) in silicon (Si) radio-frequency...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy