ICS 611

Distributed Database Systems

4 Graduate credits
Effective August 26, 2006 – Present

Graduation requirements this course fulfills

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.

Special information

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.

Learning outcomes

General

  • Allocate replicas of fragments for best performance.
  • Optimize queries for optimal performance across a distributed database.
  • Fragment a database both horizontally and vertically for optimal performance.
  • 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.