Introduction
Rule 1:- What is the Nature of the application(OLTP or OLAP)?
Rule 1:弄清(OLTP或OLAP)应用的本质是什么?
Rule 2:- Break your data in to logical pieces, make life simpler
Rule 2:将数据按照逻辑思维分成不同的块,让工作更简单
Rule 3:- Do not get overdosed with rule 2
Rule 3:当数据太多时,rule 2不适用
Rule 4:- Treat duplicate non-uniform data as your biggest enemy
Rule 4:将重复、不统一的数据视作你最大的敌人
Rule 5:- Watch for data separated by separators.
Rule 5:注意被分隔符分割的数据
Rule 6:- Watch for partial dependencies.
Rule 6:当心数据依赖
Rule 7:- Choose derived columns preciously
Rule 7:选择派生列
Rule 8:- Do not be hard on avoidingredundancy, if performance is the key
Rule 8:如果性能很关键,那么请不要避开冗余数据
Rule 9:- Multidimensional data is a different beast altogether
Rule 9:多维度收据绝对是一异类
Rule 10:- Centralize name value table design
Rule 10:集中名/值表的设计
Rule 11:- For unlimited hierarchical data self-reference PK and FK
Rule 11:无限制结构数据,自引用PK和FK
