Abstract
Order is essential for XML query processing. Efficient XML processing with order consideration over relational storage is non-trivial, especially for complex nested XQuery expressions. The order semantics may impede efficient query rewriting for nested query blocks. We propose a general order-sensitive XQuery processing approach involving three steps. First an algorithm is proposed for inferencing about and then isolating the order semantics in XQuery expressions specified over virtual XML views. This turns an ordered XQuery plan into an unordered one decorated with minimized order context annotations. Then without loss of semantics, logical optimization via XQuery rewriting can be easily applied to this transformed query plan. As last step, the translation of the optimized logical plan into SQL now correctly incorporates the order context annotations to assure the original order semantics. Our experiments illustrate the performance gains achievable by our order handling strategy.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
El-Sayed, M., Dimitrova, K., Rundensteiner, E.A.: Efficiently Supporting Order in XML Query Processing. In: WIDM, pp. 147–154 (2003)
Fernandez, M.F., Morishima, A., Suciu, D., et al.: Publishing Relational Data in XML: the SilkRoute Approach. IEEE Data Eng. Bulletin 24(2), 12–19 (2001)
Grust, T., van Keulen, M., Teubner, J.: Staircase join: Teach a relational dbms to watch its (axis) steps. In: VLDB, pp. 524–525 (2003)
Hidders, J., Michiels, P.: Avoiding Unnecessary Ordering Operations in XPath. In: DBPL, pp. 54–70 (2003)
Krishnamurthy, R., Kaushik, R., Naughton, J.F.: XML-SQL Query Translation Literature: The State of the Art and Open Problems. In: Xsym, pp. 1–18 (2003)
May, N., Helmer, S., Moerkotte, G.: Nested queries and quantifiers in an ordered context. In: ICDE, pp. 239–250 (2004)
Neumann, T., Moerkotte, G.: A combined framework for grouping and order optimization. In: VLDB, pp. 960–971 (2004)
Neumann, T., Moerkotte, G.: An efficient framework for order optimization. In: ICDE, p. 461 (2004)
O’Neil, P., O’Neil, E., Pal, S., Cseri, I., Schaller, G., Westbury, N.: ORDPATHs: insert-friendly XML node labels. In: SIGMOD, pp. 903–908 (2004)
Paparizos, S., Al-Khalifa, S., Chapman, A., Jagadish, H.V., et al.: TIMBER: A Native System for Querying XML. In: SIGMOD, p. 672 (2003)
Paparizos, S., Jagadish, H.V.: Pattern tree algebras: sets or sequences? In: VLDB, pp. 349–360 (2005)
Shanmugasundaram, J., Kiernan, J., Shekita, E.J., Fan, C., Funderburk, J.: Querying XML Views of Relational Data. In: VLDB, pp. 261–270 (2001)
Simmen, D.E., Shekita, E.J., Malkemus, T.: Fundamental Techniques for Order Optimization. In: SIGMOD, pp. 57–67 (1996)
Slivinskas, G., Jensen, C.S., Snodgrass, R.T.: Bringing order to query optimization. SIGMOD Record 31(2), 5–14 (2002)
Tatarinov, I., Viglas, S., Beyer, K.S., et al.: Storing and querying ordered XML using a relational database system. In: SIGMOD, pp. 204–215 (2002)
W3C. XQuery 1.0: An XML Query Language, http://www.w3.org/TR/xquery/
Wang, L., Wang, S., Rundensteiner, E.: Order-sensitive XML Query Processing over Relational Sources: An Algebraic Approach. In: IDEAS, pp. 175–184 (2005)
Wang, S., Rundensteiner, E.A., Mani, M.: Optimization of Nested XQuery Expressions with Orderby Clauses. In: ICDE Workshops: XSDM, p. 1277 (2005)
Wang, X., Cherniack, M.: Avoiding Sorting and Groupin In Processing Queries. In: VLDB, pp. 826–837 (2003)
Zhang, X., K.D., et al.: Rainbow: Multi-XQuery Optimization Using Materialized XML Views. In: SIGMOD, pp. 671 (2003)
Zhang, X., Pielech, B., Rundensteiner, E.A.: Honey, I Shrunk the XQuery! — An XML Algebra Optimization Approach. In: WIDM, pp. 15–22 (2002)
Zhang, X., Rundensteiner, E.A.: XAT: XML Algebra for the Rainbow System. Technical Report WPI-CS-TR-02-24, Worcester Polytechnic Institute (July 2002)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wang, S., Wang, L., Rundensteiner, E.A. (2007). Isolating Order Semantics in Order-Sensitive XQuery-to-SQL Translation. In: Cooper, R., Kennedy, J. (eds) Data Management. Data, Data Everywhere. BNCOD 2007. Lecture Notes in Computer Science, vol 4587. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-73390-4_14
Download citation
DOI: https://doi.org/10.1007/978-3-540-73390-4_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-73389-8
Online ISBN: 978-3-540-73390-4
eBook Packages: Computer ScienceComputer Science (R0)