Research And Implementation Of Virtual Laboratory In Database System Practice

The database system has the characteristics of strong operability and high dependence on theoretical knowledge and experimental practice.Only through a large number of experiments can students fully master the rich theoretical knowledge in the database system.However,the database system has great complexity,and the teachers need to expend a lot of energy to conduct the experimental teaching and correct the experimental work,and domestic universities don't have an automated experimental teaching platform that can be applied to the practice of the database system.In order to promote the automated experimental teaching of database system practice,this thesis designs and implements a new type of database system practice virtual laboratory.The main research contents and innovations of this article are as follows:(1)This thesis proposes and implements a dynamic and highly interactive automated experiment guidance teaching scheme.This scheme can automatically guide all the steps in the experiment,track and correct the learner's code writing and experiment process: when the learner's experiment step is wrong,it will be prompted,and the learning materials will be pushed to assist the learner to correct the experimental errors.This kind of dynamic,high-interaction,and complex code teaching automation experiment guidance teaching mode can reduce the teacher's experimental teaching burden,and at the same time enable the learner to experience a learning process similar to the teacher's hand-to-hand instruction.(2)Aiming at the problem that the traditional program online evaluation system can't accurately test the internal structure of the program,this thesis proposes and implements an interface-based online evaluation scheme.This scheme abstracts the key parts of the experiment into interfaces,which can control and test the student's experiment program at a finer granularity.(3)This thesis proposes and implements an automated plug-in database system storage engine online evaluation program.Through the MySQL plug-in storage engine architecture,this solution can not only help students shield non-core functions in the database system,let users focus on the realization of data storage and data acquisition functions,but also efficiently and accurately perform functional testing and performance testing on user storage engines.Compared with the traditional database experiment platform,the database system practice virtual laboratory in this thesis supports a fully automated experiment-guided teaching mode without the need for teachers to manually teach,and at the same time,it can conduct more fine-grained evaluation and testing of the student database system experiment program.This database system practice virtual laboratory provides a convenient and efficient experimental teaching system for database system practice.