UPM Institutional Repository

Versioning approach for data warehouse schema


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).


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.

Download File

[img] Text
Restricted to Repository staff only

Download (281kB)

Additional Metadata

Item Type: Conference or Workshop Item (Paper)
Divisions: Faculty of Computer Science and Information Technology
Publisher: Database Technologies and Applications Research Group (DbTA), Faculty of Computer Science and Information Technology, Universiti Putra Malaysia
Keywords: Data warehouse; Schema change; Versioning
Depositing User: Nabilah Mustapa
Date Deposited: 07 Oct 2019 07:37
Last Modified: 07 Oct 2019 07:37
URI: http://psasir.upm.edu.my/id/eprint/75515
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item