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
2080
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.
SECTION A
Attempt any TWO question.
Explain different features of enhanced ER(EER) model. Compare specialization with generalization.
Compare object oriented database with object relational database. What are different object database features that have been included in SQL ?
Why distributed database is important? What is transparency? Explain different types of transparencies in distributed databases.
SECTION B
Attempt any EIGHT question.
Why hashing is important to store data in databases? What is primary file organization?
Explain aggregation with suitable example.
What is ODMG object model? What is object definition language?
Explain different steps in query processing
Why query optimization is essential in databases? What is heuristic optimization?
Define fragmentation. Explain horizontal fragmentation with an example.
What are the characteristics of NOSQL Systems?
What is the concept of active database? What are triggers?
Write short notes on: a) Big data b) Information retrieval