| fullrecord |
[{"key": "dc.contributor.advisor", "value": "Taipalus, Toni", "language": "", "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Moberg, Jonatan", "language": "", "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2023-05-25T05:53:54Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2023-05-25T05:53:54Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2023", "language": "", "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/87170", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "SQL-NLP:ll\u00e4 viitataan luonnollisen kielen k\u00e4ytt\u00f6\u00f6n SQL-kieless\u00e4. SQL (engl. Structured Query Language) on ohjelmointi- ja kyselykieli, jota k\u00e4ytet\u00e4\u00e4n relaatiotietokantojen yhteydess\u00e4. NLP (engl. Natural Language Processing) tarkoittaa luonnollisen kielen prosessointia. Luonnollinen kieli viittaa ihmisten k\u00e4ytt\u00e4m\u00e4\u00e4n kieleen, kuten englantiin tai suomeen. Kandidaatin tutkielma toteutettiin k\u00e4ytt\u00e4m\u00e4ll\u00e4 systemaattisen kirjallisuuskartoituksen menetelm\u00e4\u00e4. Menetelm\u00e4 valittiin, koska aiempaa tutkimusta ei ollut tehty systemaattisena kirjallisuuskartoituksena. Systemaattisen kirjallisuuskartoituksen tarkoituksena on kartoittaa aiempia tutkimuksia ja l\u00f6yt\u00e4\u00e4 mahdollisia tutkimusaukkoja. T\u00e4m\u00e4n tutkielman tarkoituksena oli selvitt\u00e4\u00e4, kuinka paljon tutkimusta on tehty luonnollisen kielen hy\u00f6dynt\u00e4misess\u00e4 SQL-kieless\u00e4. Lis\u00e4ksi haluttiin selvitt\u00e4\u00e4, mill\u00e4 julkaisufoorumeilla artikkeleita on julkaistu ja mist\u00e4 n\u00e4k\u00f6kulmista artikkelit k\u00e4sittelev\u00e4t aihetta. Tutkielman aineisto saatiin luomalla tietokantakyselyit\u00e4 nelj\u00e4ss\u00e4 eri tietokannassa. Tietokantakyselyjen tukena k\u00e4ytettiin taaksep\u00e4in suuntautuvaa lumipallomenetelm\u00e4\u00e4. N\u00e4iden kahden menetelm\u00e4n avulla tutkimusaineistoksi valikoitui 110 tieteellist\u00e4 vertaisarvioidulla foorumilla julkaistua artikkelia. Tutkimuksen tulokset jaoteltiin julkaisuvuoden ja julkaisufoorumin mukaisesti. Lis\u00e4ksi tutkittiin tutkimusten n\u00e4k\u00f6kulmaa koskien SQL-NLP:t\u00e4. Tutkielmat jaoteltiin kolmeen eri luokkaan n\u00e4k\u00f6kulman perusteella, joista ensimm\u00e4inen oli uudet l\u00e4hestymistavat, menetelm\u00e4t ja mallit, toinen kahden tai useamman menetelm\u00e4n vertailu ja kolmas muut julkaisut. Tuloksista k\u00e4y ilmi, ett\u00e4 tutkimus on ajankohtaista ja uusia tutkimuksia tuotetaan koko ajan lis\u00e4\u00e4. Lis\u00e4ksi havaittiin, ett\u00e4 tutkimuksia on julkaistu monipuolisesti eri julkaisufoorumeilla. Julkaisujen n\u00e4k\u00f6kulmista todettiin, ett\u00e4 suuri osa julkaistuista artikkeleista esittelev\u00e4t uuden luonnollisen kielen menetelm\u00e4n tai tekniikan soveltamisen SQL-kielelle. Jatkotutkimuskohde aiheeseen voisi olla erilaisten SQL-NLP-sovelluksien ja -menetelmien kriittinen laajamittainen vertailu.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "The term SQL-NLP pertains to the utilization of Natural Language Processing (NLP) within the SQL (Structured Query Language) programming and query language, which is employed in the relational database domain. Natural language refers to the idiom employed by human beings, such as English or Finnish. This bachelor\u2019s thesis was conducted as a systematic mapping study methodology. This methodology was elected due to the absence of prior research conducted as a systematic mapping study. The prime objective of a systematic mapping study is to map antecedent research and unearth prospective research gaps. The objective of the thesis was to ascertain the extent of extant research with regards to the utilization of natural language in SQL, as well as to determine the publication fora and perspectives from which relevant articles approach the topic. The material for this thesis was garnered through the creation of database queries in four distinct databases. The backward snowballing method was utilized to complement these queries. The techniques culminated in the selection of a research sample consisting of 110 scientific articles published in peer-reviewed fora. The results of the study were classified according to year of publication and publication forum. Furthermore, the study probed the SQL-NLP perspective of the articles. The articles were divided into three distinct categories, predicated on their respective perspectives. The first category pertained to novel approaches, methodologies, and models, the second category focused on the comparison of two or more methodologies, and the third category encapsulated publications of an alternative nature. The findings indicate that research on the subject is germane, and that novel research is being produced on a constant basis. Furthermore, it was discovered that research had been published across a range of publication fora. Regarding the perspectives of the articles, a significant proportion of the articles proffered novel natural language methodologies or techniques, which were applied to SQL. A potential future research avenue on this subject could be a large-scale, critical comparison of divergent applications and methodologies of SQL-NLP.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by Miia Hakanen (mihakane@jyu.fi) on 2023-05-25T05:53:54Z\nNo. of bitstreams: 0", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2023-05-25T05:53:54Z (GMT). No. of bitstreams: 0\n Previous issue date: 2023", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "40", "language": "", "element": "format", "qualifier": "extent", "schema": "dc"}, {"key": "dc.language.iso", "value": "fin", "language": null, "element": "language", "qualifier": "iso", "schema": "dc"}, {"key": "dc.rights", "value": "In Copyright", "language": "en", "element": "rights", "qualifier": null, "schema": "dc"}, {"key": "dc.subject.other", "value": "NLP", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "luonnollisen kielen prosessointi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "SQL-NLP:n tutkimuskentt\u00e4 : systemaattinen kirjallisuuskartoitus", "language": "", "element": "title", "qualifier": null, "schema": "dc"}, {"key": "dc.type", "value": "bachelor thesis", "language": null, "element": "type", "qualifier": null, "schema": "dc"}, {"key": "dc.identifier.urn", "value": "URN:NBN:fi:jyu-202305253234", "language": "", "element": "identifier", "qualifier": "urn", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Bachelor's thesis", "language": "en", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Kandidaatinty\u00f6", "language": "fi", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.contributor.faculty", "value": "Informaatioteknologian tiedekunta", "language": "fi", "element": "contributor", "qualifier": "faculty", "schema": "dc"}, {"key": "dc.contributor.faculty", "value": "Faculty of Information Technology", "language": "en", "element": "contributor", "qualifier": "faculty", "schema": "dc"}, {"key": "dc.contributor.department", "value": "Informaatioteknologia", "language": "fi", "element": "contributor", "qualifier": "department", "schema": "dc"}, {"key": "dc.contributor.department", "value": "Information Technology", "language": "en", "element": "contributor", "qualifier": "department", "schema": "dc"}, {"key": "dc.contributor.organization", "value": "Jyv\u00e4skyl\u00e4n yliopisto", "language": "fi", "element": "contributor", "qualifier": "organization", "schema": "dc"}, {"key": "dc.contributor.organization", "value": "University of Jyv\u00e4skyl\u00e4", "language": "en", "element": "contributor", "qualifier": "organization", "schema": "dc"}, {"key": "dc.subject.discipline", "value": "Tietoj\u00e4rjestelm\u00e4tiede", "language": "fi", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "dc.subject.discipline", "value": "Information Systems Science", "language": "en", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "yvv.contractresearch.funding", "value": "0", "language": "", "element": "contractresearch", "qualifier": "funding", "schema": "yvv"}, {"key": "dc.type.coar", "value": "http://purl.org/coar/resource_type/c_7a1f", "language": null, "element": "type", "qualifier": "coar", "schema": "dc"}, {"key": "dc.rights.accesslevel", "value": "openAccess", "language": null, "element": "rights", "qualifier": "accesslevel", "schema": "dc"}, {"key": "dc.type.publication", "value": "bachelorThesis", "language": null, "element": "type", "qualifier": "publication", "schema": "dc"}, {"key": "dc.subject.oppiainekoodi", "value": "601", "language": "", "element": "subject", "qualifier": "oppiainekoodi", "schema": "dc"}, {"key": "dc.subject.yso", "value": "systemaattiset kirjallisuuskatsaukset", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "relaatiotietokannat", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "neurolingvistinen ohjelmointi", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "SQL", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.rights.url", "value": "https://rightsstatements.org/page/InC/1.0/", "language": null, "element": "rights", "qualifier": "url", "schema": "dc"}]
|