Architecture of database application with robust online...

Details Architecture of database application with robust online... Architecture of database application with robust online...

2007-10-09

2007-10-09

Gaffin, Jeffrey (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10734112

ABSTRACT:
An architecture for efficiently identifying the scope and timeframe of database errors, providing online history images, creating online point-in-time views of application tables, reconstructing equivalent SQL statements of a committed transaction or of a user session, providing a selective audit trail report on demand, and permitting selective online rollbacks in an application database. The rollback can be done on a single row, a single transaction, a group transactions, a user session, or all user tables. The system includes after images tables and before images tables and tracks all before images of user application tables when a user performs an INSERT, UPDATE, or DELETE operation with respect to a row in a table. Also, the system is provided to generate history images of application tables at a point-in-time, and to selectively rollback, or undo whole or a portion of application tables, to generate a selective audit trail report on demand, and to manage the before images.

REFERENCES:
patent: 5301319 (1994-04-01), Thurman et al.
patent: 5369757 (1994-11-01), Spiro et al.
patent: 5414840 (1995-05-01), Rengarajan et al.
patent: 5581750 (1996-12-01), Haderle et al.
patent: 5682527 (1997-10-01), Cooper et al.
patent: 5712971 (1998-01-01), Stanfill et al.
patent: 5758150 (1998-05-01), Bell et al.
patent: 5799323 (1998-08-01), Mosher, Jr. et al.
patent: 5864849 (1999-01-01), Bohannon et al.
patent: 5870759 (1999-02-01), Bauer et al.
patent: 5870763 (1999-02-01), Lomet
patent: 5884312 (1999-03-01), Dustan et al.
patent: 5884324 (1999-03-01), Cheng et al.
patent: 5890154 (1999-03-01), Hsiao et al.
patent: 5907849 (1999-05-01), Dias et al.
patent: 5931955 (1999-08-01), Kung
patent: 5933838 (1999-08-01), Lomet
patent: 5946698 (1999-08-01), Lomet
patent: 5974425 (1999-10-01), Obermarck et al.
patent: 6065018 (2000-05-01), Beier et al.
patent: 6078932 (2000-06-01), Haye et al.
patent: 6151607 (2000-11-01), Lomet
patent: 6163856 (2000-12-01), Dion et al.
patent: 6185577 (2001-02-01), Nainani et al.
patent: 6253211 (2001-06-01), Gillies et al.
patent: 6275824 (2001-08-01), O'Flaherty et al.
patent: 6295610 (2001-09-01), Ganesh et al.
patent: 6324548 (2001-11-01), Sorenson
patent: 6397227 (2002-05-01), Klein et al.
patent: 6421686 (2002-07-01), Martin, Jr.
patent: 6430577 (2002-08-01), Hart
patent: 6449623 (2002-09-01), Bohannon et al.
patent: 6453325 (2002-09-01), Cabrera et al.
patent: 6539402 (2003-03-01), Sorenson et al.
patent: 2002/0007363 (2002-01-01), Vaitzblit
patent: 2002/0107876 (2002-08-01), Tsuchida et al.
patent: 2002/0116404 (2002-08-01), Cha et al.
Oracle9i Database Daily Feature, Oracle9i Flashback Query, <http://technet.oracle.com/products/oracle9i/daily/Aug13.html>, printed on Aug. 28, 2003.

Affiliated with

Also associated with

Rating

Architecture of database application with robust online... does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3890903