Data Vault数据库建模指南.pdf

the scope of the broader initiative are then answered by this designation. In short, the

organization contemplating this initiative is committing to an integrated, non-volatile, time

variant and business key driven data warehouse program.

The data vault principles are specifically well suited for such a program and – when applied

consistently – can provide the organization with some very compelling benefits. These

include auditability, agility, adaptability, alignment with the business, and support for

operational data warehousing initiatives.

To gain these benefits however, the organization will need to commit to both EDW program

level factors as well as specific data vault modeling patterns, rules and methods. This guide

presents data vault modeling in the context of the EDW.

The Enterprise Data Warehousing (EDW) Program represents the ongoing data warehousing

activities of the organization. These activities will include the maintenance functions of the

data warehouse in addition to the continuous flow of incremental projects related to the

enterprise data warehouse. These incremental projects are comprised of

a) Adapting to new data sources from internal new systems, external integrations,

and from acquisitions, and

and changes to operational latency requirements.

For this reason, the EDW itself is not designated a “project” (there is no discernable

beginning and end, and no pre-determined set of specific goals).

In a broader sense, this program can be defined as the BI Function or BI Program within an

organization. To be clear however, this is not simply the group that owns the OLAP tools.

This is the higher level view of all data warehousing and business intelligence (DWBI) within

the organization which includes the business intelligence competency center or BICC, the

EDW or CDW team, the related governance components and the environment both technical

and organizational. The success of a DWBI program depends on an organizational

commitment and a corporate BI culture.