TRANSACTION RECOVERY METHOD IN DATABASE SYSTEM AND DATABASE MANAGEMENT SYSTEM

摘要

The present application discloses a transaction recovery method in a database system and a database management system, where a storage device of the database system supports copy on write. The method includes: determining a to-be-recovered transaction in the database system, where the to-be-recovered transaction is not committed, and the to-be-recovered transaction has performed an update operation on data in the database system; obtaining, from an update operation log used to record the update operation that is performed on the data by the to-be-recovered transaction, a physical address of an old value of the data in the storage device, where the old value is a value of the data before the update operation; and replacing a physical address of a new value of the data with the physical address of the old value, and setting the physical address of the new value to invalid, so that a logical address of the data points to the physical address of the old value, where the new value is a value of the data after the update operation. In comparison with a conventional technology, in the present application, write operations can be effectively reduced during transaction recovery. Erase operations on the storage device are further reduced, thereby prolonging a lifetime of the storage device.