International Business Machines Corporation

Christopher J Munson

Nigel G Slinger

John Benjamin Tobler

Arthur Marais

Jeff W Josten

According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.

Dynamic result set caching with a database accelerator

In a first aspect of the present invention, a method for recovering data in a plurality of systems is disclosed. The method comprises the steps of allowing at least one system of the plurality of systems to fail, retaining a plurality of locks of the at least one system and restarting the at least one system utilizing minimal resources. In a second aspect of the present invention, a system for recovering data in a plurality of computer systems is disclosed. The system comprises means for allowing at least one computer system of the plurality of computer systems to fail, means for retaining a plurality of locks of the at least one computer system and means for restarting the at least one computer system utilizing minimal resources. According to the present invention, the method and system for recovering retained locks in a plurality of systems recovers the data being protected by the retained locks of a failed system quickly and with minimal system disruption.

Growing community of inventors

Los Gatos, CA, United States of America

Christopher J Munson