Lecture: 3 hours
Discussion: 1 hour
Prerequisite: Course 165A
Grading: Letter; projects (60%), final (40%)
Concepts of Distributed Database Systems and Architectures, Distributed Database Design, Distributed Query Processing and Optimization, Transaction Management and Concurrency Control, Heterogeneous and Multidatabase Systems
This course exclusively focuses on the design and system issues related to distributed database systems. Students will learn the usage of different design strategies for distributed databases, and they will study query processing techniques and algorithms as well as transaction management and concurrency control concepts used in such systems. Design and implementation issues related to multidatabase systems are discussed as well.
In the project work, the class will stress on applying the techniques learned in class to commercial database management systems.
Expanded Course Description:
No textbook, a collection of papers addressing specific topics will be distributed in class.
Students work individually on projects in a UNIX workstation environment, using standard UNIX tools as well as major database software packages.
Engineering Design Statement:
The projects involve design, implementation and verification of database applications in a distributed database environment as well as the analysis and verification of query processing algorithms. The systems and tools used for these projects resemble those that would be found in industry to the extent possible, including the standard database query languages SQL and systems such as Oracle, DB2 or Informix. Projects are graded based on the design, performance, and correctness, including documentation. Examination questions are based on models and techniques discussed in the lecture and from the projects.
Instructor: M. Gertz
Prepared by: M. Gertz (February 1999)
THIS COURSE DOES NOT DUPLICATE ANY EXISTING COURSE