Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»

There are many more ways to structure data within the data warehouse. The most common are these:

■■ Simple cumulative ■■ Rolling summary ■■ Simple direct ■■ Continuous

At the key level, data warehouse keys are inevitably compounded keys. There are two compelling reasons for this:

■    Date—year, year/month, year/month/day, and so on—is almost always a part of the key.

■    Because data warehouse data is partitioned, the different components of the partitioning show up as part of the key.

Data Warehouse: The Standards Manual

The data warehouse is relevant to many people-managers, DSS analysts, developers, planners, and so forth. In most organizations, the data warehouse is new. Accordingly, there should be an official organizational explanation and description of what is in the data warehouse and how the data warehouse can be used.

Calling the explanation of what is inside the data warehouse a “standards manual” is probably deadly. Standards manuals have a dreary connotation and are famous for being ignored and gathering dust. Yet, some form of internal publication is a necessary and worthwhile endeavor.

The kinds of things the publication (whatever it is called!) should contain are the following:

■■ A description of what a data warehouse is

■■ A description of source systems feeding the warehouse

■■ How to use the data warehouse

■■ How to get help if there is a problem

■    Who is responsible for what

■    The migration plan for the warehouse

■    How warehouse data relates to operational data

Скачать в pdf «Building the Data Warehouse»