Method and system for merging logs of memory database

Abstract

The invention discloses a method and a system for merging logs of a memory database, which comprises the following steps: a. executing logic relationship judgment; b. judging if executing the logic mergence, if so, executing step c, if not, shifting to step d; c. executing logic mergence; d. executing consistency judgment of data objects; e. judging if executing consistent mergence of the log data objects, if so, executing step f, if not, executing step g; f. executing object mergence; and g. inserting logs in a buffer memory. By executing hash search and match of logs which can be merged on each log and merging the logs, the invention not only reduces the number of logs in a memory database, but also accelerates the recovery speed of the database, solves the technical problem of large amount of log of the memory database, reduces the allocation cost and enhances the system performance.

Description

Technical field [0001] The invention relates to the field of in-memory database backup and recovery, in particular to the technical field of reducing log volume in an in-memory database log system. Background technique [0002] In-memory databases are more and more widely used in telecommunications, finance, power and other industries due to their fast access performance. In the complex application field of in-memory database, it undertakes to process more and more data, receives more and more transactions, and plays an increasingly important role. Because the memory database is becoming more and more important in modern applications, its data security is being valued more and more, and it is also being valued as a log for recording database work. However, the in-memory database bears more and more transactions, the transactions are becoming more and more complex, the logs for recording transactions are also increasing, and the number of logs has become very large. Such a large...

AI Technical Summary

Problems solved by technology

Storing logs through compression technology requires a lot of operations on the logs during the backup and recovery phases (the logs need to be compressed and then stored during the backup phase, and the logs need to be decompressed and then restored during the recovery phase), although this method compresses the size of the logs , which reduces the log storage space, but this method increases the system burden and consumes a lot of time, and is not suitable for applications with high time requirements for memory databases; in addition, this method does not reduce the number of logs , there is still the same amount of log recovery during the recovery phase

Another way to reduce the amount of logs is to reduce logging through transaction protocols. This method imposes requirements on transaction processing, which makes transaction processing more complicated. It is not universal for different transaction protocols. This method of reducing logs is only applicable In databases with transaction protocols that reduce logging

Images