Skip to main content

ICS 611 Distributed Database Systems

This course covers the fundamental issues of distributed databases with focus on data fragmentation and allocation, query optimization and transaction processing. Topics include: Distributed database management systems architecture and design; data fragmentation, replication, and allocation; database security, authorization and integrity control; query optimization; transaction management; distributed concurrency control and replica control; distributed object database management systems; multidatabase systems.

Prerequisites

Special information

First day attendance is mandatory.Prerequisites: Graduate standing. Note: Students are responsible to both be aware of and abide by prerequisites for ICS courses for which they enroll, and will be administratively dropped from a course if they have not met prerequisites.
4 Graduate credits

Effective August 26, 2006 to present

Learning outcomes

General

  • Fragment a database both horizontally and vertically for optimal performance.
  • Allocate replicas of fragments for best performance.
  • Optimize queries for optimal performance across a distributed database.
  • Add distributed transaction management control including concurrency control and replica control to a distributed database.
  • Demonstrate expertise in reading peer-reviewed papers in distributed databases and explain them in writing.
  • Discuss how current database products implement database distribution including query optimization.

Spring 2021

Section Title Instructor
01 Distributed Database Systems Bile Hassan, Ismail Books Course details