The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 08, 2013
Filed:
Oct. 07, 2009
Suresh Subbiah, Plano, TX (US);
Lars Fredriksen, Downers Grove, IL (US);
Murali Mallela Krishna, Vancouver, WA (US);
Hansjorg Zeller, Los Altos, CA (US);
Suresh Subbiah, Plano, TX (US);
Lars Fredriksen, Downers Grove, IL (US);
Murali Mallela Krishna, Vancouver, WA (US);
Hansjorg Zeller, Los Altos, CA (US);
Hewlett-Packard Development Company, L.P., Houston, TX (US);
Abstract
There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first query configured to generate a result set. The query may comprise an operation for an outer table, a first predicate, and a second predicate. The second predicate may comprise a subquery correlated to the operation. Additionally, the first predicate and the second predicate may be disjunctive. The exemplary method also comprises generating a first query tree representing the first query, and generating a second query tree representing a second query. The second query may be configured to generate the result set, and may not comprise the subquery. The exemplary method additionally comprises generating a query plan based on the second query tree.