Download Mumbai University M.Sc IT Part 1 2019 May 71481 Data Warehousing and Mining and Advanced Database Systems Question Paper

IV - Data Warehousing and Mining and Advanced Database

Firstranker's choice FirstRanker.com

(Time: 3 hours) [Total Marks: 75]

--- Content provided by​ FirstRanker.com ---

Please check that you have got the correct question paper.

N. B.: (1) All questions are compulsory.

(2) Make suitable assumptions wherever necessary and state the assumptions made.

(3) Answers to the same question must be written together.

(4) Numbers to the right indicate marks.

--- Content provided by FirstRanker.com ---

(5) Draw neat labeled diagrams wherever necessary.

(6) Use of Non-programmable calculators is allowed.

SECTION - 1

1. 1. What is meta data and explain its significance? 7
   2. Explain the Dimensional nature of business data. 6

   --- Content provided by FirstRanker.com ---

   OR

   1. Explain the data design phase of a Data warehouse 7
   2. Explain in detail the concept of Information Package along with suitable example. 6
2. 1. Explain characteristics of Fact table and dimension table. 7

   --- Content provided by FirstRanker.com ---

   2. Distinguish between ROLAP vs MOLAP 6

   OR

   1. What is a Decision tree? Explain in detail 7
   2. Define clustering and explain what is meant by unsupervised learning. 6

--- Content provided by⁠ FirstRanker.com ---

3. 1. What is Web Mining? 6
   2. Data generalization and summarization based characterization 6

   OR

   1. Define the following : a. Mean b. Median c. Mode 6
   2. Explain the concept of Genetic algorithms in detail 6

   --- Content provided by‌ FirstRanker.com ---

SECTION II

4. 1. Explain characteristics of Specialization and Generalization. 7
   2. Explain the concept of weak entity sets. 6

   OR

   --- Content provided by⁠ FirstRanker.com ---

   1. Explain the concept of versions & configurations. 7
   2. Write short note on the concept of complex objects. 6
5. 1. Compare of OODBMS, RDBMS, ORDBMS. 6
   2. Define Distributed databases. List and explain its types. 6

   --- Content provided by⁠ FirstRanker.com ---

   OR

   1. Explain the Primary Site method of Distributed Concurrency Control. 6
   2. Write short note on Deductive Databases. 6
6. 1. Write a short on indexing techniques for text data. 6

   --- Content provided by FirstRanker.com ---

   2. Explain Semi structured data model and its implementation issues. 6

   OR

   1. Write short note on Mobile Databases and Temporal databases. 6
   2. Explain the concept of XML DTD. 6

--- Content provided by⁠ FirstRanker.com ---

FirstRanker.com