CFP last date
20 January 2025
Reseach Article

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

by Pushpa Suri, Divyesh Sharma
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 136 - Number 10
Year of Publication: 2016
Authors: Pushpa Suri, Divyesh Sharma
10.5120/ijca2016908584

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 },
issue_date = { February 2016 },
volume = { 136 },
number = { 10 },
month = { February },
year = { 2016 },
issn = { 0975-8887 },
pages = { 16-17 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume136/number10/24188-2016908584/ },
doi = { 10.5120/ijca2016908584 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:36:43.158877+05:30
%A Pushpa Suri
%A Divyesh Sharma
%T An Algorithm for Mapping ER Schema in to XML DTD with Recursion
%J International Journal of Computer Applications
%@ 0975-8887
%V 136
%N 10
%P 16-17
%D 2016
%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
  1. 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.
  2. 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.
  3. Li Zhou, Jue Wang , 2010 , A Method for exporting Relational Schema in to Document tye Dfination , IEEE.
  4. Nasir M , Ibrahim H , 2007 , Genererated Nested XML DTD From non normalized Relational Views , IJCSNS.
  5. F Laforest , M.Boumediene 2007 , Automatic Construction of XML Documents Models from a relational data models . IEEE.
  6. 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.
  7. M. Atay, A Chebotko, D. L iu, S. Lu, F. Fotoubi , 2005 ,Efficient schema based XML to relational data mapping, Information systems ,Elesevier .
  8. 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.
  9. 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.
  10. 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

Keywords

XML DTD Relational Databases.