Data Conversions Between Relational Database And XML Document

Abstract

XML and relational databases are two of the most important mechanisms for storing and transferring data. A reliable and flexible way of moving data between them is very desirable goal. This paper includes comparison of concepts available in RDBS and XML to bridge the gap of their integration.In this paper, source relational database is converted into XML document with XSD schema by using RDBToXML algorithm and XMLToRDB algorithm inserts data of XML document with XSD schema into target relational database. This paper verifies the correct data transfer by dual accuracy measures: Data Soundness and Data Completeness of transformation-based checks.