We are often asked about degenerate dimensions in our modeling workshops. Degenerate dimensions cause confusion since they don’t look or feel like normal dimensions. It’s helpful to remember that according to Webster, “degenerate” refers to something that’s 1) declined from the standard norm, or 2) is mathematically simpler.
A degenerate dimension (DD) acts as a dimension key in the fact table, however does not join to a corresponding dimension table because all its interesting attributes have already been placed in other analytic dimensions. In most of cases,degenerate dimensions has been treated as no other attributes related.
Degenerate dimensions commonly occur when the fact table’s grain is a single transaction (or transaction line). Transaction control header numbers assigned by the operational business process are typically degenerate dimensions, such as order, ticket, credit card transaction, or check numbers. These degenerate dimensions are natural keys of the “parents” of the line items.
Even though there is no corresponding dimension table of attributes, degenerate dimensions can be quite useful for grouping together related fact tables rows. Besides, these are the types of attributes that are typically going to be used in drilldown or data mining scenarios. For example, retail point-of-sale transaction numbers tie all the individual items purchased together into a single market basket. In health care, degenerate dimensions can group the claims items related to a single hospital stay or episode of care. Another example, imagine a user who is analyzing purchase orders in the “delayed” status. After drilling down on the delayed POs for a certain supplier in a certain time period…the next step might be to pick up the Purchase Order Number which would allow this user to trace this small subset of PO’s back to the source system to find out why they are “delayed”.
We sometimes encounter more than one DD in a fact table. For example, an insurance claim line fact table typically includes both claim and policy numbers as degenerate dimensions. A manufacturer could include degenerate dimensions for the quote, order, and bill of lading numbers in the shipments fact table.
Degenerate dimensions also serve as a helpful tie-back to the operational world. This can be especially useful during data staging development to align fact table rows to the operational system for quality assurance and integrity checking.
We typically don’t implement a surrogate key for a DD. Usually the values for the degenerate dimension are unique and reasonably sized; they don’t warrant the assignment of a surrogate key. However, if the operational identifier is a unwieldy alpha-numeric, a surrogate key might conserve significant space, especially if the fact table has a large number of rows. Likewise, a surrogate key is necessary if the operational ID is not unique over time or facilities. Of course, if you join this surrogate key to a dimension table, then the dimension is no longer degenerate.The point that I want to make is that degenerates are natural keys such as order ID. They are not attributes such as order product ordered. And degenerate dimension will likely be at or close to the same grain as the fact table.
During design reviews, we sometimes find a dimension table growing proportionately with the fact table. As rows are inserted into the fact table, new rows are also inserted into a related dimension table, often at the same rate as rows were added to the fact table. This situation should send a red flag waving. Usually when a dimension table is growing at roughly the same rate as the fact table, there is a degenerate dimension lurking that has been missed in the initial design.
参考至:https://www.youtube.com/watch?v=txad_fAijGU
http://byobi.com/blog/2013/09/dimensional-modeling-junk-vs-degenerate/
http://en.wikipedia.org/wiki/Degenerate_dimension
http://www.kimballgroup.com/2003/06/design-tip-46-another-look-at-degenerate-dimensions/
如有错误,欢迎指正
邮箱:czmcj@163.com
相关推荐
6.3.1 Degenerate dimensions(降解维度) 15 6.3.2 父子维度 16 6.4 star(星形)和snowflake(雪花)模型 18 6.4.1 Shared dimensions(共享维度) 19 7 Pentaho资源库及存储 20 8 Pentaho资源库的本地化 21 8.1 ...
退化椭圆方程的变号解,代晋军,彭双阶,本文研究一类退化椭圆问题,这个问题涉及到著名的Caffarelli-Kohn-Nirenberg不等式。我们首先证明一个全局紧结果,然后证明这个问题的变号解
Degenerate 是与一起使用的随机数据生成器。 安装 将此行添加到应用程序的 Gemfile 中: gem 'degenerate' 然后执行: $ bundle install 接下来在您的spec/spec_helper.rb文件中要求它: require 'degenerate...
混沌信号调制所致的简并光学参量振荡器系统动力学行为 ,马军,,对于简并光学参量振荡器进行了研究。通过采用LORENZ混沌信号来调制简并光学参量振荡器中电场的强度和周期。数值计算表明:恰当的混
>> > from degenerate_dna import Degenera >> > dna = 'AGTTCT' >> > res = Degenera ( dna = dna , table = 1 , method = 'S' ) >> > res . degenerate () >> > res . degenerated 'AGYAGY' 安装 pip install ...
退化椭圆方程Keldys-Fichera边值问题的正则性,李俐玫,马天,本文用锐角原理,反向Holder不等式和推广的Poincare不等式研究了Keldys-Fichera边值问题下退化椭原方程弱解的内部正则性及更高阶的正则性�
Rn 上完全非线性退化抛物系统无界黏性解的存在,王俊芳,,本文利用耦合黏性上下解技巧证明了Rn 上退化抛物系统的比较原理成立,并且利用Perron 方法证明了黏性解的存在唯一性。
锥奇异流形上具奇异位势的退化椭圆方程解的存在性,陈化,魏雅薇,这篇文章研究了锥奇异流形上的一类具有奇异位势的退化椭圆方程的狄利克雷问题.通过锥sobolev不等式和锥hardy不等式, 证明了非平凡解的
向量值函数空间中二阶退化微分方程的最大正则性,步尚全,蔡钢,本文在周期 Lebesgue-Bochner 空间 $L^p(mathbb{T},X)$ , 周期 Besov 空间 $B_{p,q}^s(mathbb{T},X)$ 和周期 Triebel-Lizorkin 空间$F_{p,q}^s(mathbb...
可退化条件下拟线性倒向随机偏微分方程及其与正倒向随机微分方程的联系,杜恺,张奇,在不假设技术性条件下,本文研究了可退化条件下拟线性倒向随机偏微分方程(简记为BSPDE)的Cauchy问题。首先证明了退化条件下拟线性...
带加权局部源项的退化抛物方程解的一致爆破速率,曾维理,,本文研究一类带 Dirichelet 边界条件的退化抛物方程 $u_t - {\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\triangle u^m} = a(x)u^...
$ npm install remove-degenerate-cells 用法 单独使用单元格索引 var removeDegenerateCells = require ( 'remove-degenerate-cells' ) ; var mesh = { cells : [ [ 0 , 1 , 2 ] , [ 0 , 1 , 1 ] ] , ...
含临界指数的退化强制和无界参数拟线性椭圆型方程的正解,沈尧天,王友军,在本文中, 我们研究两类退化限制拟线性椭圆型方程, 记为I$_{dc}$和II$_{dc}$,以及两类无界参数的拟线性椭圆型方程,记为I$_{ub}$ 和 II$_{ub...
We have observed for the first time degenerate four-wave mixing from dye-doped nematic microdroplets. We have demonstrated the possibility of observing amplified in wave front conjugation, using the ...
基于光纤延迟线的简并式光交换结构仿真代码
Non-Rigid Structure-From-Motion on Degenerate Deformations With Low-Rank Shape Deformation Model
A frequency-degenerate cavity (FDC) is the resonator that the ratio of transverse and longitudinal mode frequency spacings is a simple rational number. When an optical resonator is close to the FDC, ...
We report on the enhancement of phase conjugation degenerate four-wave mixing (DFWM) in hot atomic Rb vapor by using a Bessel beam as the probe beam. The Bessel beam was generated using cross-phase ...
Dual-wavelength filters based on two-dimensional photonic crystal degenerate modes with a ring dielectric rod inside the defect cavity
The robust stability of uncertain linear degenerate systems with discrete and distributed delays is studied in this paper. The uncertainties under consideration are norm bounded,and possibly time ...