Natural-SQL Translator A general natural language interface to SQL using the Grammatical Framework programming language

dc.contributor.authorDavallius, Daniel
dc.contributor.departmentChalmers tekniska högskola / Institutionen för data och informationstekniksv
dc.contributor.examinerAhrendt, Wolfgang
dc.contributor.supervisorRanta, Aarne
dc.date.accessioned2021-08-18T07:18:27Z
dc.date.available2021-08-18T07:18:27Z
dc.date.issued2021sv
dc.date.submitted2020
dc.description.abstractDatabases are powerful tools and the ability to use natural language to query databases makes these tools more accessible. For a natural language-database accessing system to become useful beyond niche applications, it needs to be able to scale and adapt. For that to be the case, it needs to be formulated generically to not require redesign for every new application. The central part of this system needs to be agnostic with regards to what database is to be accessed as well as agnostic with regards to what natural language is to be used. This project has as its goal to create a prototype of such a system for the database query language SQL. A system which is accessible, has a general form and can easily be adapted to new natural languages and databases. To do this the Grammatical Framework (GF) programming language was used, which is designed to enable translations based on an abstract grammar and multiple concrete descriptions of how everything that can be formed in the grammar is expressed in each language. For this project that list of languages includes SQL and natural languages such as English and Swedish. Around the GF grammar, an application was constructed which allows the user to perform translations without much technical skill, no commands need to be entered and nothing needs to be compiled once the system has been set up once. The system which is the result of this project has a general form and allows for easy use with a new database, and a somewhat more involved application to a new natural language. It allows access to databases without requiring any programming knowledge. It permits the user flexibility in their way of expressing themselves when using a natural language.sv
dc.identifier.urihttps://hdl.handle.net/20.500.12380/303909
dc.language.isoengsv
dc.setspec.uppsokTechnology
dc.subjectGrammatical frameworksv
dc.subjectGFsv
dc.subjectGrammarssv
dc.subjectStructured Query Languagesv
dc.subjectSQLsv
dc.subjectDatabasessv
dc.subjectNatural languagesv
dc.subjectHuman-computer interactionsv
dc.subjectUser friendlysv
dc.subjectGeneralsv
dc.titleNatural-SQL Translator A general natural language interface to SQL using the Grammatical Framework programming languagesv
dc.type.degreeExamensarbete för masterexamensv
dc.type.uppsokH
local.programmeComputer systems and networks (MPCSN), MSc
Ladda ner
Original bundle
Visar 1 - 1 av 1
Hämtar...
Bild (thumbnail)
Namn:
CSE 21-117 Davallius.pdf
Storlek:
2.04 MB
Format:
Adobe Portable Document Format
Beskrivning:
License bundle
Visar 1 - 1 av 1
Hämtar...
Bild (thumbnail)
Namn:
license.txt
Storlek:
1.51 KB
Format:
Item-specific license agreed upon to submission
Beskrivning: