DATA WAREHOUSE AND DATA MINING (DWDM) DECEMBER 2013 COMPUTER SCIENCE SEMESTER 6
Con. 9243-13. LJ-11650
(3 Hours) [Total Marks : 100]
N.B.: (1) Question No. 1 is compulsory.
(2) Answer any four questions out of remaining six questions.
(3) Assume data if required, and state clearly.
| Q1. (A) | What is a Data ware house? Explain the three tire architecture of Data Ware | 10 |
| (B) | Explain Data mining as a step in KDD. Explain the architecture of a typical DM | 10 |
| system. | ||
Q2. (A) | What is meant by market-basket analysis? Explain with an example. State and | 10 |
| explain with formula the meaning of following terms | ||
| (i) Support (ii) Confidence | ||
| (iii) Iceberg Queries | ||
| Hence explain how to mine multilevel Association rules from transaction datavases, with | ||
| examples. | ||
| (B) | What is meant by Web Mining? Explain any one Web mining Algorithm. | 10 |
Q3. (A) | All Electronic company have department sales, consider three dimensions | 10 |
| namely | ||
| (i) Time (ii) Product (iii) Store | ||
| The schema contains central fact table sales with two measures | ||
| (i) Dollars-cost and (ii) Units-sold | ||
| Using the above example, describe the following OLAP operations | ||
| (i) Dice (ii) Slice (iii) Roll-up (iv) Drill-Down | ||
| (B) | Explain ETL (Extract Transform Load) cycle in a Data Warehouse in detail | 10 |
Q4. (A) | Compare between OLAP and OLTP | 10 |
| (B) | Explain in detail the HITS Algorithm | 10 |
Q5. (A) | What is meant by information package Diagram, For recording the information | 10 |
| requirements for "Hotel Occupancy" having dimensions like time, hotel etc., give the | ||
| information package diagram for the same, also draw the star schema and snowflake | ||
| schema | ||
| (B) | Consider the following transactions:- | 10 |
 Apply the Apriori Algorithm with minimum support of 30% and minimum confidence of 75 | ||
| and find the large item set L | ||
Q6. (A) | Give five examples of application that can use clustering. Describe any one clustering | 10 |
| algorithm with an example. | ||
| (B) | What is meant by meta data? Explain with example. Explain the different types of | 10 |
| meta data stored in a data ware house. Illustrate with examples. | ||
| Q7. | Write short Notes on (any Two) | 20 |
| (a) Web personalization | ||
| (b) Decision Tree based classification Approach | ||
| (c) Trens in Data Ware Housing | ||
| (d) Attribute Oriented Induction |
No comments:
Post a Comment