发明名称 |
METHODS AND SYSTEMS FOR ONE DIMENSIONAL HETEROGENEOUS HISTOGRAMS |
摘要 |
A method and system to generate cardinality estimates for at least one query execution plan for a query using a histogram, the cardinality estimation being constrained by a q-error that is a factor by which the estimate deviates, at most, from a true value of the cardinality and a threshold value which the cardinality does not exceed; use the cardinality estimation to determine an optimal query plan for executing the query; and produce an output of the optimal query plan. |
申请公布号 |
US2014379693(A1) |
申请公布日期 |
2014.12.25 |
申请号 |
US201313925610 |
申请日期 |
2013.06.24 |
申请人 |
May Norman;Moerkotte Guido;Boehm Alexander |
发明人 |
May Norman;Moerkotte Guido;Boehm Alexander |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A computer-implemented method of optimizing execution of a query that accesses data by a computer, the method comprising:
generating cardinality estimates for at least one query execution plan for a query using a histogram, the cardinality estimation being constrained by a q-error that is a factor by which the estimate deviates, at most, from a true value of the cardinality and a threshold value which the cardinality does not exceed; using the cardinality estimation to determine an optimal query plan for executing the query; and producing an output of the optimal query plan. |
地址 |
Karlsruhe DE |