After normalizing your data model as far as you have intended during the logical database design process , then include some degree of de - normalization as one of the potential performance tuning options 在逻辑数据库设计过程中,您可以毫无保留地规范化数据模型,然后再加入一定程度的反规范化,作为潜在的性能调优的一种选择。
The thesis also analyzes how to optimize the performance of the whole distance education supporting platform based on sql server7 . 0 database , and emphasizes on the four aspects of logical database design , index usability , query structure and procedure objects . it also discusses the extension of system functions from the point of view of database design in order to realize the distance education quality appraisal and tracking in the future 对基于sqlserver7 . 0数据库的整个远程教育支撑平台系统的性能优化进行分析,着重从逻辑数据库设计、索引的可用性、查询结构和过程对象的使用四个方面进行论述,并从数据库设计角度讨论了对系统进行功能扩展,以实现未来对远程教育质量评价和教学质量跟踪。