1. Godel, Escher, Bach -- Because it sparked my interest and got me started down the path. 2. The Pragmatic Programmer -- a classic. Reminds me that I need to re-read it. 3. Effective Oracle by Design, by Tom Kyte -- Not that I use Oracle any more, thankfully, but really provided a lot of insight about how databases function and how it pays to deeply understand their internals when writing webapps.
……很难实现。最难的部分其实是确保 #devops 了解这个概念！Oracle 界的知名人物 Tom Kyte 在他的一本书里对这个概念进行了非常精彩的讨论（没记错的话是《Effective Oracle by Design》）。如果我没记错的话，Oracle 的做法是为相关表启用 rowdependencies，然后使用 ora_rowscn。但实际上，你几乎可以使用任何按既定规律变化的东西（时间戳、……
…difficult to implement. The hardest part is actually making sure #devops are aware of the concept ! Tom Kyte, he of Oracle fame had a particularly good discussion of the concept in one of his books (Effective Oracle by Design ... IIRC). IIRC, the Oracle way is to enable rowdependencies for the table(s) in question and then use ora_rowscn. But in reality, you can use almost anything that changes in a defined fashion (timestamps,…
1. 《哥德尔、艾舍尔、巴赫》（GEB）——因为它激起了我的兴趣，引领我走上了这条路。2. 《程序员修炼之道》（The Pragmatic Programmer）——神作。提醒我该重温一遍了。3. 《Effective Oracle by Design》，Tom Kyte 著——倒不是说我现在还用 Oracle，谢天谢地不用了，但它确实对数据库的运行机制提供了大量的真知灼见，也让我明白了写 webapp 时深入理解其底层原理是大有裨益的。
1. Godel, Escher, Bach -- Because it sparked my interest and got me started down the path. 2. The Pragmatic Programmer -- a classic. Reminds me that I need to re-read it. 3. Effective Oracle by Design, by Tom Kyte -- Not that I use Oracle any more, thankfully, but really provided a lot of insight about how databases function and how it pays to deeply understand their internals when writing webapps.
……很难实现。最难的部分其实是确保 #devops 了解这个概念！Oracle 界的知名人物 Tom Kyte 在他的一本书里对这个概念进行了非常精彩的讨论（没记错的话是《Effective Oracle by Design》）。如果我没记错的话，Oracle 的做法是为相关表启用 rowdependencies，然后使用 ora_rowscn。但实际上，你几乎可以使用任何按既定规律变化的东西（时间戳、……
…difficult to implement. The hardest part is actually making sure #devops are aware of the concept ! Tom Kyte, he of Oracle fame had a particularly good discussion of the concept in one of his books (Effective Oracle by Design ... IIRC). IIRC, the Oracle way is to enable rowdependencies for the table(s) in question and then use ora_rowscn. But in reality, you can use almost anything that changes in a defined fashion (timestamps,…