ABSTRACT
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.
- Cypher A. Watch What I Do: Programming by Demonstration. The MIT Press, 1993. Google ScholarDigital Library
- Davis, F. D. Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Technology, MIS Quarterly, Volume 13, Issue 3, September 1989, pp. 319--340.Google ScholarDigital Library
- Eclipse Birt Project. http://www.eclipse.org/birt/.Google Scholar
- Jagadish, H.V., Chapman, A., Elkiss, A., Jayapandian, M., Li, Y., Nandi, A. and Yu, C. Making database systems usable. Proceedings of the International Conference on Management of data. Beijing, China (2007), 13--24. Google ScholarDigital Library
- JavaScript Object Notation. http://www.json.org.Google Scholar
- Kimball, R. and Ross, M. The Datawarehouse Toolkit: Second Edition. John Wiley and Sons Inc., Hoboken, USA, 2002. Google ScholarDigital Library
- Lieberman, H. Your Wish is my Command. Programming By Example. Morgan Kaufmann Publishers. Academic Press, USA, 2001.Google Scholar
- Lieberman, H., Paternò, F., and Wulf, V. (eds). End-User Development. Human Computer Interaction Series. Springer Verlag, 2006. Google ScholarDigital Library
- Lin, H.,Choong, Y., Salvendy, G. A Proposed Index of Usability: A Method for Comparing the Relative Usability of Different Software Systems, Behaviour and Information Technology, Volume 16, Issue 4 & 5, Informaworld, July 1997, pp. 267--277.Google ScholarCross Ref
- Lund, A. Measuring Usability with the USE Questionnaire. Usability and User Experience Special Interest Group, Volume 8, Issue 2, October 2001.Google Scholar
- 1Macías, J.A. and Castells, P. Providing end-user facilities to simplify ontology-driven Web application authoring. Interacting with Computers. Elsevier, Volume 9, Issue 4 (July 2007), 563--585. Google ScholarDigital Library
- Moya, D. and Macías, J.A. Semantic Web Query Authoring for End-Users, in M. A. Redondo, C. Bravo and M. Ortega (eds.), Engineering the User Interface: From Research to Practice. Springer Publisher, New York, USA (2009), 147--160.Google Scholar
- Nielsen, J. Usability Engineering. Morgan Kaufmann Publishers, San Francisco, USA, 1993. Google ScholarDigital Library
- Ramey, J., Cuddihy, E., Dumas, J., Guan, Z., Van, M., Jong, M. Montreal: Does think aloud work?: how do we know. ACM, 2006, CHI '06 extended abstracts on Human factors in computing systems, págs. 45--48. Google ScholarDigital Library
- Rettig, M. Prototyping for tiny fingers. Communications of the ACM, Volume 37, Issue 4 (1994), 21--27. Google ScholarDigital Library
- Spacetree. JavaScript InfoVis Toolkit for information visualization. http://thejit.org/.Google Scholar
- Spago BI QbE Enterprise Scope. http://www.spagobi.org.Google Scholar
- Stolte, C., Tang, D. and Hanrahan, P. Polaris: a system for query, analysis, and visualization of multidimensional databases. Communications of the ACM, Volume 51, Issue 11 (2008), 75--84. Google ScholarDigital Library
- Tableau Desktop. http://www.tableausoftware.com/products/desktopGoogle Scholar
- Zloof, M.M. Query by example. Proceedings of the National Computer Conference. New York, USA, Vol. 44 (1975), 431--438. Google ScholarDigital Library
Index Terms
- Feasible database querying using a visual end-user approach
Recommendations
A visual interface for a database with version management
Special issue: selected papers from the conference on office information systemsThis paper describes a graphical interface to an experimental database system which incorporates a built-in version control mechanism that maintains a history of the database development and changes. The system is an extension of ISIS [6], Interface for ...
Dynamic Queries for Visual Information Seeking
Considers how dynamic queries allow users to "fly through" databases by adjusting widgets and viewing the animated results. In studies, users reacted to this approach with an enthusiasm more commonly associated with video games. Adoption requires ...
Visually modelling data intensive web applications to assist end-user development
VINCI '13: Proceedings of the 6th International Symposium on Visual Information Communication and InteractionDue to problems in correctly understanding user requirements the Information System (IS) development community have recognised the need to involve end-users in the development and maintenance of web applications. End-users perceive web applications ...
Comments