System and program for implementing scrollable cursors in a distributed database system
First Claim
1. A system for accessing data in a distributed database environment, wherein the system is in communication with a server program over a network, wherein the system is in communication with an application program, and wherein the distributed database environment includes a database object, the system comprising:
- a client computer; and
a client program executed by the client computer to perform;
(i) receiving multiple requests for data from the database object satisfying specified search predicates from the application program, wherein each request includes a request for at least one row from the database object;
(ii) transferring a database command and a rowset parameter indicating a maximum number of rows to return to the server program over the network if the requested row is not maintained by the client program;
(iii) receiving a data block generated by the server program including rows from the database object satisfying the search predicates in response to the database command, wherein the rows included in the data block do not exceed the rowset parameter; and
(iv) returning at least one requested row from the received data block in response to one request for the at least one row of data from the application program.
0 Assignments
0 Petitions
Accused Products
Abstract
Provided are a system and program for accessing data in a distributed database environment. A client program receives multiple requests for data from a database object satisfying specified search predicates from an application program. Each request includes a request for at least one row from the table. The client program transfers a database command and a rowset parameter indicating a maximum number of rows to return to a server program over a network if the requested row is not maintained by the client program. A data block is generated with the server program including rows from the database object satisfying the search predicates in response to the database command. The rows included in the data block do not exceed the rowset parameter. The server program transfers the data block to the client program. In turn, the client program returns at least one requested row from the received data block in response to one request for the at least one row of data from the application program.
-
Citations
12 Claims
-
1. A system for accessing data in a distributed database environment, wherein the system is in communication with a server program over a network, wherein the system is in communication with an application program, and wherein the distributed database environment includes a database object, the system comprising:
-
a client computer; and a client program executed by the client computer to perform; (i) receiving multiple requests for data from the database object satisfying specified search predicates from the application program, wherein each request includes a request for at least one row from the database object; (ii) transferring a database command and a rowset parameter indicating a maximum number of rows to return to the server program over the network if the requested row is not maintained by the client program; (iii) receiving a data block generated by the server program including rows from the database object satisfying the search predicates in response to the database command, wherein the rows included in the data block do not exceed the rowset parameter; and (iv) returning at least one requested row from the received data block in response to one request for the at least one row of data from the application program. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer readable storage medium, wherein instructions for a client program capable of communicating with a server program over a network in a distributed database environment are stored in the computer readable storage medium, wherein the distributed database environment includes a database object, wherein the client program is in communication with an application program, and wherein the instructions when executed by a machine performs:
-
receiving, with the client program, multiple requests for data from the database object satisfying specified search predicates from the application program, wherein each request includes a request for at least one row from the database object; transferring, with the client program, a database command and a rowset parameter indicating a maximum number of rows to return to the server program over the network if the requested row is not maintained by the client program; receiving, with the client program, a data block generated by the server program including rows from the database object satisfying the search predicates in response to the database command, wherein the rows included in the data block do not exceed the rowset parameter; and returning, with the client program, at least one requested row from the received data block in response to one request for the at least one row of data from the application program. - View Dependent Claims (8, 9, 10, 11, 12)
-
Specification