XML与数据库交互技术的研究及实现

Research and Implementation of the Exchange Technology Between XML and Database

通过对XML的数据存取机制和XML与数据库的映射技术的分析和研究,提出了XML与数据库进行数据交换的设计方案.通过ADO.NET实现对数据库系统的连接,在Web服务器与数据库之间建立一个数据业务接口,实现数据库中数据到XML文档和XML文档到数据库中表数据的转换.数据库与外界之间都以XML文档作为交换介质,屏蔽了所有数据库有关的技术细节,同时使系统的可扩展性更好.本文对异构数据源的数据交换有通用的参考和指导意义.

On the basis of the analysis and research of XML data access mechanism and the mapping technology of XML and database, the design plan of the data exchange between XML and database is proposed. And the transformation of the data to XML file and vice versa is implemented by establishing a data service interface between Web server and the data base based on the connection of the database system on ADO. NET. Then XMI. file is taken as the exchange medium between the database and outside, so all the related detailed technology has been shielded and the system has better extendibility. Thus the paper has the general reference and guiding significance to the data exchange of isomeric data source.