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

MIS Quarterly: Management Information Systems

Volumn 30, Issue 2, 2006, Pages 269-290

  Allen, Gove N ^a   March, Salvatore T ^b  

^a TULANE UNIVERSITY   (United States)

^b VANDERBILT UNIVERSITY   (United States)

Author keywords

Artifact based; Data models; Database user view; E R diagram; Event based; Query formulation performance; Sense making; State based

Indexed keywords

DATA REDUCTION; DATA STRUCTURES; DATABASE SYSTEMS; INTERNET; RESOURCE ALLOCATION;

ARTIFACT-BASED; DATABASE USER VIEW; E-R DIAGRAM; EVENT-BASED; QUERY FORMULATION PERFORMANCE; SENSE-MAKING; STATE-BASED;

QUERY LANGUAGES;

EID: 33750169459     PISSN: 02767783     EISSN: None     Source Type: Journal    
DOI: 10.2307/25148731     Document Type: Article

References (55)

1. Antony, S. R., and Batra, D. "CODASYS: A Consulting Tool for Novice Database Designers," ACM SIGMS Database (33:3), Summer 2002, pp. 54-68.
2. Batra, D., Hoffer, J. A., and Bostrom, R. P. "A Comparison of User Performance Between the Relational and the Extended Entity Relationship Models in the Discovery Phase of Database Design," Communications oftheACM (33:2), February 1990, pp. 126-139.
3. Bodart, F., Patel, A., Sim, M., and Weber, R. "Should the Optional Property Construct Be Used in Conceptual Modeling? A Theory and Three Empirical Tests," Information Systems Research (12:4), 2001, pp. 384-405.
4. Borthick, A. F., Bowen, P. L., Jones, D. R., and Tse, M. H. K. "The Effects of Information Request Ambiguity and Construct Incongruence on Query Development," Decision Support Systems (32), 2001, pp. 35-56.
5. th International Conference on Information Systems, R. Agarwal, L. Kirsch, and J.I. DeGross (eds.), Washington, DC, December 12-15, 2004, pp. 77-90.
6. Brody, B.A. Identity and Essence, Princeton University Press, Princeton, NJ, 1980.
7. Bronts, G. H. W. M., Brouwer, S. J., Martens, C. L. J., and Proper, H. A. "A Unifying Object Role Modeling Theory," Information Systems (20:3), 1995, pp. 213-235.
8. Bunge, M. Ontology I: the Furniture of the World, Volume 3 of Treatise on Basic Philosophy, D. Reidel Publishing Company, Boston, MA, 1977.
9. st International Conference on Information Systems, P. De and J. I. DeGross (eds.), Charlotte, NC, December 13-15, 1999, pp. 214-228.
10. Chan, H. C., Wei, K. K., and Siau, K. L. "User-Database Interface: The Effect of Abstraction Levels on Query Performance," MIS Quarterly (17:4), December 1993, pp. 441-464.
11. Chen, P. P. S. "The Entity-Relationship Model-Toward a Unified View," ACM Transactions on Database Systems (1:1), 1976, pp. 9-36.
12. Chiang, R. H. L., Barren, T. M., and Storey, V. C. "Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database," Data and Knowledge Engineering (12), 1994, pp. 107-142.
13. Denna, E. L., Cherrington, J. O., Andres, D. P., and Hollander, A. S. Event-Driven Business Solutions: Today's Revolution in Business and Information Technology, Business One Irwin, HomewoodlL, 1993.
14. Dey, D., Barren, T., and Storey, V. "A Conceptual Model for the Logical Design of Temporal Databases," Decision Support Systems (15), 1995, pp. 305-321.
15. Feibleman, J. K. Ontology, The Johns Hopkins Press, Baltimore, MD, 1951.
16. Gee, J. P. "The Narrativization of Experience in the Oral Style," Journal of Education (167), 1985, pp. 9-35.
17. Geerts, G. L., and McCarthy, W. E. "An Ontological Analysis of the Economic Primitives of the Extended-REA Enterprise Information Architecture," Internationaljournal of Accounting Information Systems (3:1), March 2002, pp. 1-16.
18. Gemino, A., and Wand, Y. "Complexity and Clarity in Conceptual Modeling: Comparison of Mandatory and Optional Properties," Data and Knowledge Engineering (55:3), December 2005, pp. 301-326.
19. Goodhue, D. L., Klein, B. D., and March, S. T. "User Evaluations of IS as Surrogates for Objective Performance," Information and Management (38), 2000, pp. 87-101.
20. Gray, P., and Watson, H. J. Decision Support in the Data Warehouse, Prentice Hall, Upper Saddle River, NJ, 1998.
21. Halevy, A. Y. "Answering Queries Using Views: A Survey," The VLDB Journal (10), 2001, pp. 270-294.
22. rd ed.), Morgan Kauffmann, San Francisco, 2001.
23. th ed.), Prentice Hall, Upper Saddle River, NJ, 2002.
24. nd ed.), McGraw-Hill/Irwin, Boston, MA, 1999.
25. Jih, W. J., Bradbard, D. A., Snyder, C. A., Thompson, N. G. "The Effects of Relational and Entity-Relationship Data Models on Query Performance of End Users," Internationaljournal of Man-Machine Studies (31:3), 1989, pp. 257-267.
26. Kent, W. Data and Reality, Elsevier Science Limited, Amsterdam, 1978.
27. Kim, Y. G., and March, S. T. "Comparing Data Modeling Formalisms," Communications of the ACM (38:6), June 1995, pp. 103-115.
28. Lakoff, G. Women, Fire and Dangerous Things: What Categories Reveal about the Mind, University of Chicago Press, Chicago, IL, 1987.
29. Leitheiser, R. L., and March, S. T. "The Influence of Database Structure Representation on Database System Learning and Use," Journal of Management Information Systems (12:4), Spring, 1996, pp 187-213.
30. Markowitz, V. M., and Shoshani, A. "Representing Extended Entity-Relationship Structures in Relational Databases: A Modular Approach," ACM Transactions on Database Systems (17:3), September 1992, pp. 423-464.
31. McCarthy, W. E. "The REA Accounting Model: A General Framework for Accounting Systems in a Shared Data Environment," The Accounting Review (57:3), July 1982, pp 554-578.
32. MicroStrategy, Inc. MicroStrategy 7i Sales Analysis Module Reference Guide (Version 7.2.3), 2003 (available online at http://www. teradatastudentnetwork.com/, accessed April 1, 2004).
33. Nyberg, L. "Mapping Episodic Memory," Behavioral Brain Research (90), 1998, pp. 107-114.
34. Orr, J. "Sharing Knowledge, Celebrating Identity: Community Memory in a Service Culture," in Collective Remembering, D. Middleton and D. Edwards (eds.), Sage Publications. Newbury Park, CA, 1990.
35. Parsons, J., and Wand, Y. "Emancipating Instances from the Tyranny of Classes in Information Modeling," ACM Transactions on Database Systems (25:2), June 2000, pp. 228-268.
36. Pillemer, D. B. Momentous Events, Vivid Memories, Harvard University Press, Cambridge, MA, 1998.
37. Ramesh, V., and Browne, G. "Expressing Casual Relationships in Conceptual Database Schema," The Journal of Systems and Software (45), 1999, pp. 225-232.
38. Robinson, J. A., and Hawpe, L. "Narrative Thinking as a Heuristic Process," in Narrative Psychology: The Storied Nature of Human Conduct, T. R. Sarbin (ed.), Prager Publishers, New York, 1986.
39. Rosenthal, A., and Reiner, D. "Tools and Transformations-Rigorous and Otherwise-for Practical Database Design," ACM Transactions on Database Systems (19:2), June 1994, pp. 167-211.
40. Shasha, D. "Tuning Databases for High Performance," ACM Computing Surveys (28:1), March 1996, pp. 113-115.
41. Shepard, R. N. "Evolution of a Mesh between Principles of the Mind and Regularities of the World," in The Latest on the Best, J. Dupre (ed.), The MIT Press, Cambridge, MA, 1987.
42. Siau, K. L., Chan, H. C., and Wei, K. K. "Effect of Query Complexity and Learning on Novice User Query Performance with Conceptual and Logical Database Interface," IEEE Transactions on Systems, Man, and Cybernetics: Part A (34:2), March 2004, pp. 276-282.
43. Silberschatz, A., and Korth, H. F. "Data Models," ACM Computing Surveys (28:1), March 1996, pp. 105-108.
44. th International Conference on Information Systems, P. De and J. I. DeGross (eds.), Charlotte, NC, December 12-15, 1999, pp. 229-244.
45. Sowa, J. F. Knowledge Representation: Logical, Philosophical, and Computational Foundations, Brooks/Cole Publishing, Pacific Grove, CA, 1999.
46. Speier, C., and Morris, M. G. "The Influence of Query Interface Design on Decision-Making Performance," MIS Quarterly (27:3), September 2003, pp. 397-423.
47. Teorey, T. J., Yang, D., and Fry, J. P. "A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model," ACM Computing Surveys (18:2), June 1986, pp. 197-222.
48. Tiles, J. E. Things that Happen, Aberdeen University Press, Aberdeen, Scotland, 1981.
49. Tulving, E. Elements of Episodic Memory, Oxford University Press, New York, 1983.
50. Tulving, E. "Episodic Memory: From Mind to Brain," Annual Review of Psychology (53), 2002, pp. 1-25.
51. Wand, Y., Storey, V. C., and Weber, R. "An Ontological Analysis of the Relationship Construct in Conceptual Modeling," ACM Transactions on Database Systems (24:4), December 1999, pp. 494-528.
52. Wand, Y., and Weber, R. "On the Deep Structure of Information Systems," Information Systems Journal (5), 1995, pp. 203-233.
53. Wand, Y., and Weber, R. "Research Commentary: Information Systems and Conceptual Modeling: A Research Agenda," Information Systems Research (13:4) December 2002, pp. 363-376.
54. th International Conference on Information Systems, J. I. DeGross, I. Benbasat, G. DeSanctis, and C. M. Beath (eds.), New York, December 16-18, 1991, pp 75-82.
55. Yates, J. F. Judgment and Decision Making, Prentice-Hall, Englewood Cliffs, NJ, 1990.