公开(公告)号：EP3441890A1

公开(公告)日：2019-02-13

申请号：EP17792430.5

申请日：2017-04-25

申请人： Huawei Technologies Co., Ltd.

发明人： MENG, Xiaofeng ,  SUN, Dongwang

IPC分类号： G06F17/30

摘要： 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.