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

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

Full text not available from this repository.
Official URL:


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.

Item Type: Article
Uncontrolled Keywords: Data warehouse; Logical data modelling; OLAP; Query processing
Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions: Faculty of Computer Science & Information Technology
Depositing User: Ms. Juhaida Abd Rahim
Date Deposited: 14 Nov 2019 08:08
Last Modified: 14 Nov 2019 08:08

Actions (login required)

View Item View Item