Interaction between application of a log and maintenance of a ta

Details Interaction between application of a log and maintenance of a ta Interaction between application of a log and maintenance of a ta

1995-06-01

1998-02-24

Black, Thomas G.

395617, 395618, 395202, G06F 1730

Patent

active

057219150

ABSTRACT:
The present invention includes reorganization of a Database Management System (DBMS) The reorganization of the present invention is implemented by recording a first current Relative Byte Address (RBA) Then, data is copied from the old area in the table space to a new area in the table space in reorganized form. In the present invention, throughout most of reorganization a user maintains access to the DBMS's normal facilities to read and write to the old area. The DBMS uses its normal facilities to record writing, which occurs during reorganization, in,a log. The reorganization in accordance with the present invention reads the log (that has been written to during reorganization) and processes the log to the new area to bring the new area up to date. This process is performed with the use of a RID mapping table. Finally, at the end of reorganization, the user's access is switched from the old area to the new area.

REFERENCES:
patent: 5307262 (1994-04-01), Ertel
R.A. Crus, "Data Recovery in IBM Database 2", IBM Systems Journal, vol. 23, No. 2, 1984.
C. Mohan, "Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates", ACM Sigmod, 1992.
Scheuermann, "Concurrent File Reorganization for Record Clustering: A Performance Study", IEEE 1992.
Omiecinski et al, "Performance Analysis of a Concurrent File Reorganization Algorithm for Record Clustering", IEEE Transactions vol. 6, No. 2 Apr. 1994.
Wiener et al., "Bulk Loading into an OODB: A Performance Study," Proceedings of the 20th VLDB Conference, Santiago, Chile, 1994, pp. 120-131.
Performance Analysis of a Concurrent File Reorganization Algorithm for Record Clustering, IEEE Transactions on Knowledge and Data Engineering, vol. 6, No. 2, pp. 248-257, Apr. 1994.
Concurrent File Reorganization for Record Clustering: A Performance Study, IEEE, pp. 265-272, Jul. 1992.
Data Recovery in IBM Database 2, IBM Systems Journal, vol. 23, No. 2, pp. 178-188, 1984.
C. Mohan and Inderpal Narang, Algorithims for Creating Indexes for Very Large Tables Without Quiescing Updates, Database Technology Institute, pp. 361-370, Jun. 1992.

Affiliated with

Also associated with

Rating

Interaction between application of a log and maintenance of a ta does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Interaction between application of a log and maintenance of a ta, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Interaction between application of a log and maintenance of a ta will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1881784