Design and Implementation Techniques of Database Systems

Number: 
CMPSC 174B
Level: 
Undergraduate
Units: 
4

Description

Prerequisite: Computer Science 130B.
Recommended Preparation: Students are strongly encouraged to complete Computer Science 56 prior to enrolling in Computer Science 174B.
Queries and processing, optimizer, cost models, execution plans, rewriting rules, access methods, spatial indexing; transactions, ACID properties, concurrency control, serializability, two-phase locking, timestamping, logging,checkpointing, transaction abort and commit, crash recovery; distributed databases.