Is query reuse potentially harmful? Anchoring and adjustment in adapting existing database queries

Information Systems Research

Volumn 21, Issue 1, 2010, Pages 56-77

  Allen, Gove ^a   Parsons, Jeffrey ^b  

^a BRIGHAM YOUNG UNIVERSITY   (United States)

^b MEMORIAL UNIVERSITY OF NEWFOUNDLAND   (Canada)

Author keywords

Anchoring and adjustment; Query formulation; Reuse; SQL

Indexed keywords

ANCHORS; QUERY PROCESSING;

ANCHORING AND ADJUSTMENT; ATTRACTIVE STRATEGIES; DOMAIN FAMILIARITIES; EXTRACTING INFORMATION; INFORMATION REQUEST; QUERY FORMULATION; REUSE; STRUCTURED QUERY LANGUAGES;

QUERY LANGUAGES;

EID: 77954305944     PISSN: 10477047     EISSN: 15265536     Source Type: Journal    
DOI: 10.1287/isre.1080.0189     Document Type: Article

References (44)

1. Allen, G., S. March. 2006. The effects of state-based and event-based data representations on user performance in query formulation tasks. MIS Quart. 30(2) 269-290.
2. Anderson, J. R. 1993. Problem solving and learning. Amer. Psychologist 48(1) 35-44.
3. Batra, D., J. Hoffer, R. Bostrom. 1990. A comparison of user performance between the relational and the extended entity relationship models in the discovery phase of database design. Comm. ACM 33(2) 126-139.
4. Borthick, A., P. Bowen, D. Jones, M. Tse. 2001. The effects of information request ambiguity and construct incongruence on query development. Decision Support Systems 32 33-56.
5. Bowen, P., R. O'Farrell, F. Rohde. 2006. Analysis of competing data structures: Does ontological clarity produce better end user query performance? J. Assoc. Inform. Systems 7(8) 514-544.
6. Burton-Jones, A., R. Weber. 1999. Understanding relationships with attributes in entity-relationship diagrams. Proc. Twentieth Internat. Conf. Inform. Systems, 214-228.
7. Chan, C., K. K. Wei, K. Siau. 1993. User-database interface: The effect of abstraction levels on query performance. MIS Quart. 17(4) 441-464.
8. Cox, B. 1990. Planning the software industrial revolution. IEEE Software 7(6) 25-33.
9. Dettinger, R., R. Stevens, J. Tenner. 2004. SQL query construction using durable query components. United States Patent Application 20040068489. Retrieved February 2, 2008, http://www.uspto.gov.
10. Dettinger, R., J. Glowacki, D. Kolz, P. Rao, M. Sperber, S. Wenzel. 2007. Query reuse through recommend parameter flexibility. United States Patent Application 20070276825. Retrieved February 2, 2008, http://www.uspto.gov.
11. Edlund, S., M. Emens, R. Kraft, P. Yim. 2002. Labeling and describing search queries for reuse. United States Patent 6,484,162. Retrieved February 2, 2008, http://www.uspto.gov.
12. Epley, N., T. Gilovich. 2006. The anchoring-and-adjustment heuristic: Why adjustments are insufficient. Psych. Sci. 17(4) 311-318.
13. Fagan, M., S. Corley. 1998. CBR for the reuse of corporate SQL knowledge. Eur. Workshop on Case Based Reasoning m1poi.-1.lparenoriEWCBR'98m1poi.-1.rparenori, Dublin, Ireland, Lecture Notes in Artificial Intelligence, Vol. 1488, 382-392.
14. Fichman, R., C. F. Kemerer. 1997. Object technology and reuse: Lessons from early adopters. IEEE Comput. 30(10) 47-59.
15. Fischhoff, B., S. Lichtenstein. 1977. Do those who know more also know more about how much they know? The calibration of probability judgments. Organ. Behav. Human Performance 20(2) 159-183.
16. Frakes, W. B., G. Succi. 2001. An industrial study of reuse, quality and productivity. J. Systems Software 57(2) 99-106.
17. Frakes, W. B., C. Terry. 1996. Software reuse: Metrics and models. ACM Comput. Surveys 28(2) 415-435.
18. George, J. F., K. Duffy, M. Ahuja. 2000. Countering the anchoring and adjustment bias with decision support systems. Decision Support Systems 29 195-206.
19. Greenwald, A. G. 1976. Within-subjects designs: To use or not to use. Psych. Bull. 83(2) 314-320.
20. Griss, M. 1993. Software reuse: From library to factory. IBM Systems J. 32(4) 548-566.
21. Irwin, G. 2002. The role of similarity in the reuse of object-oriented analysis models. J. Management Inform. Systems 19(2) 221-250.
22. Johnson, E. J., J. W. Payne. 1985. Effort and accuracy in choice. Management Sci. 31(4) 395-414.
23. Khatri, V., I. Vessey, V. Ramesh, P. Clay, S. Park. 2006. Understanding conceptual schemas: Exploring the role of application and IS domain knowledge. Inform. Systems Res. 17(3) 81-99.
24. Kim, Y., E. A. Stohr. 1998. Software reuse: Survey and research directions. J. Management Inform. Systems 14(4) 113-147.
25. Leitheiser, R., S. March. 1996. The influence of database structure representation on database system learning and use. J. Management Inform. Systems 12(4) 187-213.
26. Li, G., L. Zhang, B. Xie, W. Shao. 2006. Shortening retrieval sequences in browsing-based component retrieval using information entropy. J. Systems and Software 79(2) 216-230.
27. Lim, W. 1994. Effects of reuse on quality, productivity, and economics. IEEE Software 11(5) 23-30.
28. Mili, H., F. Mili, A. Mili. 1995. Reusing software: Issues and research directions. IEEE Trans. Software Engrg. 21(6) 528-561.
29. Morisio, M., M. Erzan, C. Tully. 2002. Success and failure factors in software reuse. IEEE Trans. Software Engrg. 28(4) 340-357.
30. Ogden, W. C. 1985. Implications of a cognitive model of database query: Comparison of a natural language, a formal language, and direct manipulation interface. ACM SIGCHI Bull. 18(2) 51-54.
31. Oussalah, C., A. Seriai. 2000a. How to reuse former queries to facilitate the formulation of new ones. Proc. Internat. Database Engrg. Appl. Sympos. (Ideas'00),Yokohama, Japan, 92-100.
32. Oussalah, C., A. Seriai. 2000b. A reuse-based object-oriented framework towards easy formulation of complex queries. Proc. Internat. Conf. Conceptual Modeling (ER2000), Springer, Berlin, 470-483.
33. Parsons, J., L. Cole. 2005. What do the pictures mean? Guidelines for experimental evaluation of representation fidelity in diagrammatical conceptual modeling techniques. Data Knowledge Engrg. 55(3) 327-342.
34. Parsons, J., C. Saunders. 2004. Cognitive heuristics in software engineering: Applying and extending anchoring and adjustment to artifact reuse. IEEE Trans. Software Engrg. 30(12) 873-888.
35. Pittman, M. 1993. Lessons learned in managing object-oriented development. IEEE Software 10(1) 43-53.
36. Plous, S. 1993. The Psychology of Judgment and Decision Making. McGraw-Hill, New York.
37. Purao, S., V. Storey, T. Han. 2003. Improving pattern reuse in conceptual design: Augmenting automated processes with supervised learning. Inform. Systems Res. 14(3) 269-290.
38. Robinson, M., J. Johnson, F. Herndon. 1997. Reaction time and assessments of cognitive effort as predictors of eyewitness memory accuracy and confidence. J. Appl. Psych. 82(3) 416-425.
39. Speier, C., M. Morris. 2003. The influence of query interface design on decision-making performance. MIS Quart. 27(3) 397-423.
40. Stacy, W., J. MacMillan. 1995. Cognitive bias in software engineering. Comm. ACM 38(6) 57-69.
41. Succi, G., L. Benedicenti, T. Vernazza. 2001. Analysis of the effects of software reuse on customer satisfaction in an RPG environment. IEEE Trans. Software Engrg. 27(5) 473-479.
42. Tversky, A., D. Kahneman. 1974. Judgment under uncertainty: Heuristics and biases. Science 185(4157) 1124-1131.
43. Wright, W. F., U. Anderson. 1989. Effects of situation familiarity and financial incentives on use of the anchoring and adjustment heuristic for probability assessment. Organ. Behav. Human Decision Processes 44(1) 68-82.
44. Yates, J. 1990. Judgment and Decision Making. Prentice-Hall, Englewood Cliffs, NJ.