{"id":23,"title":"Distributed Database Systems","credit_hour":"3","lecture_hour":"45","outcome":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<\/head>\r\n<body>\r\n<ul>\r\n<li>Analyze real-word data management scenarios and design appropriate data schemas.<\/li>\r\n<li>Formulate SQL queries to access a relational database system.<\/li>\r\n<li>Design and develop data management applications using relational database systems.<\/li>\r\n<li>Analyze and apply query optimization techniques for optimizing query.<\/li>\r\n<li>Analyze and apply data indexing techniques for speeding up query processing.<\/li>\r\n<li>Analyze and apply transaction processing techniques for executing transactions in relational database systems<\/li>\r\n<\/ul>\r\n<\/body>\r\n<\/html>","description":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<\/head>\r\n<body>\r\n<p>A detailed study of advanced topics on relational database theory, query processing and optimization, recovery techniques, concurrency control, data fragmentation, replication, security and integrity of distributed database systems. Discussion on heterogeneous databases and paradigms (deductive, object oriented) used in distributed systems.<\/p>\r\n<\/body>\r\n<\/html>","books":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<\/head>\r\n<body>\r\n<ol>\r\n<li><a href=\"https:\/\/www.amazon.com\/Principles-Distributed-Database-Systems-Tamer\/dp\/1441988335\" target=\"_blank\">Principles of Distributed Database Systems by M. Tamer Özsu and Patrick Valduriez<\/a><\/li>\r\n<li><a href=\"https:\/\/www.amazon.com\/Distributed-Database-Management-Systems-Practical\/dp\/047040745X\" target=\"_blank\"><em>Distributed Database Management Systems: A Practical Approach<\/em> by Saeed K. Rahimi and Frank S. Haug<\/a><\/li>\r\n<li><a href=\"https:\/\/www.amazon.com\/Distributed-Systems\/dp\/1292025522\/ref=dp_ob_title_bk\" target=\"_blank\"><em>Distributed Systems: Principles and Paradigms<\/em> by Andrew S. Tanenbaum and Maarten Van Steen<\/a><\/li>\r\n<\/ol>\r\n<\/body>\r\n<\/html>","created_at":"2016-08-03 22:02:05","updated_at":"2016-08-03 22:02:05"} Details | Department of Computer Science and Engineering, IUB

CNC 626: Distributed Database Systems

Offered Under: M.Sc. in Computer Networks & Communications (CNC)

Description

A detailed study of advanced topics on relational database theory, query processing and optimization, recovery techniques, concurrency control, data fragmentation, replication, security and integrity of distributed database systems. Discussion on heterogeneous databases and paradigms (deductive, object oriented) used in distributed systems.

Prerequisites:

CEN 422 : Pattern Recognition

CEN 430 + Lab : Data Communication and Computer Networks

Course Type	Major
Credit Hour	3
Lecture Hour	45

Expected Outcome(s):

Analyze real-word data management scenarios and design appropriate data schemas.
Formulate SQL queries to access a relational database system.
Design and develop data management applications using relational database systems.
Analyze and apply query optimization techniques for optimizing query.
Analyze and apply data indexing techniques for speeding up query processing.
Analyze and apply transaction processing techniques for executing transactions in relational database systems

Suggested Books:

Grading Policy:

Biweekly Quiz, One Midterm Exam, One Final Exam, Project