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