College Student Records Management System Based On Distributed Database Design And Implementation

College students file management system is the main content of the university information construction,for the management of all kinds of affairs related to students,to improve the efficiency of teaching has an important role.Along with the advance of reform in Colleges and universities with optimization,the same universities often include multiple campuses,traditional centralized student management system management model has been unable to meet the demand for use,must construct college students' archives management system based on distributed database.In theory,the system of centralized management of students' archives exist in the management of multi campus students in the archives of high data redundancy,low efficiency of query problem,put forward the construction of student archives management system based on data platform using distributed database technology,distributed database has the advantages of high reliability,high efficiency operation,solves the key problems of students.The file management system in the development process mainly includes: in the field of data inquiry,put forward the scheme of distributed data query based on genetic algorithm,the optimization of the query process,improve query efficiency;using the genetic algorithm of data distribution to solve the problem of distributed database,the database nodes are divided into clusters of different campuses,through the establishment of fitness function the total operation cost calculation,data distribution in different clusters on the final The optimal allocation scheme of data;using XML technology and Web Service technology,for the realization of data update operation,obtain a copy of stored data samples through global data dictionary location to update data and distributed database nodes related parameters,call the Web Service,to achieve synchronous update of distributed database.In practice,according to the design scheme of the management platform of college students file management system,the system construction is realized by using SSH architecture.By analyzing the function and performance requirements of the system,the functional architecture,logical structure and physical deployment framework of student's file management information system are established.Using Java language,the main function modules of the system are realized in the integrated development environment,and the supporting function of the distributed database system for the application of the student file management system is analyzed.Finally,experiments show that the system function and performance index can meet the actual demand.College students file management system to make full use of the platform of the powerful data management capabilities,improve the efficiency of student file management,for the multi campus and many colleges and universities,the higher application value.At the same time,the system optimizes the query process of the distributed database,and puts forward the optimization algorithm of the data distribution scheme,which has certain theoretical significance and application value.