Semantics-based Relational Schema To Xml Schema Conversion Methods Research

As a standard of exchanging data on the Web, XML has gradually become one of the best intermediates for sharing and changing data with its advantages such as expansibility, self-description and separation of content and display. It's very important to research the technology of translating relational data to XML document for translation and integration of heterogeneous database as well as for data publication.To translate relational schema to XML schema, most of methods can't remain intrinsic semantic information of relational database. This paper presents a semantic-based translating algorithm through denormalization. Relational schema is mapped to relational chart. Associated tables are joined according to the classify and an XML schema is created for every joined table and disjoined table. All schemas are integrated into one. Experiments show that the algorithm is valid and efficient for keeping semantic restriction and strengthening coupling. This paper presents another semantic-based translating algorithm through ER model. Relational schema is mapped to categorized tables. According to the tables ER model of the database is restituted , through which an XML-Schema graph is created. XML schemas are based on the graph. Experiments show that the algorithm is valid and efficient for keeping semantic restriction and strengthening coupling, especially for 1:1,1:n,m:n cardinality.During the data translation semantic conflict commomly includes structure conflict and conception conflict. The architecture of ontology based translation from relational data to XML data is presented to resolve data semantic conflict.