Patent ID: 9424282
Filing Date: 2016-08-23
CPC Classification: G06F

Claim Text:
1. A computer-implemented database online reorganization method for dynamically adapting a database partitioning layout of a database containing tables, wherein the tables are vertically partitioned into containers, each container containing one or more attributes of one table, the method comprising: analyzing, by a workload analysis tool of a computer system, a workload on a set of tables of the database, the workload comprising queries; detecting, by the workload analysis tool of the computer system, a workload change of the workload; analyzing, by a workload evaluation tool of the computer system, if a new partitioning layout for the set of tables is considered optimal in view of the workload change; and deciding, by the workload evaluation tool of the computer system, whether the partitioning layout of the set of tables is switched to the new partitioning layout, wherein deciding whether the partitioning layout of the set of tables is switched to the new partitioning layout comprises: