Yi H Lu

US Patent:

20190266169, Aug 29, 2019

Filed:

Feb 28, 2019

Appl. No.:

16/289542

Inventors:

- Bentonville AR, US
Jun Yi - San Marcos CA, US
Yi Lu - San Diego CA, US
Nitin Chhabra, III - San Diego CA, US
Ying Zhang - San Diego CA, US
Scott Melvin Harvester - San Marcos CA, US
Robert Perry Lowell - Carlsbad CA, US

Assignee:

Walmart Apollo, LLC - Bentonville AR

International Classification:

G06F 16/25
G06F 16/22
G06F 16/242
G06F 16/23

Abstract:

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