Invention Grant
- Patent Title: Storing multi-level metadata in database systems
-
Application No.: US16863831Application Date: 2020-04-30
-
Publication No.: US10909121B2Publication Date: 2021-02-02
- Inventor: Benoit Dageville , Yi Fang , Martin Hentschel , Ashish Motivala , 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/2455
- IPC: G06F16/2455 ; G06F16/23 ; G06F16/2457 ; G06F16/22 ; G06F16/2458 ; G06F16/27

Abstract:
The subject technology receives first metadata corresponding to a set of micro-partitions. The subject technology generates second metadata for a grouping of the first metadata. The subject technology generates a first data structure including the first metadata and a second data structure including the second metadata, the second data structure including information associating the second metadata to the first metadata. The subject technology stores the first data structure and the second data structure in persistent storage as a first file and a second file. The subject technology receives a query on a table. Further, the subject technology analyzes the query against cumulative table metadata to determine whether data stored in the table matches the query.
Public/Granted literature
- US20200272628A1 STORING MULTI-LEVEL METADATA IN DATABASE SYSTEMS Public/Granted day:2020-08-27
Information query