University Laboratory Comprehensive Information Distributed Management System Based On Oracle

This disquisition discussed the Distributed Database Management System based on Oracle, and introduced the development of University Comprehensive Information Management System.With the up-to-date research achievements of Information Management System at home and abroad as a reference , use Distributed Database technique to develop Information Management System . University Laboratory Comprehensive Information Distributed Management System make good use of the characteristics of Distributed Database , collect the information distributed at universities all over the country through internal logical relationship , then achieve all-sided and accurate information. The Educational Department -, Provinces and Universities in charge of System Management . System architecture is Client/Server distributed model . Universities transmit information totheir own province education departments ,which act as a station in this System. When the Education Department wants to find out the information about university laboratory all over the country, they can acquire the information what it needs by way of collecting information distributed at different stations through their internal logical relationship.In the environment of Distributed Database , Data Fragmentation combines horizontal Data Fragmentation and vertical Data Fragmentation, reducing the transportation over the network, improving the efficiency of this system. In the development of Oracle Distributed Database System , make the use of snapshots database link view and synonym distributed database technique to realize the transparency of this system. Distributed storage and refresh can be realized through database link distributed transaction and Two-Phase Commitment Protocal-2PC. The development of this distributed database system makes data information can be shared, and make the information transportation easy. It can also provide leaders with reliable information ,which is more accurate and comprehensive than before. In addition, this system can reduce the work of people, improving the efficiency ,saving the expense.The development of University Laboratory Comprehensive Information Management System with the use of distributed database technique is very important ,having good social and economic value.