skip to main content
10.1145/375663.375674acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
Article

Efficient evaluation of XML middle-ware queries

Published:01 May 2001Publication History

ABSTRACT

We address the problem of efficiently constructing materialized XML views of relational databases. In our setting, the XML view is specified by a query in the declarative query language of a middle-ware system, called SilkRoute. The middle-ware system evaluates a query by sending one or more SQL queries to the target relational database, integrating the resulting tuple streams, and adding the XML tags. We focus on how to best choose the SQL queries, without having control over the target RDBMS.

References

  1. 1.S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases, Addison Wesley, 1995 Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 2.C. Beeri, P Bernstein, "Computational Problems Related to the Design of Normal Form Relational Schemes", ACM Transactions on Database Systems, V4, #1, pp 30{59, 1979 Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. 3.M. Carey, et al, "XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents", VLDB 2000, pp 646-648. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. 4.A. Deutsch, M. Fernandez, D. Florescu, A. Levy, and D. Suciu. "A Query Language for XML", WWW8, 1999. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. 5.M. Fernandez, W Tan, D Suciu, "SilkRoute : Trading between Relations and XML", WWW9, 2000. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. 6.M. Rys, Microsoft, Support WebCast: Microsoft SQL Server 2000: New XML Features, April, 2000 (http://support.microsoft.com/servicedesks/ Webcasts/wc042800/wcblurb042800.asp)Google ScholarGoogle Scholar
  7. 7.A. Sahuguet, "Everything You Ever Wanted to Know About DTDs, But Were Afraid to Ask", SIGMOD WebDB Workshop 2000, pp 69-74. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. 8.P. Selinger, et al, "Access Path Selection in a Relational Database Management System", SIGMOD, pp 23-34, 1979. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. 9.J. Shanmugasundaram, E. Shekita, R. Barr, M. Carey, B. Lindsay, H. Pirahesh, B. Reinwald, "Efficiently Publishing Relational Data as XML Documents", VLDB 2000, pp 65-76. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. 10.B. Wait, Oracle Corporation, "Using XML in Oracle Database Applications", Nov., 1999, (http://technet.oracle.com/tech/xml/info /htdocs/otnwp/about xml.htm)Google ScholarGoogle Scholar
  11. 11.Transaction Processing Performance Council, TPC-H (ad-hoc, decision support) benchmark, http://www.tpc.org/Google ScholarGoogle Scholar
  12. 12.XML Extender Administration and Programming, "IBM DB2 Universal Database XML Extender", (http://www-4.ibm.com/software/data/db2/ extenders/xmlext/docs/v71wrk/english/index.htm)Google ScholarGoogle Scholar
  13. 13.World-Wide Web Consortium XSL Transformations (XSLT), Version 1.0. W3C Recommendation, Nov., 1999. http://www.w3.org/TR/xslt/.Google ScholarGoogle Scholar

Index Terms

  1. Efficient evaluation of XML middle-ware queries

          Recommendations

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in
          • Published in

            cover image ACM Conferences
            SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data
            May 2001
            630 pages
            ISBN:1581133324
            DOI:10.1145/375663

            Copyright © 2001 ACM

            Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

            Publisher

            Association for Computing Machinery

            New York, NY, United States

            Publication History

            • Published: 1 May 2001

            Permissions

            Request permissions about this article.

            Request Permissions

            Check for updates

            Qualifiers

            • Article

            Acceptance Rates

            SIGMOD '01 Paper Acceptance Rate44of293submissions,15%Overall Acceptance Rate785of4,003submissions,20%

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader