Optimizing the Data Warehouse Design by Hierarchical Denormalizing
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...
| Main Authors: | , , |
|---|---|
| Format: | Conference or Workshop Item |
| Published: |
2008
|
| Subjects: | |
| Online Access: | http://shdl.mmu.edu.my/2947/ |
| _version_ | 1848790192334307328 |
|---|---|
| author | Morteza, Zaker Pbon-Amnuaisuk, Somnuk Haw, Su-Cheng |
| author_facet | Morteza, Zaker Pbon-Amnuaisuk, Somnuk Haw, Su-Cheng |
| author_sort | Morteza, Zaker |
| building | MMU Institutional Repository |
| collection | Online Access |
| description | 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. |
| first_indexed | 2025-11-14T18:08:42Z |
| format | Conference or Workshop Item |
| id | mmu-2947 |
| institution | Multimedia University |
| institution_category | Local University |
| last_indexed | 2025-11-14T18:08:42Z |
| publishDate | 2008 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | mmu-29472011-09-29T07:08:11Z http://shdl.mmu.edu.my/2947/ Optimizing the Data Warehouse Design by Hierarchical Denormalizing Morteza, Zaker Pbon-Amnuaisuk, Somnuk Haw, Su-Cheng T Technology (General) QA75.5-76.95 Electronic computers. Computer science 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. 2008-11 Conference or Workshop Item NonPeerReviewed 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. http://apps.webofknowledge.com/full_record.do?product=WOS&search_mode=GeneralSearch&qid=1&SID=W1gbFB46DdE8F6aaJIP&page=98&doc=979 |
| spellingShingle | T Technology (General) QA75.5-76.95 Electronic computers. Computer science Morteza, Zaker Pbon-Amnuaisuk, Somnuk Haw, Su-Cheng Optimizing the Data Warehouse Design by Hierarchical Denormalizing |
| title | Optimizing the Data Warehouse Design by Hierarchical Denormalizing |
| title_full | Optimizing the Data Warehouse Design by Hierarchical Denormalizing |
| title_fullStr | Optimizing the Data Warehouse Design by Hierarchical Denormalizing |
| title_full_unstemmed | Optimizing the Data Warehouse Design by Hierarchical Denormalizing |
| title_short | Optimizing the Data Warehouse Design by Hierarchical Denormalizing |
| title_sort | optimizing the data warehouse design by hierarchical denormalizing |
| topic | T Technology (General) QA75.5-76.95 Electronic computers. Computer science |
| url | http://shdl.mmu.edu.my/2947/ http://shdl.mmu.edu.my/2947/ |