SQL Projects |
PROJECT NAME: Star Schema
Star Schema allows you to organize data from multiple relational databases into a single master table with dimensions.
Star Schema
Star Schema give you the ability to simplify and organize. When you have many complicated join between tables and databases, sometimes it is very hard to understand and maintain. To ensure integratity and accuracy, making query precise and understandable will allow reporting data much easier. For example. Given a relational database such as this: 
This schema is fairly simple in comparison to a database used by many enterprise applications. But as you can see that when multiple condition are applied between multiple tables, the condition may not be as obvious and the result may not always be correct. But by using the star schema and using simple dimension tables, you are ensuring the conditon you are applying it exact and the result to be acruate. The reason why these dimenion simplify the condition is because each dimension stand for 1 specific condition. Therefore giving it precise and acurate data. You can clearly see the difference in this picture: 
|
