Showing posts with label DATA WAREHOUSING. Show all posts
Showing posts with label DATA WAREHOUSING. 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


Saturday, May 3, 2014

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

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)
B.E. (IT) Semester- 7, (December 2010)
Con. 6110-10.
GT-8967
(3 Hours)
[Total Mark 100]

N.B. : (1) Question No 1 is compulsory.
(2) Attempt any four questions out of remaining questions.

1. One of India’s large Retail Department Chains, with annual revenues touching $2.5 billion mark and having over 3600 employees working at diverse location, was keenly interested in a business intelligence solution that can bring clear insights on operations and performance of departmental stores across the retail chain. The company needed to support a data warehouse that exceeds daily sales data from point of sales (POS) across all locations, with 80 million rows and 71 columns.

(a) List the dimensions and facts for above application. --- (5 Marks)
(b) Design Star Schema and Snow flake schema for the above application. --- (5 Marks)
(c) Design a BI application which will provide Retail Chain Company with features and performance that meet their objectives using any data mining technique. --- (10 Marks)

2. (a) What are the major issue in data mining? --- (6 Marks)
(b) Explain data Mining Task Primitives. --- (6 Marks)
(c) Explain Fact less fact table with suitable example. --- (12 Marks)

3. (a) What is web mining and explain web content mining. --- (10 Marks)

(b) Explain any one method of hierarchical clustering with an example. --- (10 marks)

4. (a) A database has four transactions. Let minimum support and confidence in 50%.

Tid
Item Bought
1
A,B,D
2
A,D
3
A,C
4
B,D,E,F

Find out the frequent item sets and strong association rules for above example. --- (5 Marks)
(a) Explain multi dimensional association rules with example. --- (5 Marks)
(b) Explain multilevel association rules. --- (5 Marks)
(c) Explain constraint based association rule mining. --- (5 Marks)

5. (a) Describe Data Discretization, Summarization with an example. --- (7 Marks)
(b) Explain Numerosity Reduction in data preprocessing. --- (6 Marks)
(c) Explain BIRCH method of clustering with an example. --- (7 Marks)

6.(a) Using a given table. Create classification model using any algorithm and hence classify following table. <income=medium, credit=good> --- (10 Marks)
Transaction ID
Income
Credit
Decision
1
Very High Excellent Authorize
2
High Good Authorize
3
Medium Excellent Authorize
4
High Good Authorize
5 Very High Good Authorize
6 Medium Excellent Authorize
7 High Bad Request ID
8 Medium Bad Request ID
9 High Bad Reject
10 Low Bad Call Police

(b)
Explain K- means clustering and solve the following with K=2. ---- (10 Marks)
{ 2, 25, 10, 15, 5, 20, 4, 40, }

7.
Write short notes on any two: --- (20 Marks)
(a) Spatial OLAP
(b) Association rule mining in data stream
(c) Approaches in Text mining
(d) Sequence mining in transactional Data base

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


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