Patent · US Active

Workload aware checking of database reorganization

US7797347B2 · kind B2 · utility

5Cited by

3References

18Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Oliver Draese · Los Gatos, US
Namik Hrle · Eppelheim, DE
Torsten Steinbach · Eppelheim, DE
Michael J. Winer · Markham, CA

Key dates

Filing date	Nov 26, 2007
Grant date	Sep 14, 2010
Priority date	—
Expiry date	Dec 24, 2028

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/22
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

The present solution addresses the need to carry out reorganization of a database storage. A statistics-based reorganization check procedure is performed on at least first database tables and indexes, resulting in a preliminary reorganization recommendation. Information on workload on tables and indexes of said database storage is received. Based on the information on workload and the preliminary reorganization recommendation, it is decided whether to carry out reorganization of the database storage in accordance with the preliminary reorganization recommendation.

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