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. 15, 2002
Filed:
Jul. 30, 1999
Gopi Krishna Attaluri, Sunnyvale, CA (US);
David Joseph Wisneski, Morgan Hill, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method and system for transparently caching and reusing database query execution plans. The method and system include caching a first query that contains a first constant. A first query is associated with an execution plan that represent the first constant with a parameter name. The method and system further include receiving a new query that contains a second constant and comparing the new query with the first query. A match is determined to exist even when the second constant fails to match the first constant. Upon a match, the first query execution plan is reused by substituting the parameter name in the query execution plan with the second constant from the new query, thereby avoiding generating a new query
Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile