Engaged in the distributed system development for a long time, recently made a courageous decision: devoted to the domestic database industry — give up anxiety, hand in hand into the bureau. Although the previous work had certain correlation, it was not systematic enough, so I spent time to sort out the knowledge graph of a database system, and learned while doing and learning while doing according to the outline.
Also make an outline and share learning resources and tips
| 1 Database Concept | What a database library is | https://www.zhihu.com/question/26802517/answer/1234617717 |
| Data model: hierarchical, network, relational model | https://zhuanlan.zhihu.com/p/101890657 | |
| The SQL statement |
https://juejin.cn/post/6977915868034367496 https://juejin.cn/column/6973102921622208543 https://juejin.cn/post/6983994955949670431 |
|
| Nosql database: wide columns, graphs, documents, timing | ||
| 2 Database Design | Database design and ER model | https://zhuanlan.zhihu.com/p/29029129 |
| Relational Database design | https://zhuanlan.zhihu.com/p/64660884 | |
| Application design and development |
https://juejin.cn/post/6977303573830828068 https://juejin.cn/post/6970933389247381541 |
|
| 3 Data storage and Query | Storage and file structure | |
| Index and hash | ||
| Query processing | ||
| Query optimization | ||
| 4 Transaction Management | The transaction | |
| Concurrency control | ||
| Recovery system | ||
| 5 System architecture | Centralized and client-server architecture | |
| Parallel system | ||
| Distributed system | ||
| Network type | ||
| Data warehouse and data mining | The data warehouse |
https://juejin.cn/post/6976050684542058509 https://juejin.cn/post/6974689270418112526 |
| Data mining |
https://juejin.cn/post/6976923356494823432 https://juejin.cn/post/6976562433695416327 https://juejin.cn/post/6970933650342805512 |
|
| classification | ||
| clustering | ||
| other | ||
| Traditional database, distributed database, and cloud database | Mysql | https://www.mysql.com/cn/products/community/ |
| PostgreSql | http://www.postgres.cn/ | |
| SqlServer | https://www.microsoft.com/ | |
| Tidb | https://pingcap.com/ | |
| OceanBase | https://www.oceanbase.com/ | |
| MemFireDB | https://memfiredb.com |
|
| 8 Database client | navicat | http://www.navicat.com.cn/ |
| dbeaver | https://dbeaver.io/ | |
| datagrip | https://www.jetbrains.com/zh-cn/datagrip/ | |
| other |
||
| 9 Operation and maintenance Management | Database Instance Management | |
| Table space, schema, table management | ||
| User management | ||
| Connection management | ||
| Import and export | ||
| Backup recovery |