Content area
Full Text
Abstract
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.
(ProQuest: ... denotes formulae omitted.)
1.Introduction
XML (Extensible Markup Language) is a markup language that defines a set of rules for Encoding documents in a format that is both human-readable and machine readable. XML has been widely accepted as a data format standard for information exchange and storage with the rapid development of internet and web services. It is defined in the XML 1.0 Specification produced by the W3C. The design goals of XML emphasize simplicity, generality and usability over the internet [14]. Significance of the XML is XML seen as a universal, open, readable representation for software integration and data exchange [16].
A Relational database is a means of storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns. A table is referred to as a relation in the sense that it is a collection of objects of the same type (rows). Data in a table can be related according to common keys or concepts, and the ability to retrieve related data from a table is the basis for the term relational database. A Database Management System (DBMS) handles the way data is stored, with constraints, maintained, and retrieved. In the...