Amazon Technologies, Inc.

Joon Ahn

Akshat Vig

Somasundaram Perianayagam

Stefano Stefani

James Christopher Sorenson

Vaibhav Jain

Alexander Richard Keyes

Oren Yossef

Fahad Ahmed

Arijit Choudhury

Tony Petrossian

Rashmi Krishnaiah Setty

Mark Roper

Akanksha Fouzdar

Kapil Singh

Systems and methods are disclosed to implement, in a database system, global table management operations for global tables or objects that are replicated across multiple locations. In embodiments, for a regional replica of a global table, a requested change to a metadata property of the replica (e.g., an attribute data type, a write throughput limit, or a time-to-live setting) is propagated to other replicas of the global table at other locations. In embodiments, before performing the requested management operation, the database system may first verify that the operation can be successfully performed in all locations. In embodiments, the operation may be performed optimistically without verification, and rolled back if it cannot be performed everywhere. In embodiments, to serialize management operations on a global table, the database system may check for other pending management operations via a shared control object, and proceed when any pending operations are finished.

Global table management operations for multi-region replicated tables

Systems and methods are provided to implement a database system configured to return the state of a data item upon failure of a condition check on the data item during a conditional write. In embodiments, a write request may specify an indicator to return the item state upon condition failure. The request may specify multiple database operations to execute as a transaction, where failure of a single condition check will cause the entire transaction to fail and an item state causing the failure to be returned. The returned state of the data item may include a selection of the item's attributes specified by the request. Advantageously, these features allow a client to easily obtain the precise cause of a write's failure. Moreover, because the item state is returned only when a conditional write fails and only when requested, the response size of most write requests remains unchanged.

Database interface to obtain item state on conditional operation failure

Growing community of inventors

Cupertino, CA, United States of America

Joon Ahn