Explain what the star schema is
What will be an ideal response?
The star schema is a simple database design. Dimensional (or descriptive) data are separated from fact or event data. The star schema consists of a fact table, which contains event data as well as links to dimensions. Dimension tables contain descriptive information. For example, we might have a dimension for sales territory which would have a unique ID as well as several levels of granularity. There might be a territory description, state, city, zip code, etc. The dimension key is also in the fact table. In this way, it is fairly simple to look up information and do some drill-down type queries.
You might also like to view...
Which of the following is the best question to include in a mail survey?
a. What do you think of a flat-rate income tax? b. Do you approve of a flat-rate income tax? c. What benefits do you think a flat-rate income tax will offer? d. Why are you in favor of a flat-rate income tax?
The customer who arrives at a bank, enters a line, and decides to leave is
A) balking. B) cropping. C) reneging. D) blithering. E) None of the above