[db] dbms

[Alice52]

rdbms

1. dimension

   • 架构:
   • 生态
   • HA
   • 部署|备份
   • crash safe
   • 性能
   • 磁盘
   • cpu
   • 数据量
   • 数据类型: json/text 等大字段支持
   • 表|试图
   • 索引
   • 事务
   • 锁
   • SP
   • 统计分析

2. mysql vs pgsql

3. mysql vs mongodb

---

product

1. mysql/mariadb
2. pgsql
3. tidb
4. mongodb
5. redis
6. es/os

rdbms vs dbms

1. Number of allowed users.
2. Hardware and software requirements.
3. Amount of data.
4. Database structure.
5. ACID implementation.
6. Distributed databases
7. Types of programs managed.
8. Support of database normalization.

---

• [x] 1. 关系型数据库对比
• [x] 2. MongoDB 的架构
• [x] 3. nosql vs sql
• [x] 4. mysql partition

[Alice52]

https://www.cnblogs.com/qiezi777/p/16851422.html https://zhuanlan.zhihu.com/p/519946960

https://zhuanlan.zhihu.com/p/87833412 https://www.zhihu.com/question/20092344 https://www.zhihu.com/question/20010554

https://time.geekbang.org/column/article/82560