US 12,443,618 B2
Columnar cache in hybrid transactional/analytical processing (HTAP) workloads
Mihir Dharamshi, Redmond, WA (US); Cristian Diaconu, Kirkland, WA (US); Chen Luo, San Mateo, CA (US); Andrew McCormick, San Francisco, CA (US); Corbin McElhanney, San Mateo, CA (US); Joshua Slocum, Austin, TX (US); and Wumengjian Zhu, Cupertino, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jul. 29, 2024, as Appl. No. 18/787,807.
Application 18/787,807 is a continuation of application No. 18/455,229, filed on Aug. 24, 2023, granted, now 12,086,154.
Prior Publication US 2025/0068640 A1, Feb. 27, 2025
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01); G06F 16/11 (2019.01); G06F 16/172 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/254 (2019.01) [G06F 16/116 (2019.01); G06F 16/172 (2019.01); G06F 16/2379 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
a memory storing instructions that cause the at least one hardware processor to perform operations comprising:
receiving, by an execution node, blob metadata from a key-value store, the blob metadata including information related to a set of blob files;
determining, by the execution node using the blob metadata, whether a copy of each of the set of blob files is stored in a local cache of the execution node;
transforming at least one blob file, retrieved from a blob store, to a second file in a column file format, the at least one blob file being in a first format that is different than the column file format, the transforming comprising at least converting a particular snapshot file from the at least one blob file to a particular set of rowsets and writing the set of rowsets into the second file in the column file format; and
storing the second file in the local cache.