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:
May. 25, 2010
Filed:
Dec. 19, 2003
Christopher Evans, Bristol, GB;
Paolo Fragapane, Bristol, GB;
Stephen Cave, Gloucester, GB;
Andrew Osborn, Bristol, GB;
Christopher Evans, Bristol, GB;
Paolo Fragapane, Bristol, GB;
Stephen Cave, Gloucester, GB;
Andrew Osborn, Bristol, GB;
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.