University of Jyväskylä | JYX Digital Repository

  • English  | Give feedback |
    • suomi
    • English
 
  • Login
JavaScript is disabled for your browser. Some features of this site may not work without it.
View Item 
  • JYX
  • Opinnäytteet
  • Väitöskirjat
  • View Item
JYX > Opinnäytteet > Väitöskirjat > View Item

Persistent Errors in Query Formulation

Thumbnail
View/Open
1.7Mb

Downloads:  
Show download detailsHide download details  
Published in
JYU dissertations
Authors
Taipalus, Toni
Date
2020

 
We use the internet daily to query data from a myriad of databases; every search term entered in a search engine, every movie watched, every song listened, ev-ery newspaper article read online. Although we as end-users only see the rel-atively effortless user interfaces as we query data, someone has had to formal-ize our queries into a language the software understands. The most common of these so called query languages is Structured Query Language (SQL). In or-der for us as end-users to retrieve exactly the data we want, it is crucial that the software developers responsible for writing the underlying queries have written the queries without errors. Educational SQL research, however, has not yet thor-oughly addressed issues related to understanding query formulation errors or some technical factors which influence the process of learning SQL. This doctoral dissertation makes the following contributions for increased understanding of SQL education: (i) a systematic overview of SQL teaching practices proposed in scientific literature, (ii) a creation of a wide taxonomy of errors committed in SQL learning, (iii) a description of which types of errors halt query formulation, and which types of encountered errors are usually fixed, (iv) evidence on the effects of database complexity on query formulation success rates, and (v) a creation of a planning notation designed to mitigate errors in query formulation. Contribu-tion (ii) presents practical implications for research by allowing the comparison of results of different SQL error studies when the taxonomy is used, and extend-ing and generalizing prior SQL error studies. While contributions (i) and (v) may be directly applied in teaching SQL, contributions (iii) and (iv) may be consid-ered when making an informed decision on what kind of databases are the most suitable for practicing SQL. ...
 
SQL-kieli (Structured Query Language) on yleisin kyselykielistä, joita käytetään tiedon hakemiseen tietokannoista. Jotta kyselykielellä kirjoitetut kyselyt palauttaisivat loppukäyttäjälle hänen haluamaansa oikeellista tietoa, täytyy kysely kirjoittaa virheettömästi. SQL-kielen opetuksen tutkimuksessa erilaiset virheet eivät kuitenkaan ole saaneet laajaa tai syvällistä tieteellistä huomiota. Lisäksi joidenkin SQL-kielen oppimiseen liittyvien seikkojen vaikutusta ei ole tieteellisesti tutkittu. Tässä väitöskirjassa (i) tehdään systemaattinen kirjallisuuskartoitus SQL-kielen opetuksessa käytetyistä menetelmistä, (ii) muodostetaan laaja SQL-kielen kyselyiden kirjoittamisessa tehtyjen virheiden taksonomia, (iii) selitetään mitkä virhetyypeistä ovat pysyviä, eli jäävät tavallisesti kyselyn kirjoittajalta korjaamatta ja mitkä virhetyypeistä tavallisesti korjataan, (iv) esitetään harjoitustietokannan monimutkaisuuden vaikutukset kyselyn kirjoittamiselle ja (v) kuvaillaan suunnittelunotaatio, jonka tarkoituksena on pysyvien virheiden lukumäärän vähentäminen. Edellä luetelluista kontribuutioista (ii) auttaa taksonomiaa käyttävien tieteellisten tutkimusten tuloksien vertailussa, sekä luo pohjan esimerkiksi virheiden ja virhetyyppien paikantamiseen koneoppimismenetelmin. Kontribuutioita (i) ja (v) voidaan käyttää sellaisenaan SQL-kielen opetuksessa, ja kontribuutiot (iii) ja (iv) auttavat päätöksenteossa sopivan monimutkaisen harjoitustietokannan valinnassa. ...
 
ISBN
978-951-39-8290-4
Contains publications
  • Artikkeli I: Taipalus, Toni; Seppänen, Ville (2020). SQL education : a systematic mapping study and future research agenda. ACM Transactions on Computing Education, 20 (3), 20. DOI: 10.1145/3398377
  • Artikkeli II: Taipalus, T., Siponen, M., & Vartiainen, T. (2018). Errors and Complications in SQL Query Formulation. ACM Transactions on Computing Education, 18 (3), 15. DOI: 10.1145/3231712
  • Artikkeli III: Taipalus, T., & Perälä, P. (2019). What to Expect and What to Focus on in SQL Query Teaching. In SIGCSE '19 : Proceedings of the 50th ACM Technical Symposium on Computer Science Education (pp. 198-203). New York: Association for Computing Machinery. DOI: 10.1145/3287324.3287359
  • Artikkeli IV: Taipalus, Toni (2020). The Effects of Database Complexity on SQL Query Formulation. Journal of Systems and Software, 165, 110576. DOI: 10.1016/j.jss.2020.110576
  • Artikkeli V: Taipalus, Toni (2019). Teaching tip : a notation for planning SQL queries. Journal of Information Systems Education, 30 (3), 160-166. http://jise.org/Volume30/n3/JISEv30n3p160.pdf
Keywords
kyselykielet SQL tietokannat relaatiotietokannat ohjelmointi virheet ohjelmointivirheet opetus Structured Query Language (SQL) computing education database relational error logical complexity planning notation loogisen rakenteen monimutkaisuus databases relational databases
URI

http://urn.fi/URN:ISBN:978-951-39-8290-4

Metadata
Show full item record
Collections
  • Väitöskirjat [3032]

Related items

Showing items with similar title or keywords.

  • The Effects of Database Complexity on SQL Query Formulation 

    Taipalus, Toni (Elsevier, 2020)
    In Structured Query Language (SQL) education, students often execute queries against a simple exercise database. Recently, databases that are more realistic have been utilized to the effect that students find exercises ...
  • What to Expect and What to Focus on in SQL Query Teaching 

    Taipalus, Toni; Perälä, Piia (Association for Computing Machinery, 2019)
    In the process of learning a new computer language, writing erroneous statements is part of the learning experience. However, some errors persist throughout the query writing process and are never corrected. Structured ...
  • Error messages in relational database management systems : A comparison of effectiveness, usefulness, and user confidence 

    Taipalus, Toni; Grahn, Hilkka; Ghanbari, Hadi (Elsevier BV, 2021)
    The database and the database management system (DBMS) are two of the main components of any information system. Structured Query Language (SQL) is the most popular query language for retrieving data from the database, as ...
  • Explaining Causes Behind SQL Query Formulation Errors 

    Taipalus, Toni (IEEE, 2020)
    This Full Research Paper presents the most prominent query formulation errors in Structured Query Language (SQL), and maps these errors to their cognitive explanations. Understanding query formulation errors is a key to ...
  • Errors and Complications in SQL Query Formulation 

    Taipalus, Toni; Siponen, Mikko; Vartiainen, Tero (Association for Computing Machinery, 2018)
    SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of ...
  • Browse materials
  • Browse materials
  • Articles
  • Conferences and seminars
  • Electronic books
  • Historical maps
  • Journals
  • Tunes and musical notes
  • Photographs
  • Presentations and posters
  • Publication series
  • Research reports
  • Research data
  • Study materials
  • Theses

Browse

All of JYXCollection listBy Issue DateAuthorsSubjectsPublished inDepartmentDiscipline

My Account

Login

Statistics

View Usage Statistics
  • How to publish in JYX?
  • Self-archiving
  • Publish Your Thesis Online
  • Publishing Your Dissertation
  • Publication services

Open Science at the JYU
 
Data Protection Description

Accessibility Statement

Unless otherwise specified, publicly available JYX metadata (excluding abstracts) may be freely reused under the CC0 waiver.
Open Science Centre