Invention Grant
- Patent Title: Database backup and restore with integrated index reorganization
- Patent Title (中): 数据库备份与恢复与综合索引重组
-
Application No.: US13465381Application Date: 2012-05-07
-
Publication No.: US08626717B2Publication Date: 2014-01-07
- Inventor: Amit Bendakovsky , Namik Hrle , Thomas Ritter
- Applicant: Amit Bendakovsky , Namik Hrle , Thomas Ritter
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Francis Lammes; Stephen J. Walder, Jr.; John D. Flynn
- Priority: DE09167456.4 20090807
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A mechanism is provided for reorganizing a source index tree of a database table resulting in a target index tree of the database table is provided. A backup process reads source leaf pages of the source index tree in a logical order defined by a sequence of index keys. The logical order can be different from a physical order of the source leaf pages defined by a sequence of respective storage locations. The backup process constructs target leaf pages of the target index tree maintaining the logical order. A restore process constructs target non-leaf pages of the target index tree based on the distribution of the index keys among the constructed leaf pages and stores the target leaf and non-leaf pages.
Public/Granted literature
- US20120221523A1 Database Backup and Restore with Integrated Index Reorganization Public/Granted day:2012-08-30
Information query