PREDICTING STORAGE REQUIREMENTS OF A DATABASE MANAGEMENT SYSTEM BASED ON APPLICATION BEHAVIOR AND BEHAVIOR OF DATABASE QUERIES

摘要

A method, system and computer program product for forecasting a storage requirement of a database management system (DBMS). The storage-related operations (e.g., create, delete, update) of the applications connected to the DBMS are monitored. The impact on the storage usage of the DBMS based on these storage-related operations performed by the applications is monitored. Furthermore, the applications are categorized into groups of applications based on the monitored storage-related operations. A mathematical model is then built to forecast the storage requirement of the DBMS based on the monitored impact on the storage usage of the DBMS by the monitored storage-related operations of the applications and the categorization of the applications. The storage requirement of the DBMS is then forecasted based on the built mathematical model. In this manner, the storage requirements of the DBMS may be accurately predicted to ensure that there is available storage thereby preventing performance degradation.