Method, system and program product for rewriting structured query language (SQL) statements
US8612422B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 21, 2012 |
| Grant date | Dec 17, 2013 |
| Priority date | — |
| Expiry date | Mar 21, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for rewriting Structured Query Language (SQL) statements. A SQL statement having search criteria including conditions pertaining to fields in database tables is received. A table from the SQL statement listing all combinations of the search criteria is created, every combination reflecting a subset of information used to determine combined results. A set of patterns among the possible combinations of the SQL statement based on the fields referenced in the combinations is identified. The table based on the set of patterns is sorted. Based on the sorting, the table is divided into temporary tables which are joined with the SQL statement. New temporary tables are generated. Each new temporary table includes results of a search conducted using a separate portion of the SQL statement as joined with the set of temporary tables. All results from the new temporary tables are combined into a single result table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.