Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Catarci, T., Constabile, M., Levialdi, S., Batini, C.: Visual query systems for databases: A survey. J of Visual Lang. Comput. 8, 215–260 (1997)
Ower, V.: Development of a conceptual query language: Adopting the user-centred methodology. Comp. J. 46, 602–624 (2003)
Mohan, L., Kashyap, R.: A Visual Query Language for Graphical Interaction with Schema-Intensive Databases. IEEE T. Knowl. Data En. 5, 843–858 (1993)
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)
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)
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)
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)
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)
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)
Zloof, M.M.: Query-By-Example, a data base language. IBM Syst. J. 16, 324–343 (1977)
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)
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)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
El-Mahgary, S., Soisalon-Soininen, E. (2007). A Two-Phased Visual Query Interface for Relational Databases. In: Wagner, R., Revell, N., Pernul, G. (eds) Database and Expert Systems Applications. DEXA 2007. Lecture Notes in Computer Science, vol 4653. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-74469-6_48
Download citation
DOI: https://doi.org/10.1007/978-3-540-74469-6_48
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-74467-2
Online ISBN: 978-3-540-74469-6
eBook Packages: Computer ScienceComputer Science (R0)