C S 84B: DISTRIBUTED DATABASES
Foothill College Course Outline of Record
| Heading | Value |
|---|---|
| Effective Term: | Summer 2021 |
| Units: | 4.5 |
| Hours: | 4 lecture, 2 laboratory per week (72 total per quarter) |
| Advisory: | C S 31A or equivalent. |
| Degree & Credit Status: | Degree-Applicable Credit Course |
| Foothill GE: | Non-GE |
| Transferable: | CSU |
| Grade Type: | Letter Grade (Request for Pass/No Pass) |
| Repeatability: | Not Repeatable |
Student Learning Outcomes
- Design a distributed database with implementation strategies to maintain transaction and concurrency control
- Develop query processing and optimization strategies for an existing distributed database design
- Develop data replication and integration plans for an existing distributed database design
Description
Course Objectives
The student will be able to:
A. Design a distributed database
B. Design implementation techniques for transactions and concurrency control
C. Design query processing and optimization strategies
D. Design data replication and integration plans
E. Design a schema mapping for a peer-to-peer system
F. Evaluate database management solutions for distributed databases including solutions for Cloud applications
Course Content
A. Distributed Database Design
1. What is a distributed database system?
B. Promises and Complications of Distribution
C. Design Issues
D. Architecture
E. Top-Down Design Process
F. Transaction Implementation Techniques
1. Definition of a transaction
2. Properties and types of transactions
G. Architecture Revisited for Transaction Management
H. Concurrency Control
I. Serializability Theory
J. Locking-Based Concurrency Control Mechanisms
1. Timestamp-based concurrency control mechanisms
2. Optimistic concurrency control
K. Deadlock Management
L. Query Processing and Optimization
1. Issues in multi-database query processing
2. Multi-database query processing architecture
3. Query optimization and execution
4. Timestamp-based concurrency control mechanisms
5. Optimistic concurrency control
6. Deadlock management
M. Data Replication
1. What is a replicated database?
2. Consistency of replicated databases
3. Update management strategies
4. Replication protocols
N. Data Integration
1. Bottom-up design methodology
2. Schema matching
3. Schema integration
4. Schema mapping
O. Peer-to-Peer Systems
1. Infrastructure
2. Querying over P2P systems
P. Distributed Database Solutions
1. Hadoop
2. Map-Reduce and Pig
3. Publish/subscribe systems
Q. Data Management in the Cloud
R. Cloud Architectures
S. Data Management Systems for Cloud Computing
1. BigTable
2. Map-Reduce
3. PNUTS
Lab Content
A. Create a distributed database design given predefined set of requirements
B. Evaluate transaction implementation techniques including the appropriate transaction locking given a set of business constraints
C. Fill in gaps or inconsistencies in a set of concurrency control rules for an existing distributed database design
D. Evaluate a query processing and optimization plan for an existing distributed database design
E. Complete a data replication plan given a partial plan
F. Prepare a schema mapping for a given incomplete data integration plan
G. Evaluate a given schema mapping for a peer-to-peer system
H. Recommend one open source solution given a real-world scenario
I. Compare and contrast two data management systems for Cloud computing
Special Facilities and/or Equipment
B. When taught via Foothill Global Access on the Internet, the college will provide a fully functional and maintained course management system through which the instructor and students can interact.
C. When taught via Foothill Global Access on the Internet, students must have currently existing email accounts and ongoing access to computers with internet capabilities.
Method(s) of Evaluation
Exams and quizzes
Distributed database design assignments
Project including implementation design for a distributed database for a real- world scenario
Method(s) of Instruction
Lectures
Online labs (including sections meeting face-to-face/on-campus), consisting of:
1. An assignment webpage located on a college-hosted course management system or other department-approved internet environment. Here, the students will review the specification of each assignment and submit their completed lab work
2. A discussion webpage located on a college-hosted course management system or other department-approved internet environment. Here, students can request assistance from the instructor and interact publicly with other class members
3. Detailed review of assignment which includes model solutions and specific comments on the student submissions
4. In-person or online discussion, which engages students and instructor in an ongoing dialog, pertaining to all aspects of database management systems
When course is taught fully online:
1. Instructor-authored lecture materials, handouts, syllabus, assignments, tests, and other relevant course material will be delivered through a college-hosted course management system or other department-approved internet environment
Representative Text(s) and Other Materials
Ozsu, M. Tamer, and Patrick Valduriez. Principles of Distributed Database Systems, 3rd ed.. 2011.
Klepman, Martin. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. 2017.
Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments
A. Reading:
1. Textbook assigned reading averaging 30 pages per week.
2. Reading online resources as directed by instructor though links pertinent to databases.
3. Reading library and reference material directed by instructor through course handouts.
B. Writing:
1. Technical prose documentation, that supports and describes the database-driven web application assignments that are submitted for grades. The document would include the following aspects of the database application:
2. A description of the web application including functional and data requirements.
3. A description of the database including data type, valid data ranges, constraints and keys.
4. A help page for users of the web application. This may be an FAQ or user manual style help page.