| 引用本文： |
-
吴璟莉,刘仁辉,何冬黎.数据库优化设计方法初探[J].广西科学院学报,2005,(2):118-121. [点击复制]
- Wu Jingli,Liu Renhui,He Dongli.Discussion on Optimization of Database Design[J].Journal of Guangxi Academy of Sciences,2005,(2):118-121. [点击复制]
|
|
| 摘要: |
| 从范式优化、索引优化、表的优化及查询优化探讨数据库优化设计的方法,并对它们的综合使用进行分析。数据库优化设计时,在逻辑设计阶段,要根据范式优化及表优化中的要求设计数据库逻辑结构,对两者的利弊进行权衡,选出折衷的方案,既可以避免不一致性和数据异常现象,又不影响整体的性能;在数据库物理设计阶段,要根据索引优化中的要求在有关属性或属性的组合上建立索引,以优化数据库物理结构;在数据库查询阶段,采用在条件子句中使用索引,嵌套查询,迟早执行选择操作,迟早消除不满足条件的记录,分组计数和避免困难的正规表达式6种优化策略,可大大提高查询效率。 |
| 关键词: 数据库 优化设计 范式 索引 临时表 查询 |
| DOI： |
| 投稿时间：2004-12-07修订日期：2005-01-07 |
| 基金项目: |
|
| Discussion on Optimization of Database Design |
|
Wu Jingli1, Liu Renhui2, He Dongli1
|
| (1.Dept. of Math. & Comp. Sci., Guangxi Normal Univ., Guilin, Guangxi, 541004, China;2.Guilin Airforce Academy, Guilin, Guangxi, 541003, China) |
| Abstract: |
| 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. |
| Key words: database design optimizing normal form index temporary table query |
