25,944 Hits in 7.6 sec

Relational Algebra Teaching Support Tool

Jonathas Jivago de Almeida Cruz, Kleber Kroll de Azevedo Silva
2017 Journal of Information Systems Engineering & Management  
The present study proposes a web-based tool to support teaching and learning Relational Algebra -an important subject that is particularly difficult for students to understand.  ...  We intend for this tool to serve as an appropriate means for teaching and learning Relational Algebra, contributing to the development of new teaching skills, as well motivating the students in the process  ...  The proposed tool has two main modules: a module for data definition and a query manager module in Relational Algebra. Clearly, the tool is in an early stage of development.  ... 
doi:10.20897/jisem.201708 fatcat:prmjeg4ewjelvjslxhtl5t5vii

A Framework For Sql Learning: Linking Learning Taxonomy, Cognitive Model And Cross Cutting Factors

Huda Al Shuaily, Karen Renaud
2016 Zenodo  
We conclude by presenting a model of SQL learning that should inform the instructional material design process better to support the SQL learning process.  ...  Databases comprise the foundation of most software systems. System developers inevitably write code to query these databases.  ...  Mannino [23] proposed a simpler two-step model: progressing from problem statement to database representation, and from database representation to a database query language statement, as illustrated  ... 
doi:10.5281/zenodo.1126325 fatcat:yw2qx4y6wjeitbnxapfj5ht4lu

Teaching Data Models with TriQL

Abdussalam Alawini, Peilin Rao, Leyao Zhou, Lujia Kang, Ping-Che Ho
2022 1st International Workshop on Data Systems Education  
In this paper, we introduce TriQL, a system for helping novices learn the schema and query languages of three major database systems, including MySQL (a relational database), Neo4J (a graph database),  ...  TriQL follows an interactive approach to learning new database models, supporting a dynamic and agile learning environment that can be easily integrated into database labs and homework assignments.  ...  Conclusions We developed TriQL, a system for helping novices learn three major database systems, including relational (MySQL), graph (Neo4J), and document-oriented (MongoDB), and their query languages.  ... 
doi:10.1145/3531072.3535320 fatcat:io7ioc474zbpzabkfgsplwitum


Yasin N. Silva, Isadora Almeida, Michell Queiroz
2016 Proceedings of the 47th ACM Technical Symposium on Computing Science Education - SIGCSE '16  
Specifically, SQL has been found to be a powerful query language in highly distributed and scalable systems that process Big Data, i.e., datasets with high volume, velocity and variety.  ...  In this paper, we propose teaching SQL as a general language that can be used in a broad range of database systems from traditional RDBMSs to Big Data systems.  ...  In this paper we propose learning SQL as a powerful language that can be used to query a wide range of database systems, from traditional relational databases to modern Big Data systems.  ... 
doi:10.1145/2839509.2844560 dblp:conf/sigcse/SilvaAQ16 fatcat:gk7o3hdibzgxnirdqdwhs7acme

Meet Cyrus - The Query by Voice Mobile Assistant for the Tutoring and Formative Assessment of SQL Learners [article]

Josue Espinosa Godinez, Hasan M. Jamil
2018 arXiv   pre-print
We present a mobile device voice query interface, called Cyrus, to arbitrary relational databases. Cyrus supports a large type of query classes, sufficient for an entry level database class.  ...  It's cooperative error reporting is more intuitive, and iOS based mobile platform is also more accessible compared to most contemporary mobile and voice enabled systems.  ...  To help students learn SQL be er, researchers have been trying to develop various teaching systems and learning strategies, and support them with powerful online [12] and desktop tools [3] .  ... 
arXiv:1811.04160v1 fatcat:5z56oxxxavgozcq3byrhcuoary

Support of Database Skills Testing

Henrieta Telepovska
2014 International journal for innovation education and research  
Testing is focused on Structured Query Language, especially statements of Data Manipulation Language, and relational algebra.  ...  The paper deals with a database system (DBS) component which is used for support of database skills testing of students.  ...  Database Systems course contains learning materials focused on the theory of database systems and Structured Query Language (SQL).  ... 
doi:10.31686/ijier.vol2.iss5.186 fatcat:747oppvg6vcsjdtd6dpe3b4pza


Bogdan Czejdo, Marek Rusinkiewicz
1984 Proceedings of the July 9-12, 1984, national computer conference and exposition on - AFIPS '84  
Various nonprocedural query languages are supported within a single system, using unified database dictionaries. Cross-translation between various query languages is allowed.  ...  REQUEST is a relational database management system that, in addition to the usual data definition and data manipulation functions, offers facilities for use in an instructional environment.  ...  An important implemented part of the system is a friendly query interface that guides an inexperienced user through the database definition process and allows him to formulate queries based on the relational  ... 
doi:10.1145/1499310.1499380 dblp:conf/afips/CzejdoR84 fatcat:jlcrdul3trbnnnrpxiimxsxowy


Yasin N. Silva, Jaime Chon
2015 Proceedings of the 46th ACM Technical Symposium on Computer Science Education - SIGCSE '15  
This paper presents DBSnap's design and implementation details, an evaluation of its effectiveness as a learning environment, and a thorough comparison with alternative ways to teach query languages.  ...  DBSnap fully supports the construction of intuitive database query trees, which is one of the most effective approaches to teach database queries.  ...  Furthermore, a solid grasp of relational algebra and query plans provides a good foundation to learn the SQL-like query languages that are used in many modern database systems.  ... 
doi:10.1145/2676723.2677220 dblp:conf/sigcse/SilvaC15 fatcat:gq5goonzxzcx5jjbkzwmokchfe


Yasin N. Silva, Alexis Loza, Humberto Razente
2022 Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1  
Learning to construct database queries can be a challenging task because students need to learn the specific query language syntax as well as properly understand the effect of each query operator and how  ...  To be able to look into the process of constructing a query, in this paper we introduce DBSnap-Eval, a tool that supports tree-based queries (similar to SQL query plans) and a block-based querying interface  ...  A good understanding of fundamental languages like RA provides an excellent basis to learn SQL, which is also supported in multiple Big Data systems due to its expressive power [20] .  ... 
doi:10.1145/3502718.3524822 fatcat:ikhgvc4bgzh3rfy7wl6yruvtwu

Ontology Based Data Access Methods to Teach Students to Transform Traditional Information Systems and Simplify Decision Making Process

Svetlana Chuprina, Igor Postanogov, Olfa Nasraoui
2016 Procedia Computer Science  
We describe a service-based approach that provides a natural language interface to legacy information systems, built on top of relational database management systems.  ...  The long term goal is to make data management and analysis accessible to a wider range of users for a diverse range of purposes and to simplify the decision making process.  ...  Acknowledgements The reported study was partially supported by the Government of Perm Krai, research project No.C-26/004.08 and by the Foundation of Assistance for Small Innovative Enterprises, Russia.  ... 
doi:10.1016/j.procs.2016.05.458 fatcat:r5sxflf7pngbnnkbg5ocfvtkgu

Implementing a MIRC Query Interface for a Database Driven Teaching File

Wyatt M. Tellis, Katherine P. Andriole
2003 Journal of digital imaging  
This paper describes the authors' experience with integrating an existing database-driven teaching file with the RSNA (Radiological Society of North America) Medical Imaging Resource Center [MIRC).  ...  MIRC is the product of an RSNA-sponsored initiative to enable medical institutions to share their  ...  The teaching file and MIRC interface were developed using the 4th Dimension Relational Database Management System (RDBMS).  ... 
doi:10.1007/s10278-003-1656-9 pmid:14517722 pmcid:PMC3046468 fatcat:xwyokh4gkbgsdk5eukwruap3hm

Designing Interactive Query Interfaces to Teach Database Systems in the Classroom

Lilong Jiang, Arnab Nandi
2015 Proceedings of the 33rd Annual ACM Conference Extended Abstracts on Human Factors in Computing Systems - CHI EA '15  
To remedy this, we describe a novel interactive electronic textbook for teaching undergraduate database systems courses.  ...  The rapid feedback loop with the database allows the user to explore and understand the full scope of valid and invalid queries to the database.  ...  Acknowledgements This work was supported in part by the National Science Foundation under CAREER award IIS-1453582.  ... 
doi:10.1145/2702613.2732900 dblp:conf/chi/JiangN15 fatcat:jmmljvlcx5hfpivz4i75cvpgii

Teaching SQL — Which Pedagogical Horse for This Course? [chapter]

Karen Renaud, Judy van Biljon
2004 Lecture Notes in Computer Science  
We conclude by making recommendations about the tools that should be used in teaching SQL if the afore-mentioned mental models are to be constructed to support a coherent and correct understanding of SQL  ...  When teaching any skill we have to take both previous learning and experience into consideration as well as the best possible way of teaching the skill.  ...  Acknowledgements Our thanks to Paula Kotzé, Ruth de Villiers, Iadh Ounis and Rebecca Mancy for their extremely helpful comments and inputs.  ... 
doi:10.1007/978-3-540-27811-5_22 fatcat:tc3uw2764jhw5hbguaciektgle

Introducing multidisciplinary thinking in Computer Engineering: A new way of teaching database systems

Claudia Bauzer Medeiros, Peter Baumann, Constantin Jucovschi
2010 IEEE EDUCON 2010 Conference  
The ultimate goal is to engage students in a richer learning environment, enhance motivation, broadening their horizons, and showing them how to solve problems in other fields by looking at a problem from  ...  This paper describes an experiment conducted in Brazil in teaching an undergraduate database course to Computer Engineering and Computer Science students at the University of Campinas (UNICAMP).  ...  In this case, the emphasis will be on examples for handling multimedia, and rasdaman will be used as a tool, but not a system to learn database concepts.  ... 
doi:10.1109/educon.2010.5492532 fatcat:ry2brfrxavb2flqnhxm2ezwp7q

PhD thesis: SQL Comprehension and Synthesis [article]

George Obaido
2022 arXiv   pre-print
Structured Query Language (SQL) remains the standard language used in Relational Database Management Systems (RDBMSs) and has found applications in healthcare (patient registries), businesses (inventories  ...  This work proposes a new approach aimed at understanding and writing correct SQL queries using principles from Formal Language and Automata Theory.  ...  QA system, 2. teaching and learning aid, 3. tutoring system for SQL, 4. query tool for complex BI systems, and 5. natural language interface to query databases.  ... 
arXiv:2203.03469v1 fatcat:mutfduvr2jgezmaomd4otvcpje
« Previous Showing results 1 — 15 out of 25,944 results