University of Mumbai 2007 M.Sc Information Technology Data Warehousing and Mining _&_ Advanced Database System - Question Paper
Scanned copy attached. Download the file.
VENKATTESH. B. IYER
B. N. Batidodkar. College (07-09 Batch)
Con/1391-07. f' J OT-5843
 Data Warehousing and Mining _&_ Advanced Database System_files/13357-26311-(07 Paper) Data Warehousing and Mining _&_ Advanced Database System-1.png)
- ( 3 Hours ) ' [ Total Marks : 75
N.B. : (1) Attempt any five questions.
(2) Figures to the right indicate full marks.
(3) Answers to the two sections must be written in separate answer-books. and should be submitted separately.
Section I
Q. 1 a What is operational systems and informational systems? Compare their 8
r
characteristics. 1
b What is CRM { Customer Relationship Management)? How can you make 7 your data warehouse CRM-ready?
v1
Q- 2 a Discuss the data flow in data storage. List the functions and services of in 8 data storage area.
b Describe the slowly changing dimensions. What are the types of slowly 7
changing dimension? Explain cach in brief.
<3 a What are hypercubes? Mowjg they apply in an Q.LAP system?___ 8
b When is a Pilot data mart useful? 7
OR
4 a Discuss the various data mining tasks. 3
b Describe K-Mean Clustring algorithm in detail. . 7
-7
Q. 5 a Discuss Apriori algorithm in detail. 8
b Discuss in detail Web usage mining. ' y
OR
Q. 6 a Describe any one Distance based algorithm for classification. 8
1 b Write note on Pattern matching. 7
ft -p. r f
[ TURN OVER yy
& CO
ll a. Explain the need for Enhanced Entity Relationship model. Explain 7 Specialization, Generalization and Categorization with examples.
b. Explain Type hierarchy and Inheritance in context with Object oriented database 8
systems.
t
8. a. Explain the following with respect to object query language: 7
i, Query results and path expressions ' ii, Extracting Single Elements from Singleton Collections .
iii. Database Entry points and Iterator Variables _ _
b. With respect to object oriented databases explain Polymorphism, Multiple 8 Inheritance, Selective Inheritance, Versions and Configurations,
a> Compare Relational, object oriented and object relational database systems. 7
b. What are the different ways of partitioning the data? Explain with examples: 8
OR
10. a. Discuss the implementation issues for extended type systems. 7
b. Compare parallel and distributed technologies. What are the advantages of 8 distributed databases?
What is a document type definition? What is a document schema? What are the 7 advantages of document schema over document type definition?
|
Ji. a. |
 Data Warehousing and Mining _&_ Advanced Database System_files/13357-26311-(07 Paper) Data Warehousing and Mining _&_ Advanced Database System-2.png) |
Enumerate the features of spatial databases. What are spatial queries? How are 8 they categorized? Explain each category. . ,
12. a. What is an active database? What are its drawbacks? How is reactive behavior 7 specified in the database? Explain giving examples. _
 Data Warehousing and Mining _&_ Advanced Database System_files/13357-26311-(07 Paper) Data Warehousing and Mining _&_ Advanced Database System-3.png)
|
Attachment: |
| Earning: Approval pending. |
