{"id":"https://openalex.org/W2105556948","doi":"https://doi.org/10.1109/icde.2008.4497492","title":"XML Index Recommendation with Tight Optimizer Coupling","display_name":"XML Index Recommendation with Tight Optimizer Coupling","publication_year":2008,"publication_date":"2008-04-01","ids":{"openalex":"https://openalex.org/W2105556948","doi":"https://doi.org/10.1109/icde.2008.4497492","mag":"2105556948"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2008.4497492","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2008.4497492","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering","raw_type":"proceedings-article"},"type":"conference-paper","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/A5087983011","display_name":"Iman Elghandour","orcid":"https://orcid.org/0000-0001-7444-4411"},"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":"Iman Elghandour","raw_affiliation_strings":["University of Waterloo, Canada","University of Waterloo, Waterloo ON#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Waterloo ON#TAB#","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000416532","display_name":"Ashraf Aboulnaga","orcid":"https://orcid.org/0000-0001-6693-7099"},"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":"Ashraf Aboulnaga","raw_affiliation_strings":["University of Waterloo, Canada","University of Waterloo, Waterloo ON#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Waterloo ON#TAB#","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102959813","display_name":"Daniel C. Zilio","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"Daniel C. Zilio","raw_affiliation_strings":["IBM Toronto Software Laboratory, Canada","IBM Toronto Lab. zilio@ca.ibm.com#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Software Laboratory, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Lab. zilio@ca.ibm.com#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061267570","display_name":"Fei Chiang","orcid":"https://orcid.org/0000-0003-4128-8074"},"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"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Fei Chiang","raw_affiliation_strings":["IBM Toronto Software Laboratory, Canada","University of Toronto. fchiang@cs.toronto.edu"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Software Laboratory, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"University of Toronto. fchiang@cs.toronto.edu","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003379355","display_name":"Andrey Balmin","orcid":"https://orcid.org/0000-0003-3034-6259"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"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","US"],"is_corresponding":false,"raw_author_name":"Andrey Balmin","raw_affiliation_strings":["University of Toronto, Canada","IBM Almaden Research Center. abalmin@us.ibm.com"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]},{"raw_affiliation_string":"IBM Almaden Research Center. abalmin@us.ibm.com","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104043964","display_name":"Kevin Beyer","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kevin Beyer","raw_affiliation_strings":["Almaden Research Center, IBM, USA","IBM Almaden Research Center. kbeyer@us.ibm.com#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Almaden Research Center, IBM, USA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center. kbeyer@us.ibm.com#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5012414288","display_name":"Calisto Zuzarte","orcid":"https://orcid.org/0009-0006-1440-6775"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"Calisto Zuzarte","raw_affiliation_strings":["IBM Toronto Software Laboratory, Canada","IBM Toronto Lab. calisto@ca.ibm.com"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Software Laboratory, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Lab. calisto@ca.ibm.com","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7637,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.66294017,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"833","last_page":"842"},"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.9998999834060669,"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.9998999834060669,"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.9995999932289124,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9972000122070312,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8119080066680908},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.7522116899490356},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.7521825432777405},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.6727002859115601},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.651997983455658},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6369963884353638},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4547244608402252},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.45375773310661316},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.44825124740600586},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.4345674514770508},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4145240783691406},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.16282111406326294},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.14254561066627502},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09647080302238464}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8119080066680908},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.7522116899490356},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.7521825432777405},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.6727002859115601},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.651997983455658},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6369963884353638},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4547244608402252},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.45375773310661316},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44825124740600586},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.4345674514770508},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4145240783691406},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.16282111406326294},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.14254561066627502},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09647080302238464}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde.2008.4497492","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2008.4497492","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.134.9550","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.134.9550","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/~ashraf/pubs/uwtr07xadv.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":43,"referenced_works":["https://openalex.org/W75609840","https://openalex.org/W1483010440","https://openalex.org/W1524500669","https://openalex.org/W1529608090","https://openalex.org/W1547831574","https://openalex.org/W1553825122","https://openalex.org/W1573136363","https://openalex.org/W1576035775","https://openalex.org/W1845564834","https://openalex.org/W1851390469","https://openalex.org/W1981097903","https://openalex.org/W1983604014","https://openalex.org/W1996468759","https://openalex.org/W2025695428","https://openalex.org/W2026463897","https://openalex.org/W2040374677","https://openalex.org/W2047085757","https://openalex.org/W2070895734","https://openalex.org/W2075552472","https://openalex.org/W2109464129","https://openalex.org/W2121667788","https://openalex.org/W2122457911","https://openalex.org/W2129554248","https://openalex.org/W2129835604","https://openalex.org/W2132546253","https://openalex.org/W2133491514","https://openalex.org/W2133640934","https://openalex.org/W2141280272","https://openalex.org/W2142086901","https://openalex.org/W2143100570","https://openalex.org/W2146581894","https://openalex.org/W2151979016","https://openalex.org/W2152175785","https://openalex.org/W2161728285","https://openalex.org/W2163793079","https://openalex.org/W2168503413","https://openalex.org/W4252112525","https://openalex.org/W6631939696","https://openalex.org/W6633471911","https://openalex.org/W6679572563","https://openalex.org/W6679654625","https://openalex.org/W6681146474","https://openalex.org/W6681363647"],"related_works":["https://openalex.org/W1505866794","https://openalex.org/W2527247821","https://openalex.org/W4237510188","https://openalex.org/W1973126996","https://openalex.org/W2048379072","https://openalex.org/W4301000806","https://openalex.org/W2059878404","https://openalex.org/W2185250746","https://openalex.org/W1562055306","https://openalex.org/W2151419829"],"abstract_inverted_index":{"XML":[0,16,48,54,171,185],"database":[1],"systems":[2,28],"are":[3],"expected":[4],"to":[5,23,31,76,81,102],"handle":[6],"increasingly":[7,11],"complex":[8],"queries":[9,112],"over":[10],"large":[12],"and":[13,58,80,145,184,187],"highly":[14],"structured":[15],"databases.":[17],"An":[18],"important":[19],"problem":[20,57],"that":[21,51,107,155],"needs":[22],"be":[24,109],"solved":[25],"for":[26,38,111,140],"these":[27],"is":[29],"how":[30],"choose":[32],"the":[33,60,68,74,83,92,99,117,135,141,146,158,191],"best":[34,136],"set":[35,93,137,152],"of":[36,63,94,138,153,178,193],"indexes":[37,96,106,139,154],"a":[39,150,175],"given":[40],"workload.":[41,119],"In":[42],"this":[43,53,197],"paper,":[44],"we":[45,125,188],"present":[46],"an":[47,122],"Index":[49,172],"Advisor":[50,173],"solves":[52],"index":[55,78,88,123],"recommendation":[56],"has":[59],"key":[61],"characteristic":[62],"being":[64],"tightly":[65],"coupled":[66],"with":[67],"query":[69,100],"optimizer.":[70],"We":[71,90,167],"rely":[72],"on":[73],"optimizer":[75,101],"enumerate":[77],"candidates":[79],"estimate":[82],"benefit":[84,157],"gained":[85],"from":[86,98],"potential":[87],"configurations.":[89],"expand":[91],"candidate":[95],"obtained":[97],"include":[103],"more":[104],"general":[105,151],"can":[108,156],"useful":[110],"other":[113,164],"than":[114],"those":[115],"in":[116,174],"training":[118,143,159],"To":[120],"recommend":[121],"configuration,":[124],"introduce":[126],"two":[127],"new":[128],"search":[129],"algorithms.":[130],"The":[131],"first":[132],"algorithm":[133,148],"finds":[134,149],"specific":[142],"workload,":[144],"second":[147],"workload":[160],"as":[161,163],"well":[162],"similar":[165],"workloads.":[166],"have":[168],"implemented":[169],"our":[170,194],"prototype":[176],"version":[177],"IBMregDB2reg9,":[179],"which":[180],"supports":[181],"both":[182],"relational":[183],"data,":[186],"experimentally":[189],"demonstrate":[190],"effectiveness":[192],"advisor":[195],"using":[196],"implementation.":[198]},"counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}