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, SQL 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 SQL statements can be turned into GraphSQL graphical representations, thus highlighting the parts of which they are composed and their interrelations.
A System for Database Visual Querying and Query Visualization: Complementing Text and Graphics to Increase Expressiveness
PORTA, MARCO
2007-01-01
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, SQL 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 SQL statements can be turned into GraphSQL graphical representations, thus highlighting the parts of which they are composed and their interrelations.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
