Multi-level data for database systems

A method comprising:

• receiving, by one or more processors, first metadata corresponding to a set of micro-partitions;
• storing, by the one or more processors, a first data structure and a second data stricture in storage as a first file and a second file, first data structure including the first metadata and a second data structure including second metadata, the first metadata corresponding to a set of micro-partitions, the second metadata for a grouping of the first metadata, the second data structure including information associating the second metadata to the first metadata;
• and
• storing, by the one or more processors, third metadata for a table, the third metadata comprising:
• information about data stored in a micro-partition of the table, the information being stored in a single metadata micro-partition associated with the table, the single metadata micro-partition being separate from the micro-partition of the table.

A non-transitory computer-readable medium comprising instructions that, when executed by at least one processor, configure the at least one processor to perform operations comprising:

• receiving first metadata corresponding to a set of micro-partitions;
• storing a first data structure and a second data structure in storage as a first file and a second file, first data structure including the first metadata and a second data structure including second metadata, the first metadata corresponding to a set of micro-partitions, the second metadata for a grouping of the first metadata, the second data structure including information associating the second metadata to the first metadata;
• and
• storing third metadata for a table, the third metadata comprising:
• information about data stored in a micro-partition of the table, the information being stored in a single metadata micro-partition associated with the table, the single metadata micro-partition being separate from the micro-partition of the table.