Research on the Data Transformation Technology between XML and Relational Database
Liang Sun · Journal of Chongqing University of Science and Technology · 2010
According to the algorithm and model on data transformation of XML document,this paper analyzes a data transformation approach based on Element-Tree. In this approach,the DTD Element-Tree is used to describe the structure of an XML document,and the structure mapping between the XML document and the relational database data is built based on the Element-Tree,which is used to complete the data transformation. Then it develops an application system of the transformation between XML document and the relational database data based on the.NET,which adopts the Element-Tree approach. The system generates the Element-Tree of a DTD,and uses the mapping between XML document elements and columns in the database provided by the user to transform the XML document and data in the database.