Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2011-08-02
2011-08-02
LeRoux, Etienne P (Department: 2161)
Data processing: database and file management or data structures
Database design
Database and data structure management
Reexamination Certificate
active
07991796
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.
REFERENCES:
patent: 4190835 (1980-02-01), Buynak
patent: 4434475 (1984-02-01), McCaskill et al.
patent: 5410693 (1995-04-01), Yu et al.
patent: 5412805 (1995-05-01), Jordan, II et al.
patent: 5446858 (1995-08-01), Copeland et al.
patent: 5581275 (1996-12-01), Glei et al.
patent: 5739817 (1998-04-01), Glei et al.
patent: 5835904 (1998-11-01), Vicik et al.
patent: 5918224 (1999-06-01), Bredenberg
patent: 5926807 (1999-07-01), Peltonen et al.
patent: 5930793 (1999-07-01), Kleewein et al.
patent: 5974416 (1999-10-01), Anand et al.
patent: 6256626 (2001-07-01), Dong et al.
patent: 6606618 (2003-08-01), Delo
patent: 6879984 (2005-04-01), Duddleson et al.
patent: 6990477 (2006-01-01), Cotner et al.
patent: 7487159 (2009-02-01), Cotner et al.
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 Structured Query Language Cursors”, vol. 38, No. 07, Jul. 1995, pp. 393-394.
Boykin, J.R., et al., “IBM Technical Disclosure Bulletin: Updateable Scrollable Cursors”, vol. 36, No. 04, Apr. 1993, pp. 263-268.
IBM Corp., “Distributed Data Management Architecture: General Information, Level 4”, IBM Document No. GC21-9527-03, 1986, 1993, pp. 1-69. Retrieved from the Internet at <URL: 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 the Internet at <URL: http://publibfp.boulder.ibm.com>.
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>.
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.
Cotner Curt Lee
Dong Margaret A.
Dutta Rabindranath
International Business Machines - Corporation
Konrad Raynes & Victor LLP
LeRoux Etienne P
LandOfFree
System and program for implementing scrollable cursors in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and program for implementing scrollable cursors in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and program for implementing scrollable cursors in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2750888