US 12,405,938 B2
Hybrid table secondary index for lookups, unique checks, and referential integrity constraints
Nikolaos Romanos Katsipoulakis, Redwood City, CA (US); Dimitrios Tsirogiannis, Belmont, CA (US); and Zhaohui Zhang, Redwood City, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Nov. 30, 2023, as Appl. No. 18/524,784.
Application 18/524,784 is a continuation of application No. 18/171,292, filed on Feb. 17, 2023, granted, now 11,880,388.
Claims priority of provisional application 63/366,317, filed on Jun. 13, 2022.
Prior Publication US 2024/0104116 A1, Mar. 28, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 17/30 (2006.01); G06F 16/22 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2272 (2019.01) [G06F 16/2264 (2019.01); G06F 16/283 (2019.01); G06F 16/284 (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:
generating a nested object based on a set of metadata, the set of metadata including information linking the nested object to a table object associated with a base table;
generating a second table object associated with the nested object, the second table object representing a secondary index of the base table, the second table object including information linking the second table object to the nested object;
generating a second nested object based on a particular set of metadata, the particular set of metadata including information linking the second nested object to the table object;
generating a third table object associated with the second nested object, the third table object representing a particular secondary index of the base table, the third table object including information linking the third table object to the second nested object; and
storing, in a metadata database, the second nested object and the third table object.