基于关系模型规范化理论查询效率研究  

Query Efficiency Research Based on Relational Model Standardization Theory

作　　者：朱蕾蕾[1] 李莉[1] 刘丹[1] 

机构地区：[1]长春理工大学计算机科学技术学院,长春130022

出　　处：《计算机光盘软件与应用》2011年第5期30-31,共2页Computer CD Software and Application

摘　　要：数据库规范化理论是关系模型中最广泛的理论，含义是将一个关系模型经过一定转换，分解为多个关系模型，通过层层优化，最终达到实体或实体关系间的一对一关系。但当强调某些特殊查询情况时，规范化程度过高的范式模型，并不能达到最优查询效率，因此根据情况需要通过反规范化理论的相关方法设计关系模型。本文将着重从查询数据性能的角度，通过LoadRnuner软件进行测试，对比特殊情况下两种模型的差别。Database standardization theory is the most extensive theoryin relation model,meaning a relation model is after a certain conversion,decomposition for multiple relation model,through the layers of optimization,achieve finally the one-to-one relationships between entity or entities relationship.But when stressed,some special inquiring cases,the paradigm high degree of standardisation cannot achieve model,and the optimal inquires the efficiency that, according to the circumstances to design relations model on the related method of the reverse standardization theory.This paper emphatically from the Angle of the performance of data query, through LoadRnuner software testing,contrast the difference of two models on the special circumstances.

关 键 词：关系模型 规范化 反规范化 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]