Advertisement

The VLDB Journal

, Volume 10, Issue 2–3, pp 133–154 | Cite as

Efficiently publishing relational data as XML documents

  • Jayavel Shanmugasundaram
  • Eugene Shekita
  • Rimon Barr
  • Michael Carey
  • Bruce Lindsay
  • Hamid Pirahesh
  • Berthold Reinwald
Special section
  • 182 Downloads

Abstract.

XML is rapidly emerging as a standard for exchanging business data on the World Wide Web. For the foreseeable future, however, most business data will continue to be stored in relational database systems. Consequently, if XML is to fulfill its potential, some mechanism is needed to publish relational data as XML documents. Towards that goal, one of the major challenges is finding a way to efficiently structure and tag data from one or more tables as a hierarchical XML document. Different alternatives are possible depending on when this processing takes place and how much of it is done inside the relational engine. In this paper, we characterize and study the performance of these alternatives. Among other things, we explore the use of new scalar and aggregate functions in SQL for constructing complex XML documents directly in the relational engine. We also explore different execution plans for generating the content of an XML document. The results of an experimental study show that constructing XML documents inside the relational engine can have a significant performance benefit. Our results also show the superiority of having the relational engine use what we call an “outer union plan” to generate the content of an XML document.

Key words: Relational databases – XML – Publishing 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • Jayavel Shanmugasundaram
    • 1
  • Eugene Shekita
    • 1
  • Rimon Barr
    • 1
  • Michael Carey
    • 1
  • Bruce Lindsay
    • 1
  • Hamid Pirahesh
    • 1
  • Berthold Reinwald
    • 1
  1. 1.IBM Almaden Research Center, 650 Harry Road, San Jose, CA 95120, USA; E-mail: {shanmuga, shekita, bgl, pirahesh, reinwald}@almaden.ibm.com; barr@cs.cornell.edu; carey@propel.com US

Personalised recommendations