System and method for implementing database cursors in a client/server environment

摘要

A system and method for implementing database cursors at the server in a client/server environment is disclosed. In operation, the system and method for implementing the database cursors is compatible with existing client/server database search engines but provides for increased control over cursor lock options, an ability to share cursors and search plans across multiple nodes in a network, and an increase in the overall operating efficiency of a database application. The invention is directed to cursors for all types of collections or compilations of data in a client/server database environment.