US Patent 7415457 Using a cache to provide cursor isolation

In one approach disclosed herein, a cache is used to provide cursor isolation. The cache is used to cache data that is updated in a query. Specifically, when a query is initiated, one or more caches may be instantiated in respect of the cursor. When data is updated during the query, the updated data is stored in the cache. By storing the updated data in the cache, the updated data is isolated from other users, from other sessions and from other queries by the same user.