| fullrecord |
[{"key": "dc.contributor.advisor", "value": "Taipalus, Toni", "language": "", "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Poutanen, Onni", "language": "", "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2022-06-02T07:00:22Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2022-06-02T07:00:22Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2022", "language": "", "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/81422", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Niin tavalliset ihmiset kuin ohjelmoijatkin t\u00f6rm\u00e4\u00e4v\u00e4t p\u00e4ivitt\u00e4isess\u00e4 el\u00e4m\u00e4ss\u00e4\u00e4n virheilmoituksiin, jotka ovat vaikeaselkoisia tai niiden ehdottama korjaus ei toimi. T\u00e4m\u00e4n Pro gradu -tutkielman on tarkoitus tutkia, onko olemassa SQL \nvirheilmoituksia, jotka mahdollisesti aiheuttavat enemm\u00e4n ongelmia virheenkorjaamisessa kuin ne ratkaisevat. T\u00e4t\u00e4 tutkielmaa varten on tutkittu SQL:n syntaksia ja tehty katsaus sit\u00e4 koskevaan kirjallisuuteen. T\u00e4m\u00e4n lis\u00e4ksi \nSQL:n ja ohjelmoinnin virheilmoituksia koskevaan kirjallisuuteen on perehdytty. Tutkimuksessa k\u00e4ytetty data ker\u00e4ttiin opiskelijoilta, jotka ovat k\u00e4yneet SQL:n ja tietokantojen perusteet sis\u00e4lt\u00e4v\u00e4n kurssin. Opiskelijoille annettiin virheellinen SQL-lause ja tunnetun tietokantahallintaj\u00e4rjestelm\u00e4n antama virheilmoitus kyseiseen lauseeseen. V\u00e4\u00e4rin korjattuja lauseita tutkittiin mahdollisten yhteyksien l\u00f6yt\u00e4miseksi virheilmoituksen ja lausekkeeseen tehdyn muutoksen v\u00e4lilt\u00e4. Tulokset osoittavat, ett\u00e4 jotkin virheilmoitukset saattavat johtaa harhaan n\u00e4ytt\u00e4ess\u00e4\u00e4n virheellist\u00e4 tietoa tai kohdistaa k\u00e4ytt\u00e4j\u00e4n huomion v\u00e4\u00e4r\u00e4n asiaan lauseessa. My\u00f6s ep\u00e4selv\u00e4t ja ep\u00e4m\u00e4\u00e4r\u00e4iset virheilmoitukset aiheuttivat ongelmia. Tulevaisuudessa tutkimusten on mahdollista kiinnitt\u00e4\u00e4 huomiota n\u00e4ihin ongelmiin ja mahdollisesti parantaa virheilmoituksien laatua.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Not only programmers but many people in their daily lives have experienced the frustration of error message that does not make sense or the suggested fix does not work. This thesis aims to study SQL error messages that might cause more problems in the error correction process than they solve. SQL as language and syntax is studied for this thesis, and literature is reviewed. In addition, error message literature is examined in the context of programmers and SQL. The data is collected from students who have completed introductory level SQL and databases course. The students were presented with the incorrect statements, and with the help of an error message provided by a popular database management system, the participant submitted the corrected statements. Incorrectly altered statements are studied to discover any connections between the error message and modifications made by the user. The results revealed that there is a possibility that some error messages might mislead, provide misinformation, or fixate the user\u2019s attention to the wrong parts of the statement. In the future is possible to focus on these problems and improve the quality of the error messages.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by Paivi Vuorio (paelvuor@jyu.fi) on 2022-06-02T07:00:22Z\nNo. of bitstreams: 0", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2022-06-02T07:00:22Z (GMT). No. of bitstreams: 0\n Previous issue date: 2022", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "60", "language": "", "element": "format", "qualifier": "extent", "schema": "dc"}, {"key": "dc.format.mimetype", "value": "application/pdf", "language": null, "element": "format", "qualifier": "mimetype", "schema": "dc"}, {"key": "dc.language.iso", "value": "eng", "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": "virheilmoitukset", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "syntaksi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "SQL error messages that hinder the syntax error correction", "language": "", "element": "title", "qualifier": null, "schema": "dc"}, {"key": "dc.type", "value": "master thesis", "language": null, "element": "type", "qualifier": null, "schema": "dc"}, {"key": "dc.identifier.urn", "value": "URN:NBN:fi:jyu-202206023044", "language": "", "element": "identifier", "qualifier": "urn", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Pro gradu -tutkielma", "language": "fi", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Master\u2019s thesis", "language": "en", "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_bdcc", "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": "masterThesis", "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": "SQL", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "kyselykielet", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "virheet", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "SQL", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "query languages", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "errors", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.format.content", "value": "fulltext", "language": null, "element": "format", "qualifier": "content", "schema": "dc"}, {"key": "dc.rights.url", "value": "https://rightsstatements.org/page/InC/1.0/", "language": null, "element": "rights", "qualifier": "url", "schema": "dc"}, {"key": "dc.type.okm", "value": "G2", "language": null, "element": "type", "qualifier": "okm", "schema": "dc"}]
|