What is the current state of art? Is there a book that I can read up on this or better yet, some academic course/offering that covers this? Mostly looking for what design decisions/algorithms/data structures used by the databases. Is the Klepmann book (DDIA) slightly out of date now or still very much relevant?
Thank you!!
CAP tradeoffs are better documented.
And there is more to go on than marketing claims.
Also, SQL is the new NoSQL.
Few advantage over traditional MPP
1. You can clone prod DB for testing with no additional cost.
2. Time travel. No need to take manual back.
3. Good integration with AWS S3
4. Can scale horizontally and vertically on demand
Klepmann's book is still a good read. A lot of the concepts are evergreen.