发明授权
- 专利标题: Consistent histogram maintenance using query feedback
- 专利标题(中): 使用查询反馈进行一致的直方图维护
-
申请号: US11239044申请日: 2005-09-30
-
公开(公告)号: US07512574B2公开(公告)日: 2009-03-31
- 发明人: Peter Jay Haas , Volker Gerhard Markl , Nimrod Megiddo , Utkarsh Srivastava
- 申请人: Peter Jay Haas , Volker Gerhard Markl , Nimrod Megiddo , Utkarsh Srivastava
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: IP Authority, LLC
- 代理商 Ramraj Soundararajan; Van Nguy
- 主分类号: G06E1/00
- IPC分类号: G06E1/00 ; G06E3/00 ; G06F15/18 ; G06G7/00
摘要:
A novel method is employed for collecting optimizer statistics for optimizing database queries by gathering feedback from the query execution engine about the observed cardinality of predicates and constructing and maintaining multidimensional histograms. This makes use of the correlation between data columns without employing an inefficient data scan. The maximum entropy principle is used to approximate the true data distribution by a histogram distribution that is as “simple” as possible while being consistent with the observed predicate cardinalities. Changes in the underlying data are readily adapted to, automatically detecting and eliminating inconsistent feedback information in an efficient manner. The size of the histogram is controlled by retaining only the most “important” feedback.
公开/授权文献
- US20070078808A1 Consistent histogram maintenance using query feedback 公开/授权日:2007-04-05
信息查询