Commit Graph

846 Commits

Author SHA1 Message Date
Gang Yin
a4be89bdf7 update PR list 2022-10-16 22:05:28 +08:00
Gang Yin
1c20fe3b37 fix a comma 2022-10-15 21:29:01 +08:00
Gang Yin
247fb1f647 update PR list and zh-tw content 2022-10-12 17:52:05 +08:00
YIN, Gang
09ca9a1afe
Merge pull request #270 from Ynjxsjmh/patch-2
Fix “更新丢失” to “丢失更新” in ch7.md
2022-10-12 17:50:02 +08:00
Winy Song
95f51ebdf6
Fix “更新丢失” to “丢失更新” in ch7.md
第一处

原文:

> However, read committed does not prevent the race condition between two
> counter increments in Figure 7-1. In this case, the second write happens after the
> first transaction has committed, so it’s not a dirty write. It’s still incorrect, but for
> a different reason—in **“Preventing Lost Updates”** on page 242 we will discuss how
> to make such counter increments safe.

翻译:

> 但是,读已提交并不能防止 [图 7-1](https://github.com/Vonng/ddia/blob/master/img/fig7-1.png) 中两个计数器增量之间的竞争状态。在这种情况下,第二次写入发生在第一个事务提交后,所以它不是一个脏写。这仍然是不正确的,但是出于不同的原因,在 **“[防止更新丢失](https://github.com/Vonng/ddia/blob/master/ch7.md#%E9%98%B2%E6%AD%A2%E4%B8%A2%E5%A4%B1%E6%9B%B4%E6%96%B0)”** 中将讨论如何使这种计数器增量安全。

--------------

第二处

原文:

> **Lost updates**
> Two clients concurrently perform a read-modify-write cycle. One overwrites the
> other’s write without incorporating its changes, so data is lost. Some implemen‐
> tations of snapshot isolation prevent this anomaly automatically, while others
> require a manual lock (SELECT FOR UPDATE).

翻译:

> **更新丢失**
> 两个客户端同时执行 读取 - 修改 - 写入序列。其中一个写操作,在没有合并另一个写入变更情况下,直接覆盖了另一个写操作的结果。所以导致数据丢失。快照隔离的一些实现可以自动防止这种异常,而另一些实现则需要手动锁定(SELECT FOR UPDATE)。
2022-10-12 16:40:00 +08:00
Gang Yin
f81763bc1e update zh-tw content 2022-10-10 11:51:04 +08:00
Gang Yin
438cd62228 update contribution list and some formatting in ch3.md 2022-10-10 11:50:46 +08:00
YIN, Gang
406b558a0d
Merge pull request #268 from MamaShip/master
优化第三章的部分语句
2022-10-10 11:35:45 +08:00
MamaShip
1398d462ba 优化第三章的部分语句 2022-09-30 16:07:26 +08:00
YIN, Gang
7bad8a04f6
Merge pull request #266 from MamaShip/master
优化第二章后半部分
2022-09-29 18:01:06 +08:00
MamaShip
a422ae808c 优化第二章后半部分 2022-09-29 12:40:07 +08:00
YIN, Gang
11feafbc3a
Merge pull request #265 from MamaShip/master
优化第二章的部分文字
2022-09-28 20:43:59 +08:00
MamaShip
0b41a5c52c 优化第二章的部分文字 2022-09-28 18:03:34 +08:00
YIN, Gang
7ea76b00e3
Merge pull request #264 from MamaShip/master
minor fix: 正确区分「可扩展性」与「可伸缩性」
2022-09-27 22:06:01 +08:00
MamaShip
faa82f20cf minor fix: 正确区分「可扩展性」与「可伸缩性」 2022-09-27 18:01:22 +08:00
YIN, Gang
843801c56e
Merge pull request #263 from zydmayday/remove-duplicated
Update ch5.md
2022-09-11 21:12:32 +08:00
Zhang Yidong
b85460bc68
remove duplicated 2022-09-11 22:02:56 +09:00
Gang Yin
05df23449c update zh-tw content and PR list 2022-08-09 12:22:51 +08:00
Gang Yin
1a64c13f98 update the last merged PR 2022-08-09 12:20:32 +08:00
YIN, Gang
dee7f4bff3
Merge pull request #260 from haifeiWu/master
修改部分翻译不准确的问题
2022-08-09 12:18:33 +08:00
wuhaifei
3a752ab340 修改部分翻译不准确的问题 2022-08-07 16:54:47 +08:00
Gang Yin
dba3f180e5 update PR list 2022-08-05 23:17:00 +08:00
Gang Yin
641cc67ac8 update zh-tw content 2022-08-05 23:11:44 +08:00
YIN, Gang
284e2d657f
Update ch7.md
materializing conflict -> materializing conflicts
2022-08-05 22:48:43 +08:00
YIN, Gang
dee0cb6c08
Merge pull request #256 from AlphaWang/ch7
fix ch7-transaction: serializability
2022-08-05 22:07:53 +08:00
YIN, Gang
68e67c6021
Merge pull request #258 from bestgrc/master
Update ch3.md
2022-08-05 20:27:15 +08:00
顾仁才
dcfc5440fd
Update ch3.md
profit margin = 利润率
2022-08-05 17:52:28 +08:00
YIN, Gang
b71baf1120
Merge pull request #257 from UnderSam/patch-1
Fix: typo nonderterministic
2022-08-03 10:26:30 +08:00
Cheng Ju Wu
50fda1e0d8
Fix: typo nonderterministic
nonderterministic -> nondeterministic
2022-08-03 00:27:04 +08:00
AlphaWang
c564c08884 fix ch7-transaction: serializability 2022-08-01 23:41:25 +08:00
AlphaWang
b9ea463bc6 Merge branch 'master' into ch7 2022-08-01 23:28:24 +08:00
AlphaWang
308066113c fix ch7-transaction: serializability 2022-08-01 23:27:44 +08:00
YIN, Gang
1a946c5ed2
Merge pull request #255 from AlphaWang/ch7
fix transaction: repeatable read
2022-07-31 12:28:00 +08:00
AlphaWang
663d64030d Merge branch 'master' into ch7 2022-07-30 23:46:25 +08:00
AlphaWang
85f2242841 fix ch7-transaction: repeatable read 2022-07-30 23:45:32 +08:00
Gang Yin
9e59aa3417 update zh-tw content and PR list 2022-07-30 10:17:42 +08:00
YIN, Gang
991371aad9
Merge pull request #253 from AlphaWang/ch7
fix ch7-transaction: Read Committed
2022-07-30 10:12:17 +08:00
AlphaWang
e38874da61 fix ch7-transaction: Read Committed 2022-07-29 23:34:39 +08:00
YIN, Gang
fa4debc715
Merge pull request #252 from songzhibin97/patch-51
Update ch9.md
2022-06-14 19:31:34 +08:00
YIN, Gang
fe79062b86
Merge pull request #251 from songzhibin97/patch-50
Update ch9.md
2022-06-14 19:29:37 +08:00
songzhibin97
42cd5096e7
Update ch9.md 2022-06-14 12:39:17 +08:00
songzhibin97
71e17320f7
Update ch9.md 2022-06-14 10:27:20 +08:00
YIN, Gang
29e1013109
Merge pull request #250 from songzhibin97/patch-49
Update ch9.md
2022-06-13 17:58:55 +08:00
songzhibin97
9d179f07c2
Update ch9.md 2022-06-13 17:56:27 +08:00
Gang Yin
34b1598ac4 update PR list and zh-tw content 2022-06-13 09:59:06 +08:00
YIN, Gang
20611e27d0
Merge pull request #249 from songzhibin97/patch-48
Update ch9.md
2022-06-12 08:50:48 +08:00
songzhibin97
7b82956ce5
Update ch9.md 2022-06-11 20:48:20 +08:00
YIN, Gang
2e878e7808
Merge pull request #248 from songzhibin97/patch-47
Update ch9.md
2022-06-11 18:53:49 +08:00
songzhibin97
f7ab4a256e
Update ch9.md 2022-06-11 18:08:35 +08:00
songzhibin97
585007faf9
Update ch9.md 2022-06-11 17:58:26 +08:00