基于數(shù)據(jù)庫(kù)查詢過程優(yōu)化設(shè)計(jì)

在大型關(guān)系數(shù)據(jù)庫(kù)管理與開發(fā)中，優(yōu)化設(shè)計(jì)極大地提高數(shù)據(jù)庫(kù)的性能。通過對(duì)一大型數(shù)據(jù)庫(kù)查詢語句執(zhí)行過程的討論，提出了對(duì)同一表格進(jìn)行多個(gè)選擇運(yùn)算的優(yōu)化、多個(gè)表格的選擇運(yùn)算的優(yōu)化、多個(gè)表格的聯(lián)結(jié)兼選擇運(yùn)算的優(yōu)化、應(yīng)用窗口優(yōu)化和索引優(yōu)化設(shè)計(jì)方法，經(jīng)實(shí)際應(yīng)用驗(yàn)證，其優(yōu)化過程簡(jiǎn)便、有效，可達(dá)到減少計(jì)算量和內(nèi)存需求，提高了查詢響應(yīng)的速度，極大地改善數(shù)據(jù)庫(kù)性能，具有較強(qiáng)的實(shí)用性。
關(guān) 鍵 詞 關(guān)系數(shù)據(jù)庫(kù); 查詢優(yōu)化; 窗口優(yōu)化; 索引優(yōu)化

Abstract In the management and development of large-scaled database, optimized design can improve its functions greatly. According to the discussion on performing query language of a large-scaled database, the authors propose an optimized design --- optimizing multi-choice operation on the same form, choice operation on multi-forms, connection & choice operation on multi-forms, the using window and index. In practical application, the process of optimization, which is simple and effective, can decrease the amount of counting and internal storage, can speed up query execution and performance and has a stronger usage.
Key words relational database; query optimization; window optimization; index optimization