DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI), B.E. (IT) Semester- 7, (May 2010)

B.E. (IT) Semester- 7, (May 2010)

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)

Con. 3244-10.

AN-3283

(3 Hours)

[Total Mark 100]

N.B. : (1) Question No 1 is compulsory.

(2) Attempt any four questions out of remaining six questions.

(3) All questions carry equal marks.

1. (a) Explain association rule mining. Explain apriori algorithm with its advantages, disadvantages and an example. --- (10 Marks)
(b) Give any ten characteristics to differentiate between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP). --- (10 Marks)

2. (a) Explain major steps in ETL process with a suitable diagram and an example. --- (10 Marks)
(b) Explain any six major transformation types in data-warehousing. --- (10 Marks)

3. (a) Explain any five general trends in data-warehousing. --- (10 Marks)
(b) Enlist different types of OLAP server. Explain following operations of OLAP with suitable example. --- (10 Marks)
I. Slice
II. Dice
III. Roll-up
IV. Drill-down
V. Rotation

4. (a) What is clustering? Explain k-means clustering algorithm. --- (10 Marks)
Suppose data for clustering is

{

2,

4,

10,

12,

3,

20,

11,

5,

25,

23

}

Consider k= 2, cluster the given data using k means clustering algorithm.

(b) Define data-warehouse with five features. Explain architecture of data-warehouse with suitable block diagram. --- (10Marks)

5. (a) What is metadata? Explain different types of metadata with an example. --- (10 Marks)|
(b) Write a short note on web-enabled data – warehouse and its major concerns for security --- (10 Marks)

6. (a) Give information package for recording information requirement for “Sales analysis”. --- (10 Marks)
Consider dimension like
I. Time
II. Location
III. Products
IV. Age group etc.
Design star schema from information package. Draw snowflake schema if possible.

(b) Explain data mining as a step in KDD. Give the architecture of typical data mining system. --- (10 Marks)

7. Write short notes on any two: --- (20 Marks)
a. Star Schema keys
b. Explain any five DMQL, statement with an example
c. Fact less fact table with an example
d. Top-down and bottom- up approach in data- warehousing (Give any 10 points)

Also see Data warehousing, Mining and business intelligence question papers for December 2013