×

Method, system and program product for rewriting structured query language (SQL) statements

  • US 8,185,518 B2
  • Filed: 11/12/2004
  • Issued: 05/22/2012
  • Est. Priority Date: 11/12/2004
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method for rewriting Structured Query Language (SQL) statements:

  • receiving a SQL statement having search criteria that include conditions that pertain to a plurality of fields in a plurality of database tables;

    creating a table from the SQL statement that lists all possible combinations of the search criteria in the SQL statement, every combination reflecting a subset of information used to determine combined results;

    identifying a set of patterns among the all possible combinations of the SQL statement based on the fields referenced in the combinations, and sorting the table based on the set of patterns;

    dividing the table into a set of temporary tables based on the sorting;

    joining the set of temporary tables with the SQL statement, and generating a new set of temporary tables, each table consisting of results of a search conducted using a separate portion of the SQL statement as joined with the set of temporary tables; and

    combining all results from the new set of temporary tables into a single result table.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×