公开(公告)号：US20200257658A1

公开(公告)日：2020-08-13

申请号：US16861516

申请日：2020-04-29

Applicant: Snowflake Inc.

Inventor： Thierry CRUANES ,  Benoit DAGEVILLE ,  Ashish MOTIVALA ,  Marcin ZUKOWSKI

IPC: G06F16/16 ,  G06F16/2453 ,  G06F16/9535 ,  G06F16/215 ,  G06F16/22

Abstract: A system and method for pruning data based on metadata. The method may include receiving a query comprising a plurality of predicates and identifying one or more applicable files comprising 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.

公开(公告)号：US20230394009A1

公开(公告)日：2023-12-07

申请号：US18448512

申请日：2023-08-11

Applicant: Snowflake Inc.

Inventor： Marcin ZUKOWSKI ,  Benoit DAGEVILLE ,  Thierry Cruanes ,  Ashish MOTIVALA

IPC: G06F16/16 ,  G06F16/22 ,  G06F16/215 ,  G06F16/9535 ,  G06F16/2453

CPC classification number: G06F16/162 ,  G06F16/22 ,  G06F16/215 ,  G06F16/9535 ,  G06F16/24544

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 including 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.

公开(公告)号：US20220206992A1

公开(公告)日：2022-06-30

申请号：US17696620

申请日：2022-03-16

Applicant: Snowflake Inc.

Inventor： Marcin ZUKOWSKI ,  Benoit DAGEVILLE ,  Thierry CRUANES ,  Ashish MOTIVALA

IPC: 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 including 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.

公开(公告)号：US20210124717A1

公开(公告)日：2021-04-29

申请号：US17141165

申请日：2021-01-04

Applicant: Snowflake Inc.

Inventor： Thierry CRUANES ,  Benoit DAGEVILLE ,  Ashish MOTIVALA ,  Marcin ZUKOWSKI

IPC: 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 comprising a plurality of predicates and identifying one or more applicable files comprising 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.