Hybrid table secondary index for lookups, unique checks, and referential integrity constraints
The subject technology generates 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. The subject technology generates 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. The subject technology generates 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. The subject technology generates 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.
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.
2. The system of claim 1 , wherein the operations further comprise:
generating a nested object based on a second set of metadata.
3. The system of claim 2 , wherein the second set of metadata includes information linking the nested object to the table object, the second set of metadata comprises a nested object identifier, a nested object domain identifier, a particular identifier corresponding to the table object, and nested relationship type identifier.
4. The system of claim 2 , wherein the second table object includes a third set of metadata, the third set of metadata including different metadata from the second set of metadata.
5. The system of claim 4 , wherein the third set of metadata comprises a nested object identifier corresponding to the nested object, a key value counter, a set of column identifiers, a particular identifier associated with the base table, an index type.
6. The system of claim 1 , wherein the operations further comprise:
determining a table object associated with the base table, the table object including a first set of metadata, the first set of metadata comprising an account identifier, a first unique identifier for the base table, a second unique identifier for a particular schema of the base table, and a name of the base table.
7. The system of claim 1 , wherein the base table is a parent table of a second table associated with the second table object.
8. The system of claim 1 , wherein the operations further comprise:
generating a constraint object associated with the second table object, the constraint object including a particular set of metadata.
9. The system of claim 8 , wherein the particular set of metadata comprises information indicating a deferability of a constraint, a definition of the constraint, an identifier of the constraint, and information indicating a kind of the constraint.
10. The system of claim 1 , wherein secondary index and the particular secondary index are associated with different prefixes and different columns of the base table.
11. A method 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.
12. The method of claim 11 , further comprising:
generating a nested object based on a second set of metadata.
13. The method of claim 12 , wherein the second set of metadata includes information linking the nested object to the table object, the second set of metadata comprises a nested object identifier, a nested object domain identifier, a particular identifier corresponding to the table object, and nested relationship type identifier.
14. The method of claim 12 , wherein the second table object includes a third set of metadata, the third set of metadata including different metadata from the second set of metadata.
15. The method of claim 14 , wherein the third set of metadata comprises a nested object identifier corresponding to the nested object, a key value counter, a set of column identifiers, a particular identifier associated with the base table, an index type.
16. The method of claim 11 , further comprising:
determining a table object associated with the base table, the table object including a first set of metadata, the first set of metadata comprising an account identifier, a first unique identifier for the base table, a second unique identifier for a particular schema of the base table, and a name of the base table.
17. The method of claim 11 , wherein the base table is a parent table of a second table associated with the second table object.
18. The method of claim 11 , further comprising:
generating a constraint object associated with the second table object, the constraint object including a particular set of metadata.
19. The method of claim 18 , wherein the particular set of metadata comprises information indicating a deferability of a constraint, a definition of the constraint, an identifier of the constraint, and information indicating a kind of the constraint.
20. 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:
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.