BS(CS) 6th

Distributed Database System CSC- 502

Credit Hours: 3 (2-1)
Prerequisites: Advanced Database Systems

Course Learning Outcomes (CLOs): 

At the end of the course the students will be able to:

To develop the skill & knowledge of Distributed Database Environment..
This is an advanced course of the previous that have previously studied and that is the “Database Systems”. This course enhances the concepts learnt earlier, moreover, the applications where will be applying the concepts and the techniques learnt in this course are also more advanced and complex by nature.
 The Distributed Database Management Systems (DDBMS) uses the concepts of:
 1) Database Management Systems
 2) Networking
Course Content:
Introduction to distributed database systems (DDBMS), architectural models, DDBMS architecture, distributed database design strategies, design issues, fragmentation, allocation, view management, data security, distributed query processing problems, query decomposition, localization of distributed data, query optimization, join ordering in fragment queries, distributed query optimization algorithms, transaction processing, concurrency control mechanisms, serializability theory, locked-based and timestamp-based algorithms, optimistic algorithms, deadlock management, reliability concepts and measures, failures in DDBMS, local reliability protocols, distributed reliability protocols, dealing with site failures, Network partitioning, database integration, data processing in multi-databases and inter-operability issues. 
Teaching Methodology: Lecturing, Written Assignments, Project, Report 
Writing Course Assessment: Sessional Exam, Home Assignments, Quizzes, Project, Presentations, Final Exam
Reference Materials as per HEC

  1.  Principles of Distributed Database Systems, M.T. Ozsu, P. Valduriez (eds.): (2nd Edition), Prentice Hall, 1999.
  2. Transactional Information Systems, G. Weikum and G. Vossen, Morgan Kaufmann, 2002.

Comments