A lot of these same problems were solved in a similar way with Datomic and xtdb.

https://www.datomic.com/ https://xtdb.com/