Using a cache to provide cursor isolation

Details Using a cache to provide cursor isolation Using a cache to provide cursor isolation

2004-07-23

2008-08-19

Kim, Chong H (Department: 3682)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

07415457

ABSTRACT:
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.

REFERENCES:
patent: 5799300 (1998-08-01), Agrawal et al.
patent: 5907848 (1999-05-01), Zaiken et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5987467 (1999-11-01), Ross et al.
patent: 5999943 (1999-12-01), Nori et al.
patent: 6163774 (2000-12-01), Lore et al.
patent: 6173292 (2001-01-01), Barber et al.
patent: 6185572 (2001-02-01), Blackman et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6282537 (2001-08-01), Madnick et al.
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6421665 (2002-07-01), Brye et al.
patent: 6438537 (2002-08-01), Netz et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6553366 (2003-04-01), Miller et al.
patent: 6560594 (2003-04-01), Cochrane et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6587857 (2003-07-01), Carothers et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6629102 (2003-09-01), Malloy et al.
patent: 6651073 (2003-11-01), Lyle et al.
patent: 6665682 (2003-12-01), DeKimpe et al.
patent: 6711575 (2004-03-01), Applewhite et al.
patent: 6826556 (2004-11-01), Miller et al.
patent: 6931418 (2005-08-01), Barnes
patent: 6941310 (2005-09-01), Ahad et al.
patent: 6980980 (2005-12-01), Yeh
patent: 7020647 (2006-03-01), Egan et al.
patent: 7194465 (2007-03-01), MacGregor
patent: 2002/0059195 (2002-05-01), Cras et al.
patent: 2002/0087516 (2002-07-01), Cras et al.
patent: 2002/0091707 (2002-07-01), Keller
patent: 2002/0103807 (2002-08-01), Yamashita
patent: 2002/0126545 (2002-09-01), Warren et al.
patent: 2002/0138353 (2002-09-01), Schreiber
patent: 2002/0168621 (2002-11-01), Cook et al.
patent: 2002/0184187 (2002-12-01), Bakalash et al.
patent: 2002/0188598 (2002-12-01), Myllymaki
patent: 2003/0014417 (2003-01-01), Kelkar
patent: 2003/0084053 (2003-05-01), Gorvin et al.
patent: 2003/0088540 (2003-05-01), Edmunds et al.
patent: 2003/0093424 (2003-05-01), Chun et al.
patent: 2003/0101202 (2003-05-01), Kelkar et al.
patent: 2003/0195865 (2003-10-01), Long et al.
patent: 2003/0195866 (2003-10-01), Long et al.
patent: 2003/0200197 (2003-10-01), Long et al.
U.S. Appl. No. 10/423,356, filed Apr. 25, 2003, Office Action Mailing Date May 14, 2007.
U.S. Appl. No. 10/898,304, filed Jul. 23, 2004, Office Action Mailing Date Jul. 16, 2007.
Ramsak, Frank, “Interactive ROLAP on Large Datasets: A Case Study with UB-Trees,” Database Engineering & Applications, Jul. 16-18 2001, pp. 167-176.
Ross, Kenneth A., “Serving Datacube Tuples from Main Memory,” Scientific and Statistical Database Management, Jul. 26-28, 2000, pp. 182-195.
IBM, “Treating Data Transformations as Objects”, IBM Technical Disclosure Bulletin, vol. 35, Issue 4a, Sep. 1992, 5 pages.

Affiliated with

Also associated with

Rating

Using a cache to provide cursor isolation does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Using a cache to provide cursor isolation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Using a cache to provide cursor isolation will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3997062