Method and apparatus for managing performance of database
AssigneeSamsung Sds Co., Ltd.
InventorsSang-Hoon PARK, Jin-Wook KIM, Beom-Seog LEE
Life of this patent
Estimating the term…
Abstract
Methods for managing performance of a database. A method includes selecting an object table predicted to be required to perform a table reorganization (Reorg) after the current timing, using performance-related information of database collected for a predetermined time period or more, generating a predictive model for predicting the timing at which there is a need to perform the reorganization (Reorg) of the object table, and predicting the timing at which there is a need to perform the reorganization of the object table, using the predictive mode.
Claims13
A method for managing performance of database, the method comprising:
- selecting an object table predicted to be required to perform a table reorganization (Reorg) after the current timing, using performance-related information of database collected for a predetermined time period or more;
- generating a predictive model for predicting the timing at which there is a need to perform the reorganization (Reorg) of the object table, and
- predicting the timing at which there is a need to perform the reorganization of the object table, using the predictive model.
A method for managing performance of database, the method comprising:
- selecting an object table space predicted to be required to perform a disc relocation after the current timing, using performance-related information of database collected for a predetermined time period or more;
- generating a predictive model for predicting the timing at which there is a need to perform the disc relocation of the object table space, and
- predicting the timing at which there is a need to perform the disc relocation of the object table space, using the predictive model.
A method for managing performance of database, the method comprising:
- selecting an object memory area predicted to be required to adjust a memory size after the current timing, using performance-related information of database collected for a predetermined time period or more;
- generating a predictive model for predicting the timing at which there is a need to perform the memory size adjustment of the object memory area, and
- predicting the timing at which there is a need to perform the memory size adjustment of the object memory area, using the predictive model.
Dependencies are inferred from the claim text.