Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQLServer automatic question judging system

An automatic and subsystem technology, applied in relational databases, multi-programming devices, instruments, etc., can solve the problems of students' codes that have not been actually run, SQL syntax cannot be accurately grasped, and cannot be tested, so as to strengthen and firm grasp , Improve the effect of programming ability

Active Publication Date: 2020-06-12
CHENGDU UNIV OF INFORMATION TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Some platforms currently implement automatic assessment of database-related courses, but the algorithm is based on string matching, and the student's code is not actually run. Even if there are grammatical errors in the code, it cannot be detected
The existing model cannot reflect the basic level of the students, and the syntax of SQL cannot be accurately grasped

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQLServer automatic question judging system
  • SQLServer automatic question judging system
  • SQLServer automatic question judging system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] Such as figure 1 , 2 As shown, the SQLServer automatic judgment system of the present invention includes an automatic judgment subsystem 1, a high-concurrency data processing subsystem 2, a data compilation and analysis subsystem 3, a micro-service unit operation safety tracking subsystem 4, and a Docker isolation compilation subsystem 5 and microservice registries6.

[0034] The automatic judgment subsystem 1 is used to initialize a corresponding database according to the submitted SQL statement, and simulate the submitted SQL statement in the database, and obtain the result display of the simulated operation; The result is stored in the expected result. If it is a student, the result is compared with the expected result of the teacher who made the question to get the final score. The judgment function of the automatic judgment subsystem 1 is realized by the sql trigger and index file reserved in the running program; the achievement display page of the automatic judg...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to an SQLServer automatic question judging system. The SQLServer automatic question judging system comprises an automatic question judging subsystem, a high-concurrency data processing subsystem, a data compiling and analyzing subsystem, a micro-service unit operation safety tracking subsystem and a Docker isolation compiling subsystem. The SQLServer automatic question judging system is reasonable in structural design, question judgment accuracy is high, according to the method, the correctness of a result can be verified by cases in multiple aspects, the firm mastering of knowledge points by students is enhanced, and an effective, rapid, fair and intelligent database knowledge assessment mode is provided, so that teachers can easily understand the learning conditionof the students on the database, the 100% reliability of question judgment can be realized, and the actual programming ability of the students is improved.

Description

technical field [0001] The invention relates to a question judgment system, in particular to a SQL Server automatic question judgment system. Background technique [0002] With the rapid development of the Internet, more and more colleges and universities are interested in online education-related platforms. For traditional colleges and universities, it is a wise move to use Web pages to manage and assess students. Among them, Web The test platform is undoubtedly an important part of colleges and universities. For computer students, it is very important to use the test platform to test various computer languages. The support has been relatively complete, but the establishment of an automatic judgment platform for courses such as "Database Principles and Applications" has basically not been seen, and the current exams for many database courses are still in the paper mode. [0003] Some platforms currently implement automatic assessment of database-related courses, but the al...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/242G06F16/28G06F9/50G06F8/41G06Q50/20
CPCG06F16/2433G06F16/284G06F8/41G06F9/5083G06Q50/20Y02D10/00
Inventor 刁仁宏马锦程邱志鹏李光成岳桐桥
Owner CHENGDU UNIV OF INFORMATION TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products