Patent ID: 7613710

Claim:
A computer-implemented method of suspending a result set, the method comprising: determining whether an original result set, access to which is maintained by a first cursor state on a side of a server and a second cursor state on a side of a client, is to be suspended by using a processor, wherein the original result set is generated in response to execution of a query; suspending the original result set by storing a first set of data of the original result set in a storage area of a computer readable medium or a storage device, wherein the act of storing the first set of data comprises caching a first row of the first set of data into a first storage area; flushing the first storage area into a second storage area, when any of a set of constraint values has been exceeded, and it is determined that the first storage area needed to be flushed, or that the first storage area is full; and repeating the act of suspending the original result set until at least required data of the original result set has been sent to the storage area, wherein upon suspension of the result set, the act of suspending the original result set allows the client to access, without re-issuing or re-executing the query, the at least required data or a same order of the at least required data of the original result set throughout a life of the second cursor state when the first cursor state is no longer available to the client.