21-05-2020 дата публикации
Номер: US20200159845A1
Methods and systems are described for managing a shared database. One or more processing nodes may access a shared database. A common log node may manage the shared database. The common log node may validate database operations requested by the one or more processing nodes. During validation, the common log node may detect conflicts that occur between database operations requested by the one or more processing nodes. 1. A method comprising: an identifier of the page,', 'a base version number corresponding to the page, and', 'an identifier of a transaction corresponding to the modify operation;, 'receiving, by a first computing device, a request to perform a modify operation on a record of a page of a database, wherein the request comprisesdetermining, by the first computing device, whether a lock corresponding to the page has been assigned;after determining that the lock has been assigned, determining, by the first computing device, whether the lock is assigned to a second computing device;comparing, by the first computing device, the base version number to a latest validated version number of the page; andafter determining that the lock has been assigned to the second computing device and that the base version number is equivalent to the latest validated version number, transmitting, by the first computing device, an indication that the modify operation has been validated.2. The method of claim 1 , further comprising adding claim 1 , by the first computing device claim 1 , the identifier of the transaction to a transaction list corresponding to the lock.3. The method of claim 2 , wherein the lock comprises:the identifier of the page;the transaction list; andan indication of the second computing device.4. The method of claim 2 , further comprising:receiving, by the first computing device and from the second computing device, an indication that the transaction has been committed;removing, by the first computing device, the transaction from the transaction list; ...
Подробнее