发明名称 |
OPTIMIZING QUERY STATEMENTS IN RELATIONAL DATABASES |
摘要 |
Optimizing query statements in relational databases including determining filtering performance for each of at least two complex predicates in a predetermined layer of the query statement based on a result of a query performed on predetermined data records by using only the complex predicate. The results are ranked based on the filtering performance and re-ordered so that a complex predicate with a higher filtering performance is ranked before a complex predicate with a lower filtering performance. These techniques produce shortened data query response times and improved execution efficiency. |
申请公布号 |
US2014358894(A1) |
申请公布日期 |
2014.12.04 |
申请号 |
US201414250505 |
申请日期 |
2014.04.11 |
申请人 |
International Business Machines Corporation |
发明人 |
Wei DongJie;Wei Ke W.;Yang Xin Ying Y.;Zheng Miao |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. An optimizing method for a query statement in a relational database, comprising:
determining filtering performance for each of at least two complex predicates in a predetermined layer of the query statement based on a result of a query performed on predetermined data records by using only the complex predicates; and re-ordering the complex predicates in the predetermined layer based on the filtering performance so as to rank a complex predicate with higher filtering performance before a complex predicate with a lower filtering performance. |
地址 |
Armonk NY US |