11 Steps to Successful Data Warehousing
Mining your corporate data for valuable customer information can improve your business performance. But it's not as simple as it sounds. Database Advisor article by Phillip Blackwood.
A Definition of Data Warehousing
Michael Reed of TechnologyEvaluation.Com gives a brief overview of the definition of a data warehouse.
Backward in Time
Ralph Kimball's Intelligent Enterprise article that offers tips for stitching late-arriving records into an existing data warehouse.
Classic articles in data warehousing
The articles are selected by DM Review editors as the most informative articles that have run in DM Review regarding business intelligence and data warehousing.
Data Mart Does Not Equal Data Warehouse
Bill Inmon article originally published in DM Review about the differences between a data mart and a data warehouse.
Data Security: Protecting the Warehouse from Withi
DM Direct article by Chris Silbernagel that outlines some of the primary issues and decision points of implementing a relational on-line analytical processing data warehouse with data security.
Data Warehouse Delivery: Federated FAQs
DM Review article by Douglas Hackney with some frequently asked questions about federated data warehouses.
Data Warehouse Delivery: How to Federate
DM Review article by Douglas Hackney that looks in more detail at how you build a federated BI architecture.
Data Warehouse Delivery: The Federated Future
DM Review article by Douglas Hackney that addresses federated data warehouse architecture.
Data Warehouse Delivery: When to Federate
DM Review article by Douglas Hackney discussing conditions that can merit a federated BI architecture.
Data Warehouse Quality Management
Laura Hadley examines ways in which organizations can think about quality in the data warehouse environment, as well as ideas for possible metrics to measure quality and extend warehouse value.
Developing a Data Warehouse Architecture
A data warehouse architecture is a description of the elements and services of the warehouse, with details showing how the components will fit together and how the system will grow over time.
Differences of Opinion
http://www.intelligententerprise.com/info_centers/dataWarehousing/showArticle.jhtml?articleID=178000
Ralph Kimball's Intelligent Enterprise article comparing the dominant approaches to enterprise data warehousing.
Factless Fact Tables
DBMS Online article by Ralph Kimball discussing two types of useful fact tables that contain no facts at all.
Help for Hierarchies
Ralph Kimball article from DBMS Online discussing how to use helper tables to handle dimensions with complex hierarchies.
How to do a Warehouse Assessment (And Why)
Arthur Moore and David Wells. The essence of data warehousing assessment is directed at refining the warehousing process and revitalizing the warehousing initiative.
Intelligent Enterprise Magazine
Offers both print and online-only articles, news and analysis focused on the business software strategies that enable IT and business decision-makers to plan, build, manage and purchase business critical enterprise applications.
Is Your Dimensional Data Warehouse Expressive?
Intelligent Enterprise Magazine article by Ralph Kimball completes the 20 criteria for rating your dimensional data warehouse by adding 8 expression criteria.
Kimball Group: articles and columns
The site gives access to Ralph Kimball and other Kimball Group members's columns and articles on data warehouse for the period 1995-2005.
Managing Current and Historical Views of Informati
Michael Jennings' DM Review article on managing current and historical views of information.
Managing Meta Data Within and Across Warehousing E
Many organizations must manage multiple warehousing initiatives underway simultaneously and these systems will most likely be based on products from multiple data warehousing vendors, in the typical decentralized approach of most corporations.
Many Alternate Realities
Intelligent Enterprise Magazine article by Ralph Kimball on the data warehouse design challenge of describing the past accurately.
Monster Dimensions
DBMS Online article by Ralph Kimball discussing design solutions for handling changes in very large dimensions.
Rating Your Dimensional Data Warehouse
Intelligent Enterprise Magazine article by Ralph Kimball that explains the first 12 of twenty criteria for comparing data webhouses.
Refreshment Strategies in the Data Warehouse Envir
William Inmon. Once the data warehouse is built, attention shifts from the building of the data warehouse to the day to day operations of making the data warehouse work.
Surrogate Keys
DBMS Online article by Ralph Kimball about keeping control over record identifiers by generating new keys for the data.
Teradata Review
Technical magazine for data warehouse professionals interested in NCR's Teradata database management system.
The Federated Data Warehouse
DM Review article by Colin White about federated data warehouses.
The Four Legs of a Successful Business Intelligenc
A successful BI project team is like a four-legged table - each leg holds up its share of the weight. Remove one and the project wobbles. The four legs of a team are Project Sponsorship and Governance, Project Management, Development Team (Core Team), and Extended Project Team.
The Problem with Dimensional Modeling
Bill Inmon's DM Review article discussing dimensional modeling.
The Unity Dimension
Nick Galemmo's Intelligent Enterprise article that offers a modeling solution for when differing entities share a role.