Q1. How is a data warehouse distinct from the database? How are they alike to each other?
Q2. Describe three data warehouse models: the enterprise warehouse, the data mart and the virtual warehouse.
Q3. Describe in brief star and snowflake schema. As well point out the main difference between the two. Which is most popular in the data warehouse design?
Q4. Describe the Data extraction, Data transformation and Data loading with respect to the Data warehouse.
Q5. Describe the typical OLAP operations in short.
Q6. Why most of the data warehouse systems support the index structures? Describe the methods to index OLAP data.