Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15150 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nethaji
A Star schema consist of fact table surrounded by one or
more dimension tables,which represent a star like
structure.Primary key of dimension tables connect to fact
tables as foreign keys.Data is is denormalized manner.For
better query performance we would go for star schema.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
Answer / pratap gangula
STAR Schema is a design that has a collection of one fact table and many dimension tables. Fact tables have the foreign keys to all the dimension tables and also keeps the additive measures for analysis. Dimension tables have the information needed to describe the measures in the fact. Basically dimensions are entities with all the attributes in a denormalized form.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What are the data marts?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
How to create prompts in report net?
Explain the importance of data warehouse?
Difference between cold fusion mx 6 and cold fusion mx 7?
Explain if a flat file cotains 1000 records how can I get first and last records only?
For faster process, what we will do with the universe?
Explain what is real time data-warehousing?
What is Analysis Services?
Disply the dname wise maximum salary
Which are the olap tools available that are supported by oracle?
Teradata 
