{"id":"https://openalex.org/W2057900544","doi":"https://doi.org/10.1145/1866480.1866499","title":"Optimizing XML twig queries in relational systems","display_name":"Optimizing XML twig queries in relational systems","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2057900544","doi":"https://doi.org/10.1145/1866480.1866499","mag":"2057900544"},"language":"en","primary_location":{"id":"doi:10.1145/1866480.1866499","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1866480.1866499","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fourteenth International Database Engineering & Applications Symposium on - IDEAS '10","raw_type":"proceedings-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/A5048210137","display_name":"Moad Maghaydah","orcid":null},"institutions":[{"id":"https://openalex.org/I99043593","display_name":"Macquarie University","ror":"https://ror.org/01sf06y89","country_code":"AU","type":"education","lineage":["https://openalex.org/I99043593"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Moad Maghaydah","raw_affiliation_strings":["Macquarie University, Sydney, NSW, Australia","Macquarie University, Sydney NSW, Australia"],"affiliations":[{"raw_affiliation_string":"Macquarie University, Sydney, NSW, Australia","institution_ids":["https://openalex.org/I99043593"]},{"raw_affiliation_string":"Macquarie University, Sydney NSW, Australia","institution_ids":["https://openalex.org/I99043593"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010152619","display_name":"Mehmet A. Orgun","orcid":"https://orcid.org/0000-0002-7873-1562"},"institutions":[{"id":"https://openalex.org/I99043593","display_name":"Macquarie University","ror":"https://ror.org/01sf06y89","country_code":"AU","type":"education","lineage":["https://openalex.org/I99043593"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Mehmet A. Orgun","raw_affiliation_strings":["Macquarie University, Sydney, NSW, Australia","Macquarie University, Sydney NSW, Australia"],"affiliations":[{"raw_affiliation_string":"Macquarie University, Sydney, NSW, Australia","institution_ids":["https://openalex.org/I99043593"]},{"raw_affiliation_string":"Macquarie University, Sydney NSW, Australia","institution_ids":["https://openalex.org/I99043593"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5089348455","display_name":"Imad Khazali","orcid":null},"institutions":[{"id":"https://openalex.org/I60158472","display_name":"Concordia University","ror":"https://ror.org/0420zvk78","country_code":"CA","type":"education","lineage":["https://openalex.org/I60158472"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Imad Khazali","raw_affiliation_strings":["Concordia University, Montreal, Quebec, Canada","Concordia University, Montreal Quebec, Canada"],"affiliations":[{"raw_affiliation_string":"Concordia University, Montreal, Quebec, Canada","institution_ids":["https://openalex.org/I60158472"]},{"raw_affiliation_string":"Concordia University, Montreal Quebec, Canada","institution_ids":["https://openalex.org/I60158472"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5048210137"],"corresponding_institution_ids":["https://openalex.org/I99043593"],"apc_list":null,"apc_paid":null,"fwci":0.3561,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.63203033,"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":"123","last_page":"129"},"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.9991999864578247,"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.9983000159263611,"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.8732569813728333},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.8177985548973083},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.7440329790115356},{"id":"https://openalex.org/keywords/twig","display_name":"Twig","score":0.6679571866989136},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.6318272352218628},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.6216046214103699},{"id":"https://openalex.org/keywords/xml-database","display_name":"XML database","score":0.5966741442680359},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5791758894920349},{"id":"https://openalex.org/keywords/efficient-xml-interchange","display_name":"Efficient XML Interchange","score":0.5557495951652527},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5480655431747437},{"id":"https://openalex.org/keywords/xml-validation","display_name":"XML validation","score":0.5268161296844482},{"id":"https://openalex.org/keywords/xml-schema-editor","display_name":"XML Schema Editor","score":0.5162805914878845},{"id":"https://openalex.org/keywords/xml-schema","display_name":"XML Schema (W3C)","score":0.4882931709289551},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4844267666339874},{"id":"https://openalex.org/keywords/streaming-xml","display_name":"Streaming XML","score":0.461612343788147},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4486958980560303},{"id":"https://openalex.org/keywords/xml-encryption","display_name":"XML Encryption","score":0.338898628950119},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2660420835018158}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8732569813728333},{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.8177985548973083},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.7440329790115356},{"id":"https://openalex.org/C2777601135","wikidata":"https://www.wikidata.org/wiki/Q11162356","display_name":"Twig","level":2,"score":0.6679571866989136},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.6318272352218628},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.6216046214103699},{"id":"https://openalex.org/C183068750","wikidata":"https://www.wikidata.org/wiki/Q357393","display_name":"XML database","level":3,"score":0.5966741442680359},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5791758894920349},{"id":"https://openalex.org/C11508877","wikidata":"https://www.wikidata.org/wiki/Q1124477","display_name":"Efficient XML Interchange","level":3,"score":0.5557495951652527},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5480655431747437},{"id":"https://openalex.org/C55348073","wikidata":"https://www.wikidata.org/wiki/Q595926","display_name":"XML validation","level":3,"score":0.5268161296844482},{"id":"https://openalex.org/C34716815","wikidata":"https://www.wikidata.org/wiki/Q8042322","display_name":"XML Schema Editor","level":3,"score":0.5162805914878845},{"id":"https://openalex.org/C40713593","wikidata":"https://www.wikidata.org/wiki/Q16342","display_name":"XML Schema (W3C)","level":5,"score":0.4882931709289551},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4844267666339874},{"id":"https://openalex.org/C44883583","wikidata":"https://www.wikidata.org/wiki/Q7622687","display_name":"Streaming XML","level":3,"score":0.461612343788147},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4486958980560303},{"id":"https://openalex.org/C173242113","wikidata":"https://www.wikidata.org/wiki/Q607488","display_name":"XML Encryption","level":4,"score":0.338898628950119},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2660420835018158},{"id":"https://openalex.org/C144027150","wikidata":"https://www.wikidata.org/wiki/Q48803","display_name":"Horticulture","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1866480.1866499","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1866480.1866499","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fourteenth International Database Engineering & Applications Symposium on - IDEAS '10","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1491315301","https://openalex.org/W1506320152","https://openalex.org/W1561806880","https://openalex.org/W1682318783","https://openalex.org/W1985722290","https://openalex.org/W2061884758","https://openalex.org/W2098569470","https://openalex.org/W2109464129","https://openalex.org/W2110459974","https://openalex.org/W2111087864","https://openalex.org/W2113836856","https://openalex.org/W2133491514","https://openalex.org/W2139242647","https://openalex.org/W2142876691","https://openalex.org/W2161225124","https://openalex.org/W2163453947","https://openalex.org/W2230830246"],"related_works":["https://openalex.org/W1738162570","https://openalex.org/W2139372063","https://openalex.org/W1975389452","https://openalex.org/W2117247354","https://openalex.org/W2141581404","https://openalex.org/W2157243284","https://openalex.org/W66057032","https://openalex.org/W2155529282","https://openalex.org/W2612836072","https://openalex.org/W1496558728"],"abstract_inverted_index":{"In":[0,94],"this":[1],"paper,":[2],"we":[3,44,96],"propose":[4],"a":[5,38],"new":[6],"approach":[7,30],"for":[8,14],"optimizing":[9],"structural-join":[10],"and":[11,60,74,107],"twig":[12,100],"queries":[13],"XML":[15,67,112],"documents":[16],"more":[17,50],"effectively":[18],"by":[19,64],"utilizing":[20],"the":[21,25,53,57,66,88],"existing":[22],"facilities":[23],"of":[24,37,91],"relational":[26],"database":[27],"systems.":[28],"Our":[29,70],"is":[31],"based":[32],"on":[33,98],"an":[34],"enhanced":[35],"structure":[36],"compact":[39],"Dewey-based":[40,80],"labeling":[41,81],"scheme.":[42],"Further,":[43],"introduce":[45],"techniques":[46,71],"to":[47,55,78],"make":[48],"RDBMS":[49],"tree-aware":[51],"without":[52,61],"need":[54],"modify":[56],"system":[58,106],"kernel":[59],"sacrificing":[62],"space":[63],"exploiting":[65],"schema":[68],"summary.":[69],"are":[72],"portable":[73],"can":[75],"be":[76],"applied":[77],"any":[79],"technique.":[82],"An":[83],"extensive":[84],"experimental":[85],"evaluation":[86],"confirms":[87],"performance":[89,102],"benefits":[90],"our":[92,105],"approach.":[93],"particular,":[95],"report":[97],"extended":[99],"query":[101],"tests":[103],"between":[104],"other":[108],"two":[109],"well":[110],"known":[111],"management":[113],"systems":[114],"(eXist:":[115],"native,":[116],"MonetDB/XQuery:":[117],"relational-based":[118],"system).":[119]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}