| US 7,613,710 B2 | ||
| Suspending a result set and continuing from a suspended result set | ||
| Mehul D. Bastawala, Menlo Park, Calif. (US); Lakshminarayanan Chidambaran, Sunnyvale, Calif. (US); Sreenivas Gollapudi, Cupertino, Calif. (US); Sanjay Kaluskar, Menlo Park, Calif. (US); Srinath Krishnaswamy, Fremont, Calif. (US); and Debashish Chatterjee, Fremont, Calif. (US) | ||
| Assigned to Oracle International Corporation, Redwood Shores, Calif. (US) | ||
| Filed on Apr. 01, 2005, as Appl. No. 11/97,422. | ||
| Claims priority of provisional application 60/601250, filed on Aug. 12, 2004. | ||
| Prior Publication US 2006/0059176 A1, Mar. 16, 2006 | ||
| Int. Cl. G06F 7/00 (2006.01); G06F 17/30 (2006.01) | ||
| U.S. Cl. 707—100 [707/10] | 39 Claims |

| 39. A system for continuing from a result set being suspended, the system comprising:
a) means for determining whether suspension of the 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 enabled, wherein
the result set is generated in response to execution of a query, and the act of determining whether suspension of the result
is performed by a processor, and
the means for determining the result set comprises a processor;
b) means for determining if a subject row in the result set has been suspended;
c) means for determining if the subject row in the result set that is available with a first cursor and a second cursor is
to be suspended, if the subject row has not been suspended;
d) means for suspending the subject row if it is determined that the subject row is to be suspended, wherein upon suspension
of the subject row,
the suspended subject row in a storage area allows the client to access, without re-issuing or re-executing the query, required
data or a same order of the required data of the subject row through a life of the second cursor state when the first cursor
state is no longer available to the client, and
the means for suspending the subject row is invoked for execution during an absolute time period added to an average row fetch
time or as a percent delay to an average row fetch time;
e) means for extracting and returning the subject row, from a suspended result set if the subject row has been suspended,
or from the cursor row source if the row is not to be suspended;
f) means for repeating a)-f) until all the rows in the result set are processed; and
a display apparatus configured for displaying a result generated by the means for suspending the subject row or a tangible
computer-readable medium or a storage device configured for storing the result.
|