Method and apparatus for accessing data as it existed at a...

Details Method and apparatus for accessing data as it existed at a... Method and apparatus for accessing data as it existed at a...

2006-01-03

2006-01-03

Mizrahi, Diane (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06983286

ABSTRACT:
Techniques are provided for sharing of flashback cursors by adding a time domain property to flashback cursors. This time domain property defines the range of flashback times for which the flashback cursor is valid. According to one embodiment, this “validity range” is closed at the lower bound and open at the upper bound. A subsequent flashback query can share an existing flashback cursor if the flashback time of the subsequent flashback query falls within the validity range of the existing flashback cursor. In one embodiment, the validity range of a flashback cursor is established based on times associated with indexes used to process the flashback query for which the flashback cursor was made. Consequently, an existing flashback cursor is less likely to be used by a subsequent flashback query when it would be inefficient to do so.

REFERENCES:
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5317731 (1994-05-01), Dias et al.
patent: 5347653 (1994-09-01), Flynn et al.
patent: 5440730 (1995-08-01), Elmasri et al.
patent: 5638508 (1997-06-01), Kanai et al.
patent: 5701480 (1997-12-01), Raz
patent: 5857204 (1999-01-01), Lordi et al.
patent: 5873102 (1999-02-01), Bridge, Jr. et al.
patent: 5890167 (1999-03-01), Bridge, Jr. et al.
patent: 5907848 (1999-05-01), Zaiken et al.
patent: 5930794 (1999-07-01), Linenbach et al.
patent: 5956731 (1999-09-01), Bamford et al.
patent: 5974427 (1999-10-01), Reiter
patent: 6012059 (2000-01-01), Neimat et al.
patent: 6012060 (2000-01-01), Loaiza et al.
patent: 6014674 (2000-01-01), McCargar
patent: 6018746 (2000-01-01), Hill et al.
patent: 6029160 (2000-02-01), Cabrera et al.
patent: 6067550 (2000-05-01), Lomet
patent: 6138121 (2000-10-01), Costa et al.
patent: 6173292 (2001-01-01), Barber et al.
patent: 6182241 (2001-01-01), Ngai et al.
patent: 6192377 (2001-02-01), Ganesh et al.
patent: 6192378 (2001-02-01), Abrams et al.
patent: 6237001 (2001-05-01), Bamford et al.
patent: 6243702 (2001-06-01), Bamford et al.
patent: 6263338 (2001-07-01), Ronström et al.
patent: 6321234 (2001-11-01), Debrunner et al.
patent: 6449624 (2002-09-01), Hammack et al.
patent: 6480847 (2002-11-01), Linenbach et al.
patent: 6502133 (2002-12-01), Baulier et al.
patent: 6505228 (2003-01-01), Schoening et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6631374 (2003-10-01), Klein et al.
patent: 6636851 (2003-10-01), Bamford et al.
patent: 6647473 (2003-11-01), Golds et al.
patent: 6647510 (2003-11-01), Ganesh et al.
patent: 6681230 (2004-01-01), Blott et al.
patent: 6735605 (2004-05-01), Bird et al.
patent: 6738975 (2004-05-01), Yee et al.
patent: 6769074 (2004-07-01), Vaitzblit
patent: 6769124 (2004-07-01), Schoening et al.
patent: 2002/0116457 (2002-08-01), Eshleman et al.
patent: 2005/0055385 (2005-03-01), Sinha et al.
patent: 2005/0055603 (2005-03-01), Soran et al.
patent: 2 746 526 (1997-09-01), None
Nassima Djafri et al., Spatio-temporal evolution: querying patterns of change in databases, 2002, ACM Press, pp. 35-41.
Sirish Chandrasekaran et al., “PSoup: a system for streaming queries over streaming data”, 2003, vol. 12, Issue 2, pp. 140-156.
Sandra Cheevers, Oracle Corporation, “Oracle9i Database Summary,” An Oracle White Paper, May 2002, pp. 1-35.
Ron Weiss, Oracle Corporation, “Oracle 9i Availability and Manageability Technology,” Feb. 13, 2001, pp. 1-39.
Ron Weiss, Oracle Corporation, “Oracle High Availability Architectural Overview,” Feb. 12, 2001, pp. 1-37.
Oracle Corporation, “Oracle9i Flashback Query,” Oracle 9i Database, Daily Feature, Apr. 18, 2002, pp. 1-2.
Oracle Corporation, “Flashback Technology,” 2004, pp. 1-5.
Chiang Lee et al, “Temporal Grid File: A File Structure for Interval Data,” Data & Knowledge Engineering, vol. 26, No. 1, May 1998, XP-001004414, pp. 71-97.
Toshiyuki Amagasa et al, “Implementing Time-Interval Class for Managing Temporal Data,” International Workshop on Database and Expert Systems Applications, Aug. 26, 2003, XP-002167975, 7 pages.

Affiliated with

Also associated with

Rating

Method and apparatus for accessing data as it existed at 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 Method and apparatus for accessing data as it existed at a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for accessing data as it existed at a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3542922