US 11,726,959 B2
Data pruning based on metadata
Marcin Zukowski, San Mateo, CA (US); Benoit Dageville, Foster City, CA (US); Thierry Cruanes, San Mateo, CA (US); and Ashish Motivala, Foster City, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., San Mateo, CA (US)
Filed on Apr. 30, 2019, as Appl. No. 16/399,448.
Application 16/399,448 is a continuation of application No. 15/210,536, filed on Jul. 14, 2016, granted, now 10,437,780.
Prior Publication US 2019/0258607 A1, Aug. 22, 2019
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/16 (2019.01); G06F 16/22 (2019.01); G06F 16/215 (2019.01); G06F 16/9535 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/162 (2019.01) [G06F 16/215 (2019.01); G06F 16/22 (2019.01); G06F 16/24544 (2019.01); G06F 16/9535 (2019.01)] 21 Claims
OG exemplary drawing
 
1. A system comprising:
a metadata store to store metadata, wherein the metadata include a summary of data in remote data storage systems as well as data from local cache; and
a processor, operatively coupled with the metadata store, to:
determine whether each of a plurality of files that comprises database data satisfies at least one of a plurality of predicates by reading the metadata stored in the metadata store that is separate from the database data, wherein the metadata includes range data for content corresponding to multiple columns of the database data, the range data including a plurality of different types of data types of the range data, and the range data further includes multiple ones of the plurality of different types of data types of the range data for at least one of the plurality of files; and
prune inapplicable files from the plurality of files that do not satisfy at least one of the plurality of predicates to create a reduced set of files.