Abstract
This paper proposes an approach to optimizing structural-join and twig queries for XML queries by utilizing the semantics/constraints defined in XML Schemas and the existing facilities of relational database systems. In the first stage, semantic query transformations that use constraints in the schema are utilized to transform given XML queries to equivalent semantic queries. In the second stage, the structure of a given XML document is captured and stored in a table in a relational database, which is subsequently used during query translation and execution. Conducted experiments confirm the performance benefits of our approach in optimization of XML queries before and after applying semantic query transformations as well as capturing the XML document structure. We also report in detail on the results of a comparison between the performance of our approach with those of established native and modified-relational XML database systems.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Al-Khalifa, S., Jagadish, H.V., Koudas, N., Patel, J.M., Srivastava, D., Wu, Y.: Structural joins: A primitive for efficient XML Query pattern matching. In: The 18th International Conference on Data Engineering (ICDE 1902), pp. 141–152. IEEE Computer Society (1902)
Bao, Z., Ling, T.-W., Lu, J., Chen, B.: Semantic twig: A semantic approach to optimize XML query processing. In: Haritsa, J.R., Kotagiri, R., Pudi, V. (eds.) DASFAA 2008. LNCS, vol. 4947, pp. 282–298. Springer, Heidelberg (2008)
Charkravarthy, U.S., Grant, J., Minker, J.: Logic–Based Approach to Semantic Query Optimization. ACM Transactions on Database Systems 15(2), 162–207 (1990)
Chan, Y., Fan, W., Zeng, Y.: Taming XPath Queries by Minimizing Wildcard Steps. In: The Thirtieth International Conference on Very Large Data Bases, pp. 156–167 (2004)
eXist-db Open Source Native XML Database, http://exist-db.org
Fernández, M., Hidders, J., Michiels, P., Siméon, J., Vercammen, R.: Optimizing sorting and duplicate elimination in xQuery path expressions. In: Andersen, K.V., Debenham, J., Wagner, R. (eds.) DEXA 2005. LNCS, vol. 3588, pp. 554–563. Springer, Heidelberg (2005)
Goldman, R., Widom, J.: DataGuides: Enabling query formulation and optimization in semistructured databases. In: The 23rd VLDB Conference, Athens, Greece, pp. 436–445 (1997)
Groppe, J., Groppe, S.: Satisfiability-Test, Rewriting and Refinement of Users’ XPath Queries According to XML Schema Definitions. In: Manolopoulos, Y., Pokorný, J., Sellis, T.K. (eds.) ADBIS 2006. LNCS, vol. 4152, pp. 22–38. Springer, Heidelberg (2006)
Grust, T., Keulen, M. V. & Teubner, J. (2003). Staircase join: Teach a relational DBMS to watch its (axis) steps. The 29th VLDB Conference. Berlin, Germany, 524-535.
Le, D.X.T., Bressan, S., Pardede, E., Rahayu, W., Taniar, D.: Semantic Transformation Approach with Schema Constraints for XPath Query Axes. In: Chen, L., Triantafillou, P., Suel, T. (eds.) WISE 2010. LNCS, vol. 6488, pp. 456–470. Springer, Heidelberg (2010a)
Thi Le, D.X., Bressan, S., Pardede, E., Taniar, D., Rahayu, W.: A utilization of schema constraints to transform predicates in xPath query. In: Bringas, P.G., Hameurlain, A., Quirchmayr, G. (eds.) DEXA 2010, Part I. LNCS, vol. 6261, pp. 331–339. Springer, Heidelberg (2010b)
Maghaydah, M., Orgun, M.A., Khazali, I.: Optimizing XML Twig Queries in Relational Systems. In: The 14th International Database Engineering and Applications Symposium (IDEAS), Montreal, Canada, pp. 123–129 (2010)
Maghaydah, M., Orgun, M.A.: Efficiently Querying Dynamic XML Documents Stored in Relational Database Systems. International Journal of Intelligent Information and Database Systems 5(4), 389–408 (2011)
Moro, M., Vagena, Z., Tsotras, V.: XML structural summaries. Proceedings of the VLDB Endowment 1, 1524–1525 (2008)
Pal, S., Cseri, I., Seeliger, O., Rys, M., Schaller, G., Yu, W., Tomic, D., Baras, A., Berg, B., Churin, D., Kogan, E.: XQuery implementaion in a relational database system. In: The 31st VLDB Conference, pp. 1175–1186. VLDB Endowment, Trondheim, Norway (2005a)
Runapongsa, K., Patel, J.M., Jagadish, H.V., Chen, Y., Al-Khalifa, S.: The Michigan benchmark. EECS The University of Michigan (2003), http://www.eecs.umich.edu/db/mbench/
Shenoy, S.T., Ozsoyoglu, Z.M.: Design and Implementation of a Semantic Query Optimizer. IEEE Transactions on Knowledge and Data Engineering 1(3), 344–361 (1997)
Su, H., Rundensteiner, E., Mani, M.: Semantic Query Optimization for XQuery over XML Streams. In: The 31st International Conference on Very Large Data Bases (VLDB), Trondheim, Norway, pp. 277–282 (2005)
Wang, G., Liu, M., Yu, J.: Effective Schema-Based XML Query Optimization Techniques. In: The Seventh International Database Engineering and Application Symposium (IDEAS), pp. 1–6 (2003)
Wu, H., Ling, T.W., Dobbie, G., Bao, Z., Xu, L.: Reducing Graph Matching to Tree Matching for XML Queries with ID References. In: Bringas, P.G., Hameurlain, A., Quirchmayr, G. (eds.) DEXA 2010, Part II. LNCS, vol. 6262, pp. 391–406. Springer, Heidelberg (2010)
Wu, H., Ling, T.W., Chen, B., Xu, L.: TwigTable: Using Semantics in XML Twig Pattern Query Processing. In: Spaccapietra, S. (ed.) Journal on Data Semantics XV. LNCS, vol. 6720, pp. 102–129. Springer, Heidelberg (2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Le, D.X.T., Maghaydah, M., Orgun, M.A., Zhong, Y. (2013). Optimization of XML Queries by Using Semantics in XML Schemas and the Document Structure. In: Lin, X., Manolopoulos, Y., Srivastava, D., Huang, G. (eds) Web Information Systems Engineering – WISE 2013. WISE 2013. Lecture Notes in Computer Science, vol 8180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-41230-1_29
Download citation
DOI: https://doi.org/10.1007/978-3-642-41230-1_29
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-41229-5
Online ISBN: 978-3-642-41230-1
eBook Packages: Computer ScienceComputer Science (R0)