Abstract
SQL/XML allows generating an XML document as the result of a query that is evaluated on relational data. This facilitates companies sharing their relational data in form of XML documents with other companies or with a marketplace, but significantly increases the exchanged data volume. To reduce both the volume of the exchanged data by exchanging compressed XML and the time needed for compression, we propose an approach that allows preparation of a compressed XML document as the answer to an SQL/XML query directly, i.e., without the need to create the XML document first and compress it afterwards. Our evaluation has shown that generating the compressed document directly is in most cases faster than generating the uncompressed XML document and compressing it, and in some cases it is even faster than the generation of the uncompressed XML document alone. As our approach of generating compressed XML requires only SQL support from the underlying database system, a second advantage is that it can be used for the generation of compressed XML even for database systems that do not (yet) support SQL/XML (like MySQL).
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
Böttcher, S., Hartel, R., Messinger, C.: Searchable Compression of Office Documents by XML Schema Subtraction. In: Lee, M.L., Yu, J.X., Bellahsène, Z., Unland, R. (eds.) XSym 2010. LNCS, vol. 6309, pp. 103–112. Springer, Heidelberg (2010)
Jahnkuhn, H., Bruder, I., Balouch, A., Nelius, M., Heuer, A.: Query Transformation of SQL into XQuery Within Federated Environments. In: Grust, T., Höpfner, H., Illarramendi, A., Jablonski, S., Fischer, F., Müller, S., Patranjan, P.-L., Sattler, K.-U., Spiliopoulou, M., Wijsen, J. (eds.) EDBT 2006. LNCS, vol. 4254, pp. 577–588. Springer, Heidelberg (2006)
Jigyasu, S., Banerjee, S., Borkar, V., Carey, M., Dixit, K., Malkani, A., Thatte, S.: SQL to XQuery Translation in the AquaLogic Data Services Platform. In: Proceedings of the 22nd International Conference on Data Engineering, ICDE 2006, Atlanta, GA, USA, p. 97 (2006)
Halverson, A., Josifovski, V., Lohman, G., Pirahesh, H., Märschel, M.: ROX: Relational Over XML. In: (e)Proceedings of the Thirtieth International Conference on Very Large Data Bases, Toronto, Canada, pp. 264–275 (2004)
Shanmugasundaram, J., Kiernan, J., Shekita, E., Fan, C., Funderburk, J.: Querying XML Views of Relational Data. In: VLDB 2001, Proceedings of 27th International Conference on Very Large Data Bases, Roma, Italy, pp. 261–270 (2001)
Shao, F., Novak, A., Shanmugasundaram, J.: Triggers over XML views of relational data. In: Proceedings of the 21st International Conference on Data Engineering, ICDE 2005, Tokyo, Japan, pp. 483–484 (2005)
Agichtein, E., Josifovski, V.: Extracting Relations from XML Documents. In: Conceptual Modeling for Novel Application Domains, ER 2003 Workshops, Chicago, IL, USA, pp. 390–401 (2003)
Bohannon, P., Freire, J., Roy, P., Simeon, J.: From XML Schema to Relations: A Cost-Based Approach to XML Storage. In: Proceedings of the 18th International Conference on Data Engineering, San Jose, CA, USA, p. 64 (2002)
Tatarinov, I., Viglas, S., Beyer, K., Shanmugasundaram, J., Shekita, E., Zhang, C.: Storing and querying ordered XML using a relational database system. In: Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, Madison, Wisconsin, USA, pp. 204–215 (2002)
Garofalakis, M., Gionis, A., Rastogi, R., Seshadri, S., Shim, K.: XTRACT: A System for Extracting Document Type Descriptors from XML Documents. In: Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, Dallas, Texas, USA, pp. 165–176 (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Böttcher, S., Bokermann, D., Hartel, R. (2011). Computing Compressed XML Data from Relational Databases. In: Fernandes, A.A.A., Gray, A.J.G., Belhajjame, K. (eds) Advances in Databases. BNCOD 2011. Lecture Notes in Computer Science, vol 7051. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24577-0_21
Download citation
DOI: https://doi.org/10.1007/978-3-642-24577-0_21
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-24576-3
Online ISBN: 978-3-642-24577-0
eBook Packages: Computer ScienceComputer Science (R0)