Index
As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.
A
accumulating snapshot fact tables 219
additive facts 219
alternate keys (AKs)
as unique constraints 80
associative entity 123
atomic grain 110
attributes 22
adding 121
attributes, as columns 70
semi-structured data, storing 72
Snowflake data types 71
auditability 265
B
Boyce-Codd Normal Form (BCNF) 138, 141, 142
bridge table 256, 264
Business Event Analysis and Modeling (BEAM) method 106
business intelligence (BI) 31
tools 85
business key 78, 200
Business Vault 264
bus matrix
visualizing, in conceptual model 112, 113
C
cache
metadata cache 44
query results cache 44
services layer 44
storage layer 45
using 43
warehouse cache 45
candidate key 139
capital expenditure (CapEx) 36
cardinality 22
...
