0
A starflake schema is a combination of a star schema and a snowflake schema. Starflake schemas are snowflake schemas where only some of the dimension tables have been denormalized. hardkingofflirt@gmail.com
Wiki User
∙ 10y ago
Wiki User
∙ 9y agoA star flake schema is nothing but simply a combination of two other schema. The two schema are star schema and snowflake schema. In star flake schema the dimensions of table are De-normalized.
Add your answer:
Earn +20 pts
How do you design star flake schema?
we can design star schema like this A central Fact Table surrounded by multiple Dimensions. It looks like a Star.
Difference between star flake schema and star schema?
STAR SCHEMA ::contains dimension tables mapped around a fact table. it is a de normalised model.no need to use complicated joins.queries results fastly. @ahsan_ravian@hotmail.com
What are the Types of database schema architecture?
The Star & Snowflake are two common type of database Schema.
What is starflake schemas?
starflake schema: A hybrid structure that contains a mixture of star and snowflake schema's.
What schemas do you use in Multidimensional Modelling?
In Multidimensional Modelling, common schemas used are Star Schema and Snowflake Schema. Star Schema involves a central fact table connected to multiple dimension tables, while Snowflake Schema normalizes the dimension tables by further breaking them down into sub-dimension tables. These schemas help organize data hierarchically for efficient querying and analysis in multidimensional databases.
What is schema and sub-schema?
The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
What part of speech is the word schema?
Schema is a noun.
Which is healthier a fruit flake or a corn flake?
fruit flake
What is schema in mysql?
Schema is structure you created for your tables in My SQL
Which holds writable copy of AD schema?
Schema Master
Why do you need mapping between schema levels?
There is need for mappings between schema levels for visualization and schema matching. The mappings between schema levels helps in the different types of transformation.
