My first Publication Agile-Data-Warehouse-Design-eBook | 页面 306

A PPENDIX B: BEAM✲ N OTATION AND
S HORT C ODES
Table Codes
Event Story and Fact Table Types
C ODE M EANING /U SAGE
C HAPTERS
[DE] Discrete Event. Event represents a point in time or short duration
transaction that has completed. Implemented as a transaction fact table. 2, 8
[RE] Recurring Event. Event represents measurements taken at predictable
regular intervals. Implemented as a periodic snapshot fact table. 2, 8
[EE] Evolving Event. Event represents a process that takes time to complete.
Implemented as an accumulating snapshot fact table. 2, 4, 8
[TF] Transaction Fact table. Physical equivalent of a discrete event [DE]. Typi-
cally maintained by insert only. 5, 8
[AS] Accumulating Snapshot. Physical fact table equivalent of an evolving event
[EE]. Maintained by insert and update. Typically contains multiple milestone
date/time dimensions with matching duration and state count facts. 8
[PS] Periodic Snapshot. Physical fact table equivalent of a recurring event [RE].
Typically contains semi-additive facts. 8
[AG] Aggregate. Fact table that summarizes an existing fact table. 8
[DF] Derived Fact table. Fact table that is constructed by merging, slicing, or
pivoting existing fact tables. 8
{Source} Data source. Default source system table or filename. 5
287