查询处理过程中的优化策略研究-河北工业科技-河北科技大学.PDFVIP

22 1 河 北 工 业 科 技 Vol. 22, No . 1 2005 1 H ebei Journal of Industrial Science and Technology Jan. 2005 : 100 1534( 2005) 1, 2 3 1 1 4 , , , , ( 1 河北科技大学经济管理学院, 河北石家庄 05001 ; 2 北京理工大学信息科学技术学院, 北京 1000 1; 3河北省残疾人联合会, 河北石家庄 0500 1; 4 河北科技大学机械电子工 学院, 河北 石家庄 050054) : 随着业务量的激增, 各种行业中数据库的规模逐渐扩大, 其结构的复杂性不断加大, 与之相 关的各类数据库管理系统( DBM S) 一定要迅速完善自身的性能, 才能更好地满足难度日益增大的 信息查询要求作为解决途径之一, 优化策略的选择与落实是十分重要的因素对各种数据库产 品中的优化器在处理查询时所采用的优化策略进行了一定的研究, 并结合实例作了进一步阐明 : 查询; 优化策略; 数据库; DBM S : T P311131 : A Research on the optimization strategy used w hen coping w ith queries 1, 2 3 1 1 4 LIU Bin , WU Yan , WANG Yuheng , SHAO Dong , LIU Zhenyu ( 1. College of Economics and Management, H ebei University of Science and Technology, Shijiazhuang H ebei 05001 , China; 2. College of Information Science and Technology , Beijing Institute of Technology, Beijing 1000 1, China; 3H ebei H andicappeds League, Shijiazhuang Hebei 0500 1, China; 4. College of M echanical and Electronic Engineering, H ebei University of Science and Technology, Shijiazhuang Hebei 050054, China) Abstract :As business becomes heavier than ever, the record amount and structure complexity of the dat abase used inevery field are also improved. To satisfy the query demands that become more and more intense, something should be done to improve the relat ed DBMS performance.As one of them, Opt imization Strategys selection and implementation is very important. This article does some research on the strategies used by the famous DBM Soptimizer to cope wit h queries, and also provides some samples. Key words: query; optimization st rategy; database; DBM S , 1 , 3 , DBM S( Database M anagement