Data Warehouse Bus Matrix
The tool we use to create, document, and communicate the bus architecture is
the data warehouse bus matrix, which we’ve illustrated in Figure 3.8.
Working in a tabular fashion, we lay out the business processes of the organization
as matrix rows. It is important to remember that we are identifying the
business processes closely identified with sources of data, not the organization’s
business departments. The matrix rows translate into data marts based
on the organization’s primary activities. We begin by listing the data marts
that are derived from a single primary source system, commonly known as
first-level data marts. These data marts are recognizable complements to their
operational source.
The rows of the bus matrix correspond to data marts. You should create separate
matrix rows if the sources are different, the processes are different, or if the matrix
row represents more than what can reasonably be tackled in a single implementation
iteration.
数据仓库总线矩阵
数据仓库总线矩阵是我们用于创建,记录和交流总线架构的工具,正如图3.8
引进表格,我们将公司的商业流程作为矩阵的行罗列出来。 重要的是我们要记住我们正在
确定和源数据一体的商业流程,而不是公司的商业部门。矩阵的行代表了位于公司主要活动基础上的数据集市。我们列出的数据集市是来单一主要源系统,也就是众所周知的第一级的数据集市。这些数据集市被认为是业务来源的补充。
总线矩阵的行对应着数据集市。如果来源不同,流程不同或是矩阵行代表着更多可以用单个实现方法重复解决,我们就应该创建单独的矩阵行。