维度表需要作为主键数据的通用键;这将作为事实表的外键。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
Informix的序号很适合作为通用键,并且我非常热衷于在每个维度表中使用序号列。
Informix serial Numbers work really well as generalized keys, and I am a fan of using a serial number column on all dimension tables.
为基于主键、外键和索引的通用查询提供访问
Provides access to common queries based on primary keys, foreign keys, and indexes.
应用推荐