The effects of database complexity on SQL query formulation

Taipalus, Toni

doi:10.1016/j.jss.2020.110576

Cited by 22 publications

(11 citation statements)

References 35 publications

(60 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Communication is carried out one-to-many with reference tables when executing SQL queries (Saeed, 2017;Taipalus, 2020). The information for user authorization is in the "user" table.…”

Section: Resultsmentioning

confidence: 99%

Implementation Of System Modelling And Software Analysis In A Higher Educational Institution

Глаголев¹

2022

The European Proceedings of Social and Behavioural Sciences

View full text Add to dashboard Cite

This paper discusses the implementation of system modelling and analysis standards in teaching technical disciplines using application programming elements in high-level development environments. In the course of education, students consistently study the software development lifecycle stages and face the problems of updating the terms of reference from municipal and private customers at the design stage of relational databases and client applications. The author showed using the IDEF0, IDEF3, and DFD standards to identify the main requirements for software implementation notations. The software development included the following stages: the official customer's query to fulfill a technical task, the subject area analysis of the customer's business and his requirements for the application development, the design of the database and application interface. Verification of the development process was carried out at the bachelor's degree courses "Information systems and technologies at enterprises" of Sholom-Aleichem Priamursky State University during the discipline "Tools," "Systems Theory and Structural Analysis," "Mobile Application Development," and "Software Engineering." Students studied the customer's business processes presented by individual entrepreneur Mishukova N.A., designed the database structure of the unique baguette products, and the interaction of screen forms of client applications based on the II2 framework provided high ergonomics of systems. Students actively discussed the issues of web resources integration and network databases, together with applications development in Windows and Android multi-platform operating environments.

show abstract

“…Communication is carried out one-to-many with reference tables when executing SQL queries (Saeed, 2017;Taipalus, 2020). The information for user authorization is in the "user" table.…”

Section: Resultsmentioning

confidence: 99%

Implementation Of System Modelling And Software Analysis In A Higher Educational Institution

Глаголев¹

2022

The European Proceedings of Social and Behavioural Sciences

View full text Add to dashboard Cite

show abstract

“…The role of tools in EA work is significant, and even more than a language, the tool may be defining how the EA work is done. Furthermore, even though using more realistic tools or environments in teaching makes learning more difficult [33], it facilitates skills required in the students' future work environments. This, in turn, helps students understand a phenomenon rather than a tool, supporting the view of deep learning.…”

Section: Discussionmentioning

confidence: 99%

Information Systems Students’ Impressions on Learning Modeling Enterprise Architectures

Seppänen

Pulkkinen

Taipalus

et al. 2020

2020 IEEE Frontiers in Education Conference (FIE)

Self Cite

View full text Add to dashboard Cite

“…However, as education aims to train future professionals, formulating only simple exercises is not a feasible solution. Given the centrality of the issue of cognitive load, some solutions have already been proposed in the form of simpler database structures [38], query templates [39] [40] and a planning notation for complex SQL queries [41]. Query planning, in particular, arguably mitigates working memory constraints as relevant parts of the data demand are separated from irrelevant, and explicitly marked as a query plan which is then written in SQL.…”

Section: B How To Mitigate Persistent Errorsmentioning

confidence: 99%