Generation of database deltas and restoration

Details Generation of database deltas and restoration Generation of database deltas and restoration

2008-06-04

2011-12-13

Mahmoudi, Tony (Department: 2169)

Data processing: database and file management or data structures

File or database maintenance

Coherency

C707S610000, C707S625000, C707S638000, C707S695000

Reexamination Certificate

active

08078655

ABSTRACT:
A checkpoint system is provided to quickly identify differences or deltas between a baseline version and a modified version of a database and to quickly restore the database to the baseline version using the deltas. The checkpoint system identifies the deltas between versions of the database by a rapid comparison of the rows of each table within a baseline version and a modified version of the database. The checkpoint system can use the rapid comparison when testing to identify sets of deltas resulting from performing an old procedure on a test database and a new procedure on the test database. The rapid comparison can be applied to these sets of deltas to identify differences resulting from the new procedure. The deltas can also be used to rapidly restore a database from a modified version to a baseline version.

REFERENCES:
patent: 5043866 (1991-08-01), Myre, Jr. et al.
patent: 5864849 (1999-01-01), Bohannon et al.
patent: 5996088 (1999-11-01), Frank et al.
patent: 6014669 (2000-01-01), Slaughter et al.
patent: 6769074 (2004-07-01), Vaitzblit
patent: 6839724 (2005-01-01), Manchanda et al.
patent: 6983291 (2006-01-01), Cochrane et al.
patent: 7331000 (2008-02-01), Ohno et al.
patent: 2001/0044834 (2001-11-01), Bradshaw et al.
patent: 2002/0107877 (2002-08-01), Whiting et al.
patent: 2003/0018644 (2003-01-01), Bala et al.
patent: 2004/0210577 (2004-10-01), Kundu et al.
patent: 2004/0260678 (2004-12-01), Verbowski et al.
patent: 2006/0004839 (2006-01-01), Nagasawa et al.
patent: 2007/0220356 (2007-09-01), Ruscio et al.
patent: 2007/0226730 (2007-09-01), Coyle et al.
patent: 2008/0147756 (2008-06-01), Stager et al.
Brad M. McGehee, New SQL Data Compare 3.0 Keeps Data in Different Databases Synchronized, Jul. 22, 2005, www.sql-server-performance.com.
ESRI Developer Network, Table Compare (Data Management), Aug. 22, 2006, edndoc.esri.com.
Crus, R.A., “Data Recovery in IBM Database 2,” IBM Systems Journal, vol. 23, No. 2, 1984, pp. 178-188. http://www.research.ibm.com/journal/sj/232/ibmsj2302H.pdf.
Joshi, Ashok et al., “Checkpointing in Oracle,” Proceedings of the 24th International Conference on Very Large Data Bases, 1998, pp. 665-668. http://www.vldb.org/conf/1998/p665.pdf.
Lin, Jun-Lin et al., “A Survey of Distributed Database Checkpointing,” Distributed and Parallel Databases, vol. 5, Issue 3, Jul. 1997, 34 pages. http://citeseer.ist.psu.edu/cache/papers/cs/29565/http:zSzzSzwww.seas.smu.eduzSz˜mhdzSzpubszSz97zSzdpd.pdf/lin97survey.pdf.

Affiliated with

Also associated with

Rating

Generation of database deltas and restoration does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Generation of database deltas and restoration, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Generation of database deltas and restoration will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4313450