The impact of alternative diagrams on the accuracy of recall: A comparison of star-schema diagrams and entity-relationship diagrams

Decision Support Systems

Volumn 42, Issue 1, 2006, Pages 450-468

  Corral, Karen ^a   Schuff, David ^b   St Louis, Robert D ^a  

^a ARIZONA STATE UNIVERSITY   (United States)

^b TEMPLE UNIVERSITY   (United States)

Author keywords

Data modeling; Data warehouse; Entity relationship diagram; Gestalt theory; Semantic network theory; Star schema diagram

Indexed keywords

DATA REDUCTION; DECISION MAKING; DECISION SUPPORT SYSTEMS; INFORMATION TECHNOLOGY; RELATIONAL DATABASE SYSTEMS; SEMANTICS;

DATA MODELING; ENTITY-RELATIONSHIP DIAGRAM; GESTALT THEORY; SEMANTIC NETWORK THEORY; STAR-SCHEMA DIAGRAM;

DATA WAREHOUSES;

EID: 33748049443     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2005.02.003     Document Type: Article

References (41)

1. Anderson J.R. Cognitive Psychology and its Implications. 3rd ed. (1990), W.H. Freeman and Co., New York
2. Ang J., and Teo T.S.H. Management issues in data warehousing: insights from the housing and development board. Decision Support Systems 29 1 (2000) 11-20
3. Ashcraft M.H. Human Memory and Cognition (1989), Scott, Foresman and Co., Glenview, IL
4. Baddeley A. The magical number seven: still magic after all these years?. Psychological Review 101 2 (1994) 353-356
5. Batra D., Hoffer J.A., and Bostrom R.P. Comparing representations with relational and EER models. Communications of the ACM 33 2 (1990) 126-139
6. Berndt D.J., Hevner A.R., and Studnicki J. The catch data warehouse: support for community health care decision-making. Decision Support Systems 35 3 (2003) 367-384
7. Bischoff J., and Alexander T. Data Warehouse: Practical Advice from the Experts (1997), Prentice-Hall, Upper Saddle River, NJ
8. Brosey M., and Shneiderman B. Two experimental comparisons of relational and hierarchical database models. International Journal of Man-Machine Studies 10 5 (1978) 625-637
9. Camerer C.F., and Hogarth R.M. The effects of financial incentives in experiments: a review and capital-labor-production framework. Journal of Risk and Uncertainty 19 1-3 (1999) 7-42
10. Collins A.M., and Quillian M.R. How to make a language user. In: Tulving E., and Donaldson W. (Eds). Organization of Memory (1972), Academic Press, NewYork 309-351
11. Cooper B.L., Watson H.J., Wixom B.H., and Goodhue D.L. Data warehousing supports corporate strategy at First American Corporation. MIS Quarterly 24 4 (2000) 547-567
12. DeSanctis G. Computer graphics as research aids: directions for research. Decision Sciences 15 4 (1984) 463-487
13. Glassey K. Seducing the end user. Communications of the ACM 41 9 (1998) 62-69
14. Hastie R., and Dawes R.M. Rational Choice in an Uncertain World: Psychology of Judgment and Decision Making (2001), Sage, Thousand Oaks, CA
15. Herman I., Melancon G., and Marshall M.S. Graph visualization and navigation in information visualization: a survey. IEEE Transactions on Visualization and Computer Graphics 6 1 (2000) 24-43
16. Hoffer J.A. An empirical investigation into individual differences in database models. In: Ginzberg M., and Ross C.A. (Eds). Proceedings of the Third International Conference on Information Systems (1982), Ann Arbor, MI 153-167
17. Inmon W.H., Imhoff C., and Sousa R. Corporate Information Factory (1998), Wiley, New York
18. R. Kimball, A dimensional modeling manifesto, DBMSmag.com, http://www.dbmsmag.com/9708d15.html (1997).
19. Kirk R.E. Experimental Design: Procedures for the Behavioral Sciences. 2nd ed. (1982), Brooks/Cole, Belmont, CA
20. Larkin J.H., and Simon H.A. Why a diagram is (sometimes) worth ten thousand words. Cognitive Science 11 1 (1987) 65-99
21. 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 (1996) 187-213
22. Lochovsky F.H., and Tsichritzis D.C. User performance considerations in DBMS selection. Proceedings of ACM SIGMOD (1997) 128-134 Toronto, Ontario, Canada
23. Loeb K., Rai A., Ramaprasad A., and Sharma S. Design, development and implementation of a global information warehouse: a case study at IBM. Information Systems Journal 8 4 (1998) 291-311
24. Mandler G. Organization in Memory. In: Spence K.W., and Spence J.T. (Eds). The Psychology of Learning and Motivation: Advances in Research and Theory vol. 1 (1967) 327-372
25. Miller G.A. The magical number seven, plus or minus two: some limits on our capacity for processing information. Psychology Review 63 2 (1956) 81-97
26. Nilsson L.-G. Motivated memory: dissociation between performance data and subjective reports. Psychological Research 49 2-3 (1987) 183-188
27. Parkes C. Data warehousing: the economy isn't the only reason the data warehouse is stumbling. Enterprise Systems (2002). www.esj.com/Departments/article.asp?EditorialsID=51
28. Plott C.R. Rational choice in experimental markets. In: Hogarth R.M., and Reder M.W. (Eds). Rational Choice: The Contrast Between Economics and Psychology (1987), University of Chicago Press
29. Reisner P. Human factors studies of database query languages: a survey and assessment. Computing Surveys 13 1 (1981) 13-31
30. Sachs J.S. Recognition memory for syntactic and semantic aspects of connected discourse. Perception & Psychophysics 2 9 (1967) 437-442
31. Shanks G., and Darke P. Understanding corporate data models. Information and Management 35 1 (1999) 19-30
32. Shneiderman B. Measuring computer program quality and comprehension. International Journal of Man-Machine Studies 9 4 (1977) 465-478
33. Simon H.A. How big is a chunk?. Science 183 4124 (1974) 482-488
34. Smelcer J.B., and Carmel E. The effectiveness of different representations for managerial problem solving: comparing tables and maps. Decision Sciences 28 2 (1997) 391-420
35. Smith V.L. Rational choice: the contrast between economics and psychology. Journal of Political Economy 99 4 (1991) 877-897
36. Smith V.L., and Walker J.M. Rewards, experience and decision costs in first price auctions. Economic Inquiry 31 (1993) 237-244
37. Tabachnick B., and Fidell L. Using Multivariate Statistics (1983), Harper Collins, New York
38. Tan J.H.K., and Benbasat I. The effectiveness of graphical presentation for information extraction: a cumulative experimental approach. Decision Sciences 24 1 (1993) 167-191
39. Weber R. Are attributes entities? a study of database designers' memory structures. Information Systems Research 7 2 (1996) 137-162
40. Wertheimer M. Gestalt theory. Social Research 11 (1924). http://gestalttheory.net/archive/wert1.html http://gestalttheory.net/archive/wert1.html
41. Wixom B.H., and Watson H.J. An empirical investigation of the factors affecting data warehousing success. MIS Quarterly 25 1 (2001) 17-41