XVerter: querying XML data with OR-DBMS

ABSTRACT

Storage techniques and queries over XML databases are being widely studied. Most works store XML documents in traditional DBMSs in order to take advantage of a well established technology and also to store both structured data and XML data within a single system. This work proposes a translation mechanism to execute queries expressed on XQuery on top of XML documents that are stored in an object DBMS using the DOM implementation in disk. Rules for automatic translation from XQuery to SQL3 are presented, where an object-based representation of XML documents is exploited.

REFERENCES

• 1: Cheng, J., Xu, J.:"XML and DB2". ICDE 2000, pp. 569--573.
• 2: Leonidas Fegaras , Ramez Elmasri, Query Engines for Web-Accessible XML Data, Proceedings of the 27th International Conference on Very Large Data Bases, p.251-260, September 11-14, 2001
• 3: Florescu, D. and Kossman, D.: "Storing and Querying XML Data using an RDBMS". IEEE Data Engineering Bulletin 22(3) 1999, pp. 27--34.
• 4: Ioana Manolescu , Daniela Florescu , Donald Kossmann, Answering XML Queries on Heterogeneous Data Sources, Proceedings of the 27th International Conference on Very Large Data Bases, p.241-250, September 11-14, 2001
• 5: Ioana Manolescu , Daniela Florescu , Donald Kossmann , Florian Xhumari , Dan Olteanu, Agora: Living with XML and Relational, Proceedings of the 26th International Conference on Very Large Data Bases, p.623-626, September 10-14, 2000
• 6: Mattoso, M.: "GOA++: Gerente de Objetos Armazenados". http://www.cos.ufrj.br/~goa
• 7: Jason George Mchugh , Jennifer Widom, Data management and query processing for semistructured data, 2000
• 8: Oracle: "The New XMLType Datatype". http://otn.oracle.com/products/oracle9i/daily/nov08.html
• 9: A. R. Schmidt , Florian Waas , Martin L. Kersten , D. Florescu , I. Manolescu , M. J. Carey , R. Busse, The XML benchmark project, CWI (Centre for Mathematics and Computer Science), Amsterdam, The Netherlands, 2001
• 10: Jayavel Shanmugasundaram , Kristin Tufte , Chun Zhang , Gang He , David J. DeWitt , Jeffrey F. Naughton, Relational Databases for Querying XML Documents: Limitations and Opportunities, Proceedings of the 25th International Conference on Very Large Data Bases, p.302-314, September 07-10, 1999
• 11: Igor Tatarinov , Stratis D. Viglas , Kevin Beyer , Jayavel Shanmugasundaram , Eugene Shekita , Chun Zhang, Storing and querying ordered XML using a relational database system, Proceedings of the 2002 ACM SIGMOD international conference on Management of data, June 03-06, 2002, Madison, Wisconsin [doi>10.1145/564691.564715]
• 12: The Apache XML Project. http://xml.apache.org/xerces-j/apiDocs/org/apache/xerces/dom/package-summary.html
• 13: Feng Tian , David J. DeWitt , Jianjun Chen , Chun Zhang, The design and performance evaluation of alternative XML storage strategies, ACM SIGMOD Record, v.31 n.1, March 2002 [doi>10.1145/507338.507341]
• 14: World Wide Web Consortium. http://www.w3.org
• 15: World Wide Web Consortium Document Object Model. http://www.w3.org/DOM
• 16: World Wide Web Consortium XML Query. http://www.w3.org/XML/Query
• 17: World Wide Web Consortium XPath http://www.w3.org/TR/xpath
• 18: World Wide Web Consortium XSL Transformations.http://www.w3c.org/TR/xslt

INDEX TERMS

Primary Classification:
  E. Data
  E.2 DATA STORAGE REPRESENTATIONS
      Subjects: Object representation

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Query languages

General Terms:
Experimentation, Languages, Management

Keywords:
DOM, SQL3, XML, XQuery, XSLT, object DBMS