发明授权
- 专利标题: Parallel index maintenance
- 专利标题(中): 并行索引维护
-
申请号: US09379625申请日: 1999-08-24
-
公开(公告)号: US06438562B1公开(公告)日: 2002-08-20
- 发明人: Shivani Gupta , William H. Waddington , Benoit Dageville
- 申请人: Shivani Gupta , William H. Waddington , Benoit Dageville
- 主分类号: G06F1730
- IPC分类号: G06F1730
摘要:
A method, system and product for coordinating a parallel update for a global index of an indexed table involves a coordinator process and slave processes. The coordinator process receives index maintenance records from data manipulation slaves for an indexed table. Each index maintenance record includes a value for an index key of a global index of the table. The coordinator process computes index key value ranges and sends each range to an index update slave. Each slave updates the global index using just the index maintenance records with key values in its respective range, thus avoiding contention among the slaves and increasing clustering so that scaleable parallelism may be more closely attained. Techniques are also described for deferring the maintenance of global indexes relative to the time when the table on which they are built is changed.
信息查询