{"id":"https://openalex.org/W2118265701","doi":"https://doi.org/10.1145/1189769.1189772","title":"Adaptive rank-aware query optimization in relational databases","display_name":"Adaptive rank-aware query optimization in relational databases","publication_year":2006,"publication_date":"2006-12-01","ids":{"openalex":"https://openalex.org/W2118265701","doi":"https://doi.org/10.1145/1189769.1189772","mag":"2118265701"},"language":"en","primary_location":{"id":"doi:10.1145/1189769.1189772","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1189769.1189772","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","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/A5000141065","display_name":"Ihab F. Ilyas","orcid":"https://orcid.org/0000-0001-9052-9714"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ihab F. Ilyas","raw_affiliation_strings":["University of Waterloo, Waterloo, Ontario, Canada","University of Waterloo, Waterloo, Ontario, CANADA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, Ontario, Canada","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Waterloo, Ontario, CANADA","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000123743","display_name":"Walid G. Aref","orcid":"https://orcid.org/0000-0001-8169-7775"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Walid G. Aref","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089912733","display_name":"Ahmed K. Elmagarmid","orcid":"https://orcid.org/0000-0002-0044-458X"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ahmed K. Elmagarmid","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018370354","display_name":"Hicham G. Elmongui","orcid":"https://orcid.org/0000-0001-5947-7450"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hicham G. Elmongui","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105778361","display_name":"Rahul Shah","orcid":"https://orcid.org/0000-0002-0605-5681"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rahul Shah","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003340402","display_name":"Jeffrey Scott Vitter","orcid":"https://orcid.org/0000-0001-7970-6118"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jeffrey Scott Vitter","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.0081,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.95079769,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"31","issue":"4","first_page":"1257","last_page":"1304"},"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.9965999722480774,"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/T12288","display_name":"Optimization and Search Problems","score":0.9955000281333923,"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.87770015001297},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6643797755241394},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.6504127979278564},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.6178319454193115},{"id":"https://openalex.org/keywords/rank","display_name":"Rank (graph theory)","score":0.6107164621353149},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5972121953964233},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5038730502128601},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4850975275039673},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.448578417301178},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.41868507862091064},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.4138139486312866},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.401019424200058},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.38533490896224976},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36201274394989014},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34815239906311035},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2788681983947754},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2590376138687134},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.21994444727897644}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.87770015001297},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6643797755241394},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.6504127979278564},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.6178319454193115},{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.6107164621353149},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5972121953964233},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5038730502128601},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4850975275039673},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.448578417301178},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.41868507862091064},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4138139486312866},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.401019424200058},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.38533490896224976},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36201274394989014},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34815239906311035},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2788681983947754},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2590376138687134},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.21994444727897644},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"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":6,"locations":[{"id":"doi:10.1145/1189769.1189772","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1189769.1189772","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:docs.lib.purdue.edu:ccpubs-1268","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/ccpubs/274","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cyber Center Publications","raw_type":"text"},{"id":"pmh:oai:docs.lib.purdue.edu:ccpubs-1368","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/ccpubs/369","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cyber Center Publications","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.153.7343","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.153.7343","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://faculty.cse.tamu.edu/jsv/Papers/IAEESV06.adaptiverankaware.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.727.3270","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.727.3270","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.csc.lsu.edu/%7Erahul/pubs/tods.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.93.2284","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.93.2284","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.uwaterloo.ca/~ilyas/papers/ilyasTods2006.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W65091138","https://openalex.org/W1489843519","https://openalex.org/W1495105959","https://openalex.org/W1600580971","https://openalex.org/W1850437073","https://openalex.org/W1975731516","https://openalex.org/W2020147322","https://openalex.org/W2020919487","https://openalex.org/W2033368934","https://openalex.org/W2041563709","https://openalex.org/W2051834357","https://openalex.org/W2060091058","https://openalex.org/W2071620504","https://openalex.org/W2083039049","https://openalex.org/W2084538728","https://openalex.org/W2086174602","https://openalex.org/W2098388305","https://openalex.org/W2102166438","https://openalex.org/W2109149785","https://openalex.org/W2120415542","https://openalex.org/W2120754641","https://openalex.org/W2125464986","https://openalex.org/W2133900260","https://openalex.org/W2134195632","https://openalex.org/W2134206624","https://openalex.org/W2136195851","https://openalex.org/W2141649964","https://openalex.org/W2143682328","https://openalex.org/W2148322068","https://openalex.org/W2148942721","https://openalex.org/W2151826520","https://openalex.org/W2153329411","https://openalex.org/W2158141386","https://openalex.org/W2164433331","https://openalex.org/W2164520297","https://openalex.org/W2166855749","https://openalex.org/W2171147420","https://openalex.org/W2203361072","https://openalex.org/W2666600683","https://openalex.org/W2915063781","https://openalex.org/W4229903866","https://openalex.org/W4230983477","https://openalex.org/W4233161060","https://openalex.org/W4233762723"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W906795786","https://openalex.org/W2469357693","https://openalex.org/W2106082581","https://openalex.org/W2413368787","https://openalex.org/W2614542053","https://openalex.org/W2152149667","https://openalex.org/W2406556739","https://openalex.org/W2106125778","https://openalex.org/W1574546694"],"abstract_inverted_index":{"Rank-aware":[0],"query":[1,38,48,81,151,160,216,235],"processing":[2,152],"has":[3],"emerged":[4],"as":[5,70],"a":[6,36,102,115,223,232,282],"key":[7,141],"requirement":[8],"in":[9,62,126,149,172,273],"modern":[10],"applications.":[11],"In":[12,31],"these":[13,98,189],"applications,":[14],"efficient":[15],"and":[16,65,110,169,192,221,239,278],"adaptive":[17,179,291],"evaluation":[18],"of":[19,27,79,97,114,146,210,231,251,265,269,293],"top-":[20,183,214],"k":[21,184,215],"queries":[22,185],"is":[23,52,122,140,236],"an":[24,71,237,243],"integral":[25],"part":[26],"the":[28,56,77,94,107,112,123,128,143,173,200,208,228,249,252,263,297],"application":[29],"semantics.":[30],"this":[32,121],"article,":[33],"we":[34,176,261,280],"introduce":[35,101,177],"rank-aware":[37,80],"optimization":[39],"framework":[40,51],"that":[41,75,186],"fully":[42],"integrates":[43],"rank-join":[44,89,116,147],"operators":[45,90,148],"into":[46],"relational":[47],"engines.":[49],"The":[50,255],"based":[53],"on":[54,92],"extending":[55],"System":[57],"R":[58],"dynamic":[59,274],"programming":[60,275],"algorithm":[61],"both":[63],"enumeration":[64],"pruning.":[66],"We":[67,100],"define":[68],"ranking":[69,138,225,234,271,294],"interesting":[72],"physical":[73],"property":[74],"triggers":[76],"generation":[78],"plans.":[82],"Unlike":[83],"traditional":[84],"join":[85],"operators,":[86],"optimizing":[87],"for":[88,105,132,182],"depends":[91],"estimating":[93,106,127],"input":[95,108,130],"cardinality":[96],"operators.":[99],"probabilistic":[103],"model":[104],"cardinality,":[109],"hence":[111],"cost":[113],"operator.":[117],"To":[118],"our":[119,266,290],"knowledge,":[120],"first":[124],"effort":[125],"needed":[129],"size":[131],"optimal":[133,154],"rank":[134],"aggregation":[135],"algorithms.":[136],"Costing":[137],"plans":[139,217,272,295],"to":[142,166,188,205,247,286],"full":[144],"integration":[145],"real-world":[150],"engines.Since":[153],"execution":[155,180,201,229,292],"strategies":[156,181],"picked":[157],"by":[158],"static":[159],"optimizers":[161],"lose":[162],"their":[163],"optimality":[164],"due":[165],"estimation":[167],"errors":[168],"unexpected":[170,190],"changes":[171,191],"computing":[174],"environment,":[175],"several":[178],"respond":[187],"costing":[193],"errors.":[194],"Our":[195],"reactive":[196],"reoptimization":[197,300],"techniques":[198],"change":[199],"plan":[202],"at":[203],"runtime":[204],"significantly":[206],"enhance":[207],"performance":[209,250],"running":[211,233],"queries.":[212],"Since":[213],"are":[218,258],"usually":[219],"pipelined":[220],"maintain":[222],"complex":[224],"state,":[226],"altering":[227],"strategy":[230],"important":[238],"challenging":[240],"task.We":[241],"conduct":[242],"extensive":[244],"experimental":[245,256],"study":[246],"evaluate":[248],"proposed":[253],"framework.":[254],"results":[257],"twofold:":[259],"(1)":[260],"show":[262,281],"effectiveness":[264],"cost-based":[267,276],"approach":[268],"integrating":[270],"optimizers;":[277],"(2)":[279],"significant":[283],"speedup":[284],"(up":[285],"300%)":[287],"when":[288],"using":[289],"over":[296],"state-of-the-art":[298],"mid-query":[299],"strategies.":[301]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":8}],"updated_date":"2026-08-01T09:00:35.917206","created_date":"2025-10-10T00:00:00"}