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.
- 1.S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases, Addison Wesley, 1995 Google ScholarDigital Library
- 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 ScholarDigital Library
- 3.M. Carey, et al, "XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents", VLDB 2000, pp 646-648. Google ScholarDigital Library
- 4.A. Deutsch, M. Fernandez, D. Florescu, A. Levy, and D. Suciu. "A Query Language for XML", WWW8, 1999. Google ScholarDigital Library
- 5.M. Fernandez, W Tan, D Suciu, "SilkRoute : Trading between Relations and XML", WWW9, 2000. Google ScholarDigital Library
- 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 Scholar
- 7.A. Sahuguet, "Everything You Ever Wanted to Know About DTDs, But Were Afraid to Ask", SIGMOD WebDB Workshop 2000, pp 69-74. Google ScholarDigital Library
- 8.P. Selinger, et al, "Access Path Selection in a Relational Database Management System", SIGMOD, pp 23-34, 1979. Google ScholarDigital Library
- 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 ScholarDigital Library
- 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 Scholar
- 11.Transaction Processing Performance Council, TPC-H (ad-hoc, decision support) benchmark, http://www.tpc.org/Google Scholar
- 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 Scholar
- 13.World-Wide Web Consortium XSL Transformations (XSLT), Version 1.0. W3C Recommendation, Nov., 1999. http://www.w3.org/TR/xslt/.Google Scholar
Index Terms
Efficient evaluation of XML middle-ware queries
Recommendations
Efficient evaluation of XML middle-ware queries
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 ...
Techniques for the evaluation of XML queries: a survey
As XML has become an emerging standard for information exchange on the World Wide Web it has gained great attention among database communities with respect to extraction of information from XML, which is considered as a database model. XML queries ...
Containment of nested XML queries
VLDB '04: Proceedings of the Thirtieth international conference on Very large data bases - Volume 30Query containment is the most fundamental relationship between a pair of database queries: a query Q is said to be contained in a query Q′ if the answer for Q is always a subset of the answer for Q′, independent of the current state of the database. ...
Comments