{"id":"https://openalex.org/W1971627640","doi":"https://doi.org/10.1145/1376616.1376752","title":"An xml index advisor for DB2","display_name":"An xml index advisor for DB2","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W1971627640","doi":"https://doi.org/10.1145/1376616.1376752","mag":"1971627640"},"language":"en","primary_location":{"id":"doi:10.1145/1376616.1376752","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376752","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","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, Waterloo, ON, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","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, Waterloo, ON, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","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 Lab, Markham, ON, Canada","IBM Toronto Lab., Markham, ON, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Lab, Markham, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Lab., Markham, ON, Canada","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"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Fei Chiang","raw_affiliation_strings":["University of Toronto, Toronto, ON, Canada","University of Toronto, Toronto, On, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, ON, Canada","institution_ids":["https://openalex.org/I185261750"]},{"raw_affiliation_string":"University of Toronto, Toronto, On, Canada","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/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":"Andrey Balmin","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104043964","display_name":"Kevin Beyer","orcid":null},"institutions":[{"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":["IBM Almaden Research Center, San Jose, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]}]},{"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 Lab, Markham, ON, Canada","IBM Toronto Lab., Markham, ON, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Lab, Markham, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Lab., Markham, ON, Canada","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":1.5275,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.81646699,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1267","last_page":"1270"},"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.9998000264167786,"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.9998000264167786,"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.9993000030517578,"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.9941999912261963,"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.8503600358963013},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.6999672651290894},{"id":"https://openalex.org/keywords/xml-database","display_name":"XML database","score":0.6920835971832275},{"id":"https://openalex.org/keywords/efficient-xml-interchange","display_name":"Efficient XML Interchange","score":0.5989530682563782},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.586183488368988},{"id":"https://openalex.org/keywords/streaming-xml","display_name":"Streaming XML","score":0.5791258811950684},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.5643350481987},{"id":"https://openalex.org/keywords/xml-schema-editor","display_name":"XML Schema Editor","score":0.5327093005180359},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4988596439361572},{"id":"https://openalex.org/keywords/xml-validation","display_name":"XML validation","score":0.4937370717525482},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.42529821395874023},{"id":"https://openalex.org/keywords/xml-schema","display_name":"XML Schema (W3C)","score":0.4137979745864868},{"id":"https://openalex.org/keywords/xml-encryption","display_name":"XML Encryption","score":0.38299858570098877},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.24286684393882751},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12384060025215149}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8503600358963013},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.6999672651290894},{"id":"https://openalex.org/C183068750","wikidata":"https://www.wikidata.org/wiki/Q357393","display_name":"XML database","level":3,"score":0.6920835971832275},{"id":"https://openalex.org/C11508877","wikidata":"https://www.wikidata.org/wiki/Q1124477","display_name":"Efficient XML Interchange","level":3,"score":0.5989530682563782},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.586183488368988},{"id":"https://openalex.org/C44883583","wikidata":"https://www.wikidata.org/wiki/Q7622687","display_name":"Streaming XML","level":3,"score":0.5791258811950684},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.5643350481987},{"id":"https://openalex.org/C34716815","wikidata":"https://www.wikidata.org/wiki/Q8042322","display_name":"XML Schema Editor","level":3,"score":0.5327093005180359},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4988596439361572},{"id":"https://openalex.org/C55348073","wikidata":"https://www.wikidata.org/wiki/Q595926","display_name":"XML validation","level":3,"score":0.4937370717525482},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.42529821395874023},{"id":"https://openalex.org/C40713593","wikidata":"https://www.wikidata.org/wiki/Q16342","display_name":"XML Schema (W3C)","level":5,"score":0.4137979745864868},{"id":"https://openalex.org/C173242113","wikidata":"https://www.wikidata.org/wiki/Q607488","display_name":"XML Encryption","level":4,"score":0.38299858570098877},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.24286684393882751},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12384060025215149}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1376616.1376752","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376752","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.216.8721","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.216.8721","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/sigmod08xadvdemo.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":8,"referenced_works":["https://openalex.org/W1996468759","https://openalex.org/W2105556948","https://openalex.org/W2108883953","https://openalex.org/W2129835604","https://openalex.org/W2151979016","https://openalex.org/W2152175785","https://openalex.org/W2168503413","https://openalex.org/W6679572563"],"related_works":["https://openalex.org/W2357844625","https://openalex.org/W2536894089","https://openalex.org/W2590489024","https://openalex.org/W1914037376","https://openalex.org/W2401139123","https://openalex.org/W2106024890","https://openalex.org/W2189177577","https://openalex.org/W2103912919","https://openalex.org/W2053173742","https://openalex.org/W2360646659"],"abstract_inverted_index":{"XML":[0,16,46,52,72],"database":[1,66],"systems":[2,28],"are":[3],"expected":[4],"to":[5,23,31,90],"handle":[6],"increasingly":[7,11],"complex":[8],"queries":[9],"over":[10],"large":[12],"and":[13,56,96],"highly":[14],"structured":[15],"databases.":[17],"An":[18],"important":[19],"problem":[20,55],"that":[21,49,87],"needs":[22],"be":[24],"solved":[25],"for":[26,38,75],"these":[27],"is":[29,57],"how":[30],"choose":[32],"the":[33,61,65,82,92,97,100],"best":[34],"set":[35],"of":[36,64,99],"indexes":[37],"a":[39],"given":[40],"workload.":[41],"We":[42,68],"have":[43,69],"developed":[44],"an":[45],"Index":[47,73],"Advisor":[48,74],"solves":[50],"this":[51,78],"index":[53,93],"recommendation":[54,94],"tightly":[58],"coupled":[59],"with":[60],"query":[62,84],"optimizer":[63,85],"system.":[67],"implemented":[70],"our":[71],"DB2.":[76],"In":[77],"demonstration":[79],"we":[80,88],"showcase":[81],"new":[83],"modes":[86],"added":[89],"DB2,":[91],"process,":[95],"effectiveness":[98],"recommended":[101],"indexes.":[102]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}