« PreviousContinue »
(12) United States Patent ao) Patent No.: us 6,990,477 B2
Cotner et al. (45) Date of Patent: Jan. 24,2006
5,918,224 A * 6/1999 Bredenberg 707/2
5,926,807 A * 7/1999 Peltonen et al 707/3
5,930,793 A * 7/1999 Kleewein et al 707/10
5,974,416 A * 10/1999 Anand et al 707/10
6,256,626 Bl 7/2001 Dong et al 707/3
6,606,618 B2 * 8/2003 Delo 707/2
2002/0040639 Al * 4/2002 Duddleson et al 92/52
IBM, "DB2 for MVS/ESA Version 4 Administration Guide", IBM Document No. SC26-3265-00,1982, pp. 1-7, [online] Sep. 2000, Retrieved from the Internet at <URL: http:/// publibfp.boulder.ibm.com>.
Primary Examiner—Safet Metjahic
Assistant Examiner—Etienne P Leroux
(74) Attorney, Agent, or Firm—David W. Victor; Konrad,
Raynes & Victor LLP
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.
64 Claims, 8 Drawing Sheets
The Open Group, "DRDA Version 2, vol. 1: Distributed Relational Database Architecture (DRDA)", The Open Group Technical Standard, 1999, pp. 31-36, 76-134, 261-334.
The Open Group, "DRDA Version 2, vol. 3: Distributed Data Management (DDM) Architecture", The Open Group Technical Standard, 1999, pp. 378-383, 385, 428-438, 514-523, 621-625.
Boykin, J.R. et al., "IBM Technical Disclosure Bulletin: Updateable Scrollable Cursors", vol. 36 No. 4, Apr. 1993; pp. 263-268.
Boykin, J.R., et al., "IBM Technical Disclosure Bulletin: New Options for FETCH in SQL," vol. 36, No. 06A, Jun. 1993; pp. 559-560.
Boykin, J.R., et al., "IBM Technical Disclosure Bulletin: Orderable, Updatable, Scrollable Structure Query Language Cursors,"vol. 38, No. 17, Jul. 1995; pp. 393-394.
IBM Corp., "Distributed Data Management Architecture: General Information; Level 4," IBM Document No. GC21-9257-03; 1986,1993; pp. 1-69; retrieved from Internet at http://publibfp.boulder.ibm.com.
IBM Corp., "Distributed Data Management (DDM) Architecture Reference Manual; Level 4," IBM Document No. SC21-9526-05; 1986, 1993; 15 selected pages; retrieved from Internet at http://publibfp.ibm.com.
* cited by examiner