JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Course Objectives

Knowledge on concepts of Distributed Databases, Object-Based Databases,

advanced database models

Course Outcomes:

• 1. Understand Database system Architectures and parallel databases
• 2. Analyze transactions, Concurrency Control in Distributed Databases
• 3. Understand the importance of Data Warehousing and Mining
• 4. Illustrate concepts of object-based databases

List of Experiments

• 1. Write a program to implement RDBMS - Cursors, Triggers
• 2. Write a Program to implement Range Partitioning sort.
• 3. Write a program to implement parallel hash join
• 4. Write a program to implement parallel nested join loop
• 5. Write a program to implement parallelize duplicate elimination by partitioning the tuples
• 6. Perform data fragmentation of distributed data(Horizontal, Vertical, Hybrid fragmentation)
• 7. Implement deadlock detection in distributed databases
• 8. Implement Semi Join algorithm.
• 9. DataCube Implementation - Aggregation
• 10. Perform data Integration - Extraction, Transformation, Loading
• 11. Implement any one classifier
• 12. Implement vector space models for Text corpus
• 13. Demonstrate type inheritance, table inheritance in object based databases
• 14. Write queries in XQueries on DTD
• 15. Write queries in SQL/XML to convert University data - XML Schema

TEXT BOOKS:

• 1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan Database System Concepts, Sixth Edition
• 2. Ramez Elmasri, Shamkant B. Navathe, Database systems- Models, Languages, Design and Application Programming