Converting relational database into XML document

Abstract

XML (eXtensible Markup Language) has emerged and is gradually being accepted as the standard for data interchange in the Internet world. XML databases are packaged by the key relational database vendors in the market as the extender or cartridge to the relational database management system. Interoperation of relational database and XML database involves schema and data translations. The paper provides a methodology of translating the conceptual schema of a relational database into XML schema through EER (extended entity relationship) model. Physical data are then translated from relational table to XML document. The semantics of the relational database, captured in EER diagram, are mapped to XML schema using stepwise procedures. The physical data are then mapped to an XML document under the definitions of the XML schema.