Data Warehouse Snowflake Design and Performance Considerations in Business Analytics - Volume 6, No. 4, November 2015 - JAIT
1. How to submit my research paper? What’s the process of publication of my paper?
The journal receives submitted manuscripts via email only. Please submit your research paper in .doc or .pdf format to the submission email:
2.Can I submit an abstract?
The journal publishes full research papers. So only full paper submission should be considered for possible publication. Papers with insufficient content may be rejected as well, make sure your paper is sufficient enough to be published...[Read More]

Data Warehouse Snowflake Design and Performance Considerations in Business Analytics

Jiangping Wang and Janet L. Kourik
Walker School of Business and Technology, Webster University, St. Louis, Missouri, USA
Abstract—Snowflake is a data warehouse schema design where dimension tables are normalized on top of a star schema design. Snowflake schema is generally not recommended due to its performance overhead in joining the normalized dimension tables. However, the Snowflake schema can be extended in a way to improve performance for business analysis activities. In business analytics paradigm, two distinct environments are complementary and work together to provide effective business analytics. Firstly, the data warehouse environment transforms operational data into information. Secondly, the analytical environment delivers information to end users for further data analysis and decision making. The snowflake schema bridges the gap between the two environments. Snowflake schema facilitates the mapping of wide dimension structures with many dimension attributes to analytical processing hierarchies. The snowflake schema makes navigation along hierarchies easier and supports flexible analysis such as drilldown and rollup. This paper examines the two complementary business intelligence environments, roles played by the snowflake design in mapping from data warehouse to analytics, and performance considerations in snowflake design with case studies.

Index Terms—data warehouse, snowflake design, business intelligence, business analytics

Cite: Jiangping Wang and Janet L. Kourik, "Data Warehouse Snowflake Design and Performance Considerations in Business Analytics," Vol. 6, No. 4, pp. 212-216, November, 2015. doi: 10.12720/jait.6.4.212-216
Copyright © 2013-2018 Journal of Advances in Information Technology, All Rights Reserved