The Design And Implementation Of The Laboratory Information Management System Based On Database Optimization

This paper is the design and implementation of laboratory information management system based on database optimization. With the development of the technology of the Internet of things improving recent years, the implementation of the concept of smart campus promote greatly and the laboratory information management system proposed in this paper is an application of the concept of smart campus. Laboratory in the university is the main office place of graduate students, and graduate students are the backbone of the output of scientific research.What’s more,the number of graduate students in university is increasing with the expansion of the scale of higher education.Therefore,it is very important to improve the laboratory daily work and management efficiency. In this paper, the laboratory information management system is studied from two aspects: the system implementation and the performance optimization.First of all, based on the analysis of the characteristics of the laboratory in the university and combined with the shortcomings of the existing attendance management system on the market, we propose and implement the information management system with the function of attendance, information management, information dissemination etc.The combination of Android terminal and RFID RF module combination enhances user interaction and the Nginx server and Tomcat ensures the stable operation of the system, Android terminal and RFID RF module communicates with serial communication and the client and the server communicates through Http network communications.Secondly, we take the laboratory information management system as the data source, and analyzes the necessity of database optimization in the case of large data and high concurrency. On the basis of the optimization of the MySQL database and combined with the characteristics of relational database and non relational database, we realize the two layer database storage model in which Redis is used as the buffer layer and the MySQL as the persistence layer.We design the data format and synchronization mechanism of MySQL and Redis to realize the unification of data. The results has a certain reference value for database optimization of other similar systems.