Rant:
Why so much focus on Key Value stores? That's the easy part of the problem.
I would like to know more about the interesting ones: secondary indexes, range scans, performance on mixed workloads, robustness, operational complexity.
Why so much focus on Key Value stores? That's the easy part of the problem.
I would like to know more about the interesting ones: secondary indexes, range scans, performance on mixed workloads, robustness, operational complexity.
There aren't enough good/fast/reliable ones
On a general purpose hardware/network adding features as you mentioned, tends to be seriously difficult and tremendously workload dependent. At some point you need help from hardware designers which itself limits the use cases of your system.
FPGA supported databases, In-network SQL processing, Server-less caches (an SSD directly connected to network without OS), Storage systems with mind blowing low energy consumption, ... are just bunch of absolutely amazing research that are being done today. however the limited public availability is badgering.
With mass public usability in-mind, a general purpose K/V system is the highest summit you can really achieve.