In this paper, we present SAVI, a new system for supporting the teaching and the understanding of the semantics of the SQL language. SAVI uses visualization to explain the way some of the SQL operators select and transform data from a target database. The contribution of our paper is two-fold. From a conceptual point of view, we improve the visualization approach provided by existing systems, in order to address the mental visualization problem faced by students when learning SQL. From a technological point of view, we leverage on emerging web technologies to develop a visualization infrastructure that can be seamlessly run on any standard HTML5-capable browser, without any need for an additional software or virtual machine installation. © 2011 ACM.
SAVI: a new system for advanced SQL visualization / Cembalo, Maurizio; De Santis, Alfredo; FERRARO PETRILLO, Umberto. - STAMPA. - (2011), pp. 165-170. (Intervento presentato al convegno 2011 ACM Special Interest Group for Information Technology Education Conference, SIGITE'11 tenutosi a West Point, NY) [10.1145/2047594.2047641].
SAVI: a new system for advanced SQL visualization
Umberto Ferraro Petrillo
2011
Abstract
In this paper, we present SAVI, a new system for supporting the teaching and the understanding of the semantics of the SQL language. SAVI uses visualization to explain the way some of the SQL operators select and transform data from a target database. The contribution of our paper is two-fold. From a conceptual point of view, we improve the visualization approach provided by existing systems, in order to address the mental visualization problem faced by students when learning SQL. From a technological point of view, we leverage on emerging web technologies to develop a visualization infrastructure that can be seamlessly run on any standard HTML5-capable browser, without any need for an additional software or virtual machine installation. © 2011 ACM.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
