FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:

FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   
BI Review content and features are now in DMReview.com!

One brand, one Web site! DM Review is now the home of all the content you're used to at BIReview.com and much more. If you are registered at BIReview.com, you're already registered at DM Review. If not, take just a moment to sign up for all the free services we have for you at the new DMReview.com.

DW Design, Methodology Channel

Articles

A Generalized Approach to the Creation of Bridge Records

Applied to data warehousing, a bridge table relates a fact record to one or more dimension records. Where a fact has a one-to-many relationship with a dimension, or many-to-many, you may choose to handle that with a bridge table

10 Mistakes to Avoid in a Business Intelligence Delivery

Every data warehousing and business intelligence project teaches us something. It is generally on failures, however, that we base our new success. You can learn from other’s failures, 10 of which are discussed in this article.

Real-Time Data Warehousing, Part 2

This article addresses the question “How is real time achieved?”

Using Data Virtualization to Maximize Return on Data Warehousing Investments

Today’s enterprises rely on the information in their data warehouses more than ever.

Essential Steps for the Integrated Enterprise Data Warehouse, Part 2

This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.

Columns

Data Warehousing Meets Data Archiving in Information Lifecycle Management

Data warehousing without archiving is like a garage that a family has used for several generations.

The Role of Packaged BI Applications in Delivering Enterprise-Wide BI and DW

This column explores addressing the role of packaged BI applications in an enterprise BI/DW architecture.

Broken Shells

Have you ever had to analyze or model a concept in your organization where enough changes could occur to create a completely new concept?

Hub and Spoke on the Wane?

Data warehousing has evolved with a DW becoming the data integration and data distribution hub feeding all the downstream feeds (spokes) to support BI applications.

CPM Information Bedrock, Part 2 - CPM Decomposed

Ask the Experts

Are there best practices or tools for creating a data dictionary?

Where is the best place for a BI application to reside?

What are your views on the advantages and/or disadvantages ETL tools and data modeling versus code?

When do you use a star schema and when to use a snowflake schema?

What are the pros and cons of including non-foreign key attributes in fact tables that are not metrics?

White Papers

Data Warehouses: What are they and how will they benefit your organization?

By by Guident Technologies, Inc.

Advances in Data Warehouse Performance

Books

The Enterprise Data Warehouse: Planning, Building, and Implementation

By Eric Sperley

Interactive Data Warehousing

By Harinder S. Singh

The Data Warehouse Method

By Tom Debevoise




Industry Vendors