{"id":"https://openalex.org/W4383749451","doi":"https://doi.org/10.14778/3598581.3598601","title":"Pando: Enhanced Data Skipping with Logical Data Partitioning","display_name":"Pando: Enhanced Data Skipping with Logical Data Partitioning","publication_year":2023,"publication_date":"2023-05-01","ids":{"openalex":"https://openalex.org/W4383749451","doi":"https://doi.org/10.14778/3598581.3598601"},"language":"en","primary_location":{"id":"doi:10.14778/3598581.3598601","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3598581.3598601","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083192448","display_name":"Sivaprasad Sudhir","orcid":"https://orcid.org/0009-0005-4522-0394"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sivaprasad Sudhir","raw_affiliation_strings":["MIT, Meta"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT, Meta","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018442175","display_name":"Wenbo Tao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wenbo Tao","raw_affiliation_strings":["Meta"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Meta","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004928497","display_name":"Nikolay Laptev","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Nikolay Laptev","raw_affiliation_strings":["Meta"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Meta","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092635968","display_name":"Cyrille Habis","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Cyrille Habis","raw_affiliation_strings":["Meta"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Meta","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039133265","display_name":"Michael Cafarella","orcid":"https://orcid.org/0000-0001-6122-0590"},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Michael Cafarella","raw_affiliation_strings":["MIT"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037742794","display_name":"Samuel Madden","orcid":null},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Samuel Madden","raw_affiliation_strings":["MIT"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.7069,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.85095638,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":99},"biblio":{"volume":"16","issue":"9","first_page":"2316","last_page":"2329"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9990000128746033,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/computer-science","display_name":"Computer science","score":0.8311245441436768},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7645851373672485},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.6681549549102783},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.5819953083992004},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.561294674873352},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4733414947986603},{"id":"https://openalex.org/keywords/block","display_name":"Block (permutation group theory)","score":0.44312429428100586},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4361482262611389},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.42186927795410156},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3518331050872803},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.33397528529167175},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.27675485610961914},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.24698448181152344},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.15108060836791992},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10682079195976257}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8311245441436768},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7645851373672485},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.6681549549102783},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.5819953083992004},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.561294674873352},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4733414947986603},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.44312429428100586},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4361482262611389},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.42186927795410156},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3518331050872803},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.33397528529167175},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.27675485610961914},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.24698448181152344},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.15108060836791992},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10682079195976257},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3598581.3598601","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3598581.3598601","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1519039476","https://openalex.org/W1535659751","https://openalex.org/W1536741282","https://openalex.org/W1585029481","https://openalex.org/W1600880963","https://openalex.org/W1981988185","https://openalex.org/W1993892970","https://openalex.org/W1997375126","https://openalex.org/W2017052417","https://openalex.org/W2020463726","https://openalex.org/W2055468282","https://openalex.org/W2105252819","https://openalex.org/W2111687586","https://openalex.org/W2119946100","https://openalex.org/W2141088026","https://openalex.org/W2396309311","https://openalex.org/W2574861468","https://openalex.org/W2728889630","https://openalex.org/W2798658665","https://openalex.org/W2899672681","https://openalex.org/W2915063781","https://openalex.org/W2923407516","https://openalex.org/W2990812675","https://openalex.org/W2992496917","https://openalex.org/W3020084632","https://openalex.org/W3029327553","https://openalex.org/W3098168353","https://openalex.org/W3098304379","https://openalex.org/W3107842002","https://openalex.org/W3112177522","https://openalex.org/W3158312191","https://openalex.org/W4226461508","https://openalex.org/W4246460340"],"related_works":["https://openalex.org/W1506942559","https://openalex.org/W2607929079","https://openalex.org/W2051711022","https://openalex.org/W2390710122","https://openalex.org/W2047624203","https://openalex.org/W2387244390","https://openalex.org/W2356889451","https://openalex.org/W2532107742","https://openalex.org/W2794029116","https://openalex.org/W4253830349"],"abstract_inverted_index":{"With":[0],"enormous":[1],"volumes":[2],"of":[3,48,51,65,71,76,152,166],"data,":[4,56],"quickly":[5],"retrieving":[6],"data":[7,27,66,93],"that":[8,120],"is":[9,14,86],"relevant":[10],"to":[11,34,60,67,160,171],"a":[12,49,150],"query":[13,39,176],"essential":[15],"for":[16],"achieving":[17],"high":[18],"performance.":[19],"Modern":[20],"cloud-based":[21],"database":[22,104],"systems":[23],"often":[24,43],"partition":[25],"the":[26,55,62,69,91,97,118,164,180],"into":[28],"blocks":[29,37,72,81,111,167],"and":[30,88,154,169],"employ":[31],"various":[32],"techniques":[33],"skip":[35],"irrelevant":[36],"during":[38],"execution.":[40],"Several":[41],"algorithms,":[42],"based":[44],"on":[45,83,101],"historical":[46],"properties":[47],"workload":[50,119],"queries":[52],"run":[53],"over":[54,179],"have":[57],"been":[58],"proposed":[59],"tune":[61],"physical":[63,92,103,142],"layout":[64,94,143],"reduce":[68],"number":[70,165],"accessed.":[73],"The":[74],"effectiveness":[75],"these":[77],"methods":[78,139],"at":[79],"skipping":[80,110,136],"depends":[82],"what":[84],"metadata":[85],"stored":[87],"how":[89],"well":[90],"aligns":[95],"with":[96,145],"queries.":[98],"Existing":[99],"work":[100],"automatic":[102],"design":[105],"misses":[106],"significant":[107],"opportunities":[108],"in":[109,117,163,174],"because":[112],"it":[113],"ignores":[114],"logical":[115,147],"predicates":[116],"exhibit":[121],"strongly":[122],"correlated":[123],"results.":[124],"In":[125],"this":[126],"paper,":[127],"we":[128],"present":[129],"Pando":[130,157],"which":[131],"enables":[132],"significantly":[133],"better":[134],"block":[135],"than":[137],"past":[138],"by":[140],"informing":[141],"decisions":[144],"correlation-aware":[146],"partitioning.":[148],"Across":[149],"range":[151],"benchmark":[153],"real-world":[155],"workloads,":[156],"attains":[158],"up":[159,170],"2.8X":[161],"reduction":[162],"scanned":[168],"2.3X":[172],"speedup":[173],"end-to-end":[175],"execution":[177],"time":[178],"state-of-the-art":[181],"techniques.":[182]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":5}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}