International Business Machines Corporation

Alok Mitra

Praveen Devarao

Smitha Pambalath

Ashok V Jose

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.

Predicting storage requirements of a database management system based on application behavior and behavior of database queries

A method, computer system, and a computer program product for managing a single database management system (DBMS) which interfaces with both a first and second application program is provided. A first data set corresponding to a first data format may be received by a DBMS interface engine. A second data set corresponding to a second data format may be received by the DBMS interface engine. A holistic data model to represent the first data set and the second dataset may be determined by analyzing the first data set and the second data set using the DBMS interface engine. The holistic data model may be structured by the DBMS interface engine with respect to a single database of the single DBMS.

Growing community of inventors

Saidupur, India

Alok Mitra