Invention Grant
- Patent Title: Storing database metadata in multiple levels
-
Application No.: US17062859Application Date: 2020-10-05
-
Publication No.: US10997212B2Publication Date: 2021-05-04
- Inventor: Ashish Motivala , Yi Fang , Martin Hentschel , Benoit Dageville , Spyridon Triantafyllis , Yizhi Zhu
- Applicant: Snowflake Inc.
- Applicant Address: US CA San Mateo
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/245 ; G06F16/22

Abstract:
The subject technology stores database data in a table, the table comprising a plurality of micro-partitions each having rows and columns. The subject technology stores metadata for the table in a data structure, the metadata comprising a first level of the data structure comprising a column expression property comprising information about data stored in a column of a micro-partition of the table, a micro-partition expression property comprising information about data stored in the micro-partition of the table, and a second level of the data structure comprising a grouping expression property comprising information about data stored in the micro-partition and one or more additional micro-partitions of the table.
Public/Granted literature
- US20210019334A1 STORING DATABASE METADATA IN MULTIPLE LEVELS Public/Granted day:2021-01-21
Information query