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

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

Building the Data Warehouse
Building the Data Warehouse
The most comprehensive introduction to the core concepts and methods of data warehousing

Data warehouses provide a much-needed strategy for organizations to collect, store, and analyze vast amounts of business data. As businesses expand both brick-and-mortar and online activities, the field of data warehousing has become increasingly important....

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin

The Extract-Transform-Load (ETL) system is the foundation of the data warehouse. A properly designed ETL system extracts data from the source systems, enforces data quality and consistency standards, conforms data so that separate sources can be used together, and finally delivers data in a presentation-ready format so that...

Google BigQuery Analytics
Google BigQuery Analytics

How to effectively use BigQuery, avoid common mistakes, and execute sophisticated queries against large datasets

Google BigQuery Analytics is the perfect guide for business and data analysts who want the latest tips on running complex queries and writing code to communicate with the BigQuery API. The book uses...


Building Your Next Big Thing with Google Cloud Platform: A Guide for Developers and Enterprise Architects
Building Your Next Big Thing with Google Cloud Platform: A Guide for Developers and Enterprise Architects

Building Your Next Big Thing with Google Cloud Platform shows you how to take advantage of the Google Cloud Platform technologies to build all kinds of cloud-hosted software and services for both public and private consumption. Whether you need a simple virtual server to run your legacy application or you need to architect a...

E.Guide: San Francisco (Dk E > > Guides)
E.Guide: San Francisco (Dk E > > Guides)

Click onto www.esanfrancisco.dk.com for the latest news from and about places listed in the guide, plus readers’  reviews and chat, features on hot topics, and an up-to-the-minute short list of  San Francisco’s most useful service providers. The website is regularly updated, so every time you visit you bring your...

Making Millions For Dummies
Making Millions For Dummies

The must-have guide to achieving great wealth

Making Millions For Dummies lays out in simple, easy-to-understand steps the best ways to achieve wealth. Through a proven methodology of saving, building a successful business, smart investing, and carefully managing assets, this up-front, reliable guide shows readers how...

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