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:
Mar. 25, 2014
Filed:
Oct. 24, 2007
Eric Lawrence Barsness, Pine Island, MN (US);
Brian Robert Muras, Rochester, MN (US);
Paul Stuart Nelsestuen, Rochester, MN (US);
John Matthew Santosuosso, Rochester, MN (US);
Eric Lawrence Barsness, Pine Island, MN (US);
Brian Robert Muras, Rochester, MN (US);
Paul Stuart Nelsestuen, Rochester, MN (US);
John Matthew Santosuosso, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Embodiments of the invention provide techniques for generating statistics for optimizing database queries containing user-defined functions (UDFs). In general, the statistics may be generated based on output values produced during past executions of a UDF. The statistics may also be generated based on input values received during past executions of the UDF. Additionally, the statistics may include input and output value pairs, such that a UDF output may be determined based on a UDF input. The generated statistics may be used by a query optimizer to determine an efficient query plan for executing the database query.
Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile