US 12,174,975 B2
Database management using sort keys
Zhe Huang, Shanghai (CN); Haoyang Jia, Shanghai (CN); Renhua Liang, Shanghai (CN); Xin Chen, Shanghai (CN); Ying Yue, Nanjing (CN); Yuliang Zhou, Shanghai (CN); Yao-Tseng Tseng, Shanghai (CN); and Pengshan Zhang, Shanghai (CN)
Assigned to PayPal, Inc., San Jose, CA (US)
Filed by PayPal, Inc., San Jose, CA (US)
Filed on Nov. 22, 2021, as Appl. No. 17/532,013.
Claims priority of application No. PCT/CN2021/124871 (WO), filed on Oct. 20, 2021.
Prior Publication US 2023/0120186 A1, Apr. 20, 2023
Int. Cl. G06F 21/60 (2013.01); G06F 16/23 (2019.01); G06F 16/2458 (2019.01); G06F 16/901 (2019.01)
CPC G06F 21/604 (2013.01) [G06F 16/2386 (2019.01); G06F 16/2477 (2019.01); G06F 16/9024 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
receiving, by a server computer system from a computing device, a request for raw data specifying a start timestamp and an end timestamp;
determining, by the server computer system, a start key and an end key for performing a query on a distributed non-relational database storing key-value pairs, wherein the determining is based on the start timestamp and the end timestamp;
comparing, by the server computer system, the start key and the end key to a sort key included in row keys of the key-value pairs stored in the non-relational database;
retrieving, by the server computer system based on the comparing, one or more rows of raw data from the non-relational database;
generating, by the server computer system, a graphical representation of the one or more rows of raw data retrieved from the non-relational database; and
periodically performing, by the server computer system, a bulk update of the raw data, wherein the bulk update includes altering a duplicate set of transactions included in the raw data by switching a source account identifier and a target account identifier associated with respective transactions in the duplicate set of transactions.