International Business Machines Corporation

Joan C Ruta

Lisa Seacat DeLuca

Dana Lea Price

Shelbee D Smith-Eigenbrode

A method and system for sizing databases. Multiple patterns of historical capacity usage by multiple databases in a computer system are identified. The multiple patterns are statistically significant for multiple characteristics due to the multiple databases including an input value of each characteristic of multiple characteristics pertaining to utilization of the multiple databases. A weighted value of capacity usage is computed as ACP*FC*PC, wherein ACP=an average value of historical capacity points for each pattern, FC=fraction of the characteristics associated with each pattern, and PC=a fraction of the multiple databases used for each pattern. One or more current databases are sized via utilization of the computed total value of capacity usage. A virtual machine or a new server of the computer system is created. The virtual machine or new server includes the sized one or more current databases.

Database capacity estimation for database sizing

A method and system for sizing databases. Multiple patterns of historical capacity usage by multiple databases are identified. The multiple patterns are statistically significant for multiple characteristics pertaining to utilization of multiple historic databases. The capacity usage is memory usage or central processing unit (CPU) usage. A weighted value of capacity usage is computed for each pattern as an average value of historical capacity usage for each pattern weighted by a function of a fraction of the multiple databases used for each pattern. A total value of capacity usage is computed as a sum of the weighted values of capacity usage. The computed total value of capacity usage is stored. A current database is sized, utilizing the computed total value of capacity usage. The database sizing may be based on query complexity in dependence on rates of occurrence of queries to the historic databases and to the current database.

Growing community of inventors

Piscataway, NJ, United States of America

Joan C Ruta