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.
Schuff, David; Corral, Karen; and Turetken, Ozgur. (2011). "Comparing the Understandability of Alternative Data Warehouse Schemas: An Empirical Study". Decision Support Systems, 52(1), 9-20. http://dx.doi.org/10.1016/j.dss.2011.04.003