Abstract
This paper provides results from a usability experiment comparing two different database query languages. The research focuses on a specific type of query task, namely classification queries. Classification is the process of assigning input data to discrete classes according to application specific criteria. While SQL can be used to perform classification tasks, we seek to discover whether a different type of query language offers any advantages over SQL. We present a rule-based language, which organizes the queries in a logical way. The rule based language is specifically designed to support classification tasks. The usability experiment measures the effectiveness, efficiency and satisfaction of novice and expert users performing a variety of classification tasks. The results show that while both approaches are usable for classification tasks, the rule-based approach was preferred by expert users.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley, Reading (1995)
Catarci, T.: What happened when database researchers met usability. Information Systems 25(3), 177–212 (2000)
Date, C.J., Darwen, H.: A Guide to the SQL Standard. Addison-Wesley, Reading (1993)
Han, J., Kamber, M.: Data Mining: Concepts and Techniques. Morgan Kaufmann, San Francisco (2001)
Hand, D., Mannila, H., Smyth, P.: Principles of Data Mining. The MIT Press, Cambridge (2001)
Meier, A., Savary, C., Schindler, G., Veryha, Y.: Database schema with fuzzy classification and classification query language. In: Computational Intelligence: Methods and Applications (2001)
Ramakrishnan, R.: Database Management Systems. McGraw-Hill, New York (1998)
Reisner, P.: Human factors studies of database query languages: A survey and assessment. ACM Computing Surveys 13(1), 13–31 (1981)
Reisner, P., Boyce, R., Chamberlin, D.: Human factors evaluation of two database query languages - square and sequel. In: Proceedings of the National Computer Conference, pp. 447–452 (1975)
Vianu, V.: Rule-based languages. Annals of Mathematics and Artificial Intelligence 19, 215–259 (1997)
Welty, C., Stemple, D.: Human factors comparison of a procedural and a nonprocedural query language. ACM Transactions on Database Systems 6(4), 626–649 (1981)
Wright, H., Brodlie, K., Brown, M.: The dataflow visualization pipeline as a problem solving environment. In: Göbel, M., David, J., Slavik, P., van Wijk, J.J. (eds.) Virtual Environments and Scientific Visualization 1996, pp. 267–276. Springer, Heidelberg (1996)
Yen, M., Scamell, R.: A human factors experimental comparison of SQL and QBE. IEEE Transactions on Software Engineering 19(4), 390–402 (1993)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Groth, D.P. (2005). An Evaluation of a Rule-Based Language for Classification Queries. In: Seipel, D., Hanus, M., Geske, U., Bartenstein, O. (eds) Applications of Declarative Programming and Knowledge Management. INAP WLP 2004 2004. Lecture Notes in Computer Science(), vol 3392. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11415763_6
Download citation
DOI: https://doi.org/10.1007/11415763_6
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-25560-4
Online ISBN: 978-3-540-32124-8
eBook Packages: Computer ScienceComputer Science (R0)