SQLVis: Visual Query Representations for Supporting SQL LearnersFull paper
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 OctDisplayed 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 10mPaper | 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 10mPaper | 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 10mPaper | 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 10mShort-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 |