# open-courses

## open-courses

- [公开课笔记](https://zhenghe.gitbook.io/open-courses/master.md)
- [Relational Data Model](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/relational-data-model.md)
- [Advanced SQL](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/advanced-sql.md): 本节介绍 SQL 的部分复杂用法
- [Database Storage](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/database-storage.md): 数据库存储层
- [Buffer Pools](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/buffer-pools.md)
- [Hash Tables](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/hash-tables.md)
- [Tree Indexes](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/tree-indexes.md)
- [Index Concurrency Control](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/index-concurrency-control.md)
- [Query Processing](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/query-processing.md)
- [Sorting\&Aggregations](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/sorting-and-aggregations.md)
- [Join Algorithms](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/join-algorithms.md)
- [Query Optimization](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/query-optimization.md)
- [Parallel Execution](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/parallel-execution.md)
- [Embedded Database Logic](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/embedded-database-logic.md)
- [Concurrency Control Theory](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/concurrency-control-theory.md)
- [Two Phase Locking](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/two-phase-locking.md)
- [Timestamp Ordering Concurrency Control](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/timestamp-ordering-concurrency-control.md)
- [Multi-Version Concurrency Control](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/multi-version-concurrency-control.md)
- [Logging Schemes](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/logging-schemes.md)
- [Database Recovery](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/database-recovery.md)
- [Introduction to Distributed Databases](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/introduction-to-distributed-databases.md)
- [Distributed OLTP Databases](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/distributed-oltp-databases.md)
- [Distributed OLAP Databases](https://zhenghe.gitbook.io/open-courses/cmu-15-445-645-database-systems/distributed-olap-databases.md)
- [OS intro](https://zhenghe.gitbook.io/open-courses/ucb-cs162/os-intro.md)
- [Introduction to the Process](https://zhenghe.gitbook.io/open-courses/ucb-cs162/os-basics.md)
- [Processes, Fork, I/O, Files](https://zhenghe.gitbook.io/open-courses/ucb-cs162/process.md)
- [I/O Continued, Sockets, Networking](https://zhenghe.gitbook.io/open-courses/ucb-cs162/os-basics-iii.md): 进程间通信
- [Concurrency: Processes & Threads](https://zhenghe.gitbook.io/open-courses/ucb-cs162/processes-and-threads.md)
- [Cooperating Threads, Synchronization](https://zhenghe.gitbook.io/open-courses/ucb-cs162/cooperating-threads-synchronization.md)
- [Semaphores, Condition Variables, Readers/Writers](https://zhenghe.gitbook.io/open-courses/ucb-cs162/semaphores-condition-variables-readers-writers.md)
- [Scheduling](https://zhenghe.gitbook.io/open-courses/ucb-cs162/scheduling.md)
- [Resource Contention & Deadlock](https://zhenghe.gitbook.io/open-courses/ucb-cs162/resource-contention-and-deadlock.md)
- [Address Translation, Caching](https://zhenghe.gitbook.io/open-courses/ucb-cs162/address-translation.md)
- [File System (18,19,20)](https://zhenghe.gitbook.io/open-courses/ucb-cs162/file-system-18-19.md)
- [Distributed Systems, Networking, TCP/IP, RPC (21,22)](https://zhenghe.gitbook.io/open-courses/ucb-cs162/distributed-systems-networking-tcp-ip-rpc-21-22.md): 本节可以理解成是计算机网络原理课程的一个概括
- [Distributed Storage, Key-Value Stores, Security (23)](https://zhenghe.gitbook.io/open-courses/ucb-cs162/distributed-storage-key-value-stores-security-23.md)
- [Security & Cloud Computing (24)](https://zhenghe.gitbook.io/open-courses/ucb-cs162/security-and-cloud-computing-24.md)
- [Topic: Ensuring Data Reaches Disk](https://zhenghe.gitbook.io/open-courses/ucb-cs162/topic-ensuring-data-reaches-disk.md): 本文翻译自这篇文章：https://lwn.net/Articles/457667/
- [Sequence and Set Interface](https://zhenghe.gitbook.io/open-courses/mit-6.006/sequence-and-set-interface.md)
- [Data Structure for Dynamic Sequence Interface](https://zhenghe.gitbook.io/open-courses/mit-6.006/data-structure-for-dynamic-sequence-interface.md)
- [Computation Complexity](https://zhenghe.gitbook.io/open-courses/mit-6.006/computation-complexity.md)
- [Algorithms and Computation](https://zhenghe.gitbook.io/open-courses/mit-6.006/algorithms-and-computation.md)
- [Structure Of Computation](https://zhenghe.gitbook.io/open-courses/mit-6.006/structure-of-computation.md)
- [Graph & Search](https://zhenghe.gitbook.io/open-courses/mit-6.006/graph-and-search.md)
- [Tree & Search](https://zhenghe.gitbook.io/open-courses/mit-6.006/tree-and-search.md): 树以及树搜索算法
- [Weighted Shortest Paths](https://zhenghe.gitbook.io/open-courses/mit-6.006/weighted-shortest-paths.md)
- [String Matching, Karp-Rabin](https://zhenghe.gitbook.io/open-courses/mit-6.006/string-matching-karp-rabin.md)
- [Priority Queue Interface & Implementation](https://zhenghe.gitbook.io/open-courses/mit-6.006/priority-queue-interface-and-implementation.md)
- [Dictionary Problem & Implementation](https://zhenghe.gitbook.io/open-courses/mit-6.006/dictionary-problem-and-implementation.md)
- [Sorting](https://zhenghe.gitbook.io/open-courses/mit-6.006/sorting.md): 总结排序算法，不局限于本课程所述的部分
- [Dynamic Programming](https://zhenghe.gitbook.io/open-courses/mit-6.006/dynamic-programming.md): 动态规划
- [Backtracking](https://zhenghe.gitbook.io/open-courses/mit-6.006/backtracking.md)
- [Self-Balancing Tree](https://zhenghe.gitbook.io/open-courses/mit-6.006/self-balancing-tree.md)
- [2PC & 3PC](https://zhenghe.gitbook.io/open-courses/mit-6.824/2pc-and-3pc.md)
- [Introduction and MapReduce](https://zhenghe.gitbook.io/open-courses/mit-6.824/di-yi-ke-jie-shao.md): 2015/2018 Lecture 1
- [RPC and Threads](https://zhenghe.gitbook.io/open-courses/mit-6.824/di-er-ke-rpc-yu-xian-cheng.md): 2015/2018 - Lecture 2
- [Primary/Backup Replication](https://zhenghe.gitbook.io/open-courses/mit-6.824/di-san-ke-zhu-cong-fu-zhi.md): 6.824 2015 Lecture 3/2018 Lecture 4
- [Lab: Primary/Backup Key/Value Service](https://zhenghe.gitbook.io/open-courses/mit-6.824/shi-yan-2primarybackup-keyvalue-service.md): 2015 Lab2
- [Google File System (GFS)](https://zhenghe.gitbook.io/open-courses/mit-6.824/google-file-system-gfs.md): 2018 - Lecture 3
- [Raft](https://zhenghe.gitbook.io/open-courses/mit-6.824/raft-part-1.md)
- [Lab: Raft - Leader Election](https://zhenghe.gitbook.io/open-courses/mit-6.824/lab-raft-leader-election.md): 以下为本人在完成 Lab 2 过程中的总结，不涉及代码细节
- [Lab: Raft - Log Replication](https://zhenghe.gitbook.io/open-courses/mit-6.824/lab-raft-log-replication.md)
- [原始数据类型及相互转化](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-er-ke-yuan-shi-shu-ju-lei-xing-ji-xiang-hu-zhuan-hua.md): 第二课
- [指鹿为马](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-san-ke-zhi-lu-wei-ma.md): 第三课
- [泛型函数](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-si-wu-ke-fan-xing-han-shu.md): 第四、五课
- [泛型栈](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-liu-ke-fan-xing-zhan.md): 第六课
- [运行时内存结构](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-qi-ba-ke-yun-hang-shi-nei-cun-jie-gou.md): 第七、八课
- [从 C 到汇编](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-jiu-ke-cong-c-dao-hui-bian.md): 第九课
- [函数的活动记录](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-ke-han-shu-de-ji-lu-huo-dong.md): 第十课
- [C 与 C++ 代码生成](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-yi-ke-c-yu-c++-dai-ma-sheng-cheng.md): 第十一课
- [编译的预处理过程](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-er-ke-bian-yi-de-yu-chu-li-guo-cheng.md): 第十二课
- [编译的链接过程](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-san-ke-bian-yi-de-lian-jie-guo-cheng.md): 第十三课
- [函数的活动记录续、并发](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-si-ke-han-shu-de-huo-dong-ji-lu-xu-bing-fa.md): 第十四课
- [从顺序到并发和并行](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-wu-ke-cong-shun-xu-dao-bing-fa-he-bing-hang.md): 第十五课
- [信号量与多线程 1](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-liu-ke-xin-hao-liang-yu-duo-xian-cheng-1.md): 第十六课
- [信号量与多线程 2](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-qi-ke-xin-hao-liang-yu-duo-xian-cheng-2.md): 第十七课
- [复杂多线程问题](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-ba-ke-fu-za-duo-xian-cheng-wen-ti.md): 第十八课
- [函数式编程 - Scheme 1](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-shi-jiu-ke-han-shu-shi-bian-cheng-scheme-1.md): 第十九课
- [函数式编程 - Scheme 2](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-er-shi-ke-han-shu-shi-bian-cheng-scheme-2.md): 第二十课
- [函数式编程 - Scheme 3](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-er-shi-yi-ke-han-shu-shi-bian-cheng-scheme-3.md): 第二十一课
- [函数式编程 - Scheme 4](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-er-shi-er-ke-han-shu-shi-bian-cheng-scheme-4.md): 第二十二课
- [函数式编程 - Scheme 5](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-er-shi-san-ke-han-shu-shi-bian-cheng-scheme-5.md): 第二十三课
- [Python 基础](https://zhenghe.gitbook.io/open-courses/stanford-cs107/di-er-shi-si-er-shi-liu-ke-python-ji-chu.md): 第二十四 - 二十六课
- [什么是程序](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/shen-me-shi-cheng-xu.md)
- [程序抽象](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/cheng-xu-chou-xiang.md)
- [替代模型](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/ti-dai-mo-xing.md)
- [时间/空间复杂度](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/shi-jian-kong-jian-fu-za-du.md)
- [数据抽象](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/shu-ju-chou-xiang.md)
- [高阶函数](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/gao-jie-han-shu.md)
- [Symbol](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/symbol.md)
- [数据驱动编程与防御式编程](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/shu-ju-qu-dong-bian-cheng-yu-fang-yu-shi-bian-cheng.md)
- [数据抽象中的效率与可读性](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/shu-ju-chou-xiang-zhong-de-xiao-lv-yu-ke-du-xing.md): 十一课
- [数据修改](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/shu-ju-xiu-gai.md): 十二课
- [环境模型](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/huan-jing-mo-xing.md): 十三课
- [面向对象-消息传递](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/mian-xiang-dui-xiang-xiao-xi-chuan-di.md): 十四课
- [面向对象 - Scheme 实现](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/mian-xiang-dui-xiang-scheme-shi-xian.md): 十五、十六课
- [构建 Scheme 解释器](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/untitled.md): 十七课
- [Eval-Apply Loop](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/eval-apply-loop.md): 十八课
- [Normal Order (Lazy) Evaluation](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/normal-order-lazy-evaluation.md): 十九课
- [通用机](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/tong-yong-ji.md): 二十课
- [寄存器机器](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/ji-cun-qi-ji-qi.md)
- [子程序、栈与递归](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/zi-cheng-xu-zhan-yu-di-gui.md)
- [在寄存器机器中执行](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/zai-ji-cun-qi-ji-qi-zhong-zhi-hang.md): 二十三课
- [内存管理](https://zhenghe.gitbook.io/open-courses/mit-6.001-sicp/nei-cun-guan-li.md): 二十四课
- [Randomized Algorithms](https://zhenghe.gitbook.io/open-courses/mit-6.046/randomized-algorithms.md)
- [Skip Lists](https://zhenghe.gitbook.io/open-courses/mit-6.046/skip-lists.md)
- [Twitter](https://zhenghe.gitbook.io/open-courses/system-design/twitter.md)
- [Cache Consistency & Coherence](https://zhenghe.gitbook.io/open-courses/system-design/cache-consistency-and-coherence.md)
- [Replication](https://zhenghe.gitbook.io/open-courses/ddia-bi-ji/topic-replication.md)
- [Transactions](https://zhenghe.gitbook.io/open-courses/ddia-bi-ji/transactions.md)
- [The Trouble with Distributed Systems](https://zhenghe.gitbook.io/open-courses/ddia-bi-ji/the-trouble-with-distributed-systems.md)
- [Consistency & Consensus](https://zhenghe.gitbook.io/open-courses/ddia-bi-ji/consistency-and-consensus.md)
- [Consistent Hashing and Random Trees (1997)](https://zhenghe.gitbook.io/open-courses/papers-we-love/consistent-hashing-and-random-trees-1997.md): Distributed Caching Protocols for Relieving Hot Spots on the World Wide Web\*
- [Dynamic Hash Tables (1988)](https://zhenghe.gitbook.io/open-courses/papers-we-love/dynamic-hash-tables-1988.md): 本文对比 in-memory 版本的 Linear Hashing 和 Spiral Storage
- [LFU Implementation With O(1) Complexity (2010)](https://zhenghe.gitbook.io/open-courses/papers-we-love/lfu-implementation-with-o-1-complexity-2010.md): An O(1) algorithm for implementing the LFU cache eviction scheme
- [Time, Clocks, and the Ordering of Events in a Distributed System (1978)](https://zhenghe.gitbook.io/open-courses/papers-we-love/time-clocks-and-the-ordering-of-events-in-a-distributed-system-1978.md): by Leslie Lamport
- [Dapper, a Large-Scale Distributed Systems Tracing Infrastructure (2010)](https://zhenghe.gitbook.io/open-courses/papers-we-love/dapper-a-large-scale-distributed-systems-tracing-infrastructure.md): Google 的调用链追踪实践
- [Gorilla: A Fast, Scalable, In-Memory Time Series Database (2015)](https://zhenghe.gitbook.io/open-courses/papers-we-love/gorilla-a-fast-scalable-in-memory-time-series-database.md): Facebook 的时序数据库
- [Anti-patterns & Patterns in Microservice Architecture](https://zhenghe.gitbook.io/open-courses/release-it-bi-ji/anti-patterns-and-patterns-in-microservice-architecture.md)
- [Log Structured Merge (LSM) Tree & Usages in KV Stores](https://zhenghe.gitbook.io/open-courses/database-design/log-structured-merge-lsm-tree-and-usages-in-kv-stores.md)
- [Prometheus](https://zhenghe.gitbook.io/open-courses/database-design/prometheus.md): prometheus 学习调研


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on a page URL with the `ask` query parameter:
```
GET https://zhenghe.gitbook.io/open-courses/master.md?ask=<question>
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.