论文标题
来自南非本地语言叙述的SQL查询的合成
Synthesis of SQL Queries from South African Local Language Narrations
论文作者
论文摘要
英语仍然是数据库课程的首选语言，并且在几乎所有南非大学以及许多国家 /地区都广泛用于教学。本地起源的新手程序员主要是通过英语作为教学媒介教授结构化查询语言（SQL）。因此，这在理解SQL的语法方面造成了无数的问题，因为大多数本地学习者都不熟练英语。这可能会影响学习者理解SQL语法的能力。为了解决此问题，这项工作提出了一种称为本地语言叙述（本地-NAR-SQL）的工具，该工具使用了使用有限的机器，例如跳跃有限的自动机将本地语言叙述转化为SQL查询。此外，生成的查询从示例数据库中提取信息，并向学习者提供输出。本文是该领域先前研究中最初提出的作品的扩展。一项涉及145名参与者的调查得出的结论是，大多数人认为本地-NAR-SQL有助于了解本地语言的SQL查询。如果建议的工具被用作学习辅助工具，那么本人学习者会发现与SQL合作更容易，这将消除许多在编程教学法中所面临的英语能力的障碍。
English remains the language of choice for database courses and widely used for instruction in nearly all South African universities, and also in many countries. Novice programmers of native origins are mostly taught Structured Query Language (SQL) through English as the medium of instruction. Consequently, this creates a myriad of problems in understanding the syntax of SQL as most native learners are not too proficient in English. This could affect a learner's ability in comprehending SQL syntaxes. To resolve this problem, this work proposes a tool called local language narrations (Local-Nar-SQL) to SQL that uses a type of Finite Machine, such as a Jumping Finite Automaton to translate local language narratives into SQL queries. Further, the generated query extracts information from a sample database and presents output to the learner. This paper is an extension of work originally presented in a previous study in this field. A survey involving 145 participants concluded that the majority found Local-Nar-SQL to be helpful in understanding SQL queries from local languages. If the proposed tool is used as a learning aid, native learners will find it easier to work with SQL, which will eliminate many of the barriers faced with English proficiencies in programming pedagogies.
