Star schema is a multidimensional model type that uses simple queries in order to access data from the database. A star schema depicts each dimension with only one-dimension table. Star schema is easy to operate as compared to fact constellation schema as it has less number of joins between the tables. It uses less space as compared to fact constellation schema.
Fact constellation Schema:
This schema is a type of multidimensional model. In this, dimension tables are shared by many fact tables. The fact constellation schema consists of more than one star schema at a time. Unlike the star schema, it is not easy to operate, as it has many between the tables. Unlike the Star schema, fact constellation schema uses heavily complex queries to access data from the database.
Let’s see that the difference between the Star Schema and fact constellation schema:
|S.NO||Star Schema||Fact constellation schema|
|1.||A star schema depicts each dimension with only one-dimension table.||While in this, dimension tables are shared by many fact tables.|
|2.||In star schema, tables can be maintained easily in comparison of fact constellation schema.||While in fact constellation schema, tables cannot be maintained easily comparatively.|
|3.||Star schema does not use normalization.||Whereas it is a normalized form of star and snowflake schema.|
|4.||In star schema, simple queries are used to access data from the database.||While in this, heavily complex queries are used to access data from the database.|
|5.||Star schema is easy to operate as compared to fact constellation schema as it has less number of joins between the tables.||While fact constellation schema is not easy to operate as compared to star schema as it has many joins between the tables.|
|6.||Star schema uses less space as compared to fact constellation schema.||While fact constellation schema uses more space comparatively.|
|7.||It is very simple to understand due to its simplicity.||While it is very difficult to understand due to its complexity.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Snowflake Schema and Fact Constellation Schema
- Difference between Star Schema and Snowflake Schema
- Fact Constellation in Data Warehouse modelling
- Star Schema in Data Warehouse modeling
- Difference between Fact Table and Dimension Table
- Difference between Schema and Database
- Difference between Schema and Instance in DBMS
- Difference between Document Type Definition (DTD) and XML Schema Definition (XSD)
- Difference between Star and Mesh Topology
- Difference between Star and Ring Topology
- Difference between Star topology and Bus topology
- Difference between Star Topology and Tree Topology
- Create, Alter and Drop schema in MS SQL Server
- Snowflake Schema in Data Warehouse Model
- Schema Integration in DBMS
- Strategies for Schema design in DBMS
- Relation Schema in DBMS
- Types of Keys in Data Warehouse Schema
- DROP SCHEMA in SQL Server
- ALTER SCHEMA in SQL Server
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.