Invention Grant
- Patent Title: System and method for partially deferred index maintenance
- Patent Title (中): 部分延期索引维护的系统和方法
-
Application No.: US13085281Application Date: 2011-04-12
-
Publication No.: US08954407B2Publication Date: 2015-02-10
- Inventor: Namik Hrle , Johannes Schuetzner , Knut Stolze
- Applicant: Namik Hrle , Johannes Schuetzner , Knut Stolze
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Mollborn Patents, Inc.
- Agent Fredrik Mollborn
- Priority: EP10169375 20100713
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

Abstract:
Methods and Apparatus, including computer program products, for maintaining indexes in a database management system. The database management system includes a table having table entries and an index data structure having index data structure entries, the index data structure relating to the table. The index data structure is updated synchronously with an insertion of table entries. The index data structure is maintained unchanged when the table entries are deleted. It is verified by an index-scan on the index data structure that a valid criterion is fulfilled for index data structure entries, and those index data structure entries that pass the valid criterion from the index-scan are returned.
Public/Granted literature
- US20120016851A1 System and Method for Partially Deferred Index Maintenance Public/Granted day:2012-01-19
Information query