Ontology-based Data Integration Methods And Applications

With the development of computer technology, especially the rapid development of network technology, E-commerce, ERP, VPN, virtual……these former IT "new favorite" have been continuously implant vigor and vitality into the enterprise information during 20 years. But it is precisely because the development stage of enterprise information, and the lack of a unified information management program, Invoicing management systems, financial management systems and office automation systems, a wide variety of information systems will also run on different hardware and software enterprise platform, That is, existing enterprise application systems are decentralized, heterogeneous, and closed systems, mutual information sharing can not be completed, forming a one "information islands." Along with the development of the process of enterprise internationalization, as well as business-to-ever-increasing demands of scientific management, horizontal between the various departments of enterprises increasingly need good communication in order to coordinate efforts and provide work efficiency, vertical businesses and between partners is also growing need for information exchange, information integration, has become a pressing requirement.To solve business "information islands" problem, the current method is EAI. EAI is mainly through the establishment of the underlying structures, to contact and across the entire enterprise heterogeneous systems, applications, data sources and so on, to achieve the enterprise's internal ERP, CRM, SCM, data warehouses, and other important internal systems of the sharing and exchange of data needs. Through integration and optimization of the different applications and different business units, the business process integration has been achieved in the enterprise-wide or in the context of the entire supply chain. EAI includes more complex contents, involving architecture, hardware, software and other processes at all levels of enterprise systems, is divided into business integration, application integration, data integration, platform integration and so on. Taking into account China's current domestic small and medium enterprises are more and more limited financial circumstances, in order to further improve the business degree of automation, data sharing and interaction, must find a cheap and effective way of information integration.In the actual context of enterprise applications, with the idea of ontology and the popular variety of data integration, this article proposes data integration methods based on the ontology. And adopt the more popular current Web Service technology, combined with the needs of enterprise data integration, to integrate various heterogeneous enterprises data sources effectively. The program is based on the form of XML structured data, to do the simple packaging of the original data source, change the original data format into XML format, in order to identify and extract all the various heterogeneous data sources. This article uses the ontological thinking in the realization, to build ontology library for achieving the mapping between modes, In this paper, the overall uses Xquery query language, Meanwhile, in order to improve query efficiency, to reduce the number of accessing the data sources, For the Global View proposes a semantic caching method, in the system adds an XML database as the cache, At the same time establishes a corresponding cache to build and update mechanism, Thus effectively reducing the number of accessing the data sources, To achieve high efficiency of the heterogeneous data source query.Finally, this program has been realized in Shandong Sino-Thai Sunshine Electric Technology Co., Ltd. CRM system, completing the data sharing and interacting between this system and the original enterprises application system. The system has been put into use, achieving the data sharing of the heterogeneous applications, eliminating the "information island", reducing the workload of the company's staff, ensuring internal information consistency and accuracy and has made a very good application effect.