Design And Implementation Of Container-Based Online SQL Examination System

At present,Colleges hope to assess the students'ability to write SQL statements in database courses and postgraduate entrance examinations.Unlike the written test,the real-time operation needs to run the SQL statements written by the students.Therefore,an examination system with an online SQL editor is needed for students to answer the questions.And the students need to submit and run their SQL and get the results of the SQL.The number of items passed will be taken as the marks of the student's examination.Based on the background,this thesis proposes and designs and implements an online SQL examination system.And this thesis introduces the design and implementation details of the question module,student group module,examination module,SQL editing module,SQL execution module,and scoring module of the online SQL examination system,as well as the relationship between them.It provides teachers with the function of editing the questions,managing student groups,and organizing the examinations.While students can take the exam in the system,answer the questions online,submit the SQL,and get the running results in real-time,and check their marks after the examination.It can quickly create or destroy a database environment to generate different table structures and table data required by different questions of an examination through the container.Because the container can be easily deployed on different machines and the containers created by the same image have the same state,the ability of concurrent execution of students' SQL submission can be quickly improved by adding deployed containers.To increase the concurrent processing ability of the system and make full use of the multiple cores of the CPU,a multi-process Web application architecture is designed and implemented in this thesis.The Master-Worker model is used to deal with the coordination and task assignment problems between multiple processes.To deal with stateful services in the multi-process architecture,a shared memory model based on master process memory space is designed to store and maintain the shared data between processes.In this thesis,we test the function,important interfaces,and performance of the system,and ensures the reliability of the system by designing the test plans and verifying the test results.In the performance test,the system has a total average request success rate of nearly 95%and an average TPS of 230 under the continuous concurrent requests of 300 simulated users.The test results show that the system can support a small-scale online examination.At present,the online SQL examination system has been online and put into use,and has supported the successful completion of an online examination for 200 students.The system fully serves the whole process of the examination and does not encounter performance problems.