International Business Machines Corporation

Norbert Heck

Michael Reichert

Namik Hrle

Holger Karn

Thorsten Steinbach

David Wiese

A method for tuning a database system is disclosed. A tuning strategy is received comprising a first procedure to determine a suggested tuning action, and a second procedure to measure performance of the database system. The suggested tuning action is determined and pre-action performance measured according to the respective procedures. Undo information that indicates how to undo the database system state change of the suggested tuning action is recorded in a database system state history. After executing the suggested tuning action, post-action database system performance is measured according to the second procedure. When the post-action performance is lower than the pre-action performance, the database system state change is undone using the undo information. Embodiments enabling to create new tuning strategies, downloading existing tuning strategies, sharing own tuning strategies and changing existing tuning strategies are disclosed as well.

Database tuning methods

Methods and systems, including computer program products, for monitoring and analyzing a database performance problem stored in a separate performance database with cube-based analysis program tools. The methods and systems include means for detecting one or more performance problems, mapping performance problems to cubes, filling the cubes with performance data collected before, and outputting the filled cubes to an output interface usable to deploy said cubes for cube-based database performance analysis.

Growing community of inventors

Hildrizhausen, Germany

Norbert Heck