Merging database log files through log transformations

Details Merging database log files through log transformations Merging database log files through log transformations

1997-06-06

1999-03-30

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 3, 707201, G06F 1700

Patent

active

058901540

ABSTRACT:
A method to construct a global equivalent database log file that transforms local log files from a parallel or distributed database system by extracting from each log file sequences of log entries from each database record, breaking the sequences into a series of segments, discarding the bulk of the segments and shortening other segments, then merging the remaining segments into an equivalent log file. The sequences are called "UID-sequences" and the segments "UID-segments" because they relate to one unique record ID or UID. The method also employs backward and forward superposition to further shorten the segments. This method works on database systems with or without instant constraint checks and also provides for treating log entries from multiple adjacent transactions on a log file as a single transaction. In systems with instant constraint checks, this method performs a "unique-key check" and a "foreign-key check" and resolves conflicts that are created because of superposition.

REFERENCES:
patent: 5043866 (1991-08-01), Myre et al.
patent: 5157779 (1992-10-01), Washburn et al.
patent: 5220501 (1993-06-01), Lawlor et al.
patent: 5481699 (1996-01-01), Saether
patent: 5751289 (1998-05-01), Myers

Affiliated with

Also associated with

Rating

Merging database log files through log transformations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Merging database log files through log transformations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Merging database log files through log transformations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1225567