UPTU Previous Year Question Papers B Tech Data Mining & Ware Housing 2006-07

UPTU Previous Year Question Papers

Data Mining & Ware Housing 2006-07

 

Note : Attempt All The Questions.

 1. Attempt Any Four Parts :        

(A)  Compare The Two-Tier And Three-Tier Client Server Architecture.

(B) What Are The Main Software Modules Of A Distributed Dbms ? Discuss The Main Functions Of Such Modules In The Context Of Client Server Architecture.

(C) What Is A Data Warehouse ? Explain Various Data Warehousing Architecture.

(D)             What Is Meant By Data Allocation And Data Replication In Distributed Database Design ?

(E) How Did Relational Dbms Evolve From The Centralized Architecture To The Client-Server Architecture ?

(F) Write Short Notes On The Following :

(I)  Cluster System

(Ii) Distribution Transparency And Fragmentation Transparency.

 

2. Attempt Any Four Parts :

(A)  Explain Multidimensional Data Base Structure And Relational Databse Structure For Data Ware­house Application.

(B) What Do You Mean By Metadata ?

(C) Illustrate Various Database Management System Schemes For Decision Support System Development.

(D)  Compare And Contrast Two Basic Approaches To Building A Data Warehouse.

(E) Explain Mapping The Data Warehouse To Multiprocessor Architecture.

(F) What Do You Understand By Data Extraction ?

Also Explain Various Transformation Tools Involved In Data Warehousing.

 

3. Attempt Any Four Parts :

(A) Explain The Term Olap. Briefly Explain The Following Olap Operations :

(I) Slicing A Cube

(Ii) Drill Down.

(B) What Are The Two Basic Approaches Used To Analyse A Data Warehouse Databse ?

(C) Give The Arguments In Favour Of Multidimensional On-Line Analytical Processing.

(D)  What Do You Understand By Virtual Data Warehouse ? Also Give The Idea About Data- Marts.

(E) What Kind Of Databse Can Olap Software Use ?

What Types Of Output Can Olap Software Provide To Its User ?

(F) Explain Why Intelligent System Technology Is Useful In Dss, With Its Advantages And Disadvantages.

 

4. Attempt Any Two Parts :

(A)             What Are The Various Goals Of Data Mining ?

And Explain The Various Tools And Techniques Of Data Mining Briefly. What Are Supervised And Unsupervised Learning Methods ? How Do They Help In Data Mining ?

(B) Describe The Working Of The Dbscan Algorithm. Explain The Concept Of A Duster As Used In Dbscan And Rock And Compare Them, With The Help Of Suitable Example.

(C) Describe The Essential Features In A Decision Tree. How Is It Useful To Classify Data ? What Are The Disadvantages Of Decision Tree Over Other Classification Techniques ?

 

5 Attempt Any Two Parts :              

(A) What Is Data Visualization ? How It Helps In Dss Model ? Give The Methods For Visualization Of Generalized Data ?

(B) Discuss The Role Of Data Warehouse Managers In Data Warehousing. Write Down Codd’s Guidelines For Olap And Explain Them.

(C) Explain The Concept Of ‘Big Data Better Returns’.

Also Discuss The Advantages And Disadvantages Of ‘Big Data-Better Return’ Concept.

Leave a Comment