Patent ID: 7797347
Filing Date: 2010-09-14
Classification: G06F

Abstract:
1. A computerised method for determining whether to carry out reorganization of a database storage, the method comprising: performing, by workload-aware reorganization check tool in a data processing system, a statistics-based reorganization check procedure on database tables and indexes, resulting in a preliminary reorganization recommendation; receiving, by the workload-aware reorganization check tool, information on workload of the database tables and the indexes of the database storage; determining, by the workload-aware reorganization check tool, based on the information on workload and the preliminary reorganization recommendation, whether to carry out reorganization of the database storage in accordance with the preliminary reorganization recommendation; and determining, by the workload-aware reorganization check tool, a potential effect of the preliminary reorganization recommendation based on a workload performed on the database tables and the indexes, wherein the reorganization is performed in response to at least one ratio being met for both table reorganization and index reorganization indicating the potential effect would be positive.