CS-422: Database systems

Lectures in this course (129)

Covers the architectures for parallel databases, including Shared Memory, Shared Disk, and Shared Nothing.

Explores distributed transactions, covering coordination, concurrency control, recovery, and the Two-Phase Commit protocol.

Explores memory hierarchy, CPU caches, SSD, HDD, and disk storage anatomy.

Explores replication strategies in distributed systems, covering synchronous, asynchronous replication, and conflict resolution.

Explores NoSQL databases, CAP theorem, BASE principles, and eventual consistency in distributed systems.

Explores file and page organization in databases, cache management, and log-structured files.

Discusses buffer management in a DBMS, covering challenges, buffer pool, and replacement policies.

Explores the N-ary Storage Model, fixed-length and variable-length record formats, and storage hierarchy.

Explores the advantages of Decomposition Storage Model with column-oriented storage and various compression techniques.

Page 7 of 7