Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between star and snowflake schemas?
- 1 Answers
- 43 Views
- I also Faced
- E-Mail Answers
Answer / Leelendra Kumar Gangwar
The main difference between Star Schema and Snowflake Schema lies in their physical data organization. A Star Schema has a central fact table surrounded by dimension tables, all with denormalized relationships (every fact table links to every dimension table). In contrast, a Snowflake Schema extends the Star Schema by normalizing the dimension tables further, creating a more complex schema but improving query performance for specific scenarios.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is smoothing?
What is model based method?
Explain the density-based method?
What is unique index?
What are the benefits of user-defined functions?
Name Data mining techniques?
Explain Syntax for Pattern Presentation and Visualization Specification?
What is Syntax for Specifying the Kind of Knowledge?
Do you know what are olap and oltp?
Explain about data mining?
Explain how to mine an olap cube?
What is hierarchical method?
-
AI Algorithms (74) - AI Natural Language Processing (96)
- AI Knowledge Representation Reasoning (12)
- AI Robotics (183)
- AI Computer Vision (13)
- AI Neural Networks (66)
- AI Fuzzy Logic (31)
- AI Games (8)
- AI Languages (141)
- AI Tools (11)
- AI Machine Learning (659)
- Data Science (671)
- Data Mining (120)
- AI Deep Learning (111)
- Generative AI (153)
- AI Frameworks Libraries (197)
- AI Ethics Safety (100)
- AI Applications (427)
- AI General (197)
- AI AllOther (6)
