Querying past versions of data in a distributed database

Details Querying past versions of data in a distributed database Querying past versions of data in a distributed database

2004-06-10

2009-06-23

Vital, Pierre M (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C711S162000

Reexamination Certificate

active

07552149

ABSTRACT:
Past versions of data in a distributed database system comprising multiple databases and associated database servers are queried using temporal database access mechanisms, where a request for data in a past state from a “remote” database can be received at a “local” database server and relevant portions of the request are passed to the remote server for processing. The processing performed by the remote server includes returning the requested data in the specified past state to the local server, or at least with enough information to reconstruct the data into the past state.

REFERENCES:
patent: 5212788 (1993-05-01), Lomet et al.
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5317731 (1994-05-01), Dias et al.
patent: 5333316 (1994-07-01), Champagne et al.
patent: 5347653 (1994-09-01), Flynn et al.
patent: 5440730 (1995-08-01), Elmasri et al.
patent: 5447164 (1995-09-01), Shaya et al.
patent: 5452445 (1995-09-01), Hallmark et al.
patent: 5613113 (1997-03-01), Goldring
patent: 5638508 (1997-06-01), Kanai et al.
patent: 5701480 (1997-12-01), Raz
patent: 5857204 (1999-01-01), Lordi et al.
patent: 5870758 (1999-02-01), Bamford 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: 5999924 (1999-12-01), Bair et al.
patent: 6003024 (1999-12-01), Bair et al.
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: 6233573 (2001-05-01), Bair 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: 6321324 (2001-11-01), Debrunner et al.
patent: 6345268 (2002-02-01), de la Huerga
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: 6714943 (2004-03-01), Ganesh 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: 7237075 (2007-06-01), Welsh et al.
patent: 7274783 (2007-09-01), Yoakum 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: 2005/0144199 (2005-06-01), Hayden
patent: 2005/0256897 (2005-11-01), Sinha et al.
patent: 2005/0278350 (2005-12-01), Yang et al.
patent: 2 746 526 (1997-09-01), None
Chandrasekaran, Sirish, “PSoup: a system for streaming queries over streaming data” (2003) vol. 12, Issue 2, pp. 140-156.
Djafri, Nassima et al., “Spatio-temporal evolution: querying patterns of change in databases” (2002) ACM Press, pp. 35-41.
Sandra Cheevers, Oracle Corporation, “Oracle9iDatabase Summary,” An Oracle White Paper, May 2002, pp. 1-35.
Ron Weiss, Oracle Corporation, “Oracle 9iAvailability 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, “Oracle9iFlashback Query,” Oracle9iDatabase, 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

Querying past versions of data in a distributed database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Querying past versions of data in a distributed database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Querying past versions of data in a distributed database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4053269