Distributed Database System CSC- 502
Credit Hours: 3 (2-1)
Prerequisites: Advanced Database Systems
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- Principles of Distributed Database Systems, M.T. Ozsu, P. Valduriez (eds.): (2nd Edition), Prentice Hall, 1999.
- Transactional Information Systems, G. Weikum and G. Vossen, Morgan Kaufmann, 2002.
Comments
Post a Comment