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. 26, 2009
Filed:
Oct. 23, 2003
Robyn Lee Focazio, Round Rock, TX (US);
Kumar Marappan, Round Rock, TX (US);
Fabian F. Morgan, Austin, TX (US);
Brent Russel Phillips, Austin, TX (US);
Robyn Lee Focazio, Round Rock, TX (US);
Kumar Marappan, Round Rock, TX (US);
Fabian F. Morgan, Austin, TX (US);
Brent Russel Phillips, Austin, TX (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
An automated method for creating only the necessary joins in a SQL query. The present invention comprises a Query Program (QP), a Query Generation Program (QGP), and a Clause Generation Program (CGP). The QP accepts the query fields, filters, and sort criteria from the user, generates the query, sends the query to the database, and displays the query results. The QGP creates the query clause strings and inserts the strings into the SQL template. The QGP generates the SELECT, (filter) WHERE, and ORDER BY clauses. The QGP analyzes each parameter in a parameter list to determine if the parameter is on the added aliases list. If the parameter is not on the added aliases list, the QGP runs the CGP for the parameter. The CGP generates the FROM, JOIN, and (join) WHERE clauses and adds the clauses to the appropriate clause strings.