International Business Machines Corporation

Nirav S Sheth

Matthew G Marum

Michael John Tabb

Steven Keith Speicher

Samuel George Padgett

Ravi Gopalakrishnan

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.

Simplified query generation from prior query results

Computer method and apparatus processing batch changes to a plurality of records employs heuristics. The system includes a computer based source of a plurality of records subject to a batch update. Each record in the plurality has respective meta data information. A computer processor projects application of changes forming the batch update in one record of the plurality. The processor applies heuristics including noting metadata information of the one record impacting changes to each record in the plurality. Using the noted metadata information and heuristics, the system further projects application of the batch update changes to remaining records in the plurality. A preview display of the projected results of the batch changes allows the user to commit, modify or revert batch updates per record.

Method and system using heuristics in performing batch updates of records

A first query is retrieved by a computing device. A second query is retrieved by the computing device, wherein the second query is linked to the first query. A derivative query is generated by the computing device based, at least in part, upon merging at least a portion of the second query with at least a portion of the first query, wherein generating the derivative query includes retrieving the first query and the second query prior to generation of the derivative query. The computing device determines whether the derivative query contains one or more conflicts. If it is determined that the derivative query contains one or more conflicts, the one or more conflicts in the derivative query are resolved by the computing device.

Growing community of inventors

Cary, NC, United States of America

Nirav S Sheth