US 11,940,975 B2
Database distribution to avoid contention
Shuo Li, Beijing (CN); Peng Hui Jiang, Beijing (CN); Xiaobo Wang, Beijing (CN); and Sheng Yan Sun, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Sep. 28, 2020, as Appl. No. 17/035,284.
Prior Publication US 2022/0100727 A1, Mar. 31, 2022
Int. Cl. G06F 16/23 (2019.01); G06F 16/25 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/2343 (2019.01) [G06F 16/2358 (2019.01); G06F 16/256 (2019.01); G06F 16/27 (2019.01); G06F 16/278 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving an ingestion request to ingest data to a database comprising physical shards;
detecting that the ingestion request is directed to a first hotspot shard comprising a shard key, wherein the first hotspot shard comprises a contention level over a threshold value;
detecting context characteristics from fields within the data other than the shard key;
generating a first virtual shard based on a first virtual shard key selected from the detected context characteristics, wherein the first virtual shard virtually stores a portion of the first hotspot shard; and
ingesting the data to the first virtual shard.