Building the Data Warehouse

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

Certain elements of design beyond this point depend on one or the other of the technical cornerstones previously identified. At the least, the following should be established:

■■ The hardware platform(s) that will be used ■■ The operating system(s) that will be used ■■ The DBMS(s) that will be used ■■ The network software to be used

■    The language(s) to be used for development

In addition to whatever hardware, software, and networking will be used, it is helpful to establish the following as well:

■■ Node residency definition (for network systems)

■    Management of the system of record

PARAMETERS OF SUCCESS: A firm, workable, technical definition that will meet the needs of the system being developed.

D1—ERD (Entity Relationship Diagram)

PRECEDING ACTIVITY: Requirements formalization.

FOLLOWING ACTIVITY: Data item set specification.

TIME ESTIMATE: For even the largest of systems, two weeks suffice if the designers know what they are doing. If they don’t, the amount of time required here is indeterminate.


DELIVERABLE: Identification of major subject areas.

From the general set of formal requirements comes the need to identify the major subjects that will make up the system and the relationship of those major subjects. As a rule, the major subject is at the highest level of abstraction.

Typical major subjects are CUSTOMER, PRODUCT, TRANSACTION, and so forth. The relationships of the major subjects are identified, as well as the cardinality of the relationship.

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