计算机与现代化 ›› 2012, Vol. 203 ›› Issue (7): 107-110.doi: 10.3969/j.issn.1006-2475.2012.07.029

• 数据库 • 上一篇    下一篇

数据查询操作代价估计

冯凯平   

  1. 四川烹饪高等专科学校网管中心,四川成都610072
  • 收稿日期:2012-02-20 修回日期:1900-01-01 出版日期:2012-08-10 发布日期:2012-08-10

Estimation of Data Query Operation Cost

FENG Kai-ping   

  1. Net & Information Management Center, Sichuan Higher Institute of Cuisine, Chengdu 610072, China
  • Received:2012-02-20 Revised:1900-01-01 Online:2012-08-10 Published:2012-08-10

摘要: 在数据库操作中查询操作所占比重最大,而查询操作又是代价最大的语句。在数据查询操作过程中,每种类型的操作发生的代价各不相同。本文结合实例,提出对查询过程中的诸如投影、选择、连接、分组与聚集等操作代价的估算方法。

关键词: 代价估计, 元组, 查询, 属性

Abstract: In the operation of database, the proportion of the query operation is the largest, and query operation is the largest statement in cost. It is different that the cost is occurred by each type of operation during the data query operation. This paper combines with the applications of actual topic, proposes the estimation method of the operation cost of projection, option, joint, group and gathered and so on in the process of the query.

Key words: cost estimate, tuple, query, attribute

中图分类号: