• DocumentCode
    3422757
  • 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
  • fYear
    2007
  • fDate
    3-7 Sept. 2007
  • Firstpage
    109
  • Lastpage
    113
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Database and Expert Systems Applications, 2007. DEXA '07. 18th International Workshop on
  • Conference_Location
    Regensburg
  • ISSN
    1529-4188
  • Print_ISBN
    978-0-7695-2932-5
  • Type

    conf

  • DOI
    10.1109/DEXA.2007.91
  • Filename
    4312867