西维蜀黍

【Database】Overview


【Database】Column-oriented DBMS(列式数据库管理系统)


【Database】Entity Relationship (E-R) Diagrams


【Database】Online Transaction Processing (OLTP) vs Online Analytical Processing (OLAP)


【Database】Write-ahead Logging (Redo Logs)


【Database】索引 - 哈希索引 VS B+ Tree 索引


【Database】存储引擎(Storage Engine)


【Database】索引 - Build an LSM-tree Database


【Database】索引 - LSM Trees VS B+ Trees


【Database】索引 - 数据结构


【Data Structure】稀疏索引(Sparse Indexes)


【Database】索引 - Log-structured Merge-Tree(LSM-Tree)


【Database】索引 - 哈希索引(Hash Indexes)


【MySQL】Best Practice


【Database】冷热存储数据分离


【Database】事务(Transactions)


【Database】ACID


【Database】Cassandra


【Database】索引 - 聚集索引(Clustered Index)与非聚集索引(Non-clustered Index)


【Database】读写分离(Read/Write Splitting)


【Database】分库分表(DB sharding)


【Distributed System】分布式事务 - Saga


【Distributed System】分布式事务 - TCC


【Distributed System】分布式事务(Distributed Transactions)


【Database】数据库连接池(Connection Pool)


【Database】索引(Index)


【Database】索引 - B 树和 B+ 树


【Database】Transactions - 两阶段锁(Two-phase Locking)


【Distributed System】分布式事务 - 三阶段提交协议(Three-phase Commit Protocol)


【Distributed System】分布式事务 - 两阶段提交协议(Two-phase Commit Protocol)


【Database】Transactions - Isolation Levels


【Database】Transactions - Consistent Anomalies


【Database】Transactions - Consistent Anomalies Demo


【Database】Concurrency Control


【Database】Relationship between Tables