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:
Jun. 28, 2011
Filed:
Mar. 17, 2008
Snehal S. Antani, Hyde Park, NY (US);
Chon N. Lei, Poughkeepsie, NY (US);
Adarsh R. Pannu, San Jose, CA (US);
Rajesh P. Ramachandran, Santa Clara, CA (US);
Snehal S. Antani, Hyde Park, NY (US);
Chon N. Lei, Poughkeepsie, NY (US);
Adarsh R. Pannu, San Jose, CA (US);
Rajesh P. Ramachandran, Santa Clara, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.