Invention Grant
- Patent Title: Data pruning based on metadata
-
Application No.: US17508705Application Date: 2021-10-22
-
Publication No.: US11494337B2Publication Date: 2022-11-08
- Inventor: Thierry Cruanes , Benoit Dageville , Ashish Motivala , Marcin Zukowski
- Applicant: SNOWFLAKE INC.
- Applicant Address: US MT Bozeman
- Assignee: SNOWFLAKE INC.
- Current Assignee: SNOWFLAKE INC.
- Current Assignee Address: US MT Bozeman
- Agency: Womble Bond Dickinson (US) LLP
- 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 with a plurality of predicates and identifying one or more applicable files that includes 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.
Information query