Converting relational database into XML document

Author

Fong, Joseph ; Pang, Francis ; Bloor, Chris

Author_Institution

Dept. of Comput. Sci., City Univ. of Hong Kong, China

fYear

2001

fDate

2001

Firstpage

61

Lastpage

65

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

Keywords

Internet; electronic data interchange; entity-relationship modelling; hypermedia markup languages; relational databases; EER diagram; Internet; XML databases; XML document; XML schema; XML standard; conceptual schema; data interchange; data translations; eXtensible Markup Language; extended entity relationship model; physical data; relational database; relational database conversion; relational database management system; relational database vendors; relational table; schema translations; stepwise procedures; Computer science; Data engineering; Data mining; Internet; Object oriented databases; Object oriented modeling; Packaging; Relational databases; Reverse engineering; XML;

fLanguage

English

Publisher

ieee

Conference_Titel

Database and Expert Systems Applications, 2001. Proceedings. 12th International Workshop on

Conference_Location

Munich

Print_ISBN

0-7695-1230-5

Type

conf

DOI

10.1109/DEXA.2001.953042

Filename

953042