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.
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.
Prerequisites
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.
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 2025
| Section | Title | Instructor | books | eservices |
|---|---|---|---|---|
| 01 | Distributed Database Systems | Bile Hassan, Ismail | Books for ICS-611-01 Spring 2025 | Course details for ICS-611-01 Spring 2025 |