ONLINE DATABASE MANAGEMENT SYSTEM AND METHOD FOR MINIMIZING PERFORMANCE DEGRADATION OF TRANSACTION WHEN RECONFIGURING TABLE

摘要

The present invention relates to an online database management system and method for minimizing performance degradation of a transaction when reconfiguring a table, and 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 and configuring and storing a partition hash map when generating the table; a partition selection module for selecting a first partition to be moved from among the plurality of partitions divided by the partition hash map configuration module; a journal file generation module for generating a synchronization journal file for recording a record insert/delete/update history, in the first partition selected by the partition selection module; a partition transfer module for transferring at least one second partition to be transferred to the first partition in which the synchronization journal file has been generated by the journal file generation module; a partition deletion module for deleting the second partition when the second partition is completely transferred to the first partition; and a journal file deletion module for deleting the synchronization journal file generated in the first partition. According to the present invention, provided are the online database management system and method for minimizing performance degradation of a transaction when reconfiguring a table, the system and method being capable of omitting a record deletion step by dividing the table into a plurality of partitions in advance when generating the table.