Invention Grant
- Patent Title: Data pruning based on metadata
-
Application No.: US16688888Application Date: 2019-11-19
-
Publication No.: US10678753B2Publication Date: 2020-06-09
- Inventor: Marcin Zukowski , Benoit Dageville , Thierry Cruanes , Ashish Motivala
- Applicant: Snowflake Inc.
- Applicant Address: US CA San Mateo
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Womble Bond Dickinson (US) LLP
- Agent Daniel E. Ovanezian
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/16 ; G06F16/22 ; G06F16/215 ; G06F16/9535 ; G06F16/2453

Abstract:
A system and method for pruning data based on metadata. The method may include receiving a query that includes a plurality of predicates and identifying one or more applicable files including database data satisfying at least one of the plurality of predicates. The identifying the one or more applicable files including reading metadata stored in a metadata store that is separate from the database data. The method further includes pruning inapplicable files comprising database data that does not satisfy at least one of the plurality of predicates to create a reduced set of files and reading the reduced set of files to execute the query.
Public/Granted literature
- US20200089655A1 DATA PRUNING BASED ON METADATA Public/Granted day:2020-03-19
Information query