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.
Full text not available from this repository.Abstract
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 |
|---|---|
| Funders: | UNSPECIFIED |
| 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 |
| URI: | http://eprints.um.edu.my/id/eprint/23009 |
Actions (login required)
 |
View Item |
