Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15153 Views
- I also Faced
- E-Mail Answers
Answer Posted / tanmay kumar meher
The star schema (sometimes referenced as star join schema)
is the simplest data warehouse schema, consisting of a
single "fact table" with a compound primary key, with one
segment for each "dimension" and with additional columns of
additive, numeric facts.
The star schema makes multi-dimensional database (MDDB)
functionality possible using a traditional relational
database. Because relational databases are the most common
data management system in organizations today, implementing
multi-dimensional views of data using a relational database
is very appealing. Even if you are using a specific MDDB
solution, its sources likely are relational databases.
Another reason for using star schema is its ease of
understanding. Fact tables in star schema are mostly in
third normal form (3NF), but dimensional tables are in de-
normalized second normal form (2NF). If you want to
normalize dimensional tables, they look like snowflakes
(see snowflake schema) and the same problems of relational
databases arise - you need complex queries and business
users cannot easily understand the meaning of data.
Although query performance may be improved by advanced DBMS
technology and hardware, highly normalized tables make
reporting difficult and applications complex.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is prompt types of prompts?use of prompts syntax of prompt?
Explain what is the extension of file to save template?
Explain what are the different methods of loading dimension tables?
What is the function of etl when used in data warehousing?
How can you clear the cache?
What is data analytics in simple terms?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is metadata in context of a datawarehouse and how it is important?
Database in use is oracle?
Can you pass sql queries in filter transformation?
What are the different types of join operations?
Tell me what is degree of a relation?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
Can we take backup when the database is opened?
What are necessary tasks to install reportnet software?
