Transformation of XML document into a relational database
Loading...
Date
2013
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
The transformation from XML to relational database is very important technique in processing
data; one common reason for transforming is that existing SQL applications might still require
access to the data in relational format. For example, legacy applications, packaged business
applications, or reporting software do not always understand XML and have fixed relational
interfaces. Therefore you might sometimes find it useful to share all or some of the data values of
an incoming XML document into rows and columns of relational tables.
In our work the first step was creating classes to analyze if the XML (with DTD or simple)
document is valid, the second step is checking the prolog, and the tags. After that, checking SQL
errors process must started. If no errors occurred, a relational database is generated from the XML
document.
The developed application could just detecting errors, showing simple messages. As a future
work we propose that those errors will be treated in order to help users having more ability when
they use this application.
Besides this we have mentioned that we have used the DTD as grammar for XML document. As
a perspective , our application can be ameliorated to manipulate XML schema in the place of DTD.
Description
Keywords
Transformation,XML document,relational database .