Two-Dimensional Specification of Universal Quantification in a Graphical Database Query Language
IEEE Transactions on Software Engineering
Gql, a declarative graphical query language based on the functional data model
AVI '94 Proceedings of the workshop on Advanced visual interfaces
A Visual Query Language for Graphical Interaction with Schema-Intensive Databases
IEEE Transactions on Knowledge and Data Engineering
Conceptual Queries Using ConQuer-II
ER '97 Proceedings of the 16th International Conference on Conceptual Modeling
New metaphors for a visual query language
DEXA '96 Proceedings of the 7th International Workshop on Database and Expert Systems Applications
Query Formulation from High-Level Concepts for Relational Databases
UIDIS '99 Proceedings of the 1999 User Interfaces to Data Intensive Systems
Query-by-example: a data base language
IBM Systems Journal
| Hi-index | 0.00 |
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.