The Database Designer's Modern-Day Cookbook
25 April - 11:30 AM - 12:20 PM @ Room 210
50 minutes conference
I’ve been learning about database internals by learning the theory, seeing how other systems have implemented ideas, and trying to implement them myself. Of course, it’s not always easy, and I’m not making anything that compares to the scale of something like MySQL or MongoDB, but reinventing a few small wheels here and there has given me a better understanding of how bigger systems work. I’ll talk about how some fundamental design choices regarding immutability, transactions, and ACID lead to some interesting trade-offs and implementation differences. I’ll also talk about replication, and how it can be as simple as sending the same queries to multiple servers or how stronger guarantees can lead systems to use more complicated approaches like synchronous replication and consensus.
Preetam is an engineer at VividCortex where he works on anomaly detection and back-end systems.