Method and mechanism for rolling back a transaction on a row...

Details Method and mechanism for rolling back a transaction on a row... Method and mechanism for rolling back a transaction on a row...

2007-10-02

2007-10-02

Le, Debbie (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C714S016000

Reexamination Certificate

active

10364065

ABSTRACT:
A method and mechanism to compensate for the effects of a transaction in a database system is disclosed. Also disclosed is a method and mechanism for identifying one or more transactions that have modified or created an object in a database system. The disclosed approach can be applied to perform auditing for queries in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.

REFERENCES:
patent: 4498145 (1985-02-01), Baker et al.
patent: 4868744 (1989-09-01), Reinsch et al.
patent: 5249300 (1993-09-01), Bachman et al.
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: 5363473 (1994-11-01), Stolfo et al.
patent: 5440730 (1995-08-01), Elmasri et al.
patent: 5481699 (1996-01-01), Saether
patent: 5524205 (1996-06-01), Lomet et al.
patent: 5638508 (1997-06-01), Kanai et al.
patent: 5701480 (1997-12-01), Raz
patent: 5758356 (1998-05-01), Hara et al.
patent: 5819020 (1998-10-01), Beeler, Jr.
patent: 5835698 (1998-11-01), Harris et al.
patent: 5845292 (1998-12-01), Bohannon et al.
patent: 5850507 (1998-12-01), Ngai et al.
patent: 5862318 (1999-01-01), Habben
patent: 5864849 (1999-01-01), Bohannon et al.
patent: 5870758 (1999-02-01), Bamford et al.
patent: 5873102 (1999-02-01), Bridge, Jr. et al.
patent: 5890161 (1999-03-01), Helland et al.
patent: 5890167 (1999-03-01), Bridge, Jr. et al.
patent: 5907848 (1999-05-01), Zaiken et al.
patent: 5923833 (1999-07-01), Freund et al.
patent: 5940839 (1999-08-01), Chen et al.
patent: 5956731 (1999-09-01), Bamford et al.
patent: 5966706 (1999-10-01), Biliris et al.
patent: 5974427 (1999-10-01), Reiter
patent: 5995980 (1999-11-01), Olson et al.
patent: 5996088 (1999-11-01), Frank et al.
patent: 5999943 (1999-12-01), Nori 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: 6138121 (2000-10-01), Costa et al.
patent: 6154847 (2000-11-01), Schofield et al.
patent: 6173292 (2001-01-01), Barber et al.
patent: 6182241 (2001-01-01), Ngai et al.
patent: 6185699 (2001-02-01), Haderle et al.
patent: 6192370 (2001-02-01), Primsch
patent: 6192377 (2001-02-01), Ganesh et al.
patent: 6237001 (2001-05-01), Bamford et al.
patent: 6321234 (2001-11-01), Debrunner
patent: 6341288 (2002-01-01), Yach et al.
patent: 6363499 (2002-03-01), Delo et al.
patent: 6405217 (2002-06-01), Lee
patent: 6438749 (2002-08-01), Chamberlain
patent: 6449624 (2002-09-01), Hammack et al.
patent: 6457021 (2002-09-01), Berkowitz et al.
patent: 6480848 (2002-11-01), DeKimpe et al.
patent: 6513093 (2003-01-01), Chen et al.
patent: 6529921 (2003-03-01), Berkowitz et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6631374 (2003-10-01), Klein et al.
patent: 6640244 (2003-10-01), Bowman-Amuah
patent: 6678696 (2004-01-01), Helland et al.
patent: 6769074 (2004-07-01), Vaitzblit
patent: 6801915 (2004-10-01), Mack
patent: 6804672 (2004-10-01), Klein et al.
patent: 6889231 (2005-05-01), Souder et al.
patent: 6918053 (2005-07-01), Thatte et al.
patent: 7010529 (2006-03-01), Klein et al.
patent: 7103597 (2006-09-01), McGoveran
patent: 7206805 (2007-04-01), McLaughlin, Jr.
patent: 2002/0007363 (2002-01-01), Vaitzblit
patent: 2004/0030954 (2004-02-01), Loaiza et al.
patent: 2005/0125430 (2005-06-01), Souder et al.
patent: 2005/0131966 (2005-06-01), Lou
patent: 2005/0240633 (2005-10-01), Krishnaswamy et al.
patent: 2006/0212492 (2006-09-01), Jacobs et al.
patent: 2 746 526 (1997-09-01), None
Lee, Chiang et al., “Temporal Grid File: A file structure for interval data”, Data & Knowledge Engineering 26, 1998, pp. 71-97.
Amagasa, Toshiyuki et al., “Implementing Time-Interval Class for Managing Temporal Data”, International Workshop on Database and Expert Systems Applications, Aug. 26, 2003, pp. 84,88,843-849.
ORACLE8™ Concepts, vol. 1, Release 8.0, Dec. 1997, Oracle®, pp. 18-14, 21-8, and 24-8 through 24-20.
Perry, J.T. et al. Understanding Oracle, 1989, Sybex, 1st ed., pp. 4-7, 43, 95 and 161-164.
Weikum, et al. “Multi-Level Recovery” ACM (1990) pp. 109-123.
Strom et al. “Optimistic Recovery in Distributed Systems” ACM Transactions on Computer System (Aug. 1995) vol. 3, No. 3, pp. 204-226.
Gomes et al. “Multiplexed State Saving for Bounded Rollback” Proceedings of the 1997 Winder Simulation Conference, Atlanta, GA pp. 460-467.
Microsoft Word User's Guide, Microsoft Corporation, 1993, pp. 14, 15, 40.
Triantafillou, P. “Independent Recovery in Large-Scale Distributed Systems” IEEE Transactions on Software Engineering (Nov. 1996) vol. 22, No. 11, pp. 812-826.
Wiener, J.L. et al. “A System Prototype for Warehouse View Maintenance” VIEWS (1996) pp. 26-33 (provided reference has been numbered pp. 1-8).
Ramakrishnan, R., Database Management System, WCB/McGraw-Hill, 1998, pp. 529-533.

Affiliated with

Also associated with

Rating

Method and mechanism for rolling back a transaction on a row... 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 mechanism for rolling back a transaction on a row..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and mechanism for rolling back a transaction on a row... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3847646