Dataware Housing & Mining (CY-604 (C)) - Important Questions

Explain Galaxy Schema for multidimensional databases in detail.

Explain Snowflake data warehouse schema in detail.

What is OLAP? Elaborate the concept of ROLAP with a neat diagram.

Explain different types of OLAP servers - ROLAP, MOLAP and HOLAP. Discuss data warehouse implementation techniques in detail.

Define data cleaning and discuss data cleaning techniques in brief.

Describe data transformation methods in detail.

What is Association Rule Mining? Discuss about the Boolean Association Rule Mining.

What is data warehouse? Explain the characteristics of data warehouse.

What is clustering? Explain commonly used distance measures and discuss K-Means clustering algorithm with a suitable example.

Explain Decision Tree Induction algorithm in detail with a suitable example. Discuss Bayesian classification briefly.

What is data mining? Explain the Knowledge Discovery Process (KDD) steps in detail.

List and explain the different types of data on which data mining is applied.

Explain Apriori algorithm to find frequent itemsets with a suitable example. Discuss FP-Growth algorithm briefly.

Differentiate between top-down and bottom-up hierarchical clustering algorithms.

Write short notes on any two: (a) Multi-level association rules (b) Time-series mining and latest trends in association rule mining (c) Efficient computation of data cubes and OLAP query processing.