Dynamic XML View Creation And Update Propogation Using Relational Database

##plugins.themes.academic_pro.article.sidebar##

Published Nov 1, 2010
https://doi.org/10.47164/ijngc.v1i2.18
Download
PDF
Statistic

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...
Volume 1, Issue 2, November 2010

##plugins.themes.academic_pro.article.main##

Sanjay K. Madria
Department of Computer Science, Missouri University of Science and Technology, Rolla, MO 65401
Janarthanan Eindhal
Department of Computer Science, Missouri University of Science and Technology, Rolla, MO 65401

Abstract

eXtensible Mark Language(XML) has already become the industry standard for exchange and representation of data. The ability of XML to provide semantics to the data it holds finds its purpose in many applications over diverse industries from petroleum to biology. While most of the existing data is stored and maintained in traditional databases there is a need for transformation of data from the database to represent them as XML views. The issues which are important are (a) how to convert data from a flat relational database into hierarchical and semi-structured XML data and vice-versa (b) how to reflect updates on the XML view in the databases and vice-versa. Hence, the problem of creating XML views from the Relational model and updating relational databases through XML views has become a primal issue and the center of attention for the research community. The aim of this paper is complete automation to create XML views of the relational database using the XML schema and the Database schema as input. A one to one mapping is defined between the data in the database and the XML; the relation between data is maintained. The paper provides a novel approach for updating the relational database based on the changes in the XML document with the help of XML change detection tools. The changes in XML provided by the change detection tool are converted into SQL queries to update the database.

##plugins.themes.academic_pro.article.details##

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite
Sanjay K. Madria, & Janarthanan Eindhal. (2010). Dynamic XML View Creation And Update Propogation Using Relational Database. International Journal of Next-Generation Computing, 1(2), 168–192. https://doi.org/10.47164/ijngc.v1i2.18
Crossref
Scopus
Google Scholar
Europe PMC

References

  1. A. Deutsch, M. Fernandez, D. Florescu,A. Levy and D. Suciu 1999. XML-QL: A Query Language for XML. In Proceedings of the International World Wide Web (WWW) Conference, Toronto, May 1999.
  2. A. Gupta and I. S. Mumick, eds., 1999. Materialized Views: Techniques, Implementations and Applications, MIT Press, 1999.
  3. Antonio Badia. Ecient Creation and Maintenance of XML Views on Relational Databases.
  4. Apache Software Foundation. 2002. Apache Xindice. 2002. http://xml.apache.org/xindice/.
  5. Bohannon, P., Ganguly, S. ,Korth, H. ,Narayan, P. and Shenoy, P. 2002. Optimizing view queries in ROLEX to support navigable result trees. In VLDB. Hong Kong, China.
  6. Braganholo, Vanessa P., Davidson , Susan B., Heuser and Carlos A 2006. A Framework to Allow Updates Through XML Views. ACM Transactions on Database Systems, vol. 31, no. 3, pp. 839-886, Sept. 2006
  7. Braganholo, V., Davidson,S. B. and Heuser, C. A 2003. UXQuery: building updatable XML views over relational databases. In Simposio Brasileiro de Banco de Dados, SBBD. Belo Horizonte: Departamento de Ciencia da Computacao/UFMG, Manaus, AM, Brasil, 26-40, 2003.
  8. I. Tatarinov , Z. G. Ives , A. Y. Halevy and D. S. Weld 2001. Updating XML. In Proc. of SIGMOD Conference, 2001.
  9. J. McHugh , S. Abiteboul,R. Goldman,D. Quass and Widom. 1997. Lore: A database management system for semistructured data. SIGMOD Record, 54 - 66, September 1997.
  10. J. Shanmugasundaram, E. Shekita,R. Barr,M. Carey,B. Lindsay,H. Pirahesh and B. Reinwald 2000.
  11. Eciently Publishing Relational Data as XML Documents, In Proceedings of the VLDB Conference, Egypt, September 2000.
  12. M. Carey , D. Florescu ,Z. Ives,Y. Lu,J. Shanmugasundaram,E. Shekita, and S. subramanian 2000. XPERANTO: publishing object-relational data as XML. Distributed and Parallel Databases 19(2-3).,67-86.
  13. M. F. Fernandez , W. C. Tan, and D. Suciu 2000. SilkRoute: Trading Between Relations and XML. In 9th International World Wide Web Conference (WWW), May 2000.
  14. Microsoft Corporation. Reducing network trac in unstructured P2P systems using top-k queries. http://msdn2.microsoft.com//ru-ru/library/ms172063.aspx M. Scholl , S. Abiteboul ,F. Bancilhon,N. Bidoit,S. Gamerman ,D. Plateau ,P. Richard and A. Verroust 1987. VERSO: A Database Machine Based On Nested Relations, Nested Relations and Complex Objects, Germany, April 1987.
  15. P. Dadam , K. Kuespert,F. Andersen ,H. Blanken ,R. Erbe ,J. Guenauer ,V. Lum ,P. Pistor , and . Walch 1986. A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies, In Proceedings of the ACM SIGMOD Conference on the Management of Data, Washington D.C., May 1986.
  16. S Ablteboul and N Bldort Non First Normal Form Relatlons to Represent Hlerarchlcally Organized Data, In Proceedings of Third ACM SIGACT-SIGMOD Sympoamm on Prmclples of Database Systems, 1984, 191-200.
  17. Sathya Sundaram 2005. XRel Change SQL: A Change Detection System for Unordered XML Documents, MS Thesis, University of Missouri - Rolla, Aug 2005.
  18. S. Banerjee, V. Krishnamurthy,M. Krishnaprasad and R. Murthy 2000. Oracle8i - The XML Enabled Data Management System. In Proceedings of the International Conference on Data Engineering (ICDE), California, March 2000.
  19. Shanmugasundaram, J., Kiernan, J. ,Shekita, E. ,Fan, C. and Funderburk, J. 2001. Querying XML views of relational data. In VLDB. Roma, Italy.
  20. Software AG. 2002. Tamino XML server. 2002. http://www.softwareag.com/corporate/products/tamino/default.asp
  21. U. Dayal and P. A. Bernstein 1982. On The Correct Translation Of Update Operations on Relational Views. In ACM Transactions on Database Systems, 1982.
  22. Vittori, C. , Dorneles, C., and Heuser, C. 2001. Creating xml documents from relational data sources. In Proceedings of EC-Web 2001, Munich, Germany, Sept. 2001, pp. 60-70.
  23. World Wide Web Consortium (W3C),. Extensible Markup Language (XML) 1.0 (2nd edition), W3C Recom- mendation, October 2000. http://www.w3.org/TR/2000/REC-xml-20001006.
  24. Xiaolei Qian and Gio Wiederhold 1991. Incremental Recomputation of Active Relational Expressions, TKDE, 3(3), Sept. 1991.
  25. Yoshifumi Masunaga1984. A Relational database view update translation mechanism. In proceedings of the Tenth International Conference on Very Large Databases (VLDB), Singapore, 1984.
  26. Yoshikawa M., Amagasa, T., Shimura, T. and Uemura, S. 2006. Xrel: A path-based approach to storage and retrieval of xml documents using relational databases. ACM Transactions on Internet Technology 1, 2001, 110-141.