Articles tagged with databases
Why Uber Engineering Switched from Postgres to MySQL — Uber Engineering Blog
Uber started with a monolithic backend application that used Postgres. As the company evolved and grew, it moved to microservices and changed its approach to working with data. The paper explains why this migration happened and what benefits the company gets from it. There is nothing about OLAP in the paper but still a very interesting story.
Following a database read to the metal — Hussein Nasser
Exciting adventure into the query path to data.
Pushdown — Trino Query optimizer docs
Pushdown is a powerful query optimization that moves predicates in the WHERE clause closer to the tables they refer to. This is Trino docs, but you can go through all types and find them in other query engines. It can help you in reading query plans a lot.
How Amazon RDS Replication Works and Why the FAA’s Database Problem Won’t Happen in AWS — Bohan Zhang, Andy Pavlo @ OtterTune Blog
Basic overview of how Amazon RDS and Amazon Aurora replication works. A good starting point to better understand what database replication is.
Databases in 2022: A Year in Review — Andy Pavlo @ OtterTune blog
Interesting review by Andy Pavlo about databases’ state by the end of 2022. Andy touched on database companies’ funding situation, blockchain, new database systems which getting popularity in 2022, and a few other topics.
The Seattle Report on Database Research (2022) — Murat Blog
A little bit about what database’s world is coming to.
Introduction to the Join Ordering Problem — Alexey Goncharuk @ Querify Labs Blog
Query optimization details from Querify Labs. With lots of pictures!
Anna Concurrenina — Kyle Kingsbury @ Scala Days Chicago 2017
Kyle Kingsbury is known for his project jepsen. In this talk, Kyle told about databases lies.
Almost all databases claim the consistency model, but this model usually has holes. It is very interesting to know which exactly holes were in which databases.
What Every Programmer has to know about Database Storage — Alex Petrov.
In the world of Big Data, it’s important to know how Database Storage works in order to be able to pick the right tool for the job. The talk covers evaluation techniques to choose storage with the best read, write, or best suitable for your data.
The physical structure of an SQL index — Kelvin Gakuo @ Medium.
Good article to brush up your knowledge about indexes before the interview.
Courses: Intro to Database Systems (Fall 2019), Advanced Database Systems (Spring 2020) — Andy Pavlo.
Intro to Database Systems
This is a very fundamental and wide course about the implementation and design concepts behind database management systems.
Advanced Database Systems
This is continuous of the first course and will cover more advanced topics about databases such as multi-version concurrency control, detailed talk about join algorithms, and query optimization implementation.
These courses require a lot of time and discipline from the listeners, but you will be rewarded with very useful information about databases. And also, Andy Pavlo is a little bit strange, but a very impressive guy and very love databases :)
PS: Here is a more than 1000 pages book which Andy recommended.
