Invention Grant
- Patent Title: Selectivity estimation for conjunctive predicates in the presence of partial knowledge about multivariate data distributions
- Patent Title (中): 在有关多变量数据分布的部分知识的情况下,联合谓词的选择性估计
-
Application No.: US12042065Application Date: 2008-03-04
-
Publication No.: US08135701B2Publication Date: 2012-03-13
- Inventor: Marcel Kutsch , Volker Gerhard Markl , Nimrod Megiddo , Tam Minh Dai Tran
- Applicant: Marcel Kutsch , Volker Gerhard Markl , Nimrod Megiddo , Tam Minh Dai Tran
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: IP Authority, LLC
- Agent Ramraj Soundararajan
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
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.
Public/Granted literature
Information query