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...
Saved in:
Main Authors: | , , , , , |
---|---|
Format: | Conference or Workshop Item |
Language: | English |
Published: |
Database Technologies and Applications Research Group (DbTA), Faculty of Computer Science and Information Technology, Universiti Putra Malaysia
2019
|
Online Access: | http://psasir.upm.edu.my/id/eprint/75515/1/ISICTMA2019-3.pdf http://psasir.upm.edu.my/id/eprint/75515/ |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.upm.eprints.75515 |
---|---|
record_format |
eprints |
spelling |
my.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). |
institution |
Universiti Putra Malaysia |
building |
UPM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Putra Malaysia |
content_source |
UPM Institutional Repository |
url_provider |
http://psasir.upm.edu.my/ |
language |
English |
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. |
format |
Conference or Workshop Item |
author |
Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah |
spellingShingle |
Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah Versioning approach for data warehouse schema |
author_facet |
Mat Yusof, Sharmila Sidi, Fatimah Affendey, Lilly Suriani Ibrahim, Hamidah Ishak, Iskandar A. Jabar, Marzanah |
author_sort |
Mat Yusof, Sharmila |
title |
Versioning approach for data warehouse schema |
title_short |
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_sort |
versioning approach for data warehouse schema |
publisher |
Database Technologies and Applications Research Group (DbTA), Faculty of Computer Science and Information Technology, Universiti Putra Malaysia |
publishDate |
2019 |
url |
http://psasir.upm.edu.my/id/eprint/75515/1/ISICTMA2019-3.pdf http://psasir.upm.edu.my/id/eprint/75515/ |
_version_ |
1648738235501772800 |
score |
13.18916 |