Advanced Database
This course includes advanced concept of database system. The main topics covered are advanced concept of relational data model, Extended E-R model, new database management technologies, query optimization, NoSQL database and big data processing techniques.
Tribhuvan University
Institute of Science and Technology
2081
Bachelor Level / eight-semester / Science
Computer Science and Information Technology( CSC461 )
Advanced Database
Full Marks: 60 + 20 + 20
Pass Marks: 24 + 8 + 8
Time: 3 Hours
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Group A
Attempt any TWO questions.
Explain different object database concepts in brief. What are type constructors?
Why do we need query optimization in databases? Explain heuristic query optimization with examples.
Explain different distributed database architectures. What is data fragmentation?
Group B
Attempt any EIGHT questions.
Explain different constraints of specialization and generalization.
What is hashing? How does hashing improve database efficiency?
Explain ODMG object model.
What are the uses of query trees in query processing? Explain.
What is the CAP theorem? Explain.
What is Big Data? What are its 3 V’s?
What are triggers? What are the uses of triggers?
Why do we need spatial databases? What are common types of analysis for spatial data?
Write short notes on:
a) Map Reduce
b) Multimedia database