Keys
- Natural Key(自然键)
- Surrogate Key(代理键)
- Primary Key(主键)
- Foreign Key(外键)
- Composite key(组合键)
- Candidate key(候选键)
- Alternate key(辅助键)
Tables
- Integration Table(集成表)
- Dimension Table(维度表)
- Fact Table(事实表)
- Bridge (Fact) Table(桥接表)
- Aggregate (Fact) Table(聚集表)
- Snapshot (Fact) Table(快照表)
- Zipper (Fact) Table(拉链表)
- Related (Fact) Table(连接表)
- Wide Table(宽表)
- Temporary Table(临时表)
With Table
Memory Table
Replicated Table - External Table(外部表)
Others
- Index
- View
- Data Types(Numeric Types, Date/Time Types, String Types, Misc Types, Complex Types<Array, Map, Struct, Union>)
- Partitioned
- Buckets - Clustered[Sorted] - Round Robin, Hash Distributed
- Skewed
- Row Format
- File Format(Orc, Parquet, Avro)
- Flat
- Relation
- Cardinality
Links
- Author:HyperJ
- Source:HyperJ’s Blog
- Link:Data Table
近期评论