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 and method for minimizing the performance degradation of a transaction when a table is reorganized, comprising: an online database management system for reorganizing a table, the system comprising: A partition hash map configuration module to store; A partition selection module for selecting a first partition to be moved among a plurality of partitions partitioned by the partition hash map configuration module; A journal file generation module for generating a synchronization journal file recording a record insertion / deletion / change history in the first partition selected by the partition selection module; A partition transfer module for transferring the at least one second partition to be migrated to the first partition where the synchronization journal file is generated in the journal file creation module; A partition deletion module for deleting a second partition when transfer of the second partition to the first partition is completed; And a journal file deletion module for deleting the synchronization journal file generated in the first partition. [7] The present invention relates to an online database management system and method for minimizing the performance degradation of a transaction in table reconstruction. According to the present invention, it is possible to provide an online database management system and a method for minimizing a performance degradation of a transaction when a table is reconstructed, in which a plurality of partitions are pre-partitioned at the time of table creation to omit the record deletion process.;