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

Automatic grading method and device of structured query language (SQL) program

A technology of automatic evaluation and programming, applied in the direction of software testing/debugging, etc., can solve problems such as the inability to scientifically evaluate the learning effect of students, the inability of learners to receive timely guidance, and the limitation of physical space.

Inactive Publication Date: 2011-04-20
JIANGSU UNIV
View PDF1 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the rapid development of computer technology and the new requirements for talents in the new era, the traditional database language experiment course adopts the centralized computer experiment, teacher tour guidance, and paper report scoring mode, causing problems: learners cannot get timely guidance ;The limitation of physical space cannot meet the needs of learners for re-learning; it cannot scientifically evaluate the actual learning effect of students
All in all, for SQL programs, there is no automatic scoring device and method

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
  • Automatic grading method and device of structured query language (SQL) program
  • Automatic grading method and device of structured query language (SQL) program
  • Automatic grading method and device of structured query language (SQL) program

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In order to better understand the present invention, the present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0022] refer to figure 1 , figure 1 It is a flow chart of the method for automatically evaluating the correctness of student SQL programs according to the present invention. Firstly, in step S10, standardize the SQL program to be evaluated to generate a normalized program. For example, the database manipulation language DML statement "SELECT * FROM users WHERE name like 'Mike%' and age > 25" assumes that the database table users has fields name and age. Due to the diversity of the SQL language itself, some rules are determined so that programs with the same semantics can be expressed uniformly. Among them, query all the fields in the users table and expand "*" to "name,age"; complete all the field names that appear so that they have the form of "table name.field name", if there are m...

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 discloses an automatic grading method of a structured query language (SQL) program, which is characterized in that an SQL program submitted by a learner in the test process is used for carrying out automatic grading so as to provide quantification evaluation indexes on knowledge point mastering and practical ability of a testee. The automatic grading method of the SQL program comprises the following steps: respectively performing standardization on an SQL source program and a template program so as to eliminate expression diversities in SQL semanteme, thus obtaining two standardized SQL programs; respectively carrying out lexical analysis and syntax analysis on the two standardized SQL programs so as to extract two abstract syntax trees of a characteristic programmed structure; calculating the two abstract syntax trees in accordance with a tree edit distance algorithm so as to obtain a similarity value; and calculating final grading results by using a functional relation between the similarity value and the grade.

Description

technical field [0001] The invention relates to the automatic evaluation of the correctness of SQL programs in database language programming practice. Background technique [0002] With the rapid development of computer technology and the new requirements for talents in the new era, the traditional database language experiment course adopts the centralized computer experiment, teacher tour guidance, and paper report scoring mode, causing problems: learners cannot get timely guidance ; The limitation of physical space cannot meet the needs of learners for re-learning; the actual learning effect of students cannot be scientifically evaluated. Although the database SQL language has its own syntax and semantics, it is difficult to read and has various expressions, making manual scoring difficult. In addition, the limitations of the human eye and the subjective influence of the scorers can easily lead to inaccurate and one-sided scoring. [0003] In Automatic program assessment...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/36
Inventor 杨鹤标
Owner JIANGSU UNIV
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com