Method, system, and program for implementing scrollable cursors in a distributed database system
First Claim
1. A method for accessing data in a distributed database environment, comprising:
- receiving, with a client program, multiple requests for data from a database object satisfying specified search predicates from an 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 a server program over a network if the requested row is not maintained by the client program;
generating a data block with 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;
transferring, with the server program, the data block to the client program; 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.
1 Assignment
0 Petitions
Accused Products
Abstract
Provided is a method, 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.
54 Citations
64 Claims
-
1. A method for accessing data in a distributed database environment, comprising:
-
receiving, with a client program, multiple requests for data from a database object satisfying specified search predicates from an 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 a server program over a network if the requested row is not maintained by the client program;
generating a data block with 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;
transferring, with the server program, the data block to the client program; 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 (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A method for accessing data in a distributed database environment, comprising:
-
receiving, with a client program, multiple requests for at least one row of data from a database object satisfying specified search predicates from an application program, wherein each request includes a request for at least one row from the database object satisfying the specified search predicates;
transferring, with the client program, a database command and a rowset parameter indicating a maximum number of rows to return to a first server program over a network if the requested row is not maintained by the client program;
transferring, with the first server program, a database command and the rowset parameter to a second server program over the network if the requested row is not maintained by the first server program;
generating a first data block with the second server program including rows from the database object satisfying the search predicates in response to the database command, wherein the rows included in the first data block do not exceed the rowset parameter;
transferring, with the second server program, the first data block to the first server program;
generating a second data block with the first server program including rows from the first data block, wherein the rows in the second data block do not exceed the rowset parameter;
transferring, with the first server program, the second data block to the client program; 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 (14, 15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A system for accessing data in a distributed database environment, comprising:
-
a computer database including at least one database object;
a client computer;
a server computer;
a network enabling communication between the client computer and server computer;
a client program executed by the client computer to perform;
(i) receiving multiple requests for data from a database object satisfying specified search predicates from an 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 a network if the requested row is not maintained by the client program;
a server program executed by the client computer to perform;
(i) generating a data block including rows from the database object satisfying the search predicates in response to the database command from the client program, wherein the rows included in the data block do not exceed the rowset parameter;
(ii) transferring the data block to the client program, wherein 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. - View Dependent Claims (24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)
-
-
35. A system for accessing data in a distributed database environment, comprising:
-
a distributed computing environment including at least one client program, first server program, second server program, and at least one database object;
a network enabling communication among the client program, first server program, and second server program;
means, performed by the client program, for receiving multiple requests for at least one row of data from a database object satisfying specified search predicates from an application program, wherein each request includes a request for at least one row from the database object satisfying the specified search predicates;
means, performed by the client program, for transferring a database command and a rowset parameter indicating a maximum number of rows to return to the first server program over the network if the requested row is not maintained by the client program;
means, performed by the first server program, for transferring a database command and the rowset parameter to the second server over the network if the requested row is not maintained by the first server program;
means, performed by the second server program, for generating a first data block including rows from the database object satisfying the search predicates in response to the database command from the first server program, wherein the rows included in the first data block do not exceed the rowset parameter;
means, performed by the second server program, for transferring the first data block to the first server program;
means, performed by the first server program, for generating a second data block including rows from the first data block, wherein the rows in the second data block do not exceed the rowset parameter;
means, performed by the first server program, for transferring the second data block to the client program; and
means, performed by the client program, for 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 (36, 37, 38, 39, 40, 41, 42, 43, 44)
-
-
45. Multiple computer readable media including instructions in a client program and server program that communicate over a network to cause computers to enable access to data in a distributed database environment by:
-
receiving, with the client program, multiple requests for data from a database object satisfying specified search predicates from an 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 a network if the requested row is not maintained by the client program;
generating a data block with 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;
transferring, with the server program, the data block to the client program; 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 (46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 62, 63, 64)
-
-
56. Multiple computer readable media including instructions in a client program, first server program, and second server program that communicate over a network to cause computers to enable access to data in a network distributed database environment by:
-
receiving, with the client program, multiple requests for at least one row of data from a database object satisfying specified search predicates from an application program, wherein each request includes a request for at least one row from the database object satisfying the specified search predicates;
transferring, with the client program, a database command and a rowset parameter indicating a maximum number of rows to return to the first server program over a network if the requested row is not maintained by the client program;
transferring, with the first server program, a database command and the rowset parameter to a second server program over the network if the requested row is not maintained by the first server program;
generating a first data block with the second server program including rows from the database object satisfying the search predicates in response to the database command, wherein the rows included in the first data block do not exceed the rowset parameter;
transferring, with the second server program, the first data block to the first server program;
generating a second data block with the first server program including rows from the first data block, wherein the rows in the second data block do not exceed the rowset parameter;
transferring, with the first server program, the second data block to the client program; 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 (57, 58, 59, 60, 61)
-
Specification