Simplified query generation from prior query results

Patent metadata

Field	Value
Publication number	US-9613090-B2
Application number	US-201414246428-A
Country	US
Kind code	B2
Filing date	Apr 7, 2014
Priority date	Jun 30, 2010
Publication date	Apr 4, 2017
Grant date	Apr 4, 2017

Abstract

Embodiments of the present invention provide a method, system and computer program product for query generation from a previous result set. In an embodiment of the invention, a method for query generation from a previous result set is provided. The method includes identifying commonalities in a selection of records of a result set produced by a previously issued query against a database in a database management system executing in memory by at least one processor of a host server. The method further includes deriving a query from the identified commonalities that when executed against the database management system would produce the selection of records as the result set. Finally, the method includes storing the derived query for subsequent use in querying the database.

First claim

We claim:

1. A method for query generation from a previous result set, the method comprising:
applying an initial query against a database in a database management system executing in memory by at least one processor of a host server;
producing a result set of different records in response to the initial query, each record of the result set includes a plurality of different fields and content in each of the different fields;
selecting a set of records in the result set;
identifying commonalities in the selection of records, the identified commonalities including at least a portion of identical content in the different fields in the selection of records;
establishing a strictness parameter that dictates a precision to which a derived query is generated based upon the selection of records, wherein the strictness parameter includes a less strict form only requiring a partial matching of content in only a subset of fields of records with commonality of identical content and a more strict form requiring a complete matching of content in all fields of records with commonality of identical content, wherein the precision specifies a first number of different fields with a quantity of content from the identified commonalities to be included in the derived query according to the less strict form and a second number of different fields with a quantity of content from the identified commonalities to be included in the derived query according to the more strict form, wherein the first number is lower than the second number, and wherein derived query when executed against the database would produce the selection of records;
applying the strictness parameter to the selection of records;
generating the derived query according to the identified commonalities and the applied strictness parameter, wherein the derived query includes either the first number or the second number of different fields and a quantity of content in each of the different fields from the identified commonalities; and
storing the derived query for subsequent use in querying the database.

2. The method of claim 1 , wherein identifying commonalities in the selection of records comprises identifying each of the different fields in the selection of records that contain at least a portion of identical content.

3. The method of claim 1 , wherein the generating the derived query further comprises:
limiting a number of the different fields in the derived query according to the strictness parameter.

4. The method of claim 1 , wherein the generating the derived query further comprises:
limiting a number of characters in the content of at least one of the different fields in the derived query according to the strictness parameter.

5. A database management data processing system comprising:
a host server with at least one processor and memory;
a database management system executing in the host server managing access to a database coupled to the host server; and,
a query derivation module communicatively linked to the database management system, the module comprising program code that when executed by a computer is configured to:
apply an initial query against a database in a database management system executing in memory by at least one processor of a host server;
produce a result set of different records in response to the initial query, each record of the result set includes a plurality of different fields and content in each of the different fields;
select a set of records in the result set;
identify commonalities in the selection of records, the identified commonalities including at least a portion of identical content in the different fields in the selection of records;
establish a strictness parameter that dictates a precision to which a derived query is generated based upon the selection of records, wherein the strictness parameter includes a less strict form only requiring a partial matching of content in only a subset of fields of records with commonality of identical content and a more strict form requiring a complete matching of content in all fields of records with commonality of identical content, wherein the precision specifies a first number of different fields with a quantity of content from the identified commonalities to be included in the derived query according to the less strict form and a second number of different fields with a quantity of content from the identified commonalities to be included in the derived query according to the more strict form, wherein the first number is lower than the second number, and wherein derived query when executed against the database would produce the selection of records;
apply the strictness parameter to the selection of records;
generate the derived query according to the identified commonalities and the applied strictness parameter, wherein the derived query includes either the first number or the second number of different fields and a quantity of content in each of the different fields from the identified commonalities; and
store the derived query for subsequent use in querying the database.

6. The system of claim 5 , wherein the identified commonalities comprise each of the different fields in the selection of records that contain at least a portion of identical content.

7. A computer program product for query generation from a previous result set, the computer program product comprising:
a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
computer readable program code for-applying an initial query against a database in a database management system executing in memory by at least one processor of a host server;
computer readable program code for-producing a result set of different records in response to the initial query, each record of the result set includes a plurality of different fields and content in each of the different fields;
computer readable program code for-selecting a set of records in the result set;
computer readable program code for-identifying commonalities in the selection of records, the identified commonalities including at least a portion of identical content in the different fields in the selection of records;
computer readable program code for-establishing a strictness parameter that dictates a precision to which a derived query is generated based upon the selection of records, wherein the strictness parameter includes a less strict form only requiring a partial matching of content in only a subset of fields of records with commonality of identical content and a more strict form requiring a complete matching of content in all fields of records with commonality of identical content, wherein the precision specifies a first number of different fields with a quantity of content from the identified commonalities to be included in the derived query according to the less strict form and a second number of different fields with a quantity of content from the identified commonalities to be included in the derived query according to the more strict form, wherein the first number is lower than the second number, and wherein derived query when executed against the database would produce the selection of records;
computer readable program code for-applying the strictness parameter to the selection of records;
computer readable program code for-generating the derived query according to the identified commonalities and the applied strictness parameter, wherein the derived query includes either the first number or the second number of different fields and a quantity of content in each of the different fields from the identified commonalities; and
computer readable program code for-storing the derived query for subsequent use in querying

Assignees

• IBM

Inventors

• Marum Matthew G
• Padgett Samuel G
• Sheth Nirav S
• Speicher Steven K
• Tabb Michael J

Classifications

• G06F17/30395

  Physics · mapped topic

• G06F17/30448

  Physics · mapped topic

• G06F17/30463

  Physics · mapped topic

• G06F17/30401 Primary

  Physics · mapped topic

• G06F16/243 Primary

  Natural language query formulation · CPC title