{"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

CEN 416: Distributed Database Systems

Offered Under: B.Sc. in Computer Engineering (CEN)

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 306 + Lab : Algorithms

CEN 401 + Lab : Database Management

CEN 305 + Lab : Object-Oriented Programming

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

Letter Grade	Marks	Grade Point
A	90 - 100	4.00
A-	85 - 89	3.70
B+	80 - 84	3.30
B	75 - 79	3.00
B-	70 - 74	2.70
C+	65 - 69	2.30
C	60 - 64	2.00
C-	55 - 59	1.70
D+	50 - 54	1.30
D	45 - 49	1.00
F	00 - 44	0.00