Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS)

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

Full description

Saved in:
Bibliographic Details
Main Authors: Zaker, Morteza, Yasin, Norizan Mohd, Amnuaisuk, Somnuk Phon, Haw, Su Cheng
Format: Article
Published: Inderscience 2011
Subjects:
QA75 Electronic computers. Computer science
Online Access:http://eprints.um.edu.my/23009/
https://doi.org/10.1504/IJBIDM.2011.039410
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Universiti Malaya
id my.um.eprints.23009
record_format eprints
spelling my.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 https://doi.org/10.1504/IJBIDM.2011.039410 doi:10.1504/IJBIDM.2011.039410
institution Universiti Malaya
building UM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Malaya
content_source UM Research Repository
url_provider http://eprints.um.edu.my/
topic QA75 Electronic computers. Computer science
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)
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.
format Article
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
title 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_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_sort data warehouse design on the basis of hierarchical degenerate snowflake (hds)
publisher Inderscience
publishDate 2011
url http://eprints.um.edu.my/23009/
https://doi.org/10.1504/IJBIDM.2011.039410
_version_ 1651867387823128576

Similar Items