Hybrid table secondary index for lookups, unique checks, and referential integrity constraints

A method comprising:

• receiving, from a metadata database, information related to a base table;
• determining a table object associated with the base table, the table object including a first set of metadata;
• generating a nested object based on a second set of metadata, the second set of metadata including information linking the nested object to the table object;
• 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;
• establishing a link between the second table object to the base table based on the nested object;
• storing, in the metadata database, the nested object and the second table 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;
• establishing a link between the third table object to the base table based on the second nested object;
• and
• storing, in the metadata database, the second nested object and the third table object.

A non-transitory computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

• receiving, from a metadata database, information related to a base table;
• determining a table object associated with the base table, the table object including a first set of metadata;
• generating a nested object based on a second set of metadata, the second set of metadata including information linking the nested object to the table object;
• 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;
• establishing a link between the second table object to the base table based on the nested object;
• storing, in the metadata database, the nested object and the second table 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;
• establishing a link between the third table object to the base table based on the second nested object;
• and
• storing, in the metadata database, the second nested object and the third table object.