| 1. coding |
- Creating Great Programmers with a Software Design Studio
- Criteria for modularization |
|
|
| 2.introduce to document database |
- Design Philosophy
- A Technical Introduction to WiredTigerl
- understand JSON |
|
Document-oriented DB:MongoBD(1) |
| 3. Logging |
- Durability _
- write-ahead logging
- Linearizability introduction ,
- Linearizability original paper |
|
存储的正确性 |
| 4. Availability |
- Raft protocol (importent),
- MongoDB Consensus internal (optional)
- Triple modular redundancy |
|
High availability - fault tolerant |
| 5. Design for document database |
- Data Modeling for Document Database
- Rules of Thumb for MongoDB Schema Design
- ORM |
|
|
| 6. Data Model(relation database) |
- Network Model
- Hierarchy Model (a bit similar to mongodb)
- Original paper on relational model by Codd 1/2)
- History of RDBMS at IBM, an interesting read
- About Expressiveness) |
|
data model |
| 7. SQL |
|
|
SQL(1)
SQL(2)
SQL(3) |
| 8. RelationDB design |
|
|
关系数据库的逻辑设计 |
| 9. Normalization |
|
|
关系数据库规范化 |
| 8. Physical Design |
|
- 物化视图
- 强函数依赖
- B-Tree
- 聚簇索引
- 索引的设计
- 存储过程（UDP） |
|
| 10. Transaction |
- Compensating Transaction
- MongoDB Transaction |
- SQL Transaction |
|
| 11. Object Relational Mismatch |
- Object Relational Mismatch Problems
- Two Camps of Opinions
- Class first
- Data first |
|
|
| 12. Query Process |
|
|
|
| 13. OLAP |
|
|
|
| 14. Database Tuning |
- Database Tuning 1st Edition |
|
|
| 15. Distributed DB |
|
|
|
| 16. Transction in DDB |
|
|
|
| 17. Scalability |
|
|
|
| 18. NewSQL |
|
|
|
| 19. Search engine |
|
|
|
| 20. Indexing |
- Multidimensional Indexing
- k-d tree
- R-tree |
- KD Tree
- Curse of dimension |