Optimizing the Data Warehouse Design by Hierarchical Denormalizing


Morteza, Zaker and Pbon-Amnuaisuk, Somnuk and Haw, Su-Cheng (2008) Optimizing the Data Warehouse Design by Hierarchical Denormalizing. In: 8th WSEAS International Conference on Applied Computer Science (ACS 08), 21-23 NOV 2008 , Venice, ITALY.

Full text not available from this repository.


Data normalization and denormalization processes are common in database design community as these processes have a great impact on the underlying performance. Current data warehouse queries involve a set of aggregations and joining operations. Thus, normalization process is not a good choice as many relations need to be merged in order to answer queries involving aggregation. On the other hand, denormalization process engages a lot of administrative task. This task takes into account the documentation structure of the denormalization assessments, data validation, schedule of migrating of data and so on. In this paper, we show that the mentioned justifications can not be convincible reasons, under certain circumstances, to ignore the effects of denormalization. Until now denormalization techniques have been introduced for various types of database design. One of the techniques is hierarchical denormalization. Our experimental results indicate that the query response time is significantly decreased when the schema is deployed by hierarchical denormalization on a large dataset with multi-billion records. Thus, we suggest that hierarchical denormalization could be considered as a fundamental method to enhance query processing performance.

Item Type: Conference or Workshop Item (Paper)
Subjects: T Technology > T Technology (General)
Q Science > QA Mathematics > QA71-90 Instruments and machines > QA75.5-76.95 Electronic computers. Computer science
Divisions: Faculty of Engineering and Technology (FET)
Depositing User: Ms Suzilawati Abu Samah
Date Deposited: 29 Sep 2011 07:08
Last Modified: 29 Sep 2011 07:08
URII: http://shdl.mmu.edu.my/id/eprint/2947


Downloads per month over past year

View ItemEdit (login required)