M.Phil. DEGREE EXAMINATION, NOVEMBER 2017
First Semester
Computer Science
ADVANCED DATABASE MANAGEMENT
(CBCS 2017 onwards)
Time 3 Hours Maximum 75 Marks
Section A x 5 25)
Answer any five questions.
1. Define Homogeneous databases Heterogeneous
databases.
2. Briefly explain the Semijoin Strategy.
3. What is data warehouse? List the benefits of data
warehouse.
4. What is data mart? List out the differences between data
warehouse and data mart.
5. Explain the Horizontal decomposition.
6. Explain the process of extracting metadata from data.
7. Explain 3-schema architecture for multimedia.
8. Write a short note on Graph schema.
Sub. Code
7PCS1C2
AFS-0205
2
Sp 6
Section B 10 50)
Answer all questions, choosing either or
9. Describe the distributed data storage.
Or
Explain the locking protocols in detail.
10. Explain the data warehouse architecture in detail.
Or
Discuss the data mining applications in detail.
11. With suitable example explain the relational
operators PACK and UNPACK.
Or
Describe the spatial data model in detail.
12. Explain the various types of metadata for
multimedia databases in detail.
Or
Describe the multimedia database management in
detail.
13. Elaborately explain the working principles of
distributed file system.
Or
Describe the data storage for batch layer.
————————