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.
4 Graduate credits
Effective August 26, 2006 to present
- 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.