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

Never Apply for a Job Again!: Break the Rules, Cut the Line, Beat the Rest
Never Apply for a Job Again!: Break the Rules, Cut the Line, Beat the Rest

"Never Apply For a Job Again! is what everyone needs to understand how the hidden job market works. Get it and use it before the secrets get out on WikiLeaks."
--Penelope Trunk, the original Brazen Careerist, author, blogger, entrepreneur

"This book is an essential read for insightful, witty, and

Urinalysis and Body Fluids
Urinalysis and Body Fluids

This thoroughly updated 5th Edition provides concise and carefully structured full-color instruction in the handling and analysis of non-blood body fluids.Readers will learn how to handle and preserve the integrity of body fluid specimens and how to keep themselves and their laboratory safe from infectious agents!Practical, focused, and reader...

Search Engine Marketing
Search Engine Marketing

Revolutionize Your Internet Marketing

Leverage today's Internet marketing strategies to reach customers, increase sales, and establish performance-based marketing in your organization. Search Engine Marketing explains how to use Web analytics, key performance indicators (KPIs), search engine optimization (SEO),...

Race, Class, and the Death Penalty: Capital Punishment in American History
Race, Class, and the Death Penalty: Capital Punishment in American History

No scholarly effort is ever conducted without heavy indebtedness to others. This is particularly true of efforts that rest as heavily as this one does upon data collection efforts carried out by others. Our largest debt is, of course, to M. Watt Espy. Without his continuing effort, this study would have been impossible. We are profoundly...

Digital Video and DSP: Instant Access
Digital Video and DSP: Instant Access
Although there are many variations and implementation techniques, video signals are just a way of transferring visual information from one point to another. The information may be from a VCR, DVD player, a channel on the local broadcast, cable television, or satellite system, the Internet, cell phone, MP3 player, or one of many other sources....
Biology (Glencoe Science)
Biology (Glencoe Science)

When you read Glencoe Biology, you need to read for information. Science is nonfiction writing; it describes real-life events, people, ideas, and technology. Here are some tools that Glencoe Biology has to help you read.

The foundation of scientific knowledge is Investigation and Experimentation. In this section, you will...
©2017 LearnIT (support@pdfchm.net) - Privacy Policy