Performing grouping and aggregate functions in XML queries
conference contribution
posted on 2023-05-23, 09:01authored byWu, H, Ling, TW, Xu, L, Bao, Z
Since more and more business data are represented in XML format, there is a compelling need of supporting analytical operations in XML queries. Particularly, the latest version of XQuery proposed by W3C, XQuery 1.1, introduces a new construct to explicitly express grouping operation in FLWOR expression. Existing works in XML query processing mainly focus on physically matching query structure over XML document. Given the explicit grouping operation in a query, how to efficiently compute grouping and aggregate functions over XML document is not well studied yet. In this paper, we extend our previous XML query processing algorithm, VERT, to efficiently perform grouping and aggregate function in queries. The main technique of our approach is introducing relational tables to index values. Query pattern matching and aggregation computing are both conducted with table indices. We also propose two semantic optimizations to further improve the query performance. Finally we present experimental results to validate the efficiency of our approach, over other existing approaches.
History
Publication title
Proceedings of the 18th International Conference on World Wide Web
Pagination
1001-1010
ISBN
978-1-60558-487-4
Publisher
Association for Computing Machinery
Place of publication
United States of America
Event title
18th International Conference on World Wide Web
Event Venue
Madrid, Spain
Date of Event (Start Date)
2009-04-20
Date of Event (End Date)
2009-04-24
Rights statement
Copyright 2009 ACM
Repository Status
Restricted
Socio-economic Objectives
Information systems, technologies and services not elsewhere classified