Microsoft’s new Azure SQL DB Hyperscale does something very similar:

https://www.brentozar.com/archive/2019/01/how-azure-sql-db-h...

I sketched out a lot of architecture diagrams in that, showing how it differs from traditional RDBMS’s, and I tried to keep the post approachable for database folks from different platforms.