US 12,169,484 B2
Techniques for adaptive independent compression of key and non-key portions of database rows in index organized tables (IOTs)
Ken Kumar, Karnataka (IN); Kamaljit Shergill, Maidenhead (GB); and Aurosish Mishra, Foster City, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Apr. 20, 2023, as Appl. No. 18/137,321.
Claims priority of provisional application 63/414,383, filed on Oct. 7, 2022.
Prior Publication US 2024/0119037 A1, Apr. 11, 2024
Int. Cl. G06F 16/22 (2019.01)
CPC G06F 16/221 (2019.01) 20 Claims
OG exemplary drawing
 
1. A method comprising:
storing an index-organized table (IOT) that comprises a plurality of rows, each of which comprises a key section and a non-key section;
after storing the IOT, performing a first compression technique on the non-key section of each row in the plurality of rows to generate a plurality of compressed non-key sections;
wherein none of the key sections of the plurality of rows is compressed using the first compression technique;
performing a second compression technique, that is different than the first compression technique, on the key section of each row in the plurality of rows to generate a plurality of compressed key sections;
wherein the plurality of compressed key sections are stored concurrently with the plurality of compressed non-key sections;
wherein the method is performed by one or more computing devices.