发明授权
- 专利标题: Selectivity estimation for conjunctive predicates in the presence of partial knowledge about multivariate data distributions
- 专利标题(中): 在有关多变量数据分布的部分知识的情况下,联合谓词的选择性估计
-
申请号: US11190947申请日: 2005-07-28
-
公开(公告)号: US07376639B2公开(公告)日: 2008-05-20
- 发明人: Marcel Kutsch , Volker Gerhard Markl , Nimrod Megiddo , Tam Minh Dai Tran
- 申请人: Marcel Kutsch , Volker Gerhard Markl , Nimrod Megiddo , Tam Minh Dai Tran
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: IP Authority, LLC
- 代理商 Ramraj Soundararajan; Van Nguy
- 主分类号: G06F17/30
- IPC分类号: G06F17/30 ; G06F7/00
摘要:
A method for consistent selectivity estimation based on the principle of maximum entropy (ME) is provided. The method efficiently exploits all available information and avoids the bias problem. In the absence of detailed knowledge, the ME approach reduces to standard uniformity and independence assumptions. The disclosed method, based on the principle of ME, is used to improve the optimizer's cardinality estimates by orders of magnitude, resulting in better plan quality and significantly reduced query execution times.
公开/授权文献
信息查询