Write a Blog >>
Tue 12 Oct 2021 14:40 - 14:50 - Visual Program and Information Representations (1) Chair(s): Stefan Sauer

SQL is a typical query language for performing data analytics. Although its usage is ubiquitous, learners ex- perience that query formulation in SQL is error-prone and time-consuming. Prior research has shown that this is due to low expressive ease, extensive training requirements and high cognitive load, all of which present a significant burden for SQL learners. Visual representations can assist learners to significantly lower this burden. The current dominant paradigm aims to facilitate SQL querying by helping users to avoid the syntax of SQL. Such Visual Querying Systems (VQS), however, are not effective for SQL learners as they hide the syntax of the language during query formulation, rather than assisting learners to write correct queries in SQL. Furthermore, training with VQSs is system specific, which leads to system dependency for learners. We argue that novices need support from Visual Query Representation (VQR) solutions which, instead, help them in learning how to write correct and portable SQL queries. In this paper we present SQLVis, a VQR to support novice SQL users in query writing. Our system represents the query as written in SQL by the user, which can improve the SQL writing proficiency of its users. Results of an in depth empirical study demonstrate the significant value of SQLVis for learners.

Tue 12 Oct

Displayed time zone: Central Time (US & Canada) change

14:40 - 15:20
Visual Program and Information Representations (1)Research Papers
Chair(s): Stefan Sauer Paderborn University
14:40
10m
Paper
SQLVis: Visual Query Representations for Supporting SQL LearnersFull paper
Research Papers
Daphne Miedema Eindhoven University of Technology, George Fletcher Eindhoven University of Technology
14:50
10m
Paper
A Visual Notation for Succinct Program TracesFull paper
Research Papers
Divya Bajaj Oregon State University, Martin Erwig Oregon State University, Danila Fedorin Oregon State University, Kai Gay Oregon State University
15:00
10m
Paper
Text vs. Graphs in Argument AnalysisFull paper
Research Papers
Guilherme Carneiro University of St Andrews, Alice Toniolo University of St Andrews, Miguel A. Nacenta University of Victoria, Aaron J. Quigley University of New South Wales
15:10
10m
Short-paper
Travel Kinematics in Virtual Reality Increases Learning EfficiencyShort paper
Research Papers
Eric Nersesian New Jersey Institute of Technology, Margarita Vinnikov New Jersey Institute of Technology, Michael Lee New Jersey Institute of Technology