SPPU Information Technology (Semester 8)
Advanced Databases
May 2017
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


Solve any one question from Q.1(a,b) &Q.2(a,b)
1(a) Explain fragmentation in distributed databases.
6 M
1(b) Write short note on Distributed Query Processing.
4 M

2(a) Explain various system parameters of parallel databases.
5 M
2(b) Comparison between object relational and object oriented database.
5 M

Solve any one question from Q.3(a,b) &Q.4(a,b)
3(a) Give the DTD for an XML representation of the following nested relational schema.
Emp = (ename, ChildrenSet set of (Children), SkillSet Set of (Skills))
Children = (day, month, year)
Skills = (type, Examset set of (Exams))
Exam = (year, city)
Use the DTD and write the following queries in Xqueries format.
i) Find the names of all employees who have a child who has a birthday in March.
ii) Find those employees who took an examination for the skill type "typing" in the city "Dayton".
iii) List all skill types in Emp.
6 M
3(b) Explain various operations performed by DynamoDB in detail.
4 M

4(a) What is Cassandra Query Language? Explain in detail.
5 M
4(b) What does column based Key-Value mean when talking about Cassandra vs DynamoDB?
5 M

Solve any one question from Q.5(a,b) &Q.6(a,b)
5(a) How stream data management system works? Explain its issues and solutions.
8 M
5(b) What is Graph Mining? Also explain its advantages & applications.
8 M

6(a) What are the models of social network generation? Explain in detail.
8 M
6(b) Write a short note on Apache Flume NG.
8 M

Solve any one question from Q.7(a,b,c) &Q.8(a,b,c)
7(a) Explain Naive Bayes classification for text categorization with example.
6 M
7(b) Explain concept of data modeling for web usage mining.
6 M
7(c) Explain concept of collaborative filtering using KNN.
6 M

8(a) Explain recommender systems. Which are the problems associated with it?
6 M
8(b) Describe matrix factorization in detail.
6 M
8(c) How navigational and sequential patterns are analyzed.
6 M

Solve any one question from Q.9(a,b) &Q.10(a,b)
9(a) Write short note on
i) Spatial databases.
ii) Temporal databases.
8 M
9(b) Explain Query Processing in Deductive database in detail. Explain SQL & Datalog Query Processing.
8 M

10(a) Explain cloud database in detail. Also explain the advantages and disadvantages of cloud databases.
8 M
10(b) What is semantics? Explain semantics in deductive database in detail.
8 M



More question papers from Advanced Databases
SPONSORED ADVERTISEMENTS