Updatable XML-views over relational databases

Authors

  • N.A. Samokhvalov

Keywords:

XML
XML-представления
SQLXML
реляционные представления
обновление представлений
базы данных

Abstract

This paper presents an overview of methods for solving the problem of creation of the system supporting updatable XML-views over relational databases using query trees and proposes some further ways to extend the set of views supported. The rules of query tree creation proposed for the SQL/XML construction make it possible the realization of such an approach as a module of relational DBMS. In addition, the tool for web-interface development as an example of query tree method implementation is described and a short review of possible areas of implementation of this approach is discussed.

New computational technologies

Downloads

Published

2006-10-03

Issue

Vol. 7 (2006): Issue 3.

Section

Section 2. Programming

Author Biography

N.A. Samokhvalov

Moscow Institute of Physics and Technology,
Phystech School of Applied Mathematics and Informatics

References

  1. Extensible Markup Language (XML) 1.0 // W3C Recommendations. W3C, 2004 (http://www.w3.org/TR/2004/REC-xml- 20040204/).
  2. SQL:2003. ISO/IEC JTC 1/SC 32. / Ed.: J. Melton. International Standard. ISO, ANSI, 2003.
  3. Microsoft SQLXML Project (http://www.sqlxml.org/).
  4. W3C DTD Specification // W3C Recommendations. W3C, 1998 (http://www.w3.org/XML/1998/06/xmlspec-report- v21.htm).
  5. XML Path Language (XPath) Version 1.0 // W3C Recommendations. W3C, 1999 (http://www.w3.org/TR/xpath).
  6. XML Schema Part 2: Datatypes // W3C Recommendations. W3C, 2001 (http://www.w3.org/TR/xmlschema-2/).
  7. Braganholo V., Davidson S., Heuser C. On the updatability of XML Views over relational databases // Proceedings of WEBDB 2003. San Diego, 2003.
  8. Braganholo V., Davidson S., Heuser C. Propagating XML View Updates to a relational database. Тесhnical Report RP- 341. Universidade Federal do Rio Grande do Sul, Instituto de Informatica. Porto Alegre, 2004.
  9. Braganholo V., Davidson S., Heuser C. Reasoning about the updatability of XML Views over relational databases. Тесhnical Report MS-CIS-03-13. University of Pennsylvania. Philadelphia, 2003.
  10. Carey M., Florescu D., Ives Z., Lu Y. XPERANTO: Publishing object-relational data as XML // Proceedings of the 25th International Conference on Very Large Data Bases. Edinburgh: Morgan Kaufmann, 1999.
  11. Date C., McGoveran D. Updating Views (6 Parts) // Database Programming & Design. 6-8. San Mateo: Miller Freeman Publications, 1994.
  12. Florescu D., Kossmann D. Storing and querying XML data using an RDMBS // IEEE Data Engineering Bulletin 22. IEEE Computer Society, 1999.
  13. Lee D., Mani M., Chiu F., Chiu W. Nesting-based Relational-to-XML schema translation // International Workshop on the Web and Databases (WebDB). Santa Barbara: ACM SIGMOD, 2001.
  14. Lee D., Mani M., Chiu F., Chiu W. NeT & CoT: Translating relational schemas to XML schemas using semantic constraints. Technical report. UCLA Computer Science Dept. University of California. Los Angeles, 2002.
  15. Lee D., Chiu W. Schema conversion methods between XML and relational models. University of California. Los Angeles, 2002.
  16. Malcolm G. Programming Microsoft SQL Server 2000 with XML. Redmond: Microsoft Press, 2002.
  17. Mani M., Lee D. XML to relational conversion using theory of regular tree grammars. University of California. Los Angeles, 2002.
  18. Murata M., Lee D., Mani M. Taxonomy of XML schema languages using formal language theory. University of California. Los Angeles, 2002.
  19. Shanmugasundaram J., Kiernan J., Fan C., Funderburk J. XPERANTO: Querying XML Views of relational data. IBM Almaden Research Center. San Jose, 2001.
  20. Новак Л.Г., Кузнецов С.Д. Свойства данных XML // Труды ИСП РАН. 4. М.: ИСП РАН, 2003.
  21. Dynamic HTML and XML: The XMLHttpRequest Object. Apple Computer, Inc., 2004 (http://developer.apple.com/internet/webcontent/xmlhttpreq.html).