Invention Grant
US07987164B2 Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems
有权
在数据库系统中的分区维护操作期间加快重建用户定义索引的方法和系统
- Patent Title: Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems
- Patent Title (中): 在数据库系统中的分区维护操作期间加快重建用户定义索引的方法和系统
-
Application No.: US12007325Application Date: 2008-01-09
-
Publication No.: US07987164B2Publication Date: 2011-07-26
- Inventor: Ying Hu , Seema Sundara , Jagannathan Srinivasan
- Applicant: Ying Hu , Seema Sundara , Jagannathan Srinivasan
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Murphy & King, P.C.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

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.
Public/Granted literature
Information query