当前位置: X-MOL 学术arXiv.cs.FL › 论文详情
Our official English website, www.x-mol.net, welcomes your feedback! (Note: you will need to create a separate account there.)
Synthesis of SQL Queries from South African Local Language Narrations
arXiv - CS - Formal Languages and Automata Theory Pub Date : 2020-11-14 , DOI: arxiv-2011.07376
George Obaido, Abejide Ade-Ibijola, Hima Vadapalli

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.

中文翻译:

南非当地语言叙述的SQL查询综合

英语仍然是数据库课程的首选语言,几乎在所有南非大学以及许多国家中,英语都广泛用于教学。母语的新手程序员大多会以英语为授课语言来学习结构化查询语言(SQL)。因此,这会在理解SQL语法时产生许多问题,因为大多数母语学习者不太会英语。这可能会影响学习者理解SQL语法的能力。为了解决此问题,这项工作提出了一种称为SQL的本地语言旁白(Local-Nar-SQL)的工具,该工具使用一种有限机器(例如Jumping Finite Automaton)将本地语言叙述转换为SQL查询。此外,生成的查询从示例数据库中提取信息,并将输出呈现给学习者。本文是该领域先前研究中最初提出的工作的扩展。一项涉及145位参与者的调查得出结论,大多数人认为Local-Nar-SQL有助于理解来自本地语言的SQL查询。如果将拟议的工具用作学习辅助工具,那么本地学习者将发现使用SQL更容易,这将消除英语熟练程度高的编程教学法所面临的许多障碍。
更新日期:2020-11-17
down
wechat
bug