The database management system and method for preventing performance degradation of transaction when table reconfiguring

摘要

The present invention relates to an online database management system for minimizing performance degradation of a transaction in a table reconfiguration, and a method thereof. The online database management system for reconfiguring a table comprises: a partition hash map configuration module for dividing a table into a plurality of partitions when the table is generated, and storing the same; a partition selection module for selecting a first partition to be moved among the partitions divided by the partition hash map configuration module; a journal file generation module for generating a synchronization journal file for recording a record insertion, deletion, and change history in the first partition selected by the partition selection module; a partition transfer module for transferring one or more second partitions to be transferred to the first partition in which the synchronization journal file is generated by the journal file generation module; a partition deletion module for deleting the second partitions when transfer of the second partitions to the first partition is completed; and a journal file deletion module for deleting the synchronization journal file generated in the first partition. According to the present invention, a plurality of partitions are previously divided at the time of generating a table such that a record deletion process can be omitted.