规范与反规范在数据库设计中的应用

在数据库设计中规范与反规范通常是一对相互对立的矛盾体,困扰着数据库关系模型的建立,从合理的关系模型及提高数据库操作性能两个角度分析了他们各自的优缺点,并提出了几种合理有效策略来协调处理它们的关系,进行了深入分析,较好地改善了数据库的关系设计,在实际数据库设计中具有一定的指导价值。

Application of Standardization and Non-standardization in Designing Database

Standardization and non -standardization are generally contradictory in the process of designing the database,which embarrasses user to build the entity relation of database. This article analysis the advantages and disadvantage from the reasonable relation modeling and the improvement of database operation efficiency. It also presents some new efficient methods to correspond those conflicts,and gives analysis more deeply,which improves the relation design better. At last,the rationality of the new methods is been proved in the practical application.