Patent · US Active

Database backup and restore with integrated index reorganization

US8200633B2 · kind B2 · utility

9Cited by

12References

18Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Amit Bendakovsky · Neu-Isenburg, DE
Namik Hrle · Eppelheim, DE
Thomas Ritter · Katy, US

Key dates

Filing date	May 27, 2010
Grant date	Jun 12, 2012
Priority date	—
Expiry date	Nov 29, 2030

Classification

Technology area (CPC G)Physics
CPC primaryG06F2201/80
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

According to an embodiment of the present invention, a method 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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.