Edith A Kanyock

US Patent:

8612422, Dec 17, 2013

Filed:

Mar 21, 2012

Appl. No.:

13/425524

Inventors:

Howard S. Bloom - Poughkeepsie NY, US
Roy Froehlich - Ontario, CA
Edith A. Kanyock - Sloatsburg NY, US
Charles F. Matula - Poughkeepsie NY, US
Arnold M. Rosenberg - New Fairfield CT, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707714, 707737

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.

US Patent:

20060106766, May 18, 2006

Filed:

Nov 12, 2004

Appl. No.:

10/987346

Inventors:

Howard Bloom - Poughkeepsie NY, US
Roy Froehlich - North York, CA
Thomas Jobson - New Paltz NY, US
Edith Kanyock - Sloatsburg NY, US
Charles Matula - Poughkeepsie NY, US
Arnold Rosenberg - New Fairfield CT, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/00

US Classification:

707003000

Abstract:

Under the present invention, a SQL statement having search criteria is received. Upon receipt, a table that lists all possible combinations of the search criteria is created. From the table, a set of patterns among the possible combinations is identified. Based on these patterns, the table is then sorted. Once sorted, the table is divided into a set of temporary tables based on the set of patterns/sorting operation. The set of temporary tables are then individually joined with the SQL statement and separate searches are conducted. A new set of temporary tables is then generated and populated with results of the separate searches. These result tables are then unioned/combined into a single result table.