Research And Application On Integration Technology Of Heterogeneous Databases In Campus One-Card-Through System

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. In addition, each branch offices and its cooperators are distributed at different geographic location with characteristic of regional dispersibility. So there are differences with different degree for these systems concerning physics and logic. However, the users need the possibility of accessing the multi intrinsic database systems pellucidly through network. How to realized the connectivity among the autonomous heterogeneous distributed databases and to attain resource sharing and distributed coordinate processing, a problem concerning the realization of heterogeneous database integration is come forth. 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 Hubei Economics College as the background. Aiming at the problem mentioned above, lots of related technical data at home and abroad has been referenced, and many former heterogeneous databases integrated or interconnected systems have been analyzed. The principle for designing heterogeneous databases integrated system is brought forward in this paper, in addition the architecture of system. Three-layers system structure based on middleware is adopted with the system to resolve the problem, and distributed object technology CORBA is adopted for the middleware that is used as supporting environment of the system. Such an integrate system with adoption of technology based on CORBA could improve manageability, maintainability and integrateability of the system greatly.