【CMU 15-445】00 课程简介

2024-01-10

Word count: 421 | Reading time≈ 1 min

【COURSE INFORMATION】

This course is on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving trees, hash tables), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). Case studies on open-source and commercial database systems are used to illustrate these techniques and trade-offs. The course is appropriate for students with lit systems programming skills.

本课程是关于数据库管理系统的设计和实现。主题包括数据模型（关系、文档、键/值）、存储模型（n元、分解）、查询语言（SQL、存储过程）、存储架构（堆、日志结构）、索引（保序树、哈希）表）、事务处理（ACID、并发控制）、恢复（日志记录、检查点）、查询处理（连接、排序、聚合、优化）和并行架构（多核、分布式）。开源和商业数据库系统的案例研究用于说明这些技术和权衡。该课程适合具有计算机系统编程技能的学生。