Error-detection in database update processes

Details Error-detection in database update processes Error-detection in database update processes

1993-02-25

1995-04-04

Atkinson, Charles E.

395600, G06F 1100

Patent

active

054045029

ABSTRACT:
A technique for integrity error detection in a temporal transaction oriented database system. The database system has records and processing rules. Each record has an effective time. Each processing rule has a range of effective times. The record types include transaction records, master records, shadow master records and snapshot records. Each transaction record or snapshot record is related to one master record and each master record may have a plurality of related transaction and snapshot records. Each snapshot record is a copy of its related master record at a given effective time. On the insertion of one or more backdated transaction records or reversal of one or more existing transaction records the master record is recalculated by replaying from a prior snapshot forward, all processing rules and transaction records, having appropriate effective times. A shadow master record is recalculated by simultaneously repeating each of the steps of the replay on the shadow master record, but in this case ignoring any new backdated transactions and including any newly reversed transaction records. The comparison of the shadow master record after replay and the value of the master record before replay indicates the presence or absence of an integrity error.

REFERENCES:
PCT International Search Report, International application No. PCT/CA94/00099, International Filing Date Feb. 24, 1994.
Proceedings of the TAIS Conference: Temporal Aspects in Information Systems, 13-15 May, 1987, Sophia Antipolis, France, pp. 239-253, Saake, G. and Lipeck, U. W., "Foundations of Temporal Integrity Monitoring".
"Acta Informatica", vol. 28, No. 4, 1991, pp. 365-407, Hulsmann and G. Saake, Theoretical foundations of handling large substitution sets in temporal integrity monitoring.
Abstract-U.S. Pat. Ser. No. 4,646,229.
Abstract-RD 302003.
Abstract-WO 8904013.
Abstract-RD 295007.
Abstract-EP 350208.
Abstract-U.S. Pat. Ser. No. 4,961,139.
Abstract-U.S. Pat. Ser. No. 5,043,871.
Abstract-EP 455440.
Abstract-EP 362971.
Abstract-EP 306197.
Abstract-U.S. Pat. Ser. No. 4,940,072.
Abstract-WO 8601018.
Abstract-U.S. Pat. Ser. No. 4,686,620.
Abstract-EP 191036.
Abstract-EP 153856.
Abstract-U.S. Pat. Ser. No. 4,635,189.
Abstract-EP 153856.

Affiliated with

Also associated with

Rating

Error-detection in database update processes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Error-detection in database update processes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Error-detection in database update processes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2385451