Feasible database querying using a visual end-user approach

Querying databases is a common daily task carried out by a great deal of end-users who do not have specific skills in SQL language. Today, most of the database interaction is achieved by means of query interfaces provided by the database environment. However, most of these interfaces suffer from expressive limitations, since they are mostly based on metaphors that drastically restrict the expressiveness of the SQL language that is generated and executed in the background. In this paper, we present a visual interaction language and tool focused on easily querying databases by end-users. We make no assumption on the level of the user's experience with query languages, as our visual metaphor is intended for querying databases by unskilled end-users and also leveraging the restriction on the expressiveness of the queries created by them. We also report on some late braking results obtained by an experiment carried out with real users.

[1]  Crescencio Bravo,et al.  Engineering the User Interface: From Research to Practice , 2008 .

[2]  Fred D. Davis Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Technology , 1989, MIS Q..

[3]  Jakob Nielsen,et al.  Usability engineering , 1997, The Computer Science and Engineering Handbook.

[4]  Henry Lieberman,et al.  End-User Development (Human-Computer Interaction Series) , 2006 .

[5]  Menno D. T. de Jong,et al.  Does think aloud work?: how do we know? , 2006, CHI Extended Abstracts.

[6]  José A. Macías,et al.  Providing end-user facilities to simplify ontology-driven web application authoring , 2007, Interact. Comput..

[7]  José A. Macías,et al.  Semantic Web Query Authoring for End-Users , 2009 .

[8]  Pat Hanrahan,et al.  Polaris: a system for query, analysis, and visualization of multidimensional databases , 2008, Commun. ACM.

[9]  Marc Rettig,et al.  Prototyping for tiny fingers , 1994, CACM.

[10]  Henry Lieberman,et al.  Your Wish is My Command , 2001, The Morgan Kaufmann series in interactive technologies.

[11]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[12]  Adriane Chapman,et al.  Making database systems usable , 2007, SIGMOD '07.

[13]  Henry Lieberman,et al.  Watch what I do: programming by demonstration , 1993 .

[14]  Moshé M. Zloof Query by example , 1899 .

[15]  Gavriel Salvendy,et al.  A proposed index of usability: A method for comparing the relative usability of different software systems , 1997, Behav. Inf. Technol..