XML的数据处理技术在ERP中的使用

Realization and Application of Data Exchange Technology Based on XML in ERP System

由于XML自身的特点，它非常适合作为异构数据源之间数据转换的中介。本系统集成中采用XML作为数据转搀的中介．实现了不同数据库之间的数据转换，并且实现了XML文档与关系数据库之间数据相互转换的构件。提高了ERP系统的可扩展性、灵活性和可维护性。该文分析了ERP系统中数据转换的基本需求，结合面向对象的方法和构件技术．设计并实现了基于XML的通用数据转换系统。本文总结了在实施ERP系统的实践中所使用的技术，提出了用标准XML模式作为交换单据的数据标识：详细描述了关系模式与XML模式之间映射的转换脚本：讨论了XML文档与关系数据库之间相互转换的数据转换构件的设计和实现接口：并基于DOM解析器，详细介绍了数据库转换构件中的数据转换的算法。在具体的使用过程中，只要对每种单据都生成一份简单直观的转换脚本，并调用数据转换构件的接口，就可以非常容易地提取（或存储）带有层次关系的XML文档。

This article analyses the primary demand of data exchange in ERP, combined with the mothod of object-oriented and component technique, it designs and realizes the system of universal data exchange based on XML. This article summarizes the technologies which are used in the practice of emplifing ERP system, and brings up that use normal XML mode as DID of exchange voucher; and describes the transform script of mapping between relational mode and XML mode in detail; it discusses the design of data exchange component and realizing joint of the exchange between XML document and RDB; and it presents how to count the data exchange in database exchange unit on the base of DOM resolver. As long as creates a simple and visual exchange sript to every kind of voucher and invokes the interface of data exchange unit during use, it will be very easy to extract（or storage） XML document with LEV relation.