{"id":"https://openalex.org/W2157734198","doi":"https://doi.org/10.1109/icde.2003.1260799","title":"Ranked join indices","display_name":"Ranked join indices","publication_year":2004,"publication_date":"2004-05-13","ids":{"openalex":"https://openalex.org/W2157734198","doi":"https://doi.org/10.1109/icde.2003.1260799","mag":"2157734198"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2003.1260799","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2003.1260799","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://www.cs.toronto.edu/~tsap/publications/icde03.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5066962453","display_name":"Panayiotis Tsaparas","orcid":"https://orcid.org/0000-0002-3490-1507"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"P. Tsaparas","raw_affiliation_strings":["University of Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053726723","display_name":"Themis Palpanas","orcid":"https://orcid.org/0000-0002-8031-0265"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"T. Palpanas","raw_affiliation_strings":["University of Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055320698","display_name":"Yannis Kotidis","orcid":null},"institutions":[{"id":"https://openalex.org/I1283103587","display_name":"AT&T (United States)","ror":"https://ror.org/02bbd5539","country_code":"US","type":"company","lineage":["https://openalex.org/I1283103587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Y. Kotidis","raw_affiliation_strings":["AT and T Research Laboratories, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AT and T Research Laboratories, USA","institution_ids":["https://openalex.org/I1283103587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035257754","display_name":"Nick Koudas","orcid":"https://orcid.org/0000-0001-5648-0638"},"institutions":[{"id":"https://openalex.org/I1283103587","display_name":"AT&T (United States)","ror":"https://ror.org/02bbd5539","country_code":"US","type":"company","lineage":["https://openalex.org/I1283103587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"N. Koudas","raw_affiliation_strings":["AT and T Research Laboratories, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AT and T Research Laboratories, USA","institution_ids":["https://openalex.org/I1283103587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088315797","display_name":"Divesh Srivastava","orcid":"https://orcid.org/0000-0002-7609-9217"},"institutions":[{"id":"https://openalex.org/I1283103587","display_name":"AT&T (United States)","ror":"https://ror.org/02bbd5539","country_code":"US","type":"company","lineage":["https://openalex.org/I1283103587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Divesh Srivastava","raw_affiliation_strings":["AT and T Research Laboratories, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AT and T Research Laboratories, USA","institution_ids":["https://openalex.org/I1283103587"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":6.4848,"has_fulltext":true,"cited_by_count":97,"citation_normalized_percentile":{"value":0.9762901,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"277","last_page":"288"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"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":1.0,"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.9976000189781189,"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/T10627","display_name":"Advanced Image and Video Retrieval Techniques","score":0.9860000014305115,"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/join","display_name":"Join (topology)","score":0.8786593675613403},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.8042604923248291},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7778741121292114},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.7712562084197998},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.659561038017273},{"id":"https://openalex.org/keywords/rank","display_name":"Rank (graph theory)","score":0.5887406468391418},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5550374388694763},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4982106685638428},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.48901066184043884},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.47049853205680847},{"id":"https://openalex.org/keywords/space","display_name":"Space (punctuation)","score":0.4675150513648987},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.4629896879196167},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3558109700679779},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.15118032693862915},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1362144947052002},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.10515689849853516}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.8786593675613403},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8042604923248291},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7778741121292114},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.7712562084197998},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.659561038017273},{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.5887406468391418},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5550374388694763},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4982106685638428},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.48901066184043884},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.47049853205680847},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.4675150513648987},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.4629896879196167},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3558109700679779},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.15118032693862915},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1362144947052002},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.10515689849853516},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1109/icde.2003.1260799","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2003.1260799","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405)","raw_type":"proceedings-article"},{"id":"pmh:oai:iris.unitn.it:11572/47158","is_oa":true,"landing_page_url":"http://hdl.handle.net/11572/47158","pdf_url":"http://www.cs.toronto.edu/~tsap/publications/icde03.pdf","source":{"id":"https://openalex.org/S4377196320","display_name":"Iris (University of Trento)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I193223587","host_organization_name":"University of Trento","host_organization_lineage":["https://openalex.org/I193223587"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.10.1354","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.10.1354","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.research.att.com/~kotidis/Publications/RankedJoinIndices.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.13.4829","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.13.4829","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.toronto.edu/~themis/publications/icde03.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.60.5239","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.60.5239","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://public.research.att.com/~divesh/papers/tpk+2003-rji.ps.gz","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:iris.unitn.it:11572/47158","is_oa":true,"landing_page_url":"http://hdl.handle.net/11572/47158","pdf_url":"http://www.cs.toronto.edu/~tsap/publications/icde03.pdf","source":{"id":"https://openalex.org/S4377196320","display_name":"Iris (University of Trento)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I193223587","host_organization_name":"University of Trento","host_organization_lineage":["https://openalex.org/I193223587"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2157734198.pdf","grobid_xml":"https://content.openalex.org/works/W2157734198.grobid-xml"},"referenced_works_count":22,"referenced_works":["https://openalex.org/W65091138","https://openalex.org/W1488719427","https://openalex.org/W1495105959","https://openalex.org/W1558190544","https://openalex.org/W1600580971","https://openalex.org/W2020919487","https://openalex.org/W2046144220","https://openalex.org/W2083039049","https://openalex.org/W2093979658","https://openalex.org/W2094320135","https://openalex.org/W2118269922","https://openalex.org/W2119806435","https://openalex.org/W2151135734","https://openalex.org/W2164520297","https://openalex.org/W2221389368","https://openalex.org/W2295596515","https://openalex.org/W4206237997","https://openalex.org/W4254335296","https://openalex.org/W6602581822","https://openalex.org/W6629505283","https://openalex.org/W6633584931","https://openalex.org/W6635907947"],"related_works":["https://openalex.org/W4205996836","https://openalex.org/W2151692181","https://openalex.org/W4392498349","https://openalex.org/W2093960938","https://openalex.org/W3214148052","https://openalex.org/W4392216655","https://openalex.org/W4245395944","https://openalex.org/W2807741550","https://openalex.org/W794462722","https://openalex.org/W3160516639"],"abstract_inverted_index":{"A":[0,68],"plethora":[1],"of":[2,16,29,152,203],"data":[3,6,207],"sources":[4,44],"contain":[5],"entities":[7,31],"that":[8,79],"could":[9],"be":[10],"ordered":[11],"according":[12,32],"to":[13,33,58,70,105,111,132,137,163,213],"a":[14,27,88,99,126,149,178,196,201],"variety":[15,202],"attributes":[17,64],"associated":[18],"with":[19,120,195],"the":[20,30,34,37,95,113,117,121,164],"entities.":[21],"Such":[22],"orderings":[23],"result":[24,119],"effectively":[25],"in":[26,36,94,116,211],"ranking":[28],"values":[35,85],"attribute":[38,84],"domain.":[39],"Commonly,":[40],"users":[41],"correlate":[42],"such":[43,72],"for":[45,91,143,171],"query":[46,53],"processing":[47],"purposes":[48],"through":[49],"join":[50,96,108,118,135,141,157,166],"operations.":[51],"In":[52],"processing,":[54],"it":[55],"is":[56,74],"desirable":[57],"incorporate":[59,71],"user":[60,81,145],"preferences":[61,73,82,147],"towards":[62],"specific":[63],"or":[65],"their":[66],"values.":[67],"way":[69],"by":[75],"utilizing":[76],"scoring":[77,153],"functions":[78],"combine":[80],"and":[83,86,148,168,185,205],"return":[87],"numerical":[89],"score":[90],"each":[92],"tuple":[93],"result.":[97],"Then,":[98],"target":[100],"query,":[101,109],"which":[102,129],"we":[103,130],"refer":[104,131],"as":[106,133],"top-k":[107,140],"seeks":[110],"identify":[112],"k":[114],"tuples":[115],"highest":[122],"scores.":[123],"We":[124,190],"propose":[125],"novel":[127],"technique,":[128],"ranked":[134],"index,":[136],"efficiently":[138],"answer":[139],"queries":[142],"arbitrary,":[144],"specified,":[146],"large":[150],"class":[151],"functions.":[154],"Our":[155],"rank":[156],"index":[158],"requires":[159],"small":[160],"space":[161,183],"(compared":[162],"entire":[165],"result)":[167],"provides":[169,177],"guarantees":[170],"its":[172,182],"performance.":[173,189],"Moreover,":[174],"our":[175,192,217],"proposal":[176],"graceful":[179],"tradeoff":[180],"between":[181],"requirements":[184],"worst":[186],"case":[187],"search":[188],"supplement":[191],"analytical":[193],"results":[194],"thorough":[197],"experimental":[198],"evaluation":[199],"using":[200],"real":[204],"synthetic":[206],"sets,":[208],"demonstrating":[209],"that,":[210],"comparison":[212],"other":[214],"viable":[215],"approaches,":[216],"technique":[218],"offers":[219],"significant":[220],"performance":[221],"benefits.":[222]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":6},{"year":2013,"cited_by_count":7},{"year":2012,"cited_by_count":11}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}