Comparing the understandability of alternative data warehouse schemas: An empirical study

Authors:
David Schuff;Karen Corral;Ozgur Turetken
Affiliations:
Department of Management Information Systems, Fox School of Business, Temple University, 207G Speakman Hall, 1810 North 13th Street, Philadelphia, PA 19122, United States;Department of Information Technology and Supply Chain Management, College of Business and Economics, Boise State University, United States;Ted Rogers School of Information Technology Management, Ryerson University, Canada
Venue:
Decision Support Systems
Year:
2011

Citing 16
Cited 2

Comparing representations with relational and EER models

Communications of the ACM
Task-technology fit and individual performance

MIS Quarterly
An experimental investigation of the interactive effects of interface style, instructions, and task familiarity on user performance

ACM Transactions on Computer-Human Interaction (TOCHI)
Browsing and querying in online documentation: a study of user interfaces and the interaction process

ACM Transactions on Computer-Human Interaction (TOCHI)
The effects of decision support and task contingencies on model formulation: a cognitive perspective

Decision Support Systems - Special issue: DSS on model formulation
A dimensional modeling manifesto

DBMS - Special issue on data warehousing
Adoption and implementation of CASE tools in Taiwan

Information and Management
On user criteria for data model evaluation

ACM Transactions on Database Systems (TODS)
Why are some diagrams easier to work with? Effects of diagrammatic representation on the cognitive intergration process of systems analysis and design

ACM Transactions on Computer-Human Interaction (TOCHI)
Document clustering for electronic meetings: an experimental comparison of two techniques

Decision Support Systems - From information retrieval to knowledge management: enabling technologies and best practices
Modeling strategies and alternatives for data warehousing projects

Communications of the ACM - Supporting exploratory search
The influence of database structure representation on database system learning and use

Journal of Management Information Systems
Information overload: addressing the productivity paradox in face-to-face electronic meetings

Journal of Management Information Systems - Special section: Exploring the outlands of the MIS discipline
The impact of alternative diagrams on the accuracy of recall: a comparison of star-schema diagrams and entity-relationship diagrams

Decision Support Systems
A multi-attribute, multi-weight clustering approach to managing ";e-mail overload"

Decision Support Systems
The influence of query interface design on decision-making performance

MIS Quarterly

Complexity metric for multidimensional models for data warehouse

Proceedings of the CUBE International Information Technology Conference
Effective data warehouse for information delivery: a literature survey and classification

International Journal of Networking and Virtual Organisations

Quantified Score

Hi-index	0.00

Visualization

Abstract

An easily understood data warehouse model enables users to better identify and retrieve its data. It also makes it easier for users to suggest changes to its structure and content. Through an exploratory, empirical study, we compared the understandability of the star and traditional relational schemas. The results of our experiment contradict previous findings and show schema type did not lead to significant performance differences for a content identification task. Further, the relational schema actually led to slightly better results for a schema augmentation task. We discuss the implications of these findings for data warehouse design and future research.