Suspending a result set and continuing from a suspended result set for transparent session migration
First Claim
Patent Images
1. A computer-implemented method for suspending a cursor result set for transparently migrating a first session, the method comprising:
- receiving notification the first session at a first server is selected for migration;
preparing to migrate, preparing including suspending a cursor result set for the first session;
suspending the cursor result set by storing the cursor result set in a storage area of a computer-usable medium for later access without re-execution of a query;
determining if the first session is ready to migrate; and
migrating the first session at the first server to a second server, the migrating comprising;
opening a second session on the second server;
copying session state of the first session into the second session; and
creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query.
1 Assignment
0 Petitions
Accused Products
Abstract
A system, method, computer program and system for suspending a result set and continuing from a suspended result set for transparent session migration is disclosed. The rows from a row source are suspended into storage, so that after session migration, the client fetches can transparently continue from the suspended result set.
-
Citations
38 Claims
-
1. A computer-implemented method for suspending a cursor result set for transparently migrating a first session, the method comprising:
-
receiving notification the first session at a first server is selected for migration; preparing to migrate, preparing including suspending a cursor result set for the first session; suspending the cursor result set by storing the cursor result set in a storage area of a computer-usable medium for later access without re-execution of a query; determining if the first session is ready to migrate; and migrating the first session at the first server to a second server, the migrating comprising; opening a second session on the second server; copying session state of the first session into the second session; and creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A computer-implemented method for suspending a cursor result set and continuing a suspended cursor result set for transparent session migration, the method comprising:
-
executing a query on a first session on a first server; receiving notification the first session was selected for migration; preparing to migrate the first session; suspending a cursor result set by storing the cursor result set in a computer-usable storage medium for later access without re-execution of a query; determining if ready to migrate the first session; and migrating the first session at the first server to a second server and accessing the cursor result set from the suspended cursor result set, the migrating comprising; opening a second session on the second server; copying session state of the first session into the second session; and creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A computer program product comprising a computer usable storage medium having executable code to execute a process for suspending a cursor result set and continuing a suspended cursor result set for transparent session migration, the process comprising:
-
executing a query on a first session on a first server; receiving notification the session was selected for migration; preparing to migrate, preparing including suspending a cursor result set for the first session; suspending the cursor result set by storing the cursor result set for later access without re-execution of a query; determining if ready to migrate the first session; and migrating the first session at the first server to a second server, when ready and accessing the cursor result set from the suspended cursor result set, the migrating comprising; opening a second session on the second server; copying session state of the first session into the second session; and creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query.
-
-
28. The computer program product of 27, the process further comprising:
- executing a fetch request on the suspended cursor result sets from the second session.
-
29. The computer program product of 27, wherein a client is unaware that a session is migrating or of a switch from the first session to the second session.
-
30. A system comprising a computer usable storage medium for suspending a cursor result set and continuing a suspended cursor result set for transparent session migration, comprising:
-
means for executing a query on a first session on a first server; means for receiving notification the first session was selected for migration; means for preparing to migrate the first session; means for suspending a cursor result set by storing in the computer usable storage medium the cursor result set for later access without re-execution of a query; means for determining if ready to migrate the first session; and means for migrating the first session at the first server to a second server and accessing the cursor result set from the suspended cursor result set, the migrating comprising; opening a second session on the second server; copying session state of the first session into the second session; and creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query. - View Dependent Claims (31, 32)
-
-
33. A computer program product comprising a computer usable storage medium having executable code to execute a process for suspending a cursor result set for transparently migrating a first session, the process comprising:
-
executing a query on a first session on a first server; receiving notification the first session was selected for migration; preparing to migrate the first session; suspending a cursor result set by storing the cursor result set for later access without re-execution of a query; determining if ready to migrate the first session; and migrating the first session at the first server to a second server, the migrating comprising; opening a second session on the second server; copying session state of the first session into the second session; and creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query.
-
-
34. The computer program product of 33, the process further comprising:
- executing a fetch request on a suspended cursor result sets from the second session.
-
35. The computer program product of 33, wherein a client is unaware that a session is migrating or of a switch from the first session to the second session.
-
36. A system comprising a computer usable storage medium for suspending a cursor result set for transparently migrating a first session, the method comprising:
-
means for executing a query on a first session on a first server; means for receiving notification the first session is selected for migration; means for preparing to migrate, preparing including suspending a cursor result set for the first session; means for suspending the cursor result set by storing in the computer usable storage medium the cursor result set for later access without re-execution of a query; means for determining if the first session is ready to migrate; and means for migrating the first session at the first server to a second server, the migrating comprising; opening a second session on the second server; copying session state of the first session into the second session; and creating a connection to the second session on the second server, wherein the connection to the second session on the second server allows for continued execution of the query from the suspended cursor result set without re-execution of the query. - View Dependent Claims (37, 38)
-
Specification