Abstract
While XML is emerging as the universal format for publishing and exchanging data on the Web, most business data is still stored and maintained in relational DBMSs. To enable eBusiness database applications, Web access to the legacy data managed by DBMSs needs to be provided. In this paper, we introduce a virtual XML database engine VXE-R which allows users query a relational database via XML as if they were accessing XML documents. Algorithms for schema transformation and query translation in VXE-R are presented.
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
Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web: From Relations to Semistructured Data and XML. Kaufmann Publishers. Morgan Kaufmann, San Francisco (2000)
Baru, C.: XViews: Xml views of relational schemas. In: Proceedings of DEXA Workshop, pp. 700–705 (1999)
Boag, S., Chamberlin, D., Fernandez, M., Florescu, D., Robie, J., Simeon, J., Stefanescu, M.: XQuery 1.0: An XML Query Language, W3C Working Draft (April 2002), http://www.w3.org/TR/2002/WD-xquery-20020430/
Bray, T., Paoli, J., Sperberg-McQueen, C., Maler, E.: Extensible Markup Language (XML) 1.0. 2nd edn. W3C Recommendation (October 2000), http://www.w3.org/TR/REC-xml
Carey, M., Kiernan, J., Shanmugasundaram, J., Shekita, E., Subramanian, S.: XPERANTO: Middleware for publishing object-relational data as xml documents. In: Proceedings of VLDB, pp. 646–648 (2000)
Fallside, D.: XML Schema Part 0: Primer. W3C Recommendation (May 2001), http://www.w3.org/TR/xmlschema-0/
Fernandez, M., Tan, W., Suciu, D.: SilkRoute: Trading between relations and xml. In: Proceedings of WWW, pp. 723–725 (2000)
Lee, D., Mani, M., Chiu, F., Chu, W.: Nesting-based relational-to-xml schema translation. In: Proceedings of the WebDB, pp. 61–66 (2001)
Liu, J., Liu, C.: A declarative way of extracting xml data in xsl. In: Manolopoulos, Y., Návrat, P. (eds.) ADBIS 2002. LNCS, vol. 2435, pp. 374–387. Springer, Heidelberg (2002)
Shanmugasundaram, J., Kiernan, J., Shekita, E., Fan, C., Funderburk, J.: Querying xml views of relational data. In: Proceedings of VLDB, pp. 261–270 (2001)
Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Lindsay, B., Pirahesh, H., Reinwald, B.: Efficiently publishing relational data as xml documents. In: Proceedings of VLDB, pp. 65–76 (2000)
Vincent, M., Liu, J., Liu, C.: A redundancy free 4NF for XML. In: Bellahsène, Z., Chaudhri, A.B., Rahm, E., Rys, M., Unland, R. (eds.) XSym 2003. LNCS, vol. 2824, pp. 254–266. Springer, Heidelberg (2003)
Vincent, M., Liu, J., Liu, C.: Redundancy free mapping from relations to xml. In: Dong, G., Tang, C., Wang, W. (eds.) WAIM 2003. LNCS, vol. 2762, pp. 55–67. Springer, Heidelberg (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Liu, C., Vincent, M.W., Liu, J., Guo, M. (2003). A Virtual XML Database Engine for Relational Databases. In: Bellahsène, Z., Chaudhri, A.B., Rahm, E., Rys, M., Unland, R. (eds) Database and XML Technologies. XSym 2003. Lecture Notes in Computer Science, vol 2824. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-39429-7_3
Download citation
DOI: https://doi.org/10.1007/978-3-540-39429-7_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-20055-0
Online ISBN: 978-3-540-39429-7
eBook Packages: Springer Book Archive