Resources

• https://cloud.tencent.com/developer/article/1694495
• https://www.youtube.com/watch?v=J0nbgXIarhc&ab_channel=CMUDatabaseGroup
• https://zhuanlan.zhihu.com/p/144926830
• https://zhuanlan.zhihu.com/p/35622907
• https://zhuanlan.zhihu.com/p/54484592
• https://zhuanlan.zhihu.com/p/100933389
• https://www.bilibili.com/video/BV1Bt411v7ST
• https://www.the-paper-trail.org/post/2013-01-30-columnar-storage/

compression

Resources

• https://15445.courses.cs.cmu.edu/fall2022 课程官网
• https://github.com/cmu-db/bustub Bustub Github Repo
• https://www.gradescope.com/ 自动测评网站 GradeScope
• https://discord.gg/YF7dMCg Discord 论坛，课程交流用
• https://www.bilibili.com/video/BV1Bg411w7kW/?spm_id_from=333.999.0.0&vd_source=06def12065e2f44a1283169bd13b48bc Moody老师的中文讲解ppt
• https://15445.courses.cs.cmu.edu/fall2022/bpt-printer/ B+ 树插入删除的官方printer

Resources

• https://15445.courses.cs.cmu.edu/fall2022 课程官网
• https://github.com/cmu-db/bustub Bustub Github Repo
• https://www.gradescope.com/ 自动测评网站 GradeScope
• https://discord.gg/YF7dMCg Discord 论坛，课程交流用
• https://www.bilibili.com/video/BV1Bg411w7kW/?spm_id_from=333.999.0.0&vd_source=06def12065e2f44a1283169bd13b48bc Moody老师的中文讲解ppt
• https://15445.courses.cs.cmu.edu/fall2022/bpt-printer/ B+ 树插入删除的官方printer

今天分享的曲子是《The Nearness of You》

参考链接：

• Transcription https://www.youtube.com/watch?v=6g9IdpdKfXQ&ab_channel=EdmundB
• Unknown transcription anaylysis https://www.youtube.com/watch?v=1kBA09Hugcs&ab_channel=JazzPianoSchool.com-LearningFreedom%28OnlineJazzPianoCourses%29
• Red garland course https://community.pianogroove.com/t/how-to-play-like-red-garland/4101/4
• Solo analysis https://www.freejazzlessons.com/red-garlands-solo-on-what-is-this-things-called-love-learn-to-really-solo/
• Play like red garland https://jazz-library.com/articles/red-garland/
• Solo analysis http://thejazzlanguage.com/tag/rhythm-changes/
• Red garland’s block chords style https://www.riccardoscivales.com/billy-boy-red-garlands-block-chords-style/

新开坑，目测相当长的一段时间里会更新一系列”play like red garland”文章（虽然大家都不屑于把Red Garland和George Shearing, Nat King Cole, Oscar Peterson, Barry Harris等人放在一起比较，但是对于初学者的我来讲很好听），当然说是analysis，更算是笔记

当然可以先看看大致风格

前言

​ 这次的lab/project分为三个步骤：实现extendible hash table, 实现LRU k replacer，实现buffer pool manager instance。值得注意的是在第三个实现会调用前两个实现，因此如果使用autograder，最好先让前两个满分（56），然后再测评第三个。

​ 对我而言，在实现时画类图蛮有效的（毕竟无法过目不忘），因此实验完成之后整理了大类关系图。接下来也会部分截图辅助说明思路。

目的

​ 目的就是让你熟悉一下SQL查询的书写，大致了解查询的

• 语法
• 嵌套
• 执行优先顺序

Resources

• 课程官网
• 官方课程视频
• Bilibili 课程视频
• P. Boncz, et al., MonetDB/X100: Hyper-Pipelining Query Execution, in CIDR, 2005
• L. Shrinivas, et al., Materialization Strategies in the Vertica Analytic Database: Lessons Learned, in ICDE, 2013 (Optional)
• M. Kester, et al., Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?, in SIGMOD, 2017 (Optional)

环境配置

2022官网，跟着配置即可，推荐使用linux，windows/docker官网不推荐，个人不推荐mac，因为mac的新版本发布后导致gdb使用困难

lab通关记录

课程安排

https://pdos.csail.mit.edu/6.828/2017/schedule.html

b站视频

https://www.bilibili.com/video/BV19k4y1C7kA?from=search&seid=14266879966158464981&spm_id_from=333.337.0.0

个人安排：书–讲义–视频–材料–实验–回顾笔记–循环