Model-based generation of synthetical database statistics

摘要

The object of the present invention was to be able to determine predictions as to database performance in a user-friendly manner with little effort at an early stage in the development process. With the help of said predictions, weaknesses in the database design and the database accesses that have been implemented are intended to be able to be effectively detected and, where relevant, corrected, before potentially serious performance problems result from these weaknesses at a later point in time. The expensive generation of (test) data is intended to be dispensed in this procedure.;In order to achieve the object, the present invention describes a method for generating synthetic database statistics on the basis of existing and suitably formalized application knowledge—the PIs. Building on these statistics, explain mechanisms can then be used for lightweight and efficient prediction of the database performance. The following invention describes which PIs are necessary for statistics generation, and how these PIs can be specified within established (UML) modeling tools. The invention furthermore concretizes the individual steps that are necessary for the generation of synthetic statistics. Finally, using the example of the DBMS IBM DB2 for z/OS, it describes an example of how the generation of synthetic statistics can be implemented, and what quality synthetic statistics have in comparison with “real” ones.