Invention Application
- Patent Title: MULTI-LEVEL METADATA IN DATABASE SYSTEMS
-
Application No.: US16775092Application Date: 2020-01-28
-
Publication No.: US20200272638A1Publication Date: 2020-08-27
- Inventor: Ashish Motivala , Yi Fang , Martin Hentschel , Benoit Dageville , Spyros Triantafylis , Yizhi Zhu
- Applicant: Snowflake Inc
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/22 ; G06F16/245

Abstract:
Systems, methods, and devices for multiple level metadata organization in database systems. A system includes a plurality of shared storage devices collectively storing database data across a plurality of tables that each comprise one or more micro-partitions including immutable storage devices. The system includes a resource manager configured to manage the storage of database data stored in a table across one or more of the plurality of shared storage devices. The resource manager is configured to manage the storage of metadata for the table. The metadata includes a column expression property with information about data stored in a column, a micro-partition expression property with information about data stored in a micro-partition, a grouping expression property with information about data stored in two or more micro-partitions, and cumulative table metadata with global information about all micro-partitions of the table.
Public/Granted literature
- US10810232B2 Multi-level metadata in database systems Public/Granted day:2020-10-20
Information query