Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

XML Publishing

  • Zachary G. IvesEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_784


XML export


XML Publishing typically refers to the creation of XML output (either in the form of a character stream or file) from a relational DBMS. XML Publishing typically must handle three issues: converting an XML query or view definition into a corresponding SQL query; encoding hierarchy in the SQL data; and generating tags around the encoded hierarchical data. Since in some cases the relational data may have originated from XML, the topics of XML Storage and XML Publishing are closely related and often addressed simultaneously.

Historical Background

The topic of XML Publishing arose very soon after database researchers suggested a connection between XML and semi-structured data [5], a topic that had previously been studied in the database literature [1, 2, 8]. Initially the assumption was that XML databases would probably need to resemble those for semi-structured data in order to get good performance. Florescu and Kossmann [11] showed that storing XML in a...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Abiteboul S, Quass D, McHugh J, Widom J, Winer JL. The Lorel query language for semistructured data. Int J Digit Libr. 1997;1(1):68–88.CrossRefGoogle Scholar
  2. 2.
    Buneman P, Davidson SB, Fernandez MF, Suciu D. Adding structure to unstructured data. In: Proceedings of the 13th International Conference on Data Engineering; 1997. p. 336–50.Google Scholar
  3. 3.
    Carey MJ, Florescu D, Ives ZG, Lu Y, Shanmugasundaram J, Shekita E, Subramanian S. XPERANTO: publishing object-relational data as XML. In: Proceedings of the 3rd International Workshop on the World Wide Web and Databases; 2000. p. 105–10.Google Scholar
  4. 4.
    Carey M, Kiernan J, Shanmugasundaram J, Shekita E, Subramanian S. XPERANTO: a middleware for publishing object-relational data as XML documents. In: Proceedings of the 26th International Conference on Very Large Data Bases; 2000. p. 646–8.Google Scholar
  5. 5.
    Deutsch A, Fernández MF, Florescu D, Levy AY, Suciu D. XML-QL. In: Proceedings of the Query Languages Workshop; 1998.Google Scholar
  6. 6.
    Deutsch A, Fernandez MF, Florescu D, Levy A, Suciu D. A query language for XML. Comp Netw. 1999;31(11–16):1155–69.CrossRefGoogle Scholar
  7. 7.
    Deutsch A, Fernandez MF, Suciu D. Storing semistructured data with STORED. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1999. p. 431–42.Google Scholar
  8. 8.
    Fernandez MF, Florescu D, Kang J, Levy AY, Suciu D. Catching the boat with strudel: experiences with a web-site management system. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 414–25.Google Scholar
  9. 9.
    Fernandez MF, Kadiyska Y, Suciu D, Morishima A, Tan WC. SilkRoute: a framework for publishing relational data in XML. ACM Trans Database Syst. 2002;27(4):438–93.CrossRefGoogle Scholar
  10. 10.
    Fernandez M, Tan WC, Suciu D. SilkRoute: trading between relations and XML. Comp Netw. 2000;33(1–6):723–45.CrossRefGoogle Scholar
  11. 11.
    Florescu D, Kossmann D. A Performance evaluation of alternative mapping schemes for storing XML data in a relational database. Technical Report 3684, INRIA; 1999.Google Scholar
  12. 12.
    ISO/IEC 9075-14:2003 Information technology – Database languages – SQL – Part 14: XML-Related Specifications (SQL/XML).Google Scholar
  13. 13.
    Shanmugasundaram J. Bridging relational technology and XML. Ph.D. thesis, University of Wisconsin-Madison; 2001.Google Scholar
  14. 14.
    Shanmugasundaram J, Shekita EJ, Barr R, Carey MJ, Lindsay BG, Pirahesh H, Reinwald B. Efficiently publishing relational data as XML documents. VLDB J. 2001;10(2–3):133–54.zbMATHGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Computer and Information Science DepartmentUniversity of PennsylvaniaPhiladelphiaUSA

Section editors and affiliations

  • Sihem Amer-Yahia
    • 1
  1. 1.Laboratoire d’Informatique de GrenobleCNRS and LIGGrenobleFrance