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

1997-06-30

2000-02-15

Fetting, Anton W.

Data processing: database and file management or data structures

Database design

Data structure types

707201, 707202, G06F 1730

Patent

active

060264128

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: 5414834 (1995-05-01), Alexander et al.
patent: 5455945 (1995-10-01), VanderDrift
V. Srinivasan & Michael J. Carey, "On-Line Index Construction Algorithms," Computer Sciences Technical Report #1008, Mar. 1991.
Gary H. Sockut & Robert P. Goldberg, "Database Reorganization-Principles And Practice", Computing Surveys, vol. 11, No. 4, Dec. 1979.
Wiener et al., "Bulk Loading into an OODB: A Performance Study," Proceedings of the 20th VLDB Conference, Santiago, Chile, 1994, pp. 120-131.
Non-Stop Availability and Database Configuration Operations, Tandem Systems Review, vol. 10, No. 3, pp. 18-23, Jul. 1994.
NonStop SQL: Scalability and Availability for Decision Support, Tandem Computers, Inc., p. 491, no date.
Reorganizing Databases Concurrently with Usage: A Survey, Technical Report, TR 03.488, Jun. 1993.
Replidata/MVS User's Guide, Release 1.0, First Edition, Jan. 1994.
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.
James O'Toole, Scott Nettles and David Gifford, Concurrent Compacting Garbage Collection of a Persistent Heap, pp. 161-173, 1993.
Data Base Restructuring: Options and Obstacles, EURO IFIP 79, North Holland Publishing Company, 1979.
Data Recovery in IBM Database 2, IBM Systems Journal, vol. 23, No. 2, pp. 178-188, 1984.
The Design of XPRS, Proceedings of the 14th VLDB Conf., pp. 318-330, 1988.
C. Mohan and Inderpal Narang, Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates, Database Technology Institute, pp. 361-370, Jun. 1992.
On-Line Index Construction Algorithms, Computer Sciences Technical Report #1008, Computer Sciences Department, University of Wisconsin-Madison, Mar. 1991.
Performance of On-Line Index Construction Algorithims, Advances in Database Technology, 3rd Int'l Conf. on Extending Database Technology, pp. 293-309, Mar. 1992.
V. Srinivasan and Michael J. Carey, Compensation-Based On-Line Query Processing, Department of Computer Sciences, University of Wisconsin-Madison, pp. 331-340, Jun. 1992.
Professor Michael Stonebraker, Hypothetical Data Bases as Views, Department of Electrical Engineering and Computer Sciences, University of California, pp. 224-229, 1981.
Database Reorganization-Principles and Practice, Computer Surveys, vol. 11, No. 4, Dec. 1979.

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-1914750