Title :
A System for Database Visual Querying and Query Visualization: Complementing Text and Graphics to Increase Expressiveness
Author :
Cerullo, Claudio ; Porta, Marco
Author_Institution :
Univ. di Pavia Via Ferrata, Pavia
Abstract :
In this paper we present a system intended for both visual specification of relational database queries and visual description of "ordinary" (textual) SQL queries. Through the GraphSQL visual language, SQI statements can be expressed graphically, which may be useful to help inexperienced users learn the principles at the basis of the interaction with relational databases, as well as to allow expert users to better express non-trivial queries. On the other hand, through the automatic translation functionality of our system, textual SQI statements can be turned into GraphSQI graphical representations, thus highlighting the parts of which they are composed and their interrelations.
Keywords :
SQL; data visualisation; query processing; relational databases; specification languages; visual languages; GraphSQL; automatic translation functionality; computer graphics; query visualization; relational database; visual language; visual specification; Aggregates; Algebra; Bandwidth; Database languages; Expert systems; Graphics; Humans; Relational databases; Visual databases; Visualization;
Conference_Titel :
Database and Expert Systems Applications, 2007. DEXA '07. 18th International Workshop on
Conference_Location :
Regensburg
Print_ISBN :
978-0-7695-2932-5
DOI :
10.1109/DEXA.2007.91