Suspending a result set and continuing from a suspended result set for scrollable cursors

A computer implemented method for continuing a suspended result set for scrollable cursors, comprising:

• receiving a call for data in an original result set which is generated in response to the call or to a query, wherein
• the original result set in a first computer readable medium is maintained by a first scrollable cursor state on a side of a server and a second scrollable cursor state on a side of a client;
• fetching, by using a processor, the data of the original result set from a suspended result set, wherein
• suspension of the original result set by copying the original result set to a second computer readable storage medium allows the client to access, from the result set that is being suspended, same data or same order of the data of the original result set without re-issuing or re-executing the query, and the result set that is being suspended allows the data of the original result set to be accessible by the client without retaining the first scrollable cursor state on the side of the server when the original result set is no longer available to the client, and
• the client is allowed to access, from the result set that is being suspended, the same data or the same order of the data of the original result set without re-issuing or re-executing the query or the new query while ensuring correctness in accessing the data;
• and
• displaying a result of the act of fetching the data on a display apparatus or storing the result of the act of fetching the data in a tangible computer usable medium, the first computer readable storage medium, the second computer readable storage medium, or a storage device.

A system for continuing a suspended result set for scrollable cursors, comprising:

• means for receiving a call for data in an original result set which is generated in response to a query, wherein
• the original result set in a first computer readable medium is maintained by a first scrollable cursor state on a side of a server and a second scrollable cursor state on a side of a client;
• and
• a processor for fetching the data of the original result set from a suspended result set, wherein
• suspension of the original result set by copying the original result set to a second computer readable storage medium allows the client to access, from the result set that being suspended, same data or same order of the data of the original result set without re-issuing or re-executing the query or a new query, and the result set that is being suspended allows the data of the original result set to be accessible by the client without retaining the first scrollable cursor state on the side of the server when the original result set is no longer available to the client, and
• the client is allowed to access, from the result set that is being suspended, the same data or the same order of the data of the original result set from the result set that is being suspended without re-issuing or re-executing the query or the new query while ensuring correctness in accessing the data;
• and
• a display apparatus configured for displaying a result of the act of fetching the data or a tangible computer usable medium, the first computer readable storage medium, the second computer readable storage medium, or a storage device configured for storing the result.

A computer program product comprising a volatile or non-volatile computer usable medium having executable code which, when executed by a processor, causes the processor to execute a process for continuing a suspended result set for scrollable cursors, the process comprising:

• receiving a call for data in an original result set which is generated in response to the call or to a query, wherein
• the original result set in a first computer readable medium is maintained by a first scrollable cursor state on a side of a server and a second scrollable cursor state on a side of a client;
• and
• fetching, by using the processor, the data of the original result set from the suspended result set, wherein
• suspension of the original result set by copying the original result set to a second computer readable storage medium allows the client to access, from the result set that is being suspended, same data or same order of the data of the original result set without re-issuing or re-executing the query or a new query, and the result set that is being suspended allows the data of the original result set to be accessible by the client without retaining the first scrollable cursor state on the side of the server when the original result set is no longer available to the client, and
• the client is allowed to access, from the result set that is being suspended, the same data or the same order of the data of the original result set from the result set that is being suspended without re-issuing or re-executing the query or the new query while ensuring correctness in accessing the data;
• and
• displaying a result of the act of fetching the data on a display apparatus or storing the result of the act of fetching the data in a tangible computer usable medium, the first computer readable storage medium, the second computer readable storage medium, or a storage device.

A system for suspending a result set for scrollable cursors, comprising:

• means for receiving a request for data in an original result set which is generated in response to the request or to a query, wherein
• the original result set in a first computer readable storage medium is maintained by a first scrollable cursor state on a side of a server and a second scrollable cursor state on a side of a client;
• a processor for suspending the data from the original result set by copying the original result set to a second computer readable storage medium to allow the client to access, from the result set that is being suspended, the same data or same order of the data of the original result set without re-issuing or re-executing the query or a new query, wherein
• the result set that is being suspended allows the data of the original result set to be accessible by the client without retaining the first scrollable cursor state on the side of the server when the original result set is no longer available to the client, and
• the client is allowed to access same data or same order of the data of the original result set from the result set that is being suspended without re-issuing or re-executing the query or a new query while ensuring correctness in accessing the data;
• and
• means for fetching the data from the original result set or from the data set that is being suspended;
• and
• a display apparatus displaying a result of the act of fetching the data or a tangible computer usable medium, the first computer readable storage medium, the second computer readable storage medium, or a storage device storing the result of the act of fetching the data.