Home   >   CSC-OpenAccess Library   >    Manuscript Information
Full Text Available

(149.25KB)
This is an Open Access publication published under CSC-OpenAccess Policy.
Publications from CSC-OpenAccess Library are being accessed from over 74 countries worldwide.
Catalog-based Conversion from Relational Database into XML Schema (XSD)
Husam Ahmed Al Hamad
Pages - 9 - 22     |    Revised - 31-07-2015     |    Published - 31-08-2015
Volume - 6   Issue - 2    |    Publication Date - July / August 2015  Table of Contents
MORE INFORMATION
KEYWORDS
Conversion Relational Schema into XML Schema, Transformation Schema, XSD Schema, XML Schema.
ABSTRACT
Where we are in the age of information revolution, exchange information, and transport data effectively among various sectors of government, commercial, service and industrial, etc., the uses of a new databases model to support this trend has become very important because inability of traditional databases models to support it. eXtensible Markup Language (XML) considers a new standard model for data interchange through internet and mobiles devices networks, it has become a common language to exchange and share the data of traditional models in easy and inexpensive ways. In this research, we propose a new technique to convert the relational database contents and schema into XML schema (XSD- XML Schema Definition), the main idea of the technique is extracting relational database catalog using Structured Query Language (SQL). We follow three steps to complete the conversion process. First, extracting relation instance (actual content) and schema catalog using SQL query language, which consider the required information to implement XML document and its schema. Second, transform the actual content into XML document tree. The idea of this step is converting table columns of the relations (tables) into the elements of XML document. Third, transform schema catalog into XML schema for describing the structure of the XML document. To do so, we transform datatype of the elements and the variant data constrains such as data length, not null, check and default, moreover define primary foreign keys and the referential integrity between the tables. Overall results of the technique are very promise while the technique is very clear and does not require complex procedures that could adversely effect on the results accuracy. We performed many experiments and report their elapsed CPU times.
1 Google Scholar 
2 CiteSeerX 
3 refSeek 
4 Scribd 
5 SlideShare 
6 PdfSR 
1 Silberschatz, A., Korth, H. F., Sudarshan, S. "Database System Concepts", McGraw-Hill, Sixth Edition, 2010, pp. 981-1025.
2 Arenas, M, Barcelo, P., Libkin, L., Synthesis FM. "Relational and XML Data Exchange", Vol. 2, No. 1, 2010, pp.1-112.
3 Jumaa, H., Rubel, P., Fayn, J. "An XML-based framework for automating data exchange in healthcare", e-Health Networking Applications and Services (Healthcom), 12th IEEE International Conference, 1-3 July 2010, pp.26124-269.
4 Al Hamad, H.A. (2015) "XML-Based Data Exchange in the Heterogeneous Databases (XDEHD)", International Journal of Web & Semantic Technology (IJWesT), Vol. 6, No. 3, 2015, pp.11-24.
5 Shanmugasundaram J., Tufte K., He G., Zhang C., DeWitt D., J. Naughton. "Relational Databases for Querying XML Documents: Limitations and Opportunities", Proceedings of the 25th VLDB Conference, Edinburgh, Scotland, 1999, pp.302314.
6 Feng, Y and Jingsheng, X. "Mapping XML DTD to Relational Schema", Database Technology and Applications, First International Workshop, 25-26 April 2009, pp.557-560.
7 Chunyan, W.; Lo, A.; Alhajj, R.; Barker, K. "Novel Approach for Reengineering Relational Databases into XML", Data Engineering Workshops, 21st International Conference, 05-08 April 2005, pp. 1284.
8 Teng, L. and Ping, Y. "Schema Conversion from Relation to XML with Semantic Constraints", Fuzzy Systems and Knowledge Discovery, FSKD 2007. Fourth International Conference, 24-27 Aug. 2007, pp.619-623.
9 Zhang, Y. and Liu, W. "Semantic integration of XML Schema", Machine Learning and Cybernetics, Proceedings. 2002 International Conference, pp. 1058- 1061.
10 Tzvetkov, V. and Xiong W. (2005) "DBXML - Connecting XML with Relational Databases", Computer and Information Technology, CIT 2005. The Fifth International Conference, 21-23 Sept. 2005, pp.130-135.
11 Hong, S. and Song, Y. "Efficient XML query using Relational Data Model", Software Engineering, Artificial Intelligence, Networking, and Parallel/Distributed Computing, SNPD 2007. Eighth ACIS International Conference, July 30 2007-Aug. 1 2007, pp.1095-1100.
12 Feng, Y. "Converting XML DTD to Database", Intelligent Systems and Applications, ISA 2009. International Workshop, 23-24 May 2009, pp.1-4.
13 Fong, J., Wonga, H.K., Chengb, Z. "Converting relational database into XML documents with DOM", Information and Software Technology, Vol. 45, 2003, pp.335 355.
14 Zhou, A., Lu, H., Zheng, S., Liang, Y., Zhang, L., W. Ji, Tian, Z., "VXMLR: a visual XMLrelational database system", Proceedings of the 27th International Conference on Very Large Data Bases, September 11-14, 2001, pp.719-720.
Dr. Husam Ahmed Al Hamad
Department of Information Technology, College of Computer, Qassim University, Qassim, Saudi Arabia - Saudi Arabia
hushamad@yahoo.com