术语表

81 条维度建模技法术语，按 Kimball 官方技法类别分组。

Fundamental Concepts

技法 Business processes 双语技法 Collaborative dimensional modeling workshops 双语技法 Dimensions for descriptive context 双语技法 Facts for measurements 双语技法 Four step dimensional design process 双语技法 Gather business requirements and data realities 双语技法 Graceful extensions to dimensional models 双语技法 Grain 双语技法 Star schemas and OLAP cubes 双语

Basic Dimension Table Techniques

技法 Calendar date dimension 技法 Degenerate dimensions 技法 Denormalized flattened dimensions 技法 Dimension surrogate keys 技法 Dimension table structure 技法 Drilling down 技法 Flags and indicators as dimension attributes 技法 Junk dimensions 技法 Multiple hierarchies in dimensions 技法 Natural, durable and supernatural keys 技法 Null attributes in dimensions 技法 Outrigger dimensions 技法 Role playing dimensions 技法 Snowflaked dimensions

Advanced Dimension Table Techniques

技法 Abstract generic dimensions 技法 Aggregated facts as dimension attributes 技法 Audit dimensions 技法 Behavior study group 技法 Behavior tag time series 技法 Dimension-to-dimension table joins 技法 Dynamic value banding 技法 Hot swappable dimensions 技法 Late arriving dimensions 技法 Measure type dimensions 技法 Multiple time zones 技法 Multivalued dimensions and bridge tables 技法 Step dimensions 技法 Text comments

Basic Fact Table Techniques

技法 Accumulating snapshot fact tables 技法 Additive, semi-additive, and non-additive facts 技法 Aggregated fact tables or cubes 技法 Conformed facts 技法 Consolidated fact tables 技法 Fact table structure 技法 Factless fact tables 技法 Nulls in fact tables 技法 Periodic snapshot fact tables 技法 Transaction fact tables

Advanced Fact Table Techniques

技法 Allocated facts 技法 Centipede fact table 技法 Fact table surrogate key 技法 Header/line fact tables 技法 Lag/duration facts 技法 Late arriving facts 技法 Multipass SQL to avoid fact-to-fact table joins 技法 Multiple currency facts 技法 Multiple units of measure 技法 Numeric values as attributes or facts 技法 Profit and loss fact tables using allocations 技法 Timespan tracking in fact tables 技法 Year-to-date facts

Dimension Hierarchy Techniques

技法 Fixed depth positional hierarchies 技法 Ragged/variable depth hierarchies 技法 Slightly ragged/variable depth hierarchies

Slowly Changing Dimension Techniques

技法 Type 0: Retain original 技法 Type 1: Overwrite 技法 Type 2: Add new row 技法 Type 3: Add new attribute 技法 Type 4: Add mini-dimension 技法 Type 5: Add mini-dimension and Type 1 outrigger 技法 Type 6: Add Type 1 attributes to Type 2 dimension 技法 Type 7: Dual Type 1 and Type 2 dimensions

Integration via Conformed Dimensions

技法 Conformed dimensions 技法 Drilling across 技法 Enterprise data warehouse bus architecture 技法 Enterprise data warehouse bus matrix 技法 Opportunity/stakeholder matrix 技法 Shrunken rollup dimensions 技法 Value chain

Special Purpose Schemas

技法 Error event schemas 技法 Real-time fact tables 技法 Supertype and subtype schemas for heterogeneous products