Research Article

An Algorithm for Mapping ER Schema in to XML DTD with Recursion

by  Pushpa Suri, Divyesh Sharma
journal cover
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 136 - Issue 10
Published: February 2016
Authors: Pushpa Suri, Divyesh Sharma
10.5120/ijca2016908584
PDF

Pushpa Suri, Divyesh Sharma . An Algorithm for Mapping ER Schema in to XML DTD with Recursion. International Journal of Computer Applications. 136, 10 (February 2016), 16-17. DOI=10.5120/ijca2016908584

                        @article{ 10.5120/ijca2016908584,
                        author  = { Pushpa Suri,Divyesh Sharma },
                        title   = { An Algorithm for Mapping ER Schema in to XML DTD with Recursion },
                        journal = { International Journal of Computer Applications },
                        year    = { 2016 },
                        volume  = { 136 },
                        number  = { 10 },
                        pages   = { 16-17 },
                        doi     = { 10.5120/ijca2016908584 },
                        publisher = { Foundation of Computer Science (FCS), NY, USA }
                        }
                        %0 Journal Article
                        %D 2016
                        %A Pushpa Suri
                        %A Divyesh Sharma
                        %T An Algorithm for Mapping ER Schema in to XML DTD with Recursion%T 
                        %J International Journal of Computer Applications
                        %V 136
                        %N 10
                        %P 16-17
                        %R 10.5120/ijca2016908584
                        %I Foundation of Computer Science (FCS), NY, USA
Abstract

XML has emerged as a standard for data exchange over the internet.Relational databases provides a mature technology to store these documents. In this paper we transform ER diagram of relational databases in to DTD of XML documents. We provide an algorithm that translates ER diagram with cycles in to recursive DTDs.This algorithim translates each component of ER diagram in to components of DTDs along with cycles in ER diagram to generate recursive DTD’s

References
  • Lee, D., Mani, M.,Chiu .F ,Chu, W 2002,. Net & CoT : Translating relational schema in to XML schema using semantic constraints. ., Proc of CIKM ,pages 282-291.
  • Kliener C.,Lipeck U. ,2001. Automatic generation of XML DTD’S From Conceptual Database Schema.”Web Databases” Work shop of the annual conference of the German and Austrian Computer Soceities in Vienna.
  • Li Zhou, Jue Wang , 2010 , A Method for exporting Relational Schema in to Document tye Dfination , IEEE.
  • Nasir M , Ibrahim H , 2007 , Genererated Nested XML DTD From non normalized Relational Views , IJCSNS.
  • F Laforest , M.Boumediene 2007 , Automatic Construction of XML Documents Models from a relational data models . IEEE.
  • J.Shanmugasundaram, K. Tufte, C. Zhang, G.He, D. Dewitt,J.Naughton, 1999 ,Relational Databases for Querying XML Documents:Limitations and opportunities,VLDB ,pp : 302-314.
  • M. Atay, A Chebotko, D. L iu, S. Lu, F. Fotoubi , 2005 ,Efficient schema based XML to relational data mapping, Information systems ,Elesevier .
  • S.Lu,Y. Sun, M.Atay,F. Fotouhi, 2003. A New inlining algorithim for mapping XML DTDS to relational schema” In Proceedings of the First International Work-shop on XML Schema and Data Management , in conjuction with the 22nd ACM International Conference on Conceptual Modeling , Chicago, IL.
  • M. YoshiKawa.,T.Amagasa,T.Shtimura, 2001. XREL: A path based approach to storage and retrieval of XML documents using relational databases.ACM Transactions on Internet Technology,1(1) ,pp:110-141.
  • J. Qin, S.Zhao, S. Yang, W. Dau,2005 , XPEV : A Storage Approch for Well-Formed XML Documents, FKSD ,LNAI 3613, pp.360-369.
Index Terms
Computer Science
Information Sciences
No index terms available.
Keywords

XML DTD Relational Databases.

Powered by PhDFocusTM