Data warehouse conceptual design - a literature survey
Data Warehouse (DW) can provide an excellent approach in transforming Online Transaction Processing (OLTP) data into useful and reliable information to support organization’s decision making. As such, it can be a basis for data analysis techniques such as multidimensional analysis and data mining. H...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Medwell Journals
2017
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/61280/ http://psasir.upm.edu.my/id/eprint/61280/1/DATA.pdf |
| _version_ | 1848854381384957952 |
|---|---|
| author | Mat Yusof, Sharmila Sidi, Fatimah Ibrahim, Hamidah Affendey, Lilly Suriani |
| author_facet | Mat Yusof, Sharmila Sidi, Fatimah Ibrahim, Hamidah Affendey, Lilly Suriani |
| author_sort | Mat Yusof, Sharmila |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | Data Warehouse (DW) can provide an excellent approach in transforming Online Transaction Processing (OLTP) data into useful and reliable information to support organization’s decision making. As such, it can be a basis for data analysis techniques such as multidimensional analysis and data mining. However, DW design process has been known as a complex task that requires systematic and structured approach to guarantee its success. Therefore, there have been various methodologies proposed to carry out the design process which can be classified into requirement-driven, data-driven and hybrid approaches. In this study, a literature survey was made to obtain related works by a set of pertinent key words related to DW conceptual design. The objective of this survey is to provide the state of the art of DW conceptual design methodologies in narrative and summarized forms. The main contribution is to provide understanding of the trend, issues and solutions proposed to date in DW conceptual design and along the way to discover the novel and great contribution works that form an important basis in the DW conceptual design. |
| first_indexed | 2025-11-15T11:08:58Z |
| format | Article |
| id | upm-61280 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T11:08:58Z |
| publishDate | 2017 |
| publisher | Medwell Journals |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-612802021-07-17T22:39:30Z http://psasir.upm.edu.my/id/eprint/61280/ Data warehouse conceptual design - a literature survey Mat Yusof, Sharmila Sidi, Fatimah Ibrahim, Hamidah Affendey, Lilly Suriani Data Warehouse (DW) can provide an excellent approach in transforming Online Transaction Processing (OLTP) data into useful and reliable information to support organization’s decision making. As such, it can be a basis for data analysis techniques such as multidimensional analysis and data mining. However, DW design process has been known as a complex task that requires systematic and structured approach to guarantee its success. Therefore, there have been various methodologies proposed to carry out the design process which can be classified into requirement-driven, data-driven and hybrid approaches. In this study, a literature survey was made to obtain related works by a set of pertinent key words related to DW conceptual design. The objective of this survey is to provide the state of the art of DW conceptual design methodologies in narrative and summarized forms. The main contribution is to provide understanding of the trend, issues and solutions proposed to date in DW conceptual design and along the way to discover the novel and great contribution works that form an important basis in the DW conceptual design. Medwell Journals 2017 Article PeerReviewed text en http://psasir.upm.edu.my/id/eprint/61280/1/DATA.pdf Mat Yusof, Sharmila and Sidi, Fatimah and Ibrahim, Hamidah and Affendey, Lilly Suriani (2017) Data warehouse conceptual design - a literature survey. Journal of Engineering and Applied Sciences, 12 (16). 4208 - 4214. ISSN 1816-949X; ESSN: 1818-7803 https://medwelljournals.com/abstract/?doi=jeasci.2017.4208.4214 10.36478/jeasci.2017.4208.4214 |
| spellingShingle | Mat Yusof, Sharmila Sidi, Fatimah Ibrahim, Hamidah Affendey, Lilly Suriani Data warehouse conceptual design - a literature survey |
| title | Data warehouse conceptual design - a literature survey |
| title_full | Data warehouse conceptual design - a literature survey |
| title_fullStr | Data warehouse conceptual design - a literature survey |
| title_full_unstemmed | Data warehouse conceptual design - a literature survey |
| title_short | Data warehouse conceptual design - a literature survey |
| title_sort | data warehouse conceptual design - a literature survey |
| url | http://psasir.upm.edu.my/id/eprint/61280/ http://psasir.upm.edu.my/id/eprint/61280/ http://psasir.upm.edu.my/id/eprint/61280/ http://psasir.upm.edu.my/id/eprint/61280/1/DATA.pdf |