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.
Factless Fact Tables - DBMS Online article by Ralph Kimball discussing two types of useful fact tables that contain no facts at all.
Surrogate Keys - DBMS Online article by Ralph Kimball about keeping control over record identifiers by generating new keys for the data.
Monster Dimensions - DBMS Online article by Ralph Kimball discussing design solutions for handling changes in very large dimensions.
Managing Meta Data Within and Across Warehousing Efforts - 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.
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.
Many Alternate Realities - Intelligent Enterprise Magazine article by Ralph Kimball on the data warehouse design challenge of describing the past accurately.
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.
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.
Help for Hierarchies - Ralph Kimball article from DBMS Online discussing how to use helper tables to handle dimensions with complex hierarchies.
The Unity Dimension - Nick Galemmo's Intelligent Enterprise article that offers a modeling solution for when differing entities share a role.
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.
Teradata Review - Technical magazine for data warehouse professionals interested in NCR's Teradata database management system.
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.
Backward in Time - Ralph Kimball's Intelligent Enterprise article that offers tips for stitching late-arriving records into an existing data warehouse.
A Definition of Data Warehousing - Michael Reed of TechnologyEvaluation.Com gives a brief overview of the definition of a data warehouse.
Differences of Opinion - Ralph Kimball's Intelligent Enterprise article comparing the dominant approaches to enterprise data warehousing.
The Four Legs of a Successful Business Intelligence (BI) Project Team - 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.
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.
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.
Beware the Objection Removers - Intelligent Enterprise article by Ralph Kimball that encourages you to ask questions when sales pitches fly in the face of conventional wisdom.
Seven Principles for Enterprise Data Warehouse Design - DMReview article by Rich Cohen providing principles for data warehouse design.
B-EYE-Network - Delivers industry-based business intelligence, business performance management, data warehousing and data quality content.
Data Warehouse Delivery: Federated FAQs - DM Review article by Douglas Hackney with some frequently asked questions about federated data warehouses.
Data Warehouse Delivery: When to Federate - DM Review article by Douglas Hackney discussing conditions that can merit a federated BI architecture.
Data Warehouse Delivery: The Federated Future - DM Review article by Douglas Hackney that addresses federated data warehouse architecture.
The Federated Data Warehouse - DM Review article by Colin White about federated data warehouses.
Managing Current and Historical Views of Information in The Data Warehouse - Michael Jennings' DM Review article on managing current and historical views of information.
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 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.
The Problem with Dimensional Modeling - Bill Inmon's DM Review article discussing dimensional modeling.
Data Security: Protecting the Warehouse from Within - 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.
|