Method and apparatus for reorganizing an active DBMS table

Details Method and apparatus for reorganizing an active DBMS table Method and apparatus for reorganizing an active DBMS table

1998-09-22

2000-09-19

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707100, 707101, G06F 1700

Patent

active

061226408

ABSTRACT:
Reorganization of database tables is performed while the tables being reorganized are available for normal OLTP activity. A trigger is setup to record OLTP activity on a source table to be reorganized. The source table is momentarily locked to establish an SCN checkpoint and determine the location of data blocks allocated for the source table. A copy of the table is created (new table) and blocks untouched/modified since the timestamp are unloaded from the source table and inserted into the new table. Transactions occurring since the timestamp are performed on the new table until no more transactions since the timestamp remain in the trigger record. The new table is switched with the source table (renamed as the source table), and the original source table is dropped.

REFERENCES:
patent: 5479654 (1995-12-01), Squibb
patent: 5553279 (1996-09-01), Goldring
patent: 5721915 (1998-02-01), Sockut et al.
patent: 5745753 (1998-04-01), Mosher, Jr.
patent: 5781903 (1998-07-01), Rusterholz
patent: 5790848 (1998-08-01), Wlaschin
patent: 5881379 (1999-03-01), Beier et al.
patent: 5887274 (1999-03-01), Barry et al.
patent: 5890154 (1999-03-01), Hsiao et al.
patent: 5963961 (1999-10-01), Cannon et al.
patent: 5983239 (1999-11-01), Cannon
patent: 5991772 (1999-11-01), Doherty et al.
Oracle 7tm Server, SQL Language Reference Manual, Part No. 778-70-1292, Dec. 1992, pp. 4-89 thru 4-96.
Oracle 7tm Server, Concepts Manual, Part No. 6693-70-1292, Dec. 1991, pp. 51-1 thru 15-14, 21-31 thru 21-32.

Affiliated with

Also associated with

Rating

Method and apparatus for reorganizing an active DBMS table does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for reorganizing an active DBMS table, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for reorganizing an active DBMS table will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1083400