The Research Of Heterogeneous Database Integration And Application

With the continual development of computer network and database technology, a variety of database management system (DBMS) has been presented in succession. A large-scale enterprise usually has lots of branch offices and they may use different DBMS to manage data because of different key emphasis in work. So large numbers of information exchanges are wanted among different offices. There exist a variety of databases which are heterogeneous in that they store different types of data, represent data differently, use different software to manage the data and run on different computer hardware. With the farther development of business collaboration and government-affair electronical publishing, the information systems often requires access to data from multiple such databases. Therefore, a new system architecture is required to make the information sharing from many heterogeneous databases, in a transparent way, while preserving their autonomy.XML has a strong capacity of describing structural and semantic structural information; Data integration course has a better expansibility with the use of XML. XML has emerged as the dominant standard data exchange format for Internet-based business applications, the extensibility of XML allows the creation of generic models that integrate data from different sources. The key to realize integration of heterogeneous databases on XML is to establish a mapping approach. At present, There are two mapping approach on XML document. The one is based on template , the other is based on model. The two approaches exist some localization, the first one only supports mapping from relational databases to XML, the second has some restrict to XML document.This thesis begins with a compare on traditional approaches of heterogeneous databases integration. We analyzed the present algorithms and models on transformation of XML document and other format data, presented an approach based on DTD Element-tree. in the approach, the Element-tree is used the mapping between XML document and columns in the databases provided by the user quickly. In order to resolve query and sharing of associated data among the existing heterogeneous in school, bank and each branch office in school, this project attaches most importance to the application of database taking the item concerning One-Card-Through System in campus of Qiqihaer University as the background.