摘要
从范式优化、索引优化、表的优化及查询优化探讨数据库优化设计的方法,并对它们的综合使用进行分析。数据库优化设计时,在逻辑设计阶段,要根据范式优化及表优化中的要求设计数据库逻辑结构,对两者的利弊进行权衡,选出折衷的方案,既可以避免不一致性和数据异常现象,又不影响整体的性能;在数据库物理设计阶段,要根据索引优化中的要求在有关属性或属性的组合上建立索引,以优化数据库物理结构;在数据库查询阶段,采用在条件子句中使用索引,嵌套查询,迟早执行选择操作,迟早消除不满足条件的记录,分组计数和避免困难的正规表达式6种优化策略,可大大提高查询效率。
Four methods of database design optimizing are discussed in standardizing relation pattern,constituting index and temporary table,optimizing query semanteme.At the stage of logical design,logical structure has to be designed based on the demands of normal form and table optimizings.A moderate scheme is chosen by the comparison of advantages and disadvantages of these two options to avoid,disaccord and data abnormity.At the stage of database physical design, some indices need to be established on the relative attributes according to the demands of index optimization to optimize database physical structure. Six kinds of query optimization are revealed to improve query efficiency.
出处
《广西科学院学报》
2005年第2期118-121,共4页
Journal of Guangxi Academy of Sciences
