Method and system for defining transactions from a database log

Details Method and system for defining transactions from a database log Method and system for defining transactions from a database log

1997-03-14

1999-05-25

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 1, 707 2, 707 8, 707 10, 707101, 707103, 707201, 707203, 707204, 707205, 705 4, G06F 1730

Patent

active

059078480

ABSTRACT:
A method and system of providing external transaction protection for a database using the database log or journal. The method involves creating a set of transaction templates which define transactions, using the templates to determine whether each record or entry in the journal represent part of a transaction, and maintaining a set of index file indicating transactions in progress. Each transaction template contains a number of filenames identifying files in the database affected during the transaction defined by the template. Each template also contains a key value representing one or more data fields in the database included in every action performed during the transaction. For each entry in the journal, a determination is made whether the entry belongs to a transaction based on the data fields represented in the entry and the key values associated with the templates. The index files are maintained by creating a new index file for each new transaction, adding data to a given index file from a journal entry which belongs to the transaction associated with the given index file, and deleting index files when transactions with which they are associated are complete. In the event the database is damaged, existing index files are used to determine which transactions did not complete before the database was damaged. The actions which were completed may be rolled back.

REFERENCES:
patent: 5193162 (1993-03-01), Bordsen
patent: 5303368 (1994-04-01), Kotaki
patent: 5680614 (1997-10-01), Bakuya
patent: 5704044 (1997-12-01), Tarter
patent: 5712987 (1998-01-01), Waits
patent: 5729594 (1998-03-01), Klingman
patent: 5734883 (1998-03-01), Umen

Affiliated with

Also associated with

Rating

Method and system for defining transactions from a database log 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 system for defining transactions from a database log, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for defining transactions from a database log will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-409131