KMITL

Permanent URI for this communityhttps://dspace.kmitl.ac.th/handle/123456789/1

Browse

Settings

Author: search.filters.author.Nalintippayawong, SrinualSubject: search.filters.subject.SQL statement

Search Results

Now showing 1 - 2 of 2
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Publication,
    Interactive SQL Learning Tool with Automated Grading using MySQL Sandbox
    (2019-05-14)
    Permpool, Tanasab
    ;
    Nalintippayawong, Srinual
    ;
    Atchariyachanvanich, Kanokwan
    This research presents an original tool for automatic grading of SQL statements using MySQL Sandbox[l]. This tool allows students to create and execute the queries in real time. There are many ways to write accurately SQL statement for one question. This is a pain point and burden to the instructors. The existing automated SQL grading algorithms have limitations on supportable statements and understandable error notification. The existing automated SQL grading tool did not support grading on data manipulation language statements i.e. INSERT, UPDATE and DELETE and do not support data definition language commands also; i.e. CREATE, ALTER and DROP. This paper presented an original algorithm which can support these commands. The proposed algorithm can analyze and display the differences between student's answer and correct answer. This algorithm can reduce the instructors' burdens by automatic scoring students' answers and the results directly notify back to both instructors and students. The students can learn and improve themselves faster and effectively.
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Publication,
    Development of a MySQL Sandbox for processing SQL statements: Case of DML and DDL statements
    (2017-09-05)
    Atchariyachanvanich, Kanokwan
    ;
    Nalintippayawong, Srinual
    ;
    Permpool, Tanasab
    This research developed the MySQL Sandbox, a secured environment for processing SQL queries. It was implemented as a RESTful web service having three services-sandbox database creation, SQL statement processing and sandbox database resetting. It supports the simultaneous processing of multiple SQL statements from multiple users in multiple databases. It uses question identification (ID) and student ID to create separate databases for each student using the MySQL feature to manage the user's privileges of their own database. Every service returns a result in the JSON format, which is easy to understand. This MySQL Sandbox is the first tool to support judging DDL statements and complex DML statements. Existing SQL grading systems have limitations on the number of supported SQL statements because they are concerned about risks from some sensitive SQL statement, such as DDL and DML statements, other than the SELECT statement. This sandbox will help eliminate the security concerns that obstruct the development and improvement of SQL grading systems, while providing a greater freedom of learning query to students, which will help them improve their own skills in three dimensions i.e., database query, database administration and database programming.