KG header
consultingkimball universityeventsbooks
articles
articles by date
fundamentals
architecture
data staging
user interface
security
project lifecycle
related tech
design tipspowerful ideasabout uscontact ussite map

  


Articles: Data Warehouse Architecture and Modeling
  -Bus Architecture and Conformed Dimensions/Facts
  -Advanced Dimension Topics
  -Advanced Fact Table Topics
  -Aggregates and Aggregate Navigation
  -Industry- and Application-Specific Issues

The Anti-Architect (1/14/2002)
How not to design and roll out a data warehouse

What Not to Do (10/24/2001)
Dimensional modeling mistakes to guard against

There Are No Guarantees (8/1/2000)
Entity-relation modeling is far from being a universal solution for data warehouse business rules

Enforcing the Rules (8/18/2000)
Most data warehouses do a poor job of supporting business rules: We can do better

The Software Developer in Us (9/8/2000)
Data warehouse designers have a lot to learn from good, old-fashioned software developers

Rating Your Dimensional Data Warehouse (4/28/2000)
The first twelve of the twenty criteria for comparing your systems

Is Your Dimensional Data Warehouse Expressive? (5/15/2000)
The final eight criteria for comparing your systems

The Millenium Ahead (1/1/2000)
Comments on change enveloping us and some predictions

Working in Web Time (11/16/1999)
An Architecture for the Webhouse, the web enabled data warehouse

The Data Webhouse Has No Center (7/13/1999)
Facing the challenges of profoundly distributed data warehouse design (Distributed DWs, ODS, Response Cache)

Stirring Things Up (6/22/1999)
Renaming the data warehouse; losing the center; ERP vendors feed the webhouse

Brave New Requirements for Data Warehousing, part 1 (10/1998)
Decentralized incremental development; continuous change; rapid deployment; atomic data: data marts make the data warehouse

Coping With The Brave New Requirements, part 2 (11/1998)
Designing the data warehouse to address the requirements from part 1

A Dimensional Modeling Manifesto (8/1997)
Drawing the line between dimensional modeling and ER modeling techniques (Feature Article)
Warning! This article is the most pugnacious article I ever wrote.
It definitely made its points, even if it riled a few folks with its tone.


Dangerous Preconceptions (8/1996)
Discovering the liberating truths that can lead to a successful data warehouse project

Is ER Modeling Hazardous to DSS? (10/1995)
Don't assume that an ER model is suitable for building a decision support database

The Database Market Splits (9/1995)
Data Warehousing gets the data out. The first Kimball article: DBMS Magazine

Home  |  Kimball University  |  Consulting  |  Events  |  Books  |  Articles  |  Design Tips  |  Commentary  |  About Us  |  Contact Us  |  Site Map