Patent · US Active

Database backup and restore with integrated index reorganization

US8626717B2 · kind B2 · utility

16Cited by

12References

17Claims

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 7, 2012
Grant date	Jan 7, 2014
Priority date	—
Expiry date	May 7, 2032

Classification

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

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.

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