Removing overflow rows in a relational database

Details Removing overflow rows in a relational database Removing overflow rows in a relational database

2004-01-14

2009-06-30

Ly, Cheyne D (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

07555491

ABSTRACT:
Techniques to repair overflow rows in a relational database table are described. In one implementation, a source table's physical memory pages are interrogated to identify overflow rows. In another implementation, overflow rows generated during database update operations are identified from non-table sources (e.g., log files). In general, overflow rows are repaired by: unloading one or more rows identified as overflow rows; locking the source table from outside access; disabling or deleting any associations associated with the unloaded rows; deleting the identified overflow/unloaded rows from the source table; reloading the previously unloaded rows back into the source table; restoring any associations previously disabled/deleted; and unlocking the tables. Rows may be processed in groups small enough not to significantly impact users accessing either the source or associated tables.

REFERENCES:
patent: 5899993 (1999-05-01), Jenkins, Jr.
patent: 6047285 (2000-04-01), Jacobs et al.
patent: 6950834 (2005-09-01), Huras et al.
patent: 2005/0080979 (2005-04-01), Wu et al.
Sockut, G., IBM Systems Journal, vol. 36, No. 3, 1997, pp. 1-19.
Haderle et al., IBM Systems Journal, vol. 23, No. 2, 1984, pp. 112-125.
Sockut et al., Computing Surveys, vol. 11, No. 4, 1979, pp. 371-395.
Ramakrishnan, R., Database Management Systems, WCB/McGraw-Hill, p. 22, 1998.
Lin et al., IEEE Transactions on Vehicular Technology, vol. 49, No. 2, Mar. 2000, pp. 520-530.
Hung et al., IEEE Journal of Selected Areas in Communications, vol. 19, No. 10, Oct. 2001, pp. 1953-1961.

Affiliated with

Also associated with

Rating

Removing overflow rows in a relational database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Removing overflow rows in a relational database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Removing overflow rows in a relational database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4095338