Think Globally, Act Locally
International warehouse designs; localization; character sets;
currencies; calendars
December, 1998, volume 1, Issue 3
Coping With The Brave New Requirements
Designing the data warehouse to address the requirements (from the October issue)
November, 1998, volume 1, Issue 2
Brave New Requirements for Data Warehousing
Decentralized incremental development; continuous change; rapid deployment; atomic data: data marts make the data warehouse
October, 1998, volume 1, Issue 1
DBMS Magazine articles by Ralph Kimball, 1995 to 1998
(The following are Data Warehouse Architect columns except where indicated)
Help for Hierarchies
Helper tables handle dimensions with complex hierarchies
September, 1998 (Vol 11, Num 9) Page 12
Help for Dimensional Modeling
Helper tables let you design and manage multivalued dimensions successfully
August, 1998 (Vol 11, Num 8) Page 14
Professional Boundaries
Defining what a data warehouse manager should (and shouldn't) do
July, 1998 (Vol 11, Num 7) Page 14
Pipelining Your Surrogates
High performance design of surrogate key system; Referential integrity; Slowly changing dimensions
June, 1998 (Vol 11, Num 6) Page 18
Surrogate Keys
Keep control over record identifiers by generating new keys for the data warehouse
May, 1998 (Vol 11, Num 5) Page 14
Is Data Staging Relational?
Or does it have more to do with sequential processing?
April, 1998 (Vol 11, Num 4) Page 14
Meta Meta Data Data
Making a list of data about metadata and exploring information cataloging tools
March, 1998 (Vol 11, Num 3) Page 18
Human Reources Data Marts
Design guidelines for querying and analyzing employee data
February, 1998 (Vol 11, Num 2) Page 16
The Operational Data Warehouse
It needs both a transaction version of data and a periodic snapshot version of data
January, 1998 (Vol 11, Num 1) Page 14
Bringing Up Supermarts
A step-by-step approach to building a data warehouse from granular data (Feature Article)
January, 1998 (Vol 11, Num 1) Page 47