Why is the snowflake schema a good data warehouse design?

@article{Levene2003WhyIT,
  title={Why is the snowflake schema a good data warehouse design?},
  author={Mark Levene and George Loizou},
  journal={Inf. Syst.},
  year={2003},
  volume={28},
  pages={225-240}
}
Database design for data warehouses is based on the notion of the snowflake schema and its important special case, the star schema. The snowflake schema represents a dimensional model which is composed of a central fact table and a set of constituent dimension tables which can be further broken up into subdimension tables. We formalise the concept of a snowflake schema in terms of an acyclic database schema whose join tree satisfies certain structural properties. We then define a normal form… CONTINUE READING

Citations

Publications citing this paper.
SHOWING 1-10 OF 78 CITATIONS

Conceptual Modeling

  • Lecture Notes in Computer Science
  • 2013
VIEW 9 EXCERPTS
CITES METHODS & BACKGROUND
HIGHLY INFLUENCED

Fuzzy Spatial Data Warehouse: A Multidimensional Model

  • Eighth Mexican International Conference on Current Trends in Computer Science (ENC 2007)
  • 2007
VIEW 4 EXCERPTS
CITES BACKGROUND & METHODS
HIGHLY INFLUENCED

Conceptual Modeling for Novel Application Domains

  • Lecture Notes in Computer Science
  • 2003
VIEW 10 EXCERPTS
CITES BACKGROUND, METHODS & RESULTS
HIGHLY INFLUENCED

FILTER CITATIONS BY YEAR

2003
2019

CITATION STATISTICS

  • 5 Highly Influenced Citations

References

Publications referenced by this paper.
SHOWING 1-10 OF 29 REFERENCES

The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses

Ralph Kimball, Laura Reeves, Margy Ross
  • 1998
VIEW 5 EXCERPTS
HIGHLY INFLUENTIAL

An information-theoretic analysis of relational databases—Part I: data dependencies and information metric

T. T. Lee
  • IEEE Trans. Software Eng. 13
  • 1987
VIEW 2 EXCERPTS
HIGHLY INFLUENTIAL