仓库：存储（和计数）非实际记录？ [英] Warehouse: Store (and count) non-fact records?

问题描述

如何存储不包含任何事实的记录？例如，假设商店想要计算有多少人进入商店（并且他们为商店内的每个人获取信息）。在仓库中，我想有维度表Person具有不同的属性，但是事实表怎么样？它只包含外键？

How to store records that don't contain any fact? For example, let's say that a shop wants to count how many people have entered inside a store (and that they take info on every person that goes inside the shop). In warehouse, I guess there would be dimension table "Person" with different attributes, but how would fact table look like? Would it contain only foreign keys?

推荐答案

正如你所说的，这只是一个事实表。实际上，这个 - 事实型事实表的名称;事实表没有任何措施。

As you described it, that would be just a fact table. Actually, there is name for this -- factless fact table; fact table without any measures.

这是很常见的重新编码事件。基本上任何记录：谁，什么，在哪里，何时和为什么？将是事实无测量表。如果你添加多少？那么进入一个度量。

It is quite common for recoding events. Essentially anything that records: who, what, where, when and why? would be fact-measure-less table. If you add how much? then that goes into a measure.

这篇关于仓库：存储（和计数）非实际记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！