Apparatus to selectively remove the effects of transactions...

Details Apparatus to selectively remove the effects of transactions... Apparatus to selectively remove the effects of transactions...

2011-01-18

2011-01-18

Lin, Shew-Fen (Department: 2166)

Data processing: database and file management or data structures

File or database maintenance

Database recovery

C707S679000, C714S015000

Reexamination Certificate

active

07873605

ABSTRACT:
A method and apparatus for selective removal of user data changes is provided. In one embodiment, the methodology is implemented by a logical recovery mechanism. Upon receiving a request to selectively remove user data changes stored in a database, the mechanism creates an empty set of transactions to be populated for selective removal, identifies one or more transactions and places them in the causal set of transactions. The mechanism further identifies other transactions that logically depend on any transaction already in the causal set of transactions. Finally, either while the causal set of transactions is being identified or after the identification is completed, the mechanism also determines user data changes made by the causal set of transactions. One or more compensating transactions may be generated by the logical recovery mechanism, which when executed, reverse the user data changes.

REFERENCES:
patent: 5878206 (1999-03-01), Chen et al.
patent: 6058389 (2000-05-01), Chandra et al.
patent: 6374264 (2002-04-01), Bohannon et al.
patent: 6625602 (2003-09-01), Meredith et al.
patent: 6671686 (2003-12-01), Pardon et al.
patent: 6769074 (2004-07-01), Vaitzblit
patent: 7277900 (2007-10-01), Ganesh et al.
patent: 2004/0068501 (2004-04-01), McGoveran
patent: 2004/0220961 (2004-11-01), Lee et al.
patent: 2005/0131966 (2005-06-01), Lou
Meckenstock et al., “Rolling Back in a Selective Way An Approach to Recovery for Interactive and Long-Running Transactions”, 2nd Int'l Baltic Workshop on DB and IS, 1996.

Affiliated with

Also associated with

Rating

Apparatus to selectively remove the effects of transactions... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus to selectively remove the effects of transactions..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus to selectively remove the effects of transactions... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2651600