Versioning approach for data warehouse schema
A Data warehouse (DW) is a repository designed for querying and analyzing data. The main aims of a DW is to provide the most accurate and historically correct information to users to support the business analysis and decision-making. The input to DW is dependent on its business requirements and data...
| المؤلفون الرئيسيون: | , , , , , |
|---|---|
| التنسيق: | Conference or Workshop Item |
| اللغة: | English |
| منشور في: |
Database Technologies and Applications Research Group (DbTA), Faculty of Computer Science and Information Technology, Universiti Putra Malaysia
2019
|
| الوصول للمادة أونلاين: | http://psasir.upm.edu.my/id/eprint/75515/1/ISICTMA2019-3.pdf |
| _version_ | 1825950481477795840 |
|---|---|
| author | Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah |
| author_facet | Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah |
| author_sort | Mat Yusof, Sharmila |
| collection | UPM |
| description | A Data warehouse (DW) is a repository designed for querying and analyzing data. The main aims of a DW is to provide the most accurate and historically correct information to users to support the business analysis and decision-making. The input to DW is dependent on its business requirements and data sources. With the nature of dynamic business requirements and autonomous data sources, the requirement of the DW is inevitably changes over times. As the DW is very critical for organization’s business analysis and strategic decision-making, the dissemination of the changes is crucial to the DW system in order to supply a precise and reliable information. Thus, the objective of this paper is to present an approach to cater for DW change management problem. We apply the approach on TPC-H benchmark data to illustrate its practicality. The application shows that the proposed approach could assist designer to manage the DW schema changes. |
| first_indexed | 2024-03-06T10:15:16Z |
| format | Conference or Workshop Item |
| id | upm.eprints-75515 |
| institution | Universiti Putra Malaysia |
| language | English |
| last_indexed | 2024-03-06T10:15:16Z |
| publishDate | 2019 |
| publisher | Database Technologies and Applications Research Group (DbTA), Faculty of Computer Science and Information Technology, Universiti Putra Malaysia |
| record_format | dspace |
| spelling | upm.eprints-755152019-10-07T07:37:04Z http://psasir.upm.edu.my/id/eprint/75515/ Versioning approach for data warehouse schema Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah A Data warehouse (DW) is a repository designed for querying and analyzing data. The main aims of a DW is to provide the most accurate and historically correct information to users to support the business analysis and decision-making. The input to DW is dependent on its business requirements and data sources. With the nature of dynamic business requirements and autonomous data sources, the requirement of the DW is inevitably changes over times. As the DW is very critical for organization’s business analysis and strategic decision-making, the dissemination of the changes is crucial to the DW system in order to supply a precise and reliable information. Thus, the objective of this paper is to present an approach to cater for DW change management problem. We apply the approach on TPC-H benchmark data to illustrate its practicality. The application shows that the proposed approach could assist designer to manage the DW schema changes. Database Technologies and Applications Research Group (DbTA), Faculty of Computer Science and Information Technology, Universiti Putra Malaysia 2019 Conference or Workshop Item PeerReviewed text en http://psasir.upm.edu.my/id/eprint/75515/1/ISICTMA2019-3.pdf Mat Yusof, Sharmila and Sidi, Fatimah and Affendey, Lilly Suriani and Ibrahim, Hamidah and Ishak, Iskandar and A. Jabar, Marzanah (2019) Versioning approach for data warehouse schema. In: International Symposium on ICT Management and Administration (ISICTMA2019), 31 July-2 Aug. 2019, Putrajaya Marriott Hotel, Malaysia. (pp. 16-21). |
| spellingShingle | Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah Versioning approach for data warehouse schema |
| title | Versioning approach for data warehouse schema |
| title_full | Versioning approach for data warehouse schema |
| title_fullStr | Versioning approach for data warehouse schema |
| title_full_unstemmed | Versioning approach for data warehouse schema |
| title_short | Versioning approach for data warehouse schema |
| title_sort | versioning approach for data warehouse schema |
| url | http://psasir.upm.edu.my/id/eprint/75515/1/ISICTMA2019-3.pdf |
| work_keys_str_mv | AT matyusofsharmila versioningapproachfordatawarehouseschema AT sidifatimah versioningapproachfordatawarehouseschema AT affendeylillysuriani versioningapproachfordatawarehouseschema AT ibrahimhamidah versioningapproachfordatawarehouseschema AT ishakiskandar versioningapproachfordatawarehouseschema AT ajabarmarzanah versioningapproachfordatawarehouseschema |