Converting Relational Database Into Xml Document
XML (Extensible Markup Language) is
emerging and gradually accepted as the standard for data
interchange in the Internet world. Interoperation of relational
database and XML database involves schema and data
translations. Through EER (extended entity relationship) model
can convert the schema of relational database into XML. The
semantics of the relational database, captured in EER diagram,
are mapped to XML schema using stepwise procedures and
mapped to XML document under the definitions of the XML
schema.
Converting Relational Database into XML Document
is a process of converting the existing databases into XML file
format. Existing conversion techniques convert a single database
into xml. The proposed approach performs the conversion of
databases like Ms-Access, MS-SQL to XML file format. Read
the tables information from the corresponding database and
generate code for the appropriate databases and convert the
tables into XML flat file format. This converted XML file is
been presented to the user.
Keywords: Relational Schema, XML Schema, SQL, EER, Conversion, Encoding
Download Full-Text
ABOUT THE AUTHORS
Kanagaraj.S
Master of Computer Application, Adhiyamaan College of Engineering Hosur, Tamilnadu-635109, India.
Sunitha Abburu
Professor and Director, Department of Computer Application, Adhiyamaan College of Engineering Hosur, Tamilnadu-635109, India.
Kanagaraj.S
Master of Computer Application, Adhiyamaan College of Engineering Hosur, Tamilnadu-635109, India.
Sunitha Abburu
Professor and Director, Department of Computer Application, Adhiyamaan College of Engineering Hosur, Tamilnadu-635109, India.