期刊文献+

基于用户查询计划的优化策略

Optimization Strategies Based on the User's Query
下载PDF
导出
摘要 在数据库系统中,查询优化对于提高数据库性能具有重大意义。文中通过对数据库和SQL语句的研究,分别从这两方面提出了查询优化过程中对用户查询计划的优化策略,减少了查询的计算量,提高了查询的响应速度,显著提高了数据库性能,具有较强的可操作性和实用性。 In the database system, query optimization is of great significance for improving database performance. Based on the research of the database and SQL, the optimized strategy for user query plan separately from these two aspects is proposed . It reduced the computation load, raised the speed of response, obviously enhanced the database performance and had strong feasibility and practicability.
出处 《科学技术与工程》 2007年第9期2095-2097,共3页 Science Technology and Engineering
关键词 用户查询计划 索引优化 SQL语句优化 wser guery plan optimiged index SQL optimigation
  • 相关文献

参考文献2

二级参考文献14

  • 1H J Lu, B C Ooi, C H Goh. Multi-Database Query Optimization: Issues and Solutions. In proc. RIDE-IMS, 1993:137~143.
  • 2L Serafini, C Ghidini. Using Wrapper Agents to Answer Queries in Distributed Information Systems. Proceedings of the First Biennial int. conf. On advances in information sysems (ADVIS2000), 2000.
  • 3S Chawathe, H Garcia-Molina, J Hammer, K Ireland. The TSIMMIS Project: Integration of Heterogeneous Information Sources. In proc. of IPSJ Conf., Tokyo, Japan, 1994.
  • 4R Yerneni, C Li. Optimizing Large Join Queries in Mediation Systems. In proc. Conf. On Database Theory, 1999.
  • 5S Chaudhuri. An Overview of Query Optimization in Relational Systems. PODS, 1998: 34~43.
  • 6P Bernstein, N Goodman, E Wong, C Reeve, J Rothnie.Query Processing in a System for Distributed Databases (SDD-1). In ACM Trans. Database Systems, 1981,6(4).
  • 7D Florscu, A Levy and A Mendelzon. Database Techniques for the Worldwide Web: a Survey. SIGMOD record, 1998.
  • 8D Florscu, D Koller and A Levy. Using Probabilistic Information in Data Integration. VLDB, 1997.
  • 9Abrahm Silberschztz.数据库系统概论[M].杨冬青译.北京:机械工业出版社,1999.
  • 10Ch Audhuri S.Data mining and database systems:Where is the intersection[J].IEEE Data Engineering Bulletin,1998,21:4-8.

共引文献8

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部