Rules

  • Do not be hard on avoiding redundancy, if performance is the key
  • Multidimensional data is a different beast altogether
  • Centralize name value table design
  • Treat duplicate non-uniform data as your biggest enemy
  • Break your data into logical pieces, make life simpler\
  • What is the nature of the application (OLTP or OLAP)?

OLTP or OLAP

  • OLTP：执行较多的数据库事务，CRUD操作，需要设计Normalized Table
  • OLAP：执行较多的数据查询、分析，设计时通常将数据放在同一张表即可，不需要relay，此为Denormalized Table