Abstract: A method of eliminating disturbance of database storage areas is provided, which includes the steps of: checking if it is time to execute database storage status analysis; analyzing a state of database storage areas and outputting values corresponding to disturbance factors as a status analysis result; checking whether each of the disturbance factors has reached a state that requires to be eliminated; and referring to an association table matching disturbance resolution processing with factors to be eliminated by the processing and selecting appropriate processing that can eliminate the disturbance caused by the factor.

Abstract: In a storage management system for managing a storage device for storing data, management information for managing the storage device, area assignment information for managing an area assignment state of the storage device, and history information for managing a history on area assuring and release are held. Further, an assignment request for temporarily using an area is received in association with designation of an area size and a using period. It is determined whether or not the requested area can be assigned by referring to information calculated from the held history information. An area with a designated size at a designated period is assigned to a request source if the area can be assigned as a result of the determination. In the determination, transition of a used amount of a storage is obtained from the history information, and it is determined based on the transition of the used amount of the storage whether or not the designated area can be assigned at the designated period.

Abstract: A database management system includes a status analysis processing unit to execute status analysis processing; a reorganization timing estimation processing unit to estimate a future reorganization timing based on data obtained from the status analysis processing unit; a storage status calculation processing unit to calculate a current storage status based on data operation information; a comparison unit to compare the current storage status estimated by the reorganization timing estimation processing unit and the current storage status calculated by the current storage status calculation processing unit; and a reorganization timing re-estimation processing unit to estimate again the future reorganization timing based on the result of the comparison unit.

Abstract: When a trigger and a method for changing partition definition information have been defined, a DBMS monitors the occurrence of the trigger. When the occurrence of the trigger is detected, a specified partition change is executed automatically. When the partition change is executed, migrations of data among storage areas are executed in parallel as long as the migration source storage area and the migration destination storage area of one piece of the data do not overlap those of another piece of the data.

Abstract: A method of eliminating disturbance of database storage areas is provided, which includes the steps of: checking if it is time to execute database storage status analysis; analyzing a state of database storage areas and outputting values corresponding to disturbance factors as a status analysis result; checking whether each of the disturbance factors has reached a state that requires to be eliminated; and referring to an association table matching disturbance resolution processing with factors to be eliminated by the processing and selecting appropriate processing that can eliminate the disturbance caused by the factor.

Abstract: To store data in an insertion process, a process 1 that inserts data into a new block and a process 2 that inserts, within the block reserved, data into areas that became free when data was deleted are prepared. A switching event to switch from the process 1 to the process 2 is designated in advance. The occurrence of the designated event is checked while executing the process 1 in an insertion process, and if the designated event occurs, the insertion process executes the process 2. If during the execution of the process 2, areas that can be reused become depleted, the execution of the insertion process reverts back to the process 1. As a result, free areas resulting from deletions can be reused according to the switching event designated.