Method and system for speeding up rebuild of user-defined...

Details Method and system for speeding up rebuild of user-defined... Method and system for speeding up rebuild of user-defined...

2011-07-26

2011-07-26

Lu, Kuen S (Department: 2163)

Data processing: database and file management or data structures

Data integrity

Index maintenance

C707S702000

Reexamination Certificate

active

07987164

ABSTRACT:
A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.

REFERENCES:
patent: 6816853 (2004-11-01), Agarwal et al.
patent: 7035851 (2006-04-01), Sinclair et al.
patent: 2002/0184253 (2002-12-01), Agarwal et al.
patent: 2004/0122828 (2004-06-01), Sidle et al.
patent: 2004/0199530 (2004-10-01), Avadhanam et al.
patent: 2005/0027692 (2005-02-01), Shyam et al.
patent: 2005/0182762 (2005-08-01), Srinivasan et al.
patent: 2008/0228802 (2008-09-01), Marshall

Affiliated with

Also associated with

Rating

Method and system for speeding up rebuild of user-defined... 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 system for speeding up rebuild of user-defined..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for speeding up rebuild of user-defined... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2638231