Mapping Of Xml Documents And Relational Database Based On The Xdr Model Study

With the widely use of the XML, the XML is becoming a huge data source. The Database can extract useful information from the XML document. At the same time, the data stored in the Database can be exchanged between the heterogeneous systems by transforming the data into XML formatted. On one hand, the XML has strong exchangeability but is weak in data management. On the other hand, the Database has intensive data management but weak exchangeability. Combining with the advantage of both the XML and the Database, the data can be exchanged easily and be managed efficiently. It' s a perfect data solution. The researches on the data exchange between the XML and the Database are getting more and more important.We establish an XMLmodel to describe the XML document. By comparing the similarities and differences between the XMLmodel and the ER model, we get some mapping principles about the exchange between XML document and the Relational Database. According to these principles, we set up a series of mapping algorithmic rules. To verify the correctness of the algorithmic rules, we establish an experimental application, choosing Java as the programming language. The system we founded transforms the data between the Relational Database and the XML by using the ODBC data source interface. In our experimental application, the data can be exchanged by ignoring the Relational Database platform. The experimental application also provides other two virtual Database platform. One is the virtual Relational Database based on the XML data, the other is the virtual XML Database based on the Relational data. The virtual Relational Database can display the XML document in a table form. And the virtual XML Database can display the Relational data in an XML form.In the first Chapter, we discuss the relative research work about the data exchange between the XML and the Relational Database, and analyze the Relational Database Management System people used nowadays. Via the analysis, we discover deficiencies in the work and in the DBMS, and then put forward a data solution. At the end of this chapter, we present an outline of our researches, and the innovation of our works. The second Chapter introduces some technical background information of our researches, such as the syntax of the XML and the XDR, and theprogramming interface of the XML. In the third Chapter, we establish an XMLmodelto describe the XML document and the XDR model. In the fourth Chapter, we set up a series of mapping algorithmic rules by analyzing the mapping principles from the XML document to the Relational Database. In the fifth Chapter, we set up a series of mapping algorithmic rules by analyzing the mapping principles from the Relational Database to the XML document. In the sixth Chapter, we present an experimental application, and verify the correctness of the mapping algorithmic rules putting forward in the forth and the fifth Chapters. At the end of this paper, we summarize our researches and works, then point out the deficiency of our researches and works.