Walmart Apollo, LLC

Yi Lu

Robert Perry Lowell

Scott Melvin Harvester

Jason Christopher Sardina

Alexei Olkhovskii

William R Eschenbruecher, Iii

Nitin Chhabra, Iii

Ying Zhang

Jun Yi

Robert Bruce Woods, Iii

A system can comprise one or more processors; and one or more non-transitory computer-readable media storing computing instructions configured to run on the one or more processors and perform: receiving a request for a write operation of an input record in a data store associated with a sharded database and an alternate-key-global-index (AKGI) database; generating a new optimistic lock value, the new optimistic lock value being unique in the sharded database; when the data store does not include a data record associated with the input record, creating the dummy data record in the data store; locking the data record for the write operation by setting the DROpLock of the data record to the new optimistic lock value; and performing the write operation of the input record in the AKGI database and the sharded database. In this embodiment, performing the writing operation further comprising inserting or updating an index record derived from the data record before updating the data record and locking the index record before inserting or updating the index record. Other embodiments are disclosed.

System and method for management of a database system

Growing community of inventors

San Diego, CA, United States of America

Yi Lu