Model-based generation of synthetic database statistics

摘要

Object of the present invention was to be able to determine in a user-friendly and low-cost way early in the development process forecasts for database performance. With their help, weaknesses in the database design as well as the implemented database accesses should be effectively identified and, if necessary, corrected, before potentially serious performance problems arise at a later date. The elaborate generation of (test) data should be dispensed with in this procedure. To achieve the object, the present invention describes a method for generating synthetic database statistics on the basis of existing suitably formalized application expertise - the PIs. Building on these statistics, explain mechanisms can then be used to easily and efficiently predict database performance. The following invention describes which PIs are needed for statistics generation and how these PIs can be specified within established (UML) modeling tools. Furthermore, the invention concretizes the individual steps that are necessary for the generation of synthetic statistics. Finally, using the example of the IBM DB2 for z / OS DBMS, she explains how the generation of synthetic statistics can be exemplarily implemented and the quality of synthetic statistics compared to "real" ones.