-
Marketplace
-
Channel Resources
Articles from this Site
Netezza Enters Location Intelligence Market
Data Warehousing Meets Data Archiving in Information Lifecycle Management
The Role of Packaged BI Applications in Delivering Enterprise-Wide BI and DW
What are your views on the advantages and/or disadvantages ETL tools and data modeling versus code?
Where is the best place for a BI application to reside?
White Papers
Data Warehouses: What are they and how will they benefit your organization?
Advances in Data Warehouse Performance
Books
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 others 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
Todays 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 ImplementationBy Eric Sperley |
|
Interactive Data WarehousingBy Harinder S. Singh |
|
The Data Warehouse MethodBy Tom Debevoise |






