Hacker News Comments on
Transaction Processing: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems)
·
5
HN comments
- This course is unranked · view top recommended courses
Hacker News Stories and Comments
All the comments and stories posted to Hacker News that reference this book.Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems) ISBN-13: 978-1558605084https://www.amazon.com/dp/1558605088/?coliid=IYEILMZI5DVNM&c...
and
Transaction Processing: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems) ISBN-13: 978-1558601901
https://www.amazon.com/dp/1558601902/?coliid=I2GWJZ9XJ5D4JI&...
I like "Architecture of a Database System" by Stonebraker, Hamilton, and Hellerstein (http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf) for an overview and then "Transaction Processing: Concepts and Techniques" by Gray and Reuter (https://www.amazon.com/Transaction-Processing-Concepts-Techn...) for the storage-side of things. Granted these are a little old (especially G&R) so extra thought must be given for modern hardware (memory, CPU performance, processor counts, network, disks, etc) as well as distributed processing, replication, and consensus.
Well, not so many people use serializable in their systems (in the whole system, for every transaction) and that is common and reasonable approach. They use the minimal isolation level for particular transaction that keeps their data consistent. Most widely used safe default is repeatable read, in PostgreSQL terms.Broadly speaking, of course there are some quirks in the field, let's start from "A critique of ANSI SQL isolation levels"[1] by Jim Gray et al., an author of highly respected fundamental book about transactions [2]. But the very kind of problems discussed in RDBMS world, is a rather contrasting with an "ACID? why do we need it?" attitude that is so often in the world of "web scale NoSQL".
[1] http://dl.acm.org/citation.cfm?id=223785
[2] https://www.amazon.com/Transaction-Processing-Concepts-Techn...?
For implementation of database systems, Gray and Reuter's Transaction Processing: Concepts and Techniques http://www.amazon.com/Transaction-Processing-Concepts-Techni.... For the ideas behind relational databases, I like C.J. Date's Introduction to Database Systems, http://www.amazon.com/Introduction-Database-Systems-C-Date/d....
Dr. Gray wrote "Transaction Processing"[1] that has proven indispensable in my career and a generally great book. I didn't know the man, but he influenced me deeply from afar. RIP.[1]: http://www.amazon.com/Transaction-Processing-Concepts-Techni...
⬐ NoneNone