Apparatus and method for validating a database record before...

Details Apparatus and method for validating a database record before... Apparatus and method for validating a database record before...

2005-11-22

2005-11-22

Mizrahi, Diane (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06968349

ABSTRACT:
An apparatus and method includes a database journal that records journal entries. Each journal entry includes a validation value that is computed from the data and metadata for the record before it is changed. In this manner, journal entries may be applied with confidence to a record in a database. This is especially useful when minimized data journal entries are used. If the validation value of the journal entry matches the validation value computed from the data and metadata of the record that the journal entry is to be applied to, then the record before applying the journal entry is identical to the record in the original database, and the journal data may be applied to the database record. If the validation value of the journal entry does not match the validation value computed from the data and metadata of the record that the journal entry is to be applied to, the record is not the same as in the original database when the journal entry was generated. As a result, an error message is generated to indicate that an error was encountered when applying the journal entry. In this manner, the apparatus and method of the preferred embodiments automatically validate a database record before applying journal data to the record.

REFERENCES:
patent: 5765172 (1998-06-01), Fox
patent: 6092189 (2000-07-01), Fisher et al.
patent: 6247149 (2001-06-01), Falls et al.
patent: 6324693 (2001-11-01), Brodersen et al.
patent: 6442748 (2002-08-01), Bowman-Amuah
patent: 6640249 (2003-10-01), Bowman-Amuah
patent: 2003/0009753 (2003-01-01), Brodersen et al.
patent: 2004/0249869 (2004-12-01), Oksanen

Affiliated with

Also associated with

Rating

Apparatus and method for validating a database record before... 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 and method for validating a database record before..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for validating a database record before... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3464405