Design And Implementation Of MES Material Management Data Integration System Based On Multi-source Heterogeneous

With the rapid development of modern information technology,informational and intelligent data recording and processing methods are gradually replacing the traditional manual data recording and processing methods.In the information system network,the database has become a unified data storage center,providing necessary data support for system development managers.In the process of building information system,database type should be selected reasonably according to the actual situation of enterprise system requirements,so as to meet the data sharing needs of system development managers.However,the heterogeneity of database will hinder the smooth sharing of data.Therefore,it is necessary to design a data synchronization system to solve the adverse impact of heterogeneity of database,ensure the sharing function of database,and ensure the relevance and consistency of database data information.In this way,it can not only guarantee the independent storage and high sharing of data,but also promote the continuous improvement of system efficiency.The heterogeneous database synchronization system designed in this paper fully considers the requirements of enterprise data management and database management of enterprise subsystems,including the requirements of material inventory information management and personnel information management,etc.It ensures the synchronous sharing of enterprise material management system data and enterprise subsystem data,and provides necessary data support for managers.In this system,the data source information is stored uniformly according to the XML file fonnat to avoid the influence of the normal data extraction due to the non-standard data storage format.Unlike other similar studies,this study uses MyCAT and Navicat Premium,a data management tool,to read,search and integrate the data in the associated data tables,and automatically complete the generation of XML data documents.Based on XML and data source relational mapping,it determines the target database that needs to load new data,and then through SQL statements.Resolve and complete the DML operation of the target table.MyCAT and Navicat Premium play a role as a link in the process of ensuring the synchronous sharing of the system database,resolving the conflict of heterogeneity of the database,improving the extended function and generality of the system,and making the value of the database fully exerted.Based on Java development language,basic process of database establishment,basic requirement of data synchronization and system design requirement,this system formulates the overall development plan of the system,ensures the synchronous sharing of database,and designs and arranges the functions of each module of the system in detail.The whole system is based on Java,front-end and database technology,aiming at facilitating the development and programming of system developers.It can flexibly guarantee the precise design of the functions of each module of the system,provide convenience for users to store and search data,and ensure that users can access different databases smoothly and manage and query data.Finally,according to the requirement of data synchronization in heterogeneous database of an enterprise information system,this paper tests the functions of the developed system in an all-round way to ensure that the system can achieve the desired results,and verifies the feasibility of the system design.Through detailed testing,the realization of each module function of the system is understood.Based on the test data information,the overall performance of the system is optimized,and the operation efficiency of the system is improved.The test results show that the design of heterogeneous database synchronization system makes the data among multiple databases share synchronously,which is consistent with the expected system design goals.