读《数据仓库工具箱：维度建模的完全指南》之第三章开篇

Inventory

 

In Chapter 2 we developed a dimensional model for the sales transactions in a

large grocery chain. We remain within the same industry in this chapter but

move up the value chain to tackle the inventory process. The designs developed

in this chapter apply to a broad set of inventory pipelines both inside and

outside the retail industry.

Even more important, this chapter provides a thorough discussion of the data

warehouse bus architecture. The bus architecture is essential to creating an

integrated data warehouse from a distributed set of related business processes.

It provides a framework for planning the overall warehouse, even though we

will build it incrementally. Finally, we will underscore the importance of using

common, conformed dimensions and facts across the warehouse’s dimensional

models.

Chapter 3 discusses the following concepts:

__ Value chain implications

__ Inventory periodic snapshot model, as well as transaction and accumulating

snapshot models

__ Semi-additive facts

__ Enhanced inventory facts

__ Data warehouse bus architecture and matrix

__ Conformed dimensions and facts

 

 

库存

 

在第二章中，我们为某个大型连锁杂货市场的销售建立了纬度模型。在本章中我们仍然停留在

这个行业中，但是我们将价值链移到库存流程处理上。本章的开发设计主要应用于零售行业内外的一套广泛的存货渠道。

 

更重要的是，本章将对数据仓库总线架构进行深入讨论。总线架构对根据一系列相关的分布式商业流程来创建完整的数据仓库是非常必要的。即使我们以后要不断的构造它，总线架构提供了设计整个数据仓库的框架。最后，我们将强调使用共同的，一致性的纬度和事实来贯穿数据仓库模型的重要性。

 

第三章讨论以下内容

 

价值链推断

象交易和积累快照模型一样，库存周期快照模型

半添加性的事实

加强库存事实

数据仓库总线架构和矩阵

一致的纬度和事实