Bhavnagar University 2008 M.Phil Computer Science Data Warehousing And Mining Concepts - Question Paper

M.Phil. (NS) DEGREE EXAMINATION, MAY 2008.
Computer Science
DATA WAREHOUSING AND MINING CONCEPTS

Time : 3 hours Maximum : 100 marks
ans any 5 ques..
every ques. carry equal marks.
1. (a) Compare the applications of Data Mining and Data Warehousing. (10)
(b) Explain the concept of Association rules with an example. What kind of issues can Association rules be applied? (10)
2. (a) What are the various kinds of OLAP tools? discuss the key features of every of them. (10)
(b) Explain the concept of Data Sources. List the typical sources of data for a Data Warehouse. (10)
3. What is a Dimensional Model? How does it differ from a Relational Model? provide an example of a Dimensional Model. (20)
4. With a block diagram discuss the different aspects of a typical Data Warehouse architecture. Highlight the different concepts associated with transformation and loading. (20)
5. Explain the concepts of Full Backup and Incremental Backup. discuss the recovery processes of them with suitable examples. (20)
6. (a) With a block diagram, discuss the different components of a typical 2-Tier architecture and 3-Tier architecture Data Warehouse. (10)
(b) List the advantages and disadvantages of a Data Mart approach. (10)
7. What are the aspects of performance tuning a Data Warehouse? discuss them with example. (20)
8. (a) How do ROLAP tools use the Aggregates in Query Processing? discuss the various scenarios with examples. (10)
(b) Explain in detail the salient features of Data warehouse.

Earning:   Approval pending.