Database transaction concurrent redo method and device based on transaction sequence analysis

• Main Authors: LI HUI, CUI LIZHEN, GUO WEI, YAN ZHONGMIN, MENG ZICHENG
• Format: Patent
• Language: Chinese; English
• Published: 24.04.2020
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention provides a database transaction concurrent redo method and system based on transaction sequence analysis, and the method comprises the steps: obtaining transaction information, carryingout the grouping according to transaction numbers, and carrying out the format conversion; carrying out transaction information preprocessing, loading corresponding transaction information according to a submission sequence, deserializing the transaction information after format conversion into a transaction object, and extracting key information in the transaction object; and determining whetherthe current transaction has a precursor transaction or not, if so, judging whether the precursor transaction is completed or not, if not, continuing waiting, and if not, remaking the transaction and recording a remaking result. According to the method and the device, data redo can be performed concurrently, the transaction redo speed can be increased on the premise of ensuring the correctness of the executed data, and the