Advantages and disadvantages of paradigm and anti-paradigm
When designing databases, there are paradigm and anti-paradigm considerations. The following is a summary.
Advantages of paradigm:
1) more rapid updates of the paradigm-based database;
2) After normalization, there is only a small amount of duplicate data, and only less data needs to be modified;
3) The table in the paradigm is smaller and can be executed in the memory;
4) there is very little redundant data and fewer distinct or group by statements are required during query.
Disadvantages of paradigm:
5) for a paradigm-based table, many associations are often required during query, because there is no redundancy or duplicate data in a single table. As a result, more complex query statements may need to be associated multiple times in the schema of the query paradigm. This increases the query cost and may also invalidate some index policies. Because normalization stores columns in different tables, these columns can belong to the same index in a table.
Advantages of anti-paradigm:
1) Avoid association because almost all data can be displayed on a table;
2) Effective indexes can be designed;
Disadvantages of anti-paradigm:
3) The table has a lot of redundancy. deleting data may cause some useful information loss in the table.
Therefore, when designing databases, you should pay attention to mixing paradigm and anti-paradigm.