Discussions
Star Schema
1. Compare and contrast the star schema and snowflake schema. What are the components of a star schema? Describe the relationship between dimension and fact tables.
OLAP vs OLTP
2. What are some differences between operational systems and data warehouses? How is the data different?
Data Warehouse Example
3. Can you think of a real-world industry in which a data warehouse implementation would be beneficial? What type of business problems could be solved.