Effects of query complexity and learning on novice user query performance with conceptual and logical database interfaces

Authors:
K. L. Siau;Hock Chuan Chan;Kwok Kee Wei
Affiliations:
Dept. of Manage., Univ. of Nebraska, Lincoln, USA;-;-
Venue:
IEEE Transactions on Systems, Man, and Cybernetics, Part A: Systems and Humans
Year:
2004

Citing 0
Cited 6

Mutating database queries

Information and Software Technology
Selecting optimal instantiations of data models: theory and validation of an ex ante approach

Decision Support Systems
A controlled experiment on white-box database testing

ACM SIGSOFT Software Engineering Notes
An Empirical Investigation of End-User Query Development: The Effects of Improved Model Expressiveness vs. Complexity

Information Systems Research
The effects of state-based and event-based data representation on user performance in query formulation tasks

MIS Quarterly
The problem of conceptual incompatibility: exploring the potential of conceptual data independence to ease data integration

ARES'11 Proceedings of the IFIP WG 8.4/8.9 international cross domain conference on Availability, reliability and security for business, enterprise and health information systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

Users see the database interface as the database system. A good interface enables them to formulate queries better. The semantics communicated through the interface can be classified according to abstraction levels, such as the conceptual and logical levels. With the conceptual interface, interaction is in terms of real-world concepts such as entities, objects and relationships. Current user-database interaction is mainly based on the logical interface, where interaction is in terms of abstract database concepts such as relations and joins. Many researchers argue that end users will perform better with the conceptual interface. This research tested this claim, as well as the effects of query complexity and learning, on the visual query performance of users. The experiment involved three tests: an initial test, a retention test and a relearning test. The results showed that, for complex queries, conceptual interface users achieved higher accuracy, were more confident in their answers, and spent less time on the queries. This is persistent across retention and relearning tests.