There's a lot of research on this topic. Peloton[0] is one example. It's an in-memory SQL DB designed for OLTP and OLAP workloads that tunes itself. Andy Pavlo,

There's a lot of research on this topic. Peloton[0] is one example. It's an in-memory SQL DB designed for OLTP and OLAP workloads that tunes itself. Andy Pavlo, one of the researchers, has an awesome series of lectures on YouTube that describes a lot of the modern research on database implementation[1]. [0]: https://pelotondb.io/ https://pelotondb.io/ [1]: https://www.youtube.com/playlist?list=PLSE8ODhjZXjYplQRUlrgQKwIAV3es0U6t https://www.youtube.com/playlist?list=PLSE8ODhjZXjYplQRUlrgQ...