×

ARCHITECTURE OF DATABASE APPLICATION WITH ROBUST ONLINE RECOVERABILITY

  • US 20080046480A1
  • Filed: 08/28/2007
  • Published: 02/21/2008
  • Est. Priority Date: 12/15/2003
  • Status: Abandoned Application
First Claim
Patent Images

1. A computer implemented database application system for managing a transaction in a database, the system comprising:

  • a database manager, an image manager, a rollback manager, a redo and undo log, a system tablespace, and a user tablespace, the user tablespace comprising;

    a rollback timestamp tracking table that stores a table owner, a table name, a retention time, and an export timestamp;

    a transaction identifier (id) tracking table that stores a transaction id, a user id, a session id, a starting timestamp, and an ending timestamp;

    a user session tracking table that stores a user id, an operating system user id, a session id, a process id, a terminal id, a login timestamp, and a logout timestamp; and

    application data, the application data comprising an after image table, a before image table, and an index, an after image view, a time-based after image view, and a history image view, wherein when a user performs a database operation on a row, the image manager inserts an original row, as the row existed prior to the database operation, into the before image table, updates parameters associated with the original row inserted into the before image table, and sets parameters associated with a modified row, as it existed after the database operation, in the after image table.

View all claims
  • 0 Assignments
Timeline View
Assignment View
    ×
    ×