{"id":"https://openalex.org/W4411374391","doi":"https://doi.org/10.1145/3722212.3724447","title":"Pruning in Snowflake: Working Smarter, Not Harder","display_name":"Pruning in Snowflake: Working Smarter, Not Harder","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4411374391","doi":"https://doi.org/10.1145/3722212.3724447"},"language":"en","primary_location":{"id":"doi:10.1145/3722212.3724447","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3724447","pdf_url":null,"source":null,"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3722212.3724447","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5118273606","display_name":"Andreas Zimmerer","orcid":"https://orcid.org/0000-0002-4158-5805"},"institutions":[{"id":"https://openalex.org/I4387153582","display_name":"University of Technology Nuremberg","ror":"https://ror.org/02sv65x64","country_code":null,"type":"education","lineage":["https://openalex.org/I4387153582"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Andreas Zimmerer","raw_affiliation_strings":["University of Technology Nuremberg, Nuremberg, Germany"],"raw_orcid":"https://orcid.org/0000-0002-4158-5805","affiliations":[{"raw_affiliation_string":"University of Technology Nuremberg, Nuremberg, Germany","institution_ids":["https://openalex.org/I4387153582"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5118273607","display_name":"Damien Dam","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Damien Dam","raw_affiliation_strings":["Snowflake Inc., Berlin, Germany"],"raw_orcid":"https://orcid.org/0009-0006-6211-4523","affiliations":[{"raw_affiliation_string":"Snowflake Inc., Berlin, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049531239","display_name":"Jan Kossmann","orcid":"https://orcid.org/0000-0003-1832-7282"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jan Kossmann","raw_affiliation_strings":["Snowflake Inc., Berlin, Germany"],"raw_orcid":"https://orcid.org/0000-0003-1832-7282","affiliations":[{"raw_affiliation_string":"Snowflake Inc., Berlin, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5118382447","display_name":"Juliane Waack","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Juliane Waack","raw_affiliation_strings":["Snowflake Inc., Berlin, Germany"],"raw_orcid":"https://orcid.org/0009-0002-8820-1036","affiliations":[{"raw_affiliation_string":"Snowflake Inc., Berlin, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033453497","display_name":"Ismail Oukid","orcid":"https://orcid.org/0000-0002-4253-4989"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ismail Oukid","raw_affiliation_strings":["Snowflake Inc., Berlin, Germany"],"raw_orcid":"https://orcid.org/0000-0002-4253-4989","affiliations":[{"raw_affiliation_string":"Snowflake Inc., Berlin, Germany","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5046188245","display_name":"Andreas Kipf","orcid":"https://orcid.org/0000-0003-3463-0564"},"institutions":[{"id":"https://openalex.org/I4387153582","display_name":"University of Technology Nuremberg","ror":"https://ror.org/02sv65x64","country_code":null,"type":"education","lineage":["https://openalex.org/I4387153582"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Andreas Kipf","raw_affiliation_strings":["University of Technology Nuremberg, Nuremberg, Germany"],"raw_orcid":"https://orcid.org/0000-0003-3463-0564","affiliations":[{"raw_affiliation_string":"University of Technology Nuremberg, Nuremberg, Germany","institution_ids":["https://openalex.org/I4387153582"]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"757","last_page":"770"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10627","display_name":"Advanced Image and Video Retrieval Techniques","score":0.9768000245094299,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9689000248908997,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/snowflake","display_name":"Snowflake","score":0.647892415523529},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.6347750425338745},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6122249960899353},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.42181557416915894},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.11082625389099121},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.06961989402770996},{"id":"https://openalex.org/keywords/botany","display_name":"Botany","score":0.06753164529800415}],"concepts":[{"id":"https://openalex.org/C54059038","wikidata":"https://www.wikidata.org/wiki/Q550147","display_name":"Snowflake","level":3,"score":0.647892415523529},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.6347750425338745},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6122249960899353},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.42181557416915894},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.11082625389099121},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.06961989402770996},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.06753164529800415},{"id":"https://openalex.org/C197046000","wikidata":"https://www.wikidata.org/wiki/Q7561","display_name":"Snow","level":2,"score":0.0},{"id":"https://openalex.org/C153294291","wikidata":"https://www.wikidata.org/wiki/Q25261","display_name":"Meteorology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3722212.3724447","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3724447","pdf_url":null,"source":null,"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2504.11540","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2504.11540","pdf_url":"https://arxiv.org/pdf/2504.11540","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3722212.3724447","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3724447","pdf_url":null,"source":null,"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":43,"referenced_works":["https://openalex.org/W1967373117","https://openalex.org/W1980344365","https://openalex.org/W1981988185","https://openalex.org/W1982387198","https://openalex.org/W1982525351","https://openalex.org/W1997375126","https://openalex.org/W2003580796","https://openalex.org/W2007070784","https://openalex.org/W2009688537","https://openalex.org/W2059922215","https://openalex.org/W2063694594","https://openalex.org/W2081660935","https://openalex.org/W2116400826","https://openalex.org/W2123845384","https://openalex.org/W2130925186","https://openalex.org/W2146183750","https://openalex.org/W2146709231","https://openalex.org/W2150414292","https://openalex.org/W2154610494","https://openalex.org/W2430301697","https://openalex.org/W2574861468","https://openalex.org/W2612543731","https://openalex.org/W2740817677","https://openalex.org/W2916238833","https://openalex.org/W2949054050","https://openalex.org/W2990812675","https://openalex.org/W2992496917","https://openalex.org/W2994941531","https://openalex.org/W3011810846","https://openalex.org/W3020084632","https://openalex.org/W3022398217","https://openalex.org/W3035614832","https://openalex.org/W3097358933","https://openalex.org/W3098304379","https://openalex.org/W3158312191","https://openalex.org/W3207801254","https://openalex.org/W4210681134","https://openalex.org/W4237407586","https://openalex.org/W4248080722","https://openalex.org/W4317639412","https://openalex.org/W4366492460","https://openalex.org/W4398233610","https://openalex.org/W6891959504"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2331374196","https://openalex.org/W2097553621","https://openalex.org/W4244843934","https://openalex.org/W2469781627","https://openalex.org/W4249934362","https://openalex.org/W2769371135","https://openalex.org/W110343638"],"abstract_inverted_index":{"Modern":[0],"cloud-based":[1],"data":[2,10,31],"analytics":[3],"systems":[4,21],"must":[5],"efficiently":[6],"process":[7],"petabytes":[8],"of":[9,30],"residing":[11],"on":[12],"cloud":[13],"storage.":[14],"A":[15],"key":[16],"optimization":[17],"technique":[18],"in":[19],"state-of-the-art":[20],"like":[22],"Snowflake":[23],"is":[24],"partition":[25],"pruning":[26],"-":[27],"skipping":[28],"chunks":[29],"that":[32],"do":[33],"not":[34],"contain":[35],"relevant":[36],"information":[37],"for":[38],"computing":[39],"query":[40],"results.":[41]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":1}],"updated_date":"2026-07-28T07:46:37.118299","created_date":"2025-10-10T00:00:00"}