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. 22, 2012
Filed:
Nov. 12, 2004
Howard S. Bloom, Poughkeepsie, NY (US);
Roy Froehlich, North York, CA;
Thomas A. Jobson, Jr., New Paltz, NY (US);
Edith A. Kanyock, Sloatsburg, NY (US);
Charles F. Matula, Poughkeepsie, NY (US);
Arnold M. Rosenberg, New Fairfield, CT (US);
Howard S. Bloom, Poughkeepsie, NY (US);
Roy Froehlich, North York, CA;
Thomas A. Jobson, Jr., New Paltz, NY (US);
Edith A. Kanyock, Sloatsburg, NY (US);
Charles F. Matula, Poughkeepsie, NY (US);
Arnold M. Rosenberg, New Fairfield, CT (US);
International Business Machines Corporation, Armonk, NY (US);
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.