Showing posts with label MINING AND BUSINESS INTELLIGENCE (DWMBI). Show all posts
Showing posts with label MINING AND BUSINESS INTELLIGENCE (DWMBI). Show all posts

Wednesday, May 7, 2014

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

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)

B.E. (IT) Semester- 7, (December 2013)

Con. 8517-13.
LJ-14017

(3 Hours)
[Total Mark 100]

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

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

1. Answer any four: -

(a) Differentiate between DLAP and OLAP. --- (5 Marks)
(b) What is noisy data? How to handle it.--- (5 Marks)
(c) Explain constraint based association Rule mining. --- (5 Marks)
(d) Why is tree pruning useful in decision tree induction. --- (5 Marks)
(e) What is balanced score card. --- (5 Marks)

2. (a) Explain in details HITS algorithm in web mining. --- (10 Marks)
(b) What are issues regarding classification? Differentiate between classification and prediction. --- (10 Marks)

3. (a) Explain Data Mining Premitives. --- (10 Marks)
(b) Give the architecture of Typical Data Mining System. --- (10 Marks)

4. (a) Consider the following database with minimum support count = 60%. Find all frequent item set using Aprion and also generate strong association roles if minimum confidence = 50%.--- (10 Marks)
Tid      Item – brought
T1 { M, O, N, K, E, Y }
T2 { D, O, N, K, E, Y }
T3 { M, A, K, E }
T4 { M, U, C, K, E, Y }
T5 { C, O, o, K, I, e }

(b)
Explain multidimensional and multilevel association rules with an example. ---(10 Marks)

5. (a) What do you mean by pre-processing? Why it is required. --- (10 Marks)
(b) What is ETL process? Explain in detail giving emphasis on Data Transformation. --- (10 Marks)

6. (a) Explain Bayesian classification. --- (10 Marks)
(b) Explain periodic crawfer and Incremental Crawfer. --- (10 Marks)

7. Write short notes on any two: --- (20 Marks)
(a) Test Mining Approaches

(b) Numerority reduction

(c) Data Discretization and Sommarization.

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

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

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)

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

Con. 7596-13.
GS-5344
(3 Hours)
[Total Mark 100]

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

(2) Attempt any four questions from remaining six questions.

(3) Assume suitable data if required.

1. Attempt any four : -

(a) Give difference between OLTP and OLAP. --- (5 Marks)
(b) Explain DBSCAN. --- (5 Marks)

(c) Give difference between Classification and Clustering. --- (5 Marks)
(d) Explain Regression. --- (5 Marks)

2. (a) List the dimension and facts for hospital management system and also draw star schema and snowflake schema. --- (10 Marks)
(b) Why pre-processing is required? --- (5 Marks)
(c) Explain multidimension association rule. --- (5 Marks)

3. (a) What is Web structure mining? Explain technique of Web structure mining. --- (10 Marks)
(b) Explain data discritization and summarization with example. --- (10 Marks)

4. (a) Define the following terms with example: --- (10 Marks)

I. Item Set

II. Frequent Item Set

III. Closed Item Set

(b) What is market basket analysis? Explain its use. --- (10 Marks)

5. (a) Following table gives fat and proteins content of items. Apply single linkage clustering and construct dendrogram: - --- (10 Marks)
Food Item Protein Fat
1 1.1 60
2 8.2 20
3 4.2 35
4 1.5 21
5 7.6 15
6 2.0 55
7 3.9 39

(b)
Explain spatial data mining (SDM). Also explain a model of spatial data warehouse. --- (10 Marks)

6. (a) Use K- mean Algorithm to create three clusters for given set of values: --- (10 Marks)
{ 2, 3, 7, 8, 9, 15, 17, 19, 25 }
(b) Explain Hoeffding tree algorithm with example. --- (10 Marks)

7. Write short notes on any three:- --- (20 Marks)
(a) Spatial data cube construction

(b) Bayesian classification

(c) Text mining approaches

(d) Issues in data mining

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

Tuesday, May 6, 2014

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

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)

B.E. (IT) Semester- 7, (December 2012)
Con. 8391-12.
KR-1089
(3 Hours)
[Total Mark 100]

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

(2) Solve any four questions from remaining six questions.

1. Solve any four:-

(a) What is noisy data? How to handle it? --- (5 Marks)
(b) What is market segmentation? --- (5 Marks)
(c) Explain fact less fact table with suitable example. --- (5 Marks)
(d) How FP tree is better than Apriori Algorithm. --- (5 Marks)
(e) Differentiate between Periodic Crawler and Incremental Crawler. --- (5 Marks)

2. (a) Explain multidimensional association rules with suitable example. --- (10 Marks)
(b) Explain spatial data cube construction and spatial OLAP with example. --- (10 Marks)

3. (a) Explain Hoeffding Tree algorithm with example. --- (10 Marks)
(b) What is Web mining? Explain web content mining with reference to personalization harvest system. --- (10 Marks)

4. (a) What is clustering? Explain requirements and applications in detail. --- (10 Marks)
(b) Explain Agglomerative Clustering with an example. --- (10 Marks)

5. (a) Write difference between OLTP and OLAP explain different OLAP operations. --- (10 Marks)
(b) Explain regression? Explain Linear Regression with example. --- (10 Marks)

6. (a) Explain HITS Algorithm in Web mining. --- (10 Marks)
(b) A database has four transitions. Let minimum support and confidence is 50%. --- (10 Marks)
D=
Tid Item
100 ---------------------------------- 1, 3, 4
200 ---------------------------------- 2, 3, 5
300 ---------------------------------- 1, 2, 3, 5
400 ---------------------------------- 2, 5
500 ---------------------------------- 1, 2, 3
600 ---------------------------------- 3, 5
700 ---------------------------------- 1, 2, 3, 5
800 ---------------------------------- 1, 5
900 ---------------------------------- 1, 3

7. Write short notes on any two: --- (20 Marks)
(a) Issues in classification and explain any one technique of classification

(b) Sequence mining in transactional database

(c) Text mining approaches

(d) Fraud detection

Also see Data warehousing, Mining and business intelligence question papers for May 2012

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

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)
B.E. (IT) Semester- 7, (May 2012)
Con. 3839-12.
GN-6443
(3 Hours)
[Total Mark 100]

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

(2) Solve any four questions from remaining six questions.

Q.1: Solve any four from following.

(a) Compare Data Mining and Text Mining --- (5 Marks)
(b) What is Web Usage Mining? --- (5 Marks)
(c) What are the major issues in Data Mining? --- (5 Marks)
(d) Explain multilevel association rules --- (5 Marks)
(e) Compare Database and Data Warehouse. --- (5 Marks)

Q.2: (a) Explain mining sequence patterns in transactional Database. --- (10 Marks)
(b) Explain any one method of hierarchical clustering with example. --- (10 Marks)

Q.3: (a) Explain different data stream methodologies. --- (10 Marks)
(b) Explain Data Integration and Transformation with an example. --- (10 Marks)

Q.4: (a) Explain Hoeffding Tree Algorithm with example. --- (10 Marks)
(b) List the dimensions and for Clinical information system and design star and snowflake schema. --- (10 Marks)

Q.5: (a) Explain different PLAP Operations and applications. --- (10 Marks)
(b) Use K- means algorithm to create 3- clusters for given set of values. --- (10 Marks)
{ 2, 3, 6, 8, 9, 15, 18, 22 }

Q. 6: (a) Design a BI application which will provide Retail Chain Company with features and performance that meet their objectives. Use any data mining technique. --- (10 Marks)
(b) Explain Web Content Mining with reference to crawlers, Harvest System, Virtual Web view and personalization. --- (10 Marks)

Q. 7: Write short notes on any Three. --- (20 Marks)
(a) Difference between Periodic crawler and Incremental crawler.

(b) Spatial Data Mining

(c) Market Segmentation

(d) Outlier analysis.

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

Monday, May 5, 2014

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

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)
B.E. (IT) Semester- 7, (December 2011)
Con. 6150-11
MP-5732
(3 Hours)
[Total Mark 100]

N.B. : (1) Question No 1 is compulsory.
(2) Solve any four from remaining six questions.

1. (a) A Manufacturing company has a huge sales network. To control the sales, it is divided in the regions. Each region has multiple zones. Each zone has different cities. Each sales person is allotted different cities. The object is to track sales figure at different granularity levels of region and also to count the number of products sold. Create both data warehouse schema to take into consideration of above granularity levels for region, Sales person and the quarterly, yearly and monthly sales. ---- (10 Marks)
(b) Compare database and data warehouse. --- (5 Marks)
(c) Explain Business Intelligence issues. --- (5 Marks)

2. (a) What are the major issues in Data Mining? --- (5 Marks)
(b) Explain BIRCH method of clustering with an example. --- (5 Marks)
(c) Explain data integration and Transformation with an example. --- (10 Marks)

3. (a) Explain techniques of Web Structure Mining. --- (10 Marks)
(b) Explain the KDD process in detail. --- (10 Marks)

4. (a) How to FP tree is better than Apriori Algorithm. --- (5 Marks)
(b) A database has four transitions. Let minimum support and confidence is 50%
D=
            Tid Items
100 1, 3, 4
200 2, 3, 5
300 1, 2, 3, 5
400 2, 5

Find out frequent item sets and strong association rules for above example. --- (5 Marks)
(c) Explain constraint based association rule mining. --- (5 Marks)
(d) Explain multilevel association rules. --- (5 Marks)

5. (a) What is noise data? How to handle noisy data. --- (5 Marks)
(b) Explain Regression. Write short note on Linear Regression. --- (5 Marks)
(c) Explain K – means clustering and solve the following with k=3 ----- (10 Marks)
{ 2, 3, 6, 8, 9, 12, 15, 18, 22 }

6. (a) Using given training data set. Create classification model using decision tree and hence classify following table. --- (10 Marks)
Tid Income Age Own House
1 Very High Young Yes
2 High Medium Yes
3 Low Young Rented
4 High Medium Yes
5 Very High Medium Yes
6 Medium Young Yes
7 High Old Yes
8 Medium Medium Rented
9 Low Medium Rented

(b)
Suppose we have six object (within name A, B, C, D, E and F) and each object have two measured features (X1 and X2)

X1 X2
A 1 1
B 1.5 1.5
C 5 5
D 3 4
E 4 4
F 3 3.5

Apply single linkage clustering and draw Dendrogram. --- (10 Marks)

7. Write notes on any two: --- (20 Marks)
(a) Applications of Web Mining
(b) Outlier analysis
(c) Market Basket Analysis and use of it
(d) Spatial Data Mining

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