US 11,989,530 B2
Avoiding hot spots during ingest where ingest ordering must be preserved
James W. Stamos, Saratoga, CA (US); and Devendra Singh, Banglore (IN)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Dec. 13, 2017, as Appl. No. 15/841,149.
Prior Publication US 2019/0179613 A1, Jun. 13, 2019
Int. Cl. G06F 5/06 (2006.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/27 (2019.01)
CPC G06F 5/065 (2013.01) [G06F 16/221 (2019.01); G06F 16/2282 (2019.01); G06F 16/2379 (2019.01); G06F 16/278 (2019.01); G06F 2205/067 (2013.01)] 28 Claims
OG exemplary drawing
 
1. A method comprising:
storing, on a persistent storage device, a first set of items in a table that has a slot number column;
wherein the persistent storage device comprises a plurality of persistent storage blocks;
wherein storing the first set of items in the table causes a first set of rows that correspond to the first set of items to be stored in a set of two or more persistent storage blocks of the plurality of persistent storage;
storing, in the slot number column, slot numbers that produce a particular item- dispersal pattern;
wherein the particular item-dispersal pattern is such that rows, in the first set of rows, that contain consecutive slot numbers are not stored in a same persistent storage block;
after storing the slot numbers that produce the particular item-dispersal pattern, storing subsequent sets of items in the table by performing updates, to the first set of rows, in a sequence that follows the slot numbers in the slot number column of the first set of rows; and
wherein the method is performed by one or more computing devices.