期刊文献+

基于近似函数依赖的查询评估改进

Approximate Functional Dependencies Based Query Evaluation Improvement
下载PDF
导出
摘要 查询评估和近似函数依赖是数据查询和管理中非常重要的两个研究方向。在本文中,基于已经挖掘的近似函数依赖,一个关系被分解成等价的几个子关系。同时,一些基本的查询表达式也相应的被重写,这些重写的查询表达式在执行时所需的时间成本更少。这一方法能让我们以更加有效的方式来处理一些查询问题。 Query evaluation improvement and approximate functional dependencies (AFD) are two important research topics in data query and management. In this paper, the relations are decomposed with respect to the discovered AFDs, and several basic data queries are reformulated in light of expressive equivalence, aimed at reducing time cost. This is helpful for processing queries in an efficient manner.
出处 《工程数学学报》 CSCD 北大核心 2007年第6期951-956,共6页 Chinese Journal of Engineering Mathematics
基金 国家自然科学基金(70231010/70321001) 清华大学现代管理研究中心资助.
关键词 查询评估 查询表达式 分解 近似函数依赖 query evaluation query expression decomposition approximate functional dependencies
  • 相关文献

参考文献10

  • 1Codd E F. A relational model for large shared data banks[J]. Communications of the ACM, 1970, 13(6): 377-387
  • 2Chaudhuri S. An overview of query optimization in relational systems[C]//Proceedings of the 7th ACM SIGACT-SIGMOD-SIGART symposium on principles of database systems, 1998:34-43
  • 3Ioannidis Y E. Query optimization[J]. ACM Computing Surveys, 1996, 28(1): 121-123
  • 4Jarke M, Koch J. Query optimization in database systems[J]. ACM Computing Surveys, 1984, 16(2): 111- 152
  • 5Huhtala Y, et al. TANE: An efficient algorithm for discovering functional and approximate dependencies[J]. The Computer Journal, 1999, 42(2): 100-111
  • 6Date C J. An Introduction to Database Systems (Tth Edition)[M]. Addison Wesley, 1999
  • 7Wei Q, Chen G Q. Efficient discovery of functional dependencies with degrees of satisfaction[J]. International Journal of Intelligent Systems, 2004, 19(11): 1089-1110
  • 8Bra P D, Paredaens J. Horizontal decompositions and their impact on query solving[J]. ACM SIGMOD Record, 1982, 13(1): 46-50
  • 9Giannella C M, et al. Improving query evaluation with approximate functional dependency based decompositions[J]. Lecture Notes in Computer Science, 2002, 2405:26-41
  • 10Elmasri R, Navathe S B. Fundamentals of Database Systems (3rd Edition)[M]. Addison Wesley, 2002

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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