US 2022/0092049 A1 · WORKLOAD-DRIVEN DATABASE REORGANIZATION

Abstract

A system, computer program product, and method are provided for driving database reorganizations subject to determined workloads, and, more specifically, to providing an online partial reorganization of a database to improve workload performance. The method includes collecting performance information for one or more performance sensitive workloads associated with one or more portions of a database and analyzing the collected performance information. For each of the one or more performance sensitive workloads, indications of performance declines thereof are determined. Subject to the determined performance declines, at least one of the one or more database portions affected by the determined performance declines are determined. Subject to the database portions determination, the determined performance declines are classified. Subject to the classification of the performance declines, one or more partial reorganizations of the one or more database portions is executed.

Claims20

Dependent claims

A computer system comprising:

one or more processing devices and at least one memory device operably coupled to the one or more processing devices, the one or more processing devices are configured to:
collect performance information for one or more performance sensitive workloads associated with one or more portions of a database;
analyze the collected performance information comprising one or more of:
determine for each of the one or more performance sensitive workloads, indications of performance declines thereof;
determine, subject to the determined performance declines, at least one of the one or more database portions affected by the determined performance declines;
classify, subject to the database portions determination, the determined performance declines;
and
execute, subject to the classification of the performance declines, one or more partial reorganizations of the one or more database portions.

5 more elements

A computer program product, comprising:

one or more computer readable storage media;
and
program instructions collectively stored on the one or more computer storage media, the program instructions comprising:
program instructions to collect performance information for one or more performance sensitive workloads associated with one or more portions of a database;
program instructions to analyze the collected performance information comprising one or more of:
program instructions to determine for each of the one or more performance sensitive workloads, indications of performance declines thereof;
program instructions to determine, subject to the determined performance declines, at least one of the one or more database portions affected by the determined performance declines;
program instructions to classify, subject to the database portions determination, the determined performance declines;
and
program instructions to execute, subject to the classification of the performance declines, one or more partial reorganizations of the one or more database portions.

7 more elements

A computer-implemented method comprising:

collecting performance information for one or more performance sensitive workloads associated with one or more portions of a database;
analyzing the collected performance information comprising one or more of:
determining for each of the one or more performance sensitive workloads, indications of performance declines thereof;
determining, subject to the determined performance declines, at least one of the one or more database portions affected by the determined performance declines;
classifying, subject to the database portions determination, the determined performance declines;
and
executing, subject to the classification of the performance declines, one or more partial reorganizations of the one or more database portions.

4 more elements

Dependencies are inferred from the claim text.

Workload-driven database reorganization

Life of this patent

Workload-driven database reorganization

Life of this patent

Abstract

Claims20