A Two-Phased Visual Query Interface for Relational Databases

  • Sami El-Mahgary
  • Eljas Soisalon-Soininen
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4653)


Developing an easy-to-use, visual query tool for non-expert users to perform their own ad-hoc queries from relational databases is an active research area. The challenge lies in designing a visual query application that is both versatile and user-friendly; often expressive power comes at the expense of non-intuitive user interfaces. This work is based on a novel two-phased approach, so that users first specify the subset of data that is of interest (using a so-called principal concept), whereby the query generates an intermediary dataset. In the second phase, users query this dataset to further eliminate unwanted rows through Boolean constraints and to perform any additional operations, i.e. grouping or columns renaming. The user interface has been kept simple and the presented ideas have been successfully implemented in a prototype known as OVI-2, for use with the university student database at Helsinki University of Technology.


Relational databases visual query interfaces query languages 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Catarci, T., Constabile, M., Levialdi, S., Batini, C.: Visual query systems for databases: A survey. J of Visual Lang. Comput. 8, 215–260 (1997)CrossRefGoogle Scholar
  2. 2.
    Ower, V.: Development of a conceptual query language: Adopting the user-centred methodology. Comp. J. 46, 602–624 (2003)CrossRefGoogle Scholar
  3. 3.
    Mohan, L., Kashyap, R.: A Visual Query Language for Graphical Interaction with Schema-Intensive Databases. IEEE T. Knowl. Data En. 5, 843–858 (1993)CrossRefGoogle Scholar
  4. 4.
    Murray, N., Paton, N., Goble, C., Bryce, J.: Kaleidoquery: a flow-based visual language and its evaluation. J. of Visual Lang. Comput. 11, 151–189 (2000)CrossRefGoogle Scholar
  5. 5.
    Benzi, F., Maio, D., Rizzi, S.: VISIONARY: a Viewpoint-based Visual Language for Querying Relational Databases. J. of Visual Lang. Comput. 10, 117–145 (1999)CrossRefGoogle Scholar
  6. 6.
    Zhang, G., Chu, W., Meng, F., Kong, G.: Query Formulation from High-Level Concepts for Relational Databases. In: Proc. of User Interfaces to Data Intensive Systems, Los Angeles, pp. 64–74 (1999)Google Scholar
  7. 7.
    Bélières, B., Trépied, C.: New metaphors for a visual query language. In: Proc. Of International Workshop on Database and Expert Systems Applications, DEXA 1996 University of Zurich, pp. 229–236 (1996)Google Scholar
  8. 8.
    Whang, K.-Y., Malhotra, A., Sockut, G.H., Burns, L., Choi, K.-S.: Two-Dimensional specification of universal quantification in a grapahical database query language. IEEE Transact. on Softw. Eng. 18, 216–224 (1992)CrossRefGoogle Scholar
  9. 9.
    Papantonakis, A., King, P.J.H.: Gql a declarative graphical query language based on the functional mode. In: Proc of the Workshop on Advanced Visual Interfaces, Bari Italy, pp. 113–122 (1994)Google Scholar
  10. 10.
    Zloof, M.M.: Query-By-Example, a data base language. IBM Syst. J. 16, 324–343 (1977)CrossRefGoogle Scholar
  11. 11.
    Bloesch, A., Halpin, T.: Conceptual queries using ConQuer-II. In: Embley, D.W. (ed.) ER 1997. LNCS, vol. 1331, pp. 113–126. Springer, Heidelberg (1997)Google Scholar
  12. 12.
    Bresciani, P., Nori, M., Pedot, N.: QueloDB: a Knowledge Based Visual Query System. In: Arabinia, H. (ed.) Proceedings of the 16th International Conference of Artificial Intelligence-IC-AI 2000, Las Vegas, pp. 1319–1325. Springer, Heidelberg (2000)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • Sami El-Mahgary
    • 1
  • Eljas Soisalon-Soininen
    • 2
  1. 1.Computing Centre, Helsinki University of Technology, Box 1100, FI-02015 TKKFinland.
  2. 2.Laboratory of Software Technology, Helsinki University of Technology, Box 5400, FI-02015 TKKFinland.

Personalised recommendations