Batch processing of updates to indexes

Details Batch processing of updates to indexes Batch processing of updates to indexes

1997-06-04

2000-02-15

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707 7, G06F 1730

Patent

active

060264063

ABSTRACT:
A method and apparatus for batch processing of updates to indexes is provided. A plurality of index update records are generated that identify a plurality of index update operations to be made to an index. The plurality of index entry records are sorted and then applied, in an order that corresponds to the sort order, in batches to their respective indexes. As a result of performing batch processing of updates to indexes, the number of disk I/Os will be greatly reduced, freeing database system resources to perform other tasks. The overall efficiency of index maintenance is also improved, as is the recovery of the database system after a failure, resultant from an ordering of the index maintenance operations and a partial ordering of the persistent redo log file.

REFERENCES:
patent: 4933848 (1990-06-01), Harderle et al.
patent: 5276872 (1994-01-01), Lomet et al.
patent: 5288894 (1994-02-01), Deran
patent: 5563997 (1996-10-01), Fisher
patent: 5717921 (1998-02-01), Lomet et al.
patent: 5758356 (1998-05-01), Hara et al.
D. Knuth, The Art of Computer Programming vol. 3, "Sorting and Searching," Addison-Wesley Publishing Co., Jan. 1973, ISBN 0-201-03803-X, pp. 158-168; Table of Contents (xii-xiii); Index and Glossary (pp. 757-780).
J. Gray and A. Rueter, Transaction Processing Concepts and Techniques, Morgan Kaufman Publishers, Jan. 1993, ISBN-1-55860-190-2; pp. 406-416, Table of Contents (vii-xx); Index (pp. 1047-1070).

Affiliated with

Also associated with

Rating

Batch processing of updates to indexes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Batch processing of updates to indexes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Batch processing of updates to indexes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1914715