Skip to main content

Apply Today! Undergraduate final deadline is August 1

—

Metro State will observe Summer Hours May 22–July 25: On Fridays, services will be virtual only, and buildings will be closed Fridays and Saturdays (except the Library will be open Fridays and Saturdays from 10 a.m-6 p.m.).
Metro State University (Home)

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.