Browse > Article

An Efficient Transformation Technique from Relational Schema to Redundancy Free XML Schema  

Cho, Jung-Gil (성결대학교 컴퓨터공학부)
Publication Information
Journal of Internet Computing and Services / v.11, no.6, 2010 , pp. 123-133 More about this Journal
Abstract
XML has been become the new standard for publishing and exchanging data on the Web. However, most business data is still stored and maintained in relational database management systems. As such, there is an increasing need to efficiently publish relational data as XML data for Internet-based applications. The most important issue in the transformation is to reflect structural and semantic relations of RDB to XML schema exactly. Most transformation approaches have been done to resolve the issue, but those methods have several problems. In this paper, we discuss algorithm in transforming a relational database schema into corresponding XML schema in XML Schema. We aim to achieve not only explicit/implicit referential integrity relation information but also high level of nested structure while introducing no data redundancy for the transformed XML schema. To achieve these goals, we propose a transformation model which is redundancy free and then we improve the XML Schema structure by exploring more nested structure.
Keywords
Transformation; Relational schema; XML; XML schema; XML Schema; Referential Integrity;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 D. Lee, M. Mani, F. Chiu, and W. Chu. Nesting-based relational-to-xml schema translation. In Proceedings of the WebDB, pages 61-66, 2001.
2 J. Kim, D. Jeong, D. Baik, "A Translation Algorithm for Effective RDB-to-XML Schema Conversion Considering Referential Integrity Information", JISE, Vol.25, No.1 pp.137-166, January 2009.
3 J. Kim, D. Jeong, and D. Baik, "Query Pattern-based Relational Data to XML Data Translation Algorithm," Journal if Computer Science 3(4):212-217, 2007.   DOI
4 D. Lee, M. Mani, F. Chiu, and W. W. Chu, "Net&CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints", CIKM, McLean, VA, USA, November, 2002.
5 C. Liu, and J. Liu, "On Transformation to Redundancy Free XML Schema from relational Databases Schema", LNCS 2642 - APWeb, pp.35-46, Xi'an, China, 2003.
6 김진형, 정동원, 백두권, "묵시적 참조 무결성을 고려한 관계형 스키마 모델의 XML 스키마 모델 변환 알고리즘," 한국정보과학회, 정보과학회논문지: 데이타베이스, 제 33권, 제 5호, pp. 526-537, 2006년 10월   과학기술학회마을
7 M. Carey, D. Floirescu, Z. Ives, Y. Lu, J. Shanmugasundaram, E. Shekita, and S. Subramanian. "XPERANTO: Publishing Object- Relational Data as XML", WebDB, pp.105-110, May, 2000.
8 C. Liu, J. Liu, and M. Guo, "Accessing Relational Databases via XML Schema", CAiSE'03 Forum, Klagenfurt/Velden, Austria, pp.17-20, June 2003.
9 V. Turau, "Making Legacy Data Accessible for XML Applications",. http://www.informatik. fhwiesbaden.de/~tarau/veroeff.html, 1999.
10 C. Liu, M. Vincent and J. Liu, "Constraint preserving transformation from relational schema to XML schema", World Wide Web Journal, vol.9, No.1, pp.93-110, 2006.   DOI   ScienceOn
11 M. Fernandez, W. Tab, and D. Suciu, "SilkRoute: Trading between relations and XML", In Proceedings of WWW, pp. 723-745, 2000.
12 A. C. Duta, K. Barker, R. Alhajj, "ConvRel: Relationship Conversion to XML Nested Structures", SAC 2004, Nicosia, Cyprus, March 14-17, 2004.
13 조정길, "함수적 종속성을 반영한 XML 문서의 관계형 스키마 매핑 기법", 한국인터넷정보학회논문지, 제8권, 제2호, pp.95-103, 2007.   과학기술학회마을
14 W. Fan and J. Simeon, "Integrity Constraints for XML", Journal of Computer Systems Sciences, Vol. 66, pp.254-291, 2003.   DOI   ScienceOn
15 World_Wide Web Consortium, "XML Schema Part1:Structures", W3C Recomendation, http://www.w3.org/TR/xmlschema-1, 2004.
16 C. Baru, "XViews: XML views of relational schemas", In Proceedings of DEXA Workshop, pp. 700-705, 1999.