问题描述
如何存储不包含任何事实的记录?例如，假设一家商店想要计算进入商店的人数(并且他们获取进入商店的每个人的信息).在仓库中，我猜会有不同属性的维度表人"，但事实表会是什么样子?它会只包含外键吗?
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?
推荐答案
正如你所描述的，那只是一个事实表.实际上，它有一个名字——factless 事实表；没有任何度量的事实表.
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.
重新编码事件很常见.基本上任何记录:who, what, where,when and why? 将是无事实测量表.如果你添加多少?，那么这就是一个度量.
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.
这篇关于仓库:存储(并计算)非事实记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！