{"id":"https://openalex.org/W2150915021","doi":"https://doi.org/10.1145/1526709.1526844","title":"Performing grouping and aggregate functions in XML queries","display_name":"Performing grouping and aggregate functions in XML queries","publication_year":2009,"publication_date":"2009-04-20","ids":{"openalex":"https://openalex.org/W2150915021","doi":"https://doi.org/10.1145/1526709.1526844","mag":"2150915021"},"language":"en","primary_location":{"id":"doi:10.1145/1526709.1526844","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1526709.1526844","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th international conference on World wide web","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://figshare.com/articles/conference_contribution/Performing_grouping_and_aggregate_functions_in_XML_queries/23092874","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103622653","display_name":"Huayu Wu","orcid":null},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Huayu Wu","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037961481","display_name":"Tok Wang Ling","orcid":"https://orcid.org/0000-0002-0496-0565"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Tok Wang Ling","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100673719","display_name":"Liang Xu","orcid":"https://orcid.org/0000-0001-8171-0247"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Liang Xu","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080660416","display_name":"Zhifeng Bao","orcid":"https://orcid.org/0000-0003-2477-381X"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Zhifeng Bao","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5103622653"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":1.4502,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.84604268,"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":"1001","last_page":"1010"},"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.9997000098228455,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9930999875068665,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.8595918416976929},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.7907469272613525},{"id":"https://openalex.org/keywords/xml-validation","display_name":"XML validation","score":0.6810628175735474},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6712363362312317},{"id":"https://openalex.org/keywords/xml-database","display_name":"XML database","score":0.6666538119316101},{"id":"https://openalex.org/keywords/streaming-xml","display_name":"Streaming XML","score":0.6403246521949768},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.5821830034255981},{"id":"https://openalex.org/keywords/efficient-xml-interchange","display_name":"Efficient XML Interchange","score":0.5592265725135803},{"id":"https://openalex.org/keywords/xml-schema-editor","display_name":"XML Schema Editor","score":0.5576505064964294},{"id":"https://openalex.org/keywords/xml-encryption","display_name":"XML Encryption","score":0.5387535691261292},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.4786361753940582},{"id":"https://openalex.org/keywords/xml-schema","display_name":"XML Schema (W3C)","score":0.4286189675331116},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.381409227848053},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.1555250585079193}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8595918416976929},{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.7907469272613525},{"id":"https://openalex.org/C55348073","wikidata":"https://www.wikidata.org/wiki/Q595926","display_name":"XML validation","level":3,"score":0.6810628175735474},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6712363362312317},{"id":"https://openalex.org/C183068750","wikidata":"https://www.wikidata.org/wiki/Q357393","display_name":"XML database","level":3,"score":0.6666538119316101},{"id":"https://openalex.org/C44883583","wikidata":"https://www.wikidata.org/wiki/Q7622687","display_name":"Streaming XML","level":3,"score":0.6403246521949768},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.5821830034255981},{"id":"https://openalex.org/C11508877","wikidata":"https://www.wikidata.org/wiki/Q1124477","display_name":"Efficient XML Interchange","level":3,"score":0.5592265725135803},{"id":"https://openalex.org/C34716815","wikidata":"https://www.wikidata.org/wiki/Q8042322","display_name":"XML Schema Editor","level":3,"score":0.5576505064964294},{"id":"https://openalex.org/C173242113","wikidata":"https://www.wikidata.org/wiki/Q607488","display_name":"XML Encryption","level":4,"score":0.5387535691261292},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.4786361753940582},{"id":"https://openalex.org/C40713593","wikidata":"https://www.wikidata.org/wiki/Q16342","display_name":"XML Schema (W3C)","level":5,"score":0.4286189675331116},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.381409227848053},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1555250585079193}],"mesh":[],"locations_count":7,"locations":[{"id":"doi:10.1145/1526709.1526844","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1526709.1526844","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th international conference on World wide web","raw_type":"proceedings-article"},{"id":"pmh:oai:ecite.utas.edu.au:92213","is_oa":false,"landing_page_url":"http://ecite.utas.edu.au/92213","pdf_url":null,"source":{"id":"https://openalex.org/S4306401569","display_name":"eCite Digital Repository (University of Tasmania)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I129801699","host_organization_name":"University of Tasmania","host_organization_lineage":["https://openalex.org/I129801699"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Refereed Conference Paper"},{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/41013","is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/41013","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scopus","raw_type":"Conference Paper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.150.7110","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.150.7110","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.comp.nus.edu.sg/~lingtw/papers/www2009.wuhuayu.pdf","raw_type":"text"},{"id":"pmh:oai:alma.61RMIT_INST:11247803110001341","is_oa":false,"landing_page_url":"http://doi.org/10.1145/1526709.1526844","pdf_url":null,"source":{"id":"https://openalex.org/S4306402074","display_name":"RMIT Research Repository (RMIT University Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I82951845","host_organization_name":"RMIT University","host_organization_lineage":["https://openalex.org/I82951845"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:figshare.com:article/23092874","is_oa":true,"landing_page_url":"https://figshare.com/articles/conference_contribution/Performing_grouping_and_aggregate_functions_in_XML_queries/23092874","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},{"id":"pmh:oai:figshare.com:article/27390318","is_oa":true,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"}],"best_oa_location":{"id":"pmh:oai:figshare.com:article/23092874","is_oa":true,"landing_page_url":"https://figshare.com/articles/conference_contribution/Performing_grouping_and_aggregate_functions_in_XML_queries/23092874","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W14900795","https://openalex.org/W17883164","https://openalex.org/W26389071","https://openalex.org/W1504392687","https://openalex.org/W1523735491","https://openalex.org/W1555065582","https://openalex.org/W1597597527","https://openalex.org/W1994694191","https://openalex.org/W1995213245","https://openalex.org/W2008116177","https://openalex.org/W2014569520","https://openalex.org/W2021640262","https://openalex.org/W2042587761","https://openalex.org/W2056859949","https://openalex.org/W2061884758","https://openalex.org/W2089211036","https://openalex.org/W2096321409","https://openalex.org/W2103201239","https://openalex.org/W2114627486","https://openalex.org/W2128686935","https://openalex.org/W2137924956","https://openalex.org/W2139242647","https://openalex.org/W2142234917","https://openalex.org/W2148515013","https://openalex.org/W2165286227","https://openalex.org/W4243649771"],"related_works":["https://openalex.org/W1970085714","https://openalex.org/W56340752","https://openalex.org/W2130593017","https://openalex.org/W2357844625","https://openalex.org/W2038564770","https://openalex.org/W2276215951","https://openalex.org/W2536894089","https://openalex.org/W2590489024","https://openalex.org/W1914037376","https://openalex.org/W2060533116"],"abstract_inverted_index":{"Since":[0],"more":[1,3],"and":[2,75,102,123],"business":[4],"data":[5],"are":[6,126],"represented":[7],"in":[8,20,43,48,67,105],"XML":[9,21,49,60,79,93],"format,":[10],"there":[11],"is":[12,81,113],"a":[13,35,68],"compelling":[14],"need":[15],"of":[16,27,110,153],"supporting":[17],"analytical":[18],"operations":[19],"queries.":[22,106],"Particularly,":[23],"the":[24,63,141,151],"latest":[25],"version":[26],"XQuery":[28,32],"proposed":[29],"by":[30],"W3C,":[31],"1.1,":[33],"introduces":[34],"new":[36],"construct":[37],"to":[38,71,98,117,138,149],"explicitly":[39],"express":[40],"grouping":[41,65,74,101],"operation":[42,66],"FLWOR":[44],"expression.":[45],"Existing":[46],"works":[47],"query":[50,57,94,142],"processing":[51,95],"mainly":[52],"focus":[53],"on":[54],"physically":[55],"matching":[56,122],"structure":[58],"over":[59,78,156],"document.":[61],"Given":[62],"explicit":[64],"query,":[69],"how":[70],"efficiently":[72,99],"compute":[73],"aggregate":[76,103],"functions":[77],"document":[80],"not":[82],"well":[83],"studied":[84],"yet.":[85],"In":[86],"this":[87],"paper,":[88],"we":[89,145],"extend":[90],"our":[91,111,154],"previous":[92],"algorithm,":[96],"VERT,":[97],"perform":[100],"function":[104],"The":[107],"main":[108],"technique":[109],"approach":[112],"introducing":[114],"relational":[115],"tables":[116],"index":[118],"values.":[119],"Query":[120],"pattern":[121],"aggregation":[124],"computing":[125],"both":[127],"conducted":[128],"with":[129],"table":[130],"indices.":[131],"We":[132],"also":[133],"propose":[134],"two":[135],"semantic":[136],"optimizations":[137],"further":[139],"improve":[140],"performance.":[143],"Finally":[144],"present":[146],"experimental":[147],"results":[148],"validate":[150],"efficiency":[152],"approach,":[155],"other":[157],"existing":[158],"approaches.":[159]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}