摘自《Data Mining - Concepts and Techniques》
The most popular data model for a data warehouse is a multidimensional model.Such a model can exist in the form of a star schema, a snowflake schema, or a fact constellation
schema. Let’s look at each of these schema types.
Star schema: The most common modeling paradigm is the star schema, in which the data warehouse contains (1) a large central table (fact table) containing the bulk of the data, with no redundancy, and (2) a set of smaller attendant tables (dimension tables), one for each dimension. The schema graph resembles a starburst, with the dimension tables displayed in a radial pattern around the central fact table.
Snowflake schema: The snowflake schema is a variant of the star schema model, where
some dimension tables are normalized, thereby further splitting the data into additional
tables. The resulting schema graph forms a shape similar to a snowflake.
Fact constellation: Sophisticated applications may require multiple fact tables to share
dimension tables. This kind of schema can be viewed as a collection of stars, and hence
is called a galaxy schema or a fact constellation.
分享到:
相关推荐
Data Mining - Concepts and Techniques 电子版
Data Mining-Concepts and Techniques
《数据挖掘概念与技术-3rd英文版》韩家炜
Data-Mining-Concepts-and-Techniques 第3版 高清版 pdf 电子书
Data Mining - Concepts and Techniques (3rd Ed).pdf )
十大经典java书籍之Morgan Kaufmann - Data Mining - Concepts and Techniques
Data Mining Concepts and Techniques 3rd Edition(数据挖掘概念与技术第三版)英文原版
Data.Mining-Concepts.and.Techniques.2nd_2006,韩家炜著,英文版的,不好找不好找啊
Data Mining, Concepts and Techniques, Second Edition.part2
数据挖掘的经典教材《Data Mining.Concepts and Techniques》.
数据挖掘经典英文原版教材
经典数据挖掘著作,重新分享!有需要的来吧!
2015最新出版的RapidMiner参考书,得之不易,识货的下载 Predictive Analytics and Data Mining----Concepts and Practice with RapidMiner Vijay Kotu Bala Deshpande, PhD
Data Mining: Concepts and Techniques, Second Edition 的ppt
This book explores the concepts and techniques of data mining, a promising and Data mining, also popularly referred to as knowledge discovery in databases.
Data Mining Concepts and Techniques.pdf