International Business Machines Corporation

Ibm Canada Limited - Ibm Canada Limitee

Iqbal A Goralwalla

David C Sharpe

Matthew Albert Huras

Michael Jeffrey Winer

William T O'Connell

Michael J Winer

Matthew A Huras

The present invention provides a system and a method for materializing records in a result set in response to a query. The computer system comprises a server and a client. The server has a database and a database management system for providing access to the database. The client is operatively coupled to the database management system. The client is adapted to provide a query to the database management system and the database management system is adapted to materialize a number of records in a result set in response to the query. The number of materialized records is selected to reduce inefficient materialization of records from the database in response to the query.

Method and system for slow materialization of scrollable cursor result sets

A procedure optimizes command execution in a database system. According to one embodiment, the database system stores data records on data pages, and provides an identifier for each data page. The identifier indicates when any of the data records contained in the data page were last modified. A data record is selected from a data page and copied to a second storage area. Verification that the selected data record has not been modified since the time that is was copied to the second storage area is based upon the identifier, and then the command is executed.

Optimizing command execution in database systems that provide support for updatable scrollable cursors

Growing community of inventors

Pickering, Canada

Iqbal A Goralwalla