ADBMS-UNIT 5-Questions

Unit5 Questions

1.       Discuss data warehouse and list the characteristics.  [10]

2.       Discuss the star schema and snowflake schema. Give one example.  [10]

3.       Information about daily operations of an organization is stored in operational databases. Why is data warehouse used to store data from operational databases? What issues arise up in data warehousing? Discuss data extraction, clearing, transformation and leading. Explain the challenges in efficiently refreshing and purging data. [10]

4.       Discuss the step involved in building a   data warehouse. [10]

5.       Write a brief note on multidimensional Data Model and Database Design. [10]

6.       With a neat diagram explain the architecture of data warehousing. [10]

7.       What is a fundamental difference between MOLAP and ROLAP systems? What is a star schema? Is it typically in BCNF? Why or why not?  [7]

8.       What is the role of the metadata repository in data warehouse? Briefly discuss the functions of back end tools and utilities of warehouse.   [8]

9.       Why are views important in decision support environments? How are views related to data warehousing and OLAP? [5]

10.    Explain view and its materialization. Mention the issues that arise in view materialization. [10]

11.    Write short notes on:

a.       Views with aggregation

b.       KDD process

c.        Mining for rules

12.    Define data mining. What is the necessity of data mining in database? [4]

13.    What is data mining? Discuss the goals of data mining. [10]

14.    Write the Apriori and decision tree algorithms. [10]

15.    Explain the association rules and Apriori algorithm in detail. [10]

16.    What is the Apriori property? Describe an algorithm for finding frequent item sets. [8]

17.    Give the difference between classification and clustering. With an example, explain how are decision trees constructed. [8]

18.    What are classification rules? How are decision trees related to them? Explain with examples. [6]

19.    What is a cluster? What information do we usually output for a cluster? Discuss the Clustering algorithm Called BIRCH that handles very large databases. [10]

20.    Describe a block evolution model and define the problems of incremental model maintenance and change detection. What are the added challenges in mining data streams?    [10]