{"id":"https://openalex.org/W1719877808","doi":"https://doi.org/10.14778/2732286.2732287","title":"Rank join queries in NoSQL databases","display_name":"Rank join queries in NoSQL databases","publication_year":2014,"publication_date":"2014-03-01","ids":{"openalex":"https://openalex.org/W1719877808","doi":"https://doi.org/10.14778/2732286.2732287","mag":"1719877808"},"language":"en","primary_location":{"id":"doi:10.14778/2732286.2732287","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2732286.2732287","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/A5021697915","display_name":"Nikos Ntarmos","orcid":"https://orcid.org/0000-0001-8676-0948"},"institutions":[{"id":"https://openalex.org/I7882870","display_name":"University of Glasgow","ror":"https://ror.org/00vtgdb53","country_code":"GB","type":"education","lineage":["https://openalex.org/I7882870"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Nikos Ntarmos","raw_affiliation_strings":["School of Computing Science University of Glasgow, UK","School of Computing Science, University of Glasgow,UK"],"affiliations":[{"raw_affiliation_string":"School of Computing Science University of Glasgow, UK","institution_ids":["https://openalex.org/I7882870"]},{"raw_affiliation_string":"School of Computing Science, University of Glasgow,UK","institution_ids":["https://openalex.org/I7882870"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042989243","display_name":"I. Patlakas","orcid":null},"institutions":[{"id":"https://openalex.org/I4210109712","display_name":"Max Planck Institute for Informatics","ror":"https://ror.org/01w19ak89","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210109712"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Ioannis Patlakas","raw_affiliation_strings":["Max-Planck-Institut f\u00fcr Informatik, Germany"],"affiliations":[{"raw_affiliation_string":"Max-Planck-Institut f\u00fcr Informatik, Germany","institution_ids":["https://openalex.org/I4210109712"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5052475427","display_name":"Peter Triantafillou","orcid":"https://orcid.org/0000-0002-5807-6011"},"institutions":[{"id":"https://openalex.org/I7882870","display_name":"University of Glasgow","ror":"https://ror.org/00vtgdb53","country_code":"GB","type":"education","lineage":["https://openalex.org/I7882870"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Peter Triantafillou","raw_affiliation_strings":["School of Computing Science University of Glasgow, UK","School of Computing Science, University of Glasgow,UK"],"affiliations":[{"raw_affiliation_string":"School of Computing Science University of Glasgow, UK","institution_ids":["https://openalex.org/I7882870"]},{"raw_affiliation_string":"School of Computing Science, University of Glasgow,UK","institution_ids":["https://openalex.org/I7882870"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5021697915"],"corresponding_institution_ids":["https://openalex.org/I7882870"],"apc_list":null,"apc_paid":null,"fwci":3.825,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.93847996,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"7","issue":"7","first_page":"493","last_page":"504"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9987999796867371,"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.9987999796867371,"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.9944000244140625,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.987500011920929,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8704779744148254},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.8332985043525696},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.49718478322029114},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49591121077537537},{"id":"https://openalex.org/keywords/rank","display_name":"Rank (graph theory)","score":0.48569735884666443},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.4724807143211365},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.4706522524356842},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.45104432106018066},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.41546013951301575},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4054581820964813},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.3745045065879822},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08978745341300964}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8704779744148254},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.8332985043525696},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.49718478322029114},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49591121077537537},{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.48569735884666443},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4724807143211365},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.4706522524356842},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.45104432106018066},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.41546013951301575},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4054581820964813},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.3745045065879822},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08978745341300964},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/2732286.2732287","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2732286.2732287","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"},{"id":"pmh:oai:eprints.gla.ac.uk:89359","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4210235606","display_name":"ENLIGHTEN (Jurnal Bimbingan dan Konseling Islam)","issn_l":"2622-8912","issn":["2622-8912","2622-8920"],"is_oa":false,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"","raw_type":"Articles"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5400000214576721}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W65091138","https://openalex.org/W788498898","https://openalex.org/W1483763945","https://openalex.org/W1544095808","https://openalex.org/W1600580971","https://openalex.org/W1977785821","https://openalex.org/W2009688537","https://openalex.org/W2023797161","https://openalex.org/W2035543557","https://openalex.org/W2044490410","https://openalex.org/W2061601738","https://openalex.org/W2075620950","https://openalex.org/W2087235445","https://openalex.org/W2098935637","https://openalex.org/W2100080574","https://openalex.org/W2100344784","https://openalex.org/W2105436061","https://openalex.org/W2110086534","https://openalex.org/W2115613939","https://openalex.org/W2116400826","https://openalex.org/W2123845384","https://openalex.org/W2125775320","https://openalex.org/W2127088713","https://openalex.org/W2133863472","https://openalex.org/W2134206624","https://openalex.org/W2136986825","https://openalex.org/W2142669732","https://openalex.org/W2143682328","https://openalex.org/W2151645025","https://openalex.org/W2162709812","https://openalex.org/W6679101267"],"related_works":["https://openalex.org/W4385834214","https://openalex.org/W2621972978","https://openalex.org/W3129344858","https://openalex.org/W3001928035","https://openalex.org/W4301431331","https://openalex.org/W4320802139","https://openalex.org/W2588045195","https://openalex.org/W2889462242","https://openalex.org/W2791661407","https://openalex.org/W3111831117"],"abstract_inverted_index":{"Rank":[0],"(i.e.,":[1],"top-":[2],"k":[3],")":[4],"join":[5],"queries":[6,182],"play":[7],"a":[8,40,105,113],"key":[9],"role":[10],"in":[11,28,166],"modern":[12],"analytics":[13],"tasks.":[14],"However,":[15],"despite":[16],"their":[17,46],"importance":[18],"and":[19,44,58,119,142,155,169,171,188,199,219],"unlike":[20],"centralized":[21,107],"settings,":[22],"they":[23],"have":[24],"been":[25],"completely":[26],"overlooked":[27],"cloud":[29],"NoSQL":[30],"settings.":[31],"We":[32,38,64,110,131,162,192,206],"attempt":[33],"to":[34,138,147,152,196],"fill":[35],"this":[36],"gap:":[37],"contribute":[39,112],"suite":[41],"of":[42,177,185,203],"solutions":[43,50,67],"study":[45],"performance":[47,208],"comprehensively.":[48],"Baseline":[49],"are":[51,69,95],"offered":[52],"using":[53,79],"SQL-like":[54],"languages":[55],"(like":[56],"Hive":[57],"Pig),":[59],"based":[60,70,90],"on":[61,71,91,174,183],"MapReduce":[62,81,98,134],"jobs.":[63,99],"first":[65,86],"provide":[66,132,207],"that":[68],"specialized":[72],"indices,":[73,93,154],"which":[74,94,122],"may":[75],"themselves":[76],"be":[77],"accessed":[78,96],"either":[80],"or":[82],"coordinator-based":[83],"strategies.":[84],"The":[85,100],"index-based":[87,102,129],"solution":[88,103],"is":[89],"inverted":[92],"with":[97],"second":[101],"adapts":[104],"popular":[106],"rank-join":[108],"algorithm.":[109],"further":[111],"novel":[114],"statistical":[115,143],"structure":[116],"comprising":[117],"histograms":[118],"Bloom":[120],"filters,":[121],"forms":[123],"the":[124,127],"basis":[125],"for":[126,149,210,221],"third":[128],"solution.":[130],"(i)":[133],"algorithms":[135,146,159,165],"showing":[136],"how":[137],"build":[139],"these":[140,153],"indices":[141],"structures,":[144],"(ii)":[145],"allow":[148],"online":[150],"updates":[151],"(iii)":[156],"query":[157,213,222],"processing":[158],"utilizing":[160,180],"them.":[161],"implemented":[163],"all":[164],"Hadoop":[167],"(HDFS)":[168],"HBase":[170],"tested":[172],"them":[173],"TPC-H":[175],"datasets":[176],"various":[178,186,204],"scales,":[179],"different":[181,189],"tables":[184],"sizes":[187],"score-attribute":[190],"distributions.":[191],"ported":[193],"our":[194],"implementations":[195],"Amazon":[197],"EC2":[198],"\"in-house\"":[200],"lab":[201],"clusters":[202],"scales.":[205],"results":[209],"three":[211],"metrics:":[212],"execution":[214],"time,":[215],"network":[216],"bandwidth":[217],"consumption,":[218],"dollar-cost":[220],"execution.":[223]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}