I would build a distributed relational in-memory HTAP database.
In my past few roles, the most difficult problems have been surrounding timely analytics on operational data. The most recent solution that I built involved a system that could shard analytical queries between an OLAP and OLTP database and a complex ETL to constantly migrate data between the two. While it works well, it is quite a bespoke solution, and I would love to create something that could solve the problem more generally.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I would build a distributed relational in-memory HTAP database.
In my past few roles, the most difficult problems have been surrounding timely analytics on operational data. The most recent solution that I built involved a system that could shard analytical queries between an OLAP and OLTP database and a complex ETL to constantly migrate data between the two. While it works well, it is quite a bespoke solution, and I would love to create something that could solve the problem more generally.