Bottom-up computation of sparse and Iceberg CUBE
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
On optimizing an SQL-like nested query
ACM Transactions on Database Systems (TODS)
Query processing of streamed XML data
Proceedings of the eleventh international conference on Information and knowledge management
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
EDBT '02 Proceedings of the Worshops XMLDM, MDDE, and YRWS on XML-Based Data Management and Multimedia Engineering-Revised Papers
Nested Queries in Object Bases
DBLP-4 Proceedings of the Fourth International Workshop on Database Programming Languages - Object Models and Languages
Algebraic XML Construction in Natix
WISE '01 Proceedings of the Second International Conference on Web Information Systems Engineering (WISE'01) Volume 1 - Volume 1
System RX: one part relational, one part XML
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
The NEXT framework for logical XQuery optimization
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Bridging the gap between OLAP and SQL
VLDB '05 Proceedings of the 31st international conference on Very large data bases
A relevance-extended multi-dimensional model for a data warehouse contextualized with documents
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Rewriting nested XML queries using nested views
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Efficient XSLT processing in relational database system
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Strategies for query unnesting in XML databases
ACM Transactions on Database Systems (TODS)
Mapping-driven XML transformation
Proceedings of the 16th international conference on World Wide Web
Haskell '07 Proceedings of the ACM SIGPLAN workshop on Haskell workshop
Ix-cubes: iceberg cubes for data warehousing and olap on xml data
Proceedings of the sixteenth ACM conference on Conference on information and knowledge management
Contextualizing data warehouses with documents
Decision Support Systems
Damia: data mashups for intranet applications
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Expressing OLAP operators with the TAX XML algebra
DataX '08 Proceedings of the 2008 EDBT workshop on Database technologies for handling XML information on the web
Multidimensional content eXploration
Proceedings of the VLDB Endowment
Some rewrite optimizations of DB2 XQuery navigation
Proceedings of the 17th ACM conference on Information and knowledge management
Data mining-based fragmentation of XML data warehouses
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Performing grouping and aggregate functions in XML queries
Proceedings of the 18th international conference on World wide web
Enhancing XML data warehouse query performance by fragmentation
Proceedings of the 2009 ACM symposium on Applied Computing
A relational data harmonization approach to XML
Journal of Information Science
Fragmenting very large XML data warehouses via K-means clustering algorithm
International Journal of Business Intelligence and Data Mining
LMDQL: link-based and multidimensional query language
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Model driven development of secure XML data warehouses: a case study
Proceedings of the 2010 EDBT/ICDT Workshops
Document-centric OLAP in the schema-chaos world
BIRTE'06 Proceedings of the 1st international conference on Business intelligence for the real-time enterprises
Declarative XML data cleaning with XClean
CAiSE'07 Proceedings of the 19th international conference on Advanced information systems engineering
A secure multiparty computation privacy preserving OLAP framework over distributed XML data
Proceedings of the 2010 ACM Symposium on Applied Computing
Finding an application-appropriate model for XML data warehouses
Information Systems
Graphical XQuery in the aqualogic data services platform
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML
Journal of Intelligent Information Systems
Business intelligence for small and middle-sized entreprises
ACM SIGMOD Record
Real-time data warehousing for business intelligence
Proceedings of the 8th International Conference on Frontiers of Information Technology
XWeB: the XML warehouse benchmark
TPCTC'10 Proceedings of the Second TPC technology conference on Performance evaluation, measurement and characterization of complex systems
Journal of Computer and System Sciences
A practical application of our MDD approach for modeling secure XML data warehouses
Decision Support Systems
Supporting efficient grouping and summary information for semistructured digital libraries
ICADL'06 Proceedings of the 9th international conference on Asian Digital Libraries: achievements, Challenges and Opportunities
Benchmarking summarizability processing in XML warehouses with complex hierarchies
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Efficient XQuery evaluation of grouping conditions with duplicate removals
XSym'07 Proceedings of the 5th international conference on Database and XML Technologies
Analytical Processing Over XML and XLink
International Journal of Data Warehousing and Mining
| Hi-index | 0.00 |
XQuery is a query language under development by the W3C XML Query Working Group. The language contains constructs for navigating, searching, and restructuring XML data. With XML gaining importance as the standard for representing business data, XQuery must support the types of queries that are common in business analytics. One such class of queries is OLAP-style aggregation queries. Although these queries are expressible in XQuery Version 1, the lack of explicit grouping constructs makes the construction of these queries non-intuitive and places a burden on the XQuery engine to recognize and optimize the implicit grouping constructs. Furthermore, although the flexibility of the XML data model provides an opportunity for advanced forms of grouping that are not easily represented in relational systems, these queries are difficult to express using the current XQuery syntax. In this paper, we provide a proposal for extending the XQuery FLWOR expression with explicit syntax for grouping and for numbering of results. We show that these new XQuery constructs not only simplify the construction and evaluation of queries requiring grouping and ranking but also enable complex analytic queries such as moving-window aggregation and rollups along dynamic hierarchies to be expressed without additional language extensions.