公开(公告)号：US11379463B1

公开(公告)日：2022-07-05

申请号：US16586563

申请日：2019-09-27

Applicant: Amazon Technologies, Inc.

Inventor： Tengiz Kharatishvili ,  Alexandre Olegovich Verbitski ,  Justin Levandoski ,  Niket Goel ,  Kamal Kant Gupta ,  Xiaofeng Bao ,  Punit Rajgaria

IPC: G06F16/00 ,  G06F16/23 ,  G06F9/46

Abstract: Systems and methods are disclosed to implement, in a database system, a database engine node that generates write tracking transactions to atomically enforce cross-page constraints for write operations. In embodiments, the database system may include multiple database engine nodes that optimistically perform page writes without checking for potential conflicts at a shared storage system. The storage system is configured to detect and report conflicting writes on the same page. To cause the storage system to report cross-page conflicts for a write, the database engine node creates a transaction that includes the write and a write tracker (WT) operation for a tracked page. The WT operation will cause the storage system to report any conflicting writes to the tracked page before the actual write is accepted by the storage system. If a reported conflict is not favorably resolved, the database engine node will abort the entire transaction, including the actual write.