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:
Feb. 09, 2016
Filed:
Mar. 27, 2014
International Business Machines Corporation, Armonk, NY (US);
Jason L. Alpers, Lee's Summit, MO (US);
Thomas A. Beavin, Milpitas, CA (US);
Patrick D. Bossman, Sarasota, FL (US);
Shuanglin Guo, Cupertino, CA (US);
Terence P. Purcell, Springfield, IL (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.