Briefly describe the features of Star Schema-00459
This subjective question is related to the book/course
vu cs301 Data Structures.
It can also be found in
vu cs301 Mid Term Solved Past Paper No. 3.
Question 1: Briefly describe the features of Star Schema?
Answer:
Dimensional hierarchies are collapsed into a single table for each dimension. Loss of information A single fact table created with a single header from the detail records, resulting in:- A vastly simplified physical data model!
- Fewer tables (thousands of tables in some ERP systems).
- Fewer join resulting in high performance.
- Some requirement of additional space.
