Relational model vs. dimensional model-further experimentation on understandability of the two schemas
Data warehouse (DW) has been commonly accepted as a solution to support organization’s decision support. Despite technical aspects of DW implementation, one of the most important tasks that need to be considered is its data modeling. Data modeling is important as it deals with structuring the data s...
| Main Authors: | , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
2014
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/38828/ http://psasir.upm.edu.my/id/eprint/38828/1/38828.pdf |
| _version_ | 1848848981004648448 |
|---|---|
| author | Mat Yusof, Sharmila Sidi, Fatimah |
| author_facet | Mat Yusof, Sharmila Sidi, Fatimah |
| author_sort | Mat Yusof, Sharmila |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | Data warehouse (DW) has been commonly accepted as a solution to support organization’s decision support. Despite technical aspects of DW implementation, one of the most important tasks that need to be considered is its data modeling. Data modeling is important as it deals with structuring the data so that users can easily access for decision support process. The two predominant data models in data warehouse project are dimensional model (i.e. Star Schema Diagram (SSD)) and relational model (i.e. Entity-Relationship Diagram (ERD)). The decision whether to build a data warehouse using either model has created controversy among practitioners. Semantic network theory support that SSD is better than ERD in terms of its understanding measures. However, previous studies have produced conflicting result regarding the support and claim. Thus, the objective of this study is to further explore whether one schema is better than another in terms of its understandability. This study aims to design and conduct an experiment that test the understandability of the SSD and ERD with schema complexity factor. |
| first_indexed | 2025-11-15T09:43:08Z |
| format | Conference or Workshop Item |
| id | upm-38828 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T09:43:08Z |
| publishDate | 2014 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-388282016-07-29T08:09:28Z http://psasir.upm.edu.my/id/eprint/38828/ Relational model vs. dimensional model-further experimentation on understandability of the two schemas Mat Yusof, Sharmila Sidi, Fatimah Data warehouse (DW) has been commonly accepted as a solution to support organization’s decision support. Despite technical aspects of DW implementation, one of the most important tasks that need to be considered is its data modeling. Data modeling is important as it deals with structuring the data so that users can easily access for decision support process. The two predominant data models in data warehouse project are dimensional model (i.e. Star Schema Diagram (SSD)) and relational model (i.e. Entity-Relationship Diagram (ERD)). The decision whether to build a data warehouse using either model has created controversy among practitioners. Semantic network theory support that SSD is better than ERD in terms of its understanding measures. However, previous studies have produced conflicting result regarding the support and claim. Thus, the objective of this study is to further explore whether one schema is better than another in terms of its understandability. This study aims to design and conduct an experiment that test the understandability of the SSD and ERD with schema complexity factor. 2014 Conference or Workshop Item NonPeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/38828/1/38828.pdf Mat Yusof, Sharmila and Sidi, Fatimah (2014) Relational model vs. dimensional model-further experimentation on understandability of the two schemas. In: Malaysian National Conference of Databases 2014 (MaNCoD 2014), 17 Sept. 2014, Universiti Putra Malaysia, Serdang, Selangor. (pp. 40-45). (Unpublished) http://mancod2014.blogspot.my/p/proceedings.html |
| spellingShingle | Mat Yusof, Sharmila Sidi, Fatimah Relational model vs. dimensional model-further experimentation on understandability of the two schemas |
| title | Relational model vs. dimensional model-further experimentation on understandability of the two
schemas |
| title_full | Relational model vs. dimensional model-further experimentation on understandability of the two
schemas |
| title_fullStr | Relational model vs. dimensional model-further experimentation on understandability of the two
schemas |
| title_full_unstemmed | Relational model vs. dimensional model-further experimentation on understandability of the two
schemas |
| title_short | Relational model vs. dimensional model-further experimentation on understandability of the two
schemas |
| title_sort | relational model vs. dimensional model-further experimentation on understandability of the two
schemas |
| url | http://psasir.upm.edu.my/id/eprint/38828/ http://psasir.upm.edu.my/id/eprint/38828/ http://psasir.upm.edu.my/id/eprint/38828/1/38828.pdf |