3D XPoint SSDs should be amazing for databases I think. I am curious to the point that I would try to write product targeting this specific tech. Unfortunately 3D XPoint's commercial status is in a very iffy state
In PCIe gen 3 it is already possible to saturate the PCI lanes with NAND. Even in gen 4 you get 6 GB/s. You gain some in latency but you really need to invest in the software to eke out that latency gain.
3DXpoint really shines in persistent memory but that requires investing quite a bit to change software to make use of it and the problem is that of a single vendor and high prices.
There are users for it but I havent seen anything to convince me its really viable.
As long as the hardware and accompanying libraries support transactional memory then sure. Otherwise it is more easy to just use the vast existing transactional storage libs. The say that Pmem supports block access so maybe it is win win in this area