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