Application Research Of Heterogeneous ERP Database Integration In Network Auditing

The rapid development of the E-commerce-based network economy and network financial will lead to the emergence of network auditing. Due to the ERP system used in the enterprise are different, heterogeneous ERP data sources integration with heterogeneous platforms and data is the essential problem of implementation the network auditing.This paper analyzes and studies the traditional heterogeneous data integration technology and network auditing feature, presents an virtual heterogeneous ERP data source integration framework ERP-DSIF based on XML, analyzes and designs modules of this framework and gives scheme of main modules. ERP-DSIF based on Wrapper/Mediator method used Web Services technology to realize communication between the internal modules. It create a data sharing model, through making mapping between different patterns by XML Schema, and form a global virtual view, which shields data source isomerism, preserves autonomy of data source, provides a unified data interface for system users. In system data processing, design query decomposition method and algorithm by XQuery's standardization rewriting. System query data in many ERP data source and combine result after decompose query and transform pattern automatically, which assure get result data newly.ERP-DSIF has realized the ERP data source high autonomy. ERP-DSIF use Web Service and SOAP technology to solve the problem of system communication that make the system has have the good extension and the high flexibility. ERP-DSIF model system verified the practicability of the ERP-DSIF.