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.
Original language | English (US) |
---|---|
Pages (from-to) | 450-468 |
Number of pages | 19 |
Journal | Decision Support Systems |
Volume | 42 |
Issue number | 1 |
DOIs | |
State | Published - Oct 2006 |
Keywords
- Data modeling
- Data warehouse
- Entity-relationship diagram
- Gestalt theory
- Semantic network theory
- Star-schema diagram
ASJC Scopus subject areas
- Management Information Systems
- Information Systems
- Developmental and Educational Psychology
- Arts and Humanities (miscellaneous)
- Information Systems and Management