Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS)
Two of the most data model in Data Warehouse (DW) and advanced database includes star and snowflake schema, which play pivotal roles in the underlying performance. Today, DW queries comprise a group of aggregations and joining operations. As a result, snowflake schema does not seem to be an adequate...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Published: |
Inderscience
2011
|
| Subjects: |
| _version_ | 1796961740106235904 |
|---|---|
| author | Zaker, Morteza Yasin, Norizan Mohd Amnuaisuk, Somnuk Phon Haw, Su Cheng |
| author_facet | Zaker, Morteza Yasin, Norizan Mohd Amnuaisuk, Somnuk Phon Haw, Su Cheng |
| author_sort | Zaker, Morteza |
| collection | UM |
| description | Two of the most data model in Data Warehouse (DW) and advanced database includes star and snowflake schema, which play pivotal roles in the underlying performance. Today, DW queries comprise a group of aggregations and joining operations. As a result, snowflake schema does not seem to be an adequate option since several relations must combine to provide answers for queries that involve aggregation. In spite of its widespread application and undeniable advantages, snowflaking technique has certain theoretical and practical demerits. This paper proposes Hierarchical Degenerate Snowflake (HDS) as an alternative logical data model to achieve DW structure to improve the query performance. Copyright © 2011 Inderscience Enterprises Ltd. |
| first_indexed | 2024-03-06T05:58:38Z |
| format | Article |
| id | um.eprints-23009 |
| institution | Universiti Malaya |
| last_indexed | 2024-03-06T05:58:38Z |
| publishDate | 2011 |
| publisher | Inderscience |
| record_format | dspace |
| spelling | um.eprints-230092019-11-14T08:08:06Z http://eprints.um.edu.my/23009/ Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) Zaker, Morteza Yasin, Norizan Mohd Amnuaisuk, Somnuk Phon Haw, Su Cheng QA75 Electronic computers. Computer science Two of the most data model in Data Warehouse (DW) and advanced database includes star and snowflake schema, which play pivotal roles in the underlying performance. Today, DW queries comprise a group of aggregations and joining operations. As a result, snowflake schema does not seem to be an adequate option since several relations must combine to provide answers for queries that involve aggregation. In spite of its widespread application and undeniable advantages, snowflaking technique has certain theoretical and practical demerits. This paper proposes Hierarchical Degenerate Snowflake (HDS) as an alternative logical data model to achieve DW structure to improve the query performance. Copyright © 2011 Inderscience Enterprises Ltd. Inderscience 2011 Article PeerReviewed Zaker, Morteza and Yasin, Norizan Mohd and Amnuaisuk, Somnuk Phon and Haw, Su Cheng (2011) Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS). International Journal of Business Intelligence and Data Mining, 6 (2). pp. 154-183. ISSN 1743-8187, DOI https://doi.org/10.1504/IJBIDM.2011.039410 <https://doi.org/10.1504/IJBIDM.2011.039410>. https://doi.org/10.1504/IJBIDM.2011.039410 doi:10.1504/IJBIDM.2011.039410 |
| spellingShingle | QA75 Electronic computers. Computer science Zaker, Morteza Yasin, Norizan Mohd Amnuaisuk, Somnuk Phon Haw, Su Cheng Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) |
| title | Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) |
| title_full | Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) |
| title_fullStr | Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) |
| title_full_unstemmed | Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) |
| title_short | Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS) |
| title_sort | data warehouse design on the basis of hierarchical degenerate snowflake hds |
| topic | QA75 Electronic computers. Computer science |
| work_keys_str_mv | AT zakermorteza datawarehousedesignonthebasisofhierarchicaldegeneratesnowflakehds AT yasinnorizanmohd datawarehousedesignonthebasisofhierarchicaldegeneratesnowflakehds AT amnuaisuksomnukphon datawarehousedesignonthebasisofhierarchicaldegeneratesnowflakehds AT hawsucheng datawarehousedesignonthebasisofhierarchicaldegeneratesnowflakehds |