A Virtual XML Database Engine for Relational Databases

  • Chengfei Liu
  • Millist W. Vincent
  • Jixue Liu
  • Minyi Guo
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2824)


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.


Relational Database Integrity Constraint Relational Schema Path Expression Query Translation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web: From Relations to Semistructured Data and XML. Kaufmann Publishers. Morgan Kaufmann, San Francisco (2000)Google Scholar
  2. 2.
    Baru, C.: XViews: Xml views of relational schemas. In: Proceedings of DEXA Workshop, pp. 700–705 (1999)Google Scholar
  3. 3.
    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),
  4. 4.
    Bray, T., Paoli, J., Sperberg-McQueen, C., Maler, E.: Extensible Markup Language (XML) 1.0. 2nd edn. W3C Recommendation (October 2000),
  5. 5.
    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)Google Scholar
  6. 6.
    Fallside, D.: XML Schema Part 0: Primer. W3C Recommendation (May 2001),
  7. 7.
    Fernandez, M., Tan, W., Suciu, D.: SilkRoute: Trading between relations and xml. In: Proceedings of WWW, pp. 723–725 (2000)Google Scholar
  8. 8.
    Lee, D., Mani, M., Chiu, F., Chu, W.: Nesting-based relational-to-xml schema translation. In: Proceedings of the WebDB, pp. 61–66 (2001)Google Scholar
  9. 9.
    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)CrossRefGoogle Scholar
  10. 10.
    Shanmugasundaram, J., Kiernan, J., Shekita, E., Fan, C., Funderburk, J.: Querying xml views of relational data. In: Proceedings of VLDB, pp. 261–270 (2001)Google Scholar
  11. 11.
    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)Google Scholar
  12. 12.
    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)CrossRefGoogle Scholar
  13. 13.
    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)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Chengfei Liu
    • 1
  • Millist W. Vincent
    • 1
  • Jixue Liu
    • 1
  • Minyi Guo
    • 2
  1. 1.University of South AustraliaAdelaideAustralia
  2. 2.The University of AizuAizu-Wakamatsu City, FukushimaJapan

Personalised recommendations