{"id":"https://openalex.org/W4378713432","doi":"https://doi.org/10.1145/3584372.3588670","title":"Efficient Computation of Quantiles over Joins","display_name":"Efficient Computation of Quantiles over Joins","publication_year":2023,"publication_date":"2023-06-02","ids":{"openalex":"https://openalex.org/W4378713432","doi":"https://doi.org/10.1145/3584372.3588670"},"language":"en","primary_location":{"id":"doi:10.1145/3584372.3588670","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588670","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2305.16525","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083668297","display_name":"Nikolaos Tziavelis","orcid":"https://orcid.org/0000-0001-8342-2177"},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Nikolaos Tziavelis","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030337488","display_name":"Nofar Carmeli","orcid":"https://orcid.org/0000-0003-0673-5510"},"institutions":[{"id":"https://openalex.org/I1294671590","display_name":"Centre National de la Recherche Scientifique","ror":"https://ror.org/02feahw73","country_code":"FR","type":"government","lineage":["https://openalex.org/I1294671590"]},{"id":"https://openalex.org/I19894307","display_name":"Universit\u00e9 de Montpellier","ror":"https://ror.org/051escj72","country_code":"FR","type":"education","lineage":["https://openalex.org/I19894307"]},{"id":"https://openalex.org/I4210101743","display_name":"Laboratoire d'Informatique, de Robotique et de Micro\u00e9lectronique de Montpellier","ror":"https://ror.org/013yean28","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I1326498283","https://openalex.org/I151295451","https://openalex.org/I19894307","https://openalex.org/I4210101743","https://openalex.org/I4210159245","https://openalex.org/I4405261681"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Nofar Carmeli","raw_affiliation_strings":["Inria, LIRMM, Univ Montpellier, CNRS, Montpellier, France"],"affiliations":[{"raw_affiliation_string":"Inria, LIRMM, Univ Montpellier, CNRS, Montpellier, France","institution_ids":["https://openalex.org/I4210101743","https://openalex.org/I19894307","https://openalex.org/I1294671590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086781628","display_name":"Wolfgang Gatterbauer","orcid":"https://orcid.org/0000-0002-9614-0504"},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006706357","display_name":"Benny Kimelfeld","orcid":"https://orcid.org/0000-0002-7156-1572"},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Benny Kimelfeld","raw_affiliation_strings":["Technion - Israel Institute of Technology, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion - Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049802784","display_name":"Mirek Riedewald","orcid":"https://orcid.org/0000-0002-6102-7472"},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mirek Riedewald","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5083668297"],"corresponding_institution_ids":["https://openalex.org/I12912129"],"apc_list":null,"apc_paid":null,"fwci":0.7832,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.69867079,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"303","last_page":"315"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T10720","display_name":"Complexity and Algorithms in Graphs","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/joins","display_name":"Joins","score":0.9059903621673584},{"id":"https://openalex.org/keywords/subroutine","display_name":"Subroutine","score":0.7353473901748657},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7251269221305847},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.6845583915710449},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.636988639831543},{"id":"https://openalex.org/keywords/generality","display_name":"Generality","score":0.5881274342536926},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5555150508880615},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.4530784487724304},{"id":"https://openalex.org/keywords/monotone-polygon","display_name":"Monotone polygon","score":0.4518902897834778},{"id":"https://openalex.org/keywords/disjoint-sets","display_name":"Disjoint sets","score":0.44335633516311646},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.433610200881958},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4277438223361969},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.370399534702301},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.340317964553833},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.33778929710388184},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.32818663120269775},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14371594786643982},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1300453543663025}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9059903621673584},{"id":"https://openalex.org/C96147967","wikidata":"https://www.wikidata.org/wiki/Q190686","display_name":"Subroutine","level":2,"score":0.7353473901748657},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7251269221305847},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.6845583915710449},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.636988639831543},{"id":"https://openalex.org/C2780767217","wikidata":"https://www.wikidata.org/wiki/Q5532421","display_name":"Generality","level":2,"score":0.5881274342536926},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5555150508880615},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.4530784487724304},{"id":"https://openalex.org/C2834757","wikidata":"https://www.wikidata.org/wiki/Q4925424","display_name":"Monotone polygon","level":2,"score":0.4518902897834778},{"id":"https://openalex.org/C45340560","wikidata":"https://www.wikidata.org/wiki/Q215382","display_name":"Disjoint sets","level":2,"score":0.44335633516311646},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.433610200881958},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4277438223361969},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.370399534702301},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.340317964553833},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.33778929710388184},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.32818663120269775},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14371594786643982},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1300453543663025},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C542102704","wikidata":"https://www.wikidata.org/wiki/Q183257","display_name":"Psychotherapist","level":1,"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/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3584372.3588670","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588670","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2305.16525","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2305.16525","pdf_url":"https://arxiv.org/pdf/2305.16525","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"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"},{"id":"pmh:oai:HAL:lirmm-04277973v1","is_oa":true,"landing_page_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-04277973","pdf_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-04277973v1/file/2022_Quantile_Selection.pdf","source":{"id":"https://openalex.org/S4406922461","display_name":"SPIRE - Sciences Po Institutional REpository","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"SIGMOD/PODS 2023 - International Conference on Management of Data, Jun 2023, Seattle, WA, United States. pp.303-315, ⟨10.1145/3584372.3588670⟩","raw_type":"Conference papers"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2305.16525","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2305.16525","pdf_url":"https://arxiv.org/pdf/2305.16525","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"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"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1247588296","display_name":null,"funder_award_id":"412400621","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G1480139564","display_name":null,"funder_award_id":"PhD Fellowship","funder_id":"https://openalex.org/F4320309327","funder_display_name":"Google"},{"id":"https://openalex.org/G1537211332","display_name":null,"funder_award_id":"IIS-1956096","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2414388330","display_name":null,"funder_award_id":"IIS-1762268, IIS-1956096","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2699994585","display_name":"CAREER: Scaling Approximate Inference and Approximation-Aware Learning","funder_award_id":"1762268","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5921281487","display_name":null,"funder_award_id":"number","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6052429835","display_name":null,"funder_award_id":"(DFG)","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6745713617","display_name":null,"funder_award_id":"1956096","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6755165505","display_name":null,"funder_award_id":"award","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7593840704","display_name":"Collaborative Research: Quantifying terrestrial riparian-stream carbon connections across a salt gradient","funder_award_id":"2400621","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G762232396","display_name":null,"funder_award_id":"Project","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320309327","display_name":"Google","ror":"https://ror.org/00njsd438"},{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4378713432.pdf","grobid_xml":"https://content.openalex.org/works/W4378713432.grobid-xml"},"referenced_works_count":19,"referenced_works":["https://openalex.org/W1505212787","https://openalex.org/W1607456165","https://openalex.org/W2040895999","https://openalex.org/W2077814962","https://openalex.org/W2098207812","https://openalex.org/W2103201239","https://openalex.org/W2146507303","https://openalex.org/W2962896117","https://openalex.org/W2963025941","https://openalex.org/W2963069375","https://openalex.org/W2963560792","https://openalex.org/W2994853131","https://openalex.org/W3013804781","https://openalex.org/W3121750545","https://openalex.org/W3138379487","https://openalex.org/W4205548518","https://openalex.org/W4234318375","https://openalex.org/W4280619330","https://openalex.org/W4313476522"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W650102067","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W1550806730","https://openalex.org/W2589740103","https://openalex.org/W3033055359","https://openalex.org/W2172084996","https://openalex.org/W1966967794","https://openalex.org/W1501284171"],"abstract_inverted_index":{"We":[0],"present":[1],"efficient":[2],"algorithms":[3],"for":[4,14,24,80,89,98,118],"Quantile":[5],"Join":[6,35],"Queries,":[7],"abbreviated":[8],"as":[9,125],"%JQ.":[10,144],"A":[11,68],"%JQ":[12],"asks":[13],"the":[15,25,31,44,56,59,63,74,94],"answer":[16],"at":[17],"a":[18,34,81],"specified":[19],"relative":[20],"position":[21],"(e.g.,":[22],"50%":[23],"median)":[26],"under":[27],"some":[28],"ordering":[29,99],"over":[30,129],"answers":[32],"to":[33,41,51],"Query":[36],"(JQ).":[37],"Our":[38],"goal":[39],"is":[40,135,140],"avoid":[42],"materializing":[43],"set":[45],"of":[46,58,62,66,76,84],"all":[47],"join":[48,104],"answers,":[49],"and":[50,86],"achieve":[52],"quasilinear":[53],"time":[54],"in":[55],"size":[57],"database,":[60],"regardless":[61],"total":[64],"number":[65],"answers.":[67],"recent":[69],"dichotomy":[70],"result":[71],"rules":[72],"out":[73],"existence":[75],"such":[77,124],"an":[78],"algorithm":[79],"general":[82],"family":[83],"queries":[85],"orders.":[87],"Specifically,":[88],"acyclic":[90],"JQs":[91],"without":[92],"self-joins,":[93],"problem":[95],"becomes":[96],"intractable":[97],"by":[100],"sum":[101],"whenever":[102],"we":[103],"more":[105],"than":[106],"two":[107],"relations":[108],"(and":[109],"these":[110],"joins":[111],"are":[112],"not":[113,136],"trivial":[114],"intersections).":[115],"Moreover,":[116],"even":[117],"basic":[119],"ranking":[120],"functions":[121],"beyond":[122],"sum,":[123],"min":[126],"or":[127],"max":[128],"different":[130],"attributes,":[131],"so":[132],"far":[133],"it":[134],"known":[137],"whether":[138],"there":[139],"any":[141],"nontrivial":[142],"tractable":[143]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2}],"updated_date":"2026-04-13T07:58:08.660418","created_date":"2025-10-10T00:00:00"}