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

Authors:
Karen Corral;David Schuff;Robert D. St. Louis
Affiliations:
Arizona State University, Department of Information Systems, AZ;School of Business and Management, Temple University, Philadelphia, PA;Arizona State University, Department of Information Systems, AZ
Venue:
Decision Support Systems
Year:
2006

Citing 14
Cited 4

Comparing representations with relational and EER models

Communications of the ACM
A dimensional modeling manifesto

DBMS - Special issue on data warehousing
Data warehouse: practical advice from the experts

Data warehouse: practical advice from the experts
Seducing the end user

Communications of the ACM
Understanding corporate data models

Information and Management
Management issues in data warehousing: insights from the housing and development board

Decision Support Systems
Human Factors Studies of Database Query Languages: A Survey and Assessment

ACM Computing Surveys (CSUR)
User performance considerations in DBMS selection

SIGMOD '77 Proceedings of the 1977 ACM SIGMOD international conference on Management of data
Corporate Information Factory

Corporate Information Factory
Graph Visualization and Navigation in Information Visualization: A Survey

IEEE Transactions on Visualization and Computer Graphics
The Catch data warehouse: support for community health care decision-making

Decision Support Systems
The influence of database structure representation on database system learning and use

Journal of Management Information Systems
Data warehousing supports corporate strategy at first American corporation1,2

MIS Quarterly
An empirical investigation of the factors affecting data warehousing success

MIS Quarterly

A systematic approach for transformation of ER schema to dimensional schema

Proceedings of the 7th International Conference on Frontiers of Information Technology
Comparing the understandability of alternative data warehouse schemas: An empirical study

Decision Support Systems
A comparison of the usability of performing ad hoc querying on dimensionally modeled data versus operationally modeled data

Decision Support Systems
A study on the effects of routing symbol design on process model comprehension

Decision Support Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

Data warehouses can be constructed using either a relational or a dimensional model. This research compares the diagrammatic representations of these two models. Semantic network theory suggests that, because of their structure, star-schema diagrams (SSDs) are more understandable than entity-relationship diagrams (ERDs). Through two experiments that test both the accuracy and pattern of users' recall, we find strong evidence that SSDs are easier to understand than ERDs. Our findings imply that the use of the dimensional model should help decision makers query the warehouse directly, thereby reducing costs and the need for intervention and support by IT professionals.