Apache Cassandra will work well on the Raspberry Pi. He must fill out an account of what you want to do. I experimented with it on my blog, here , to see my results and setup information on my blog.
However, I noted that you announced transaction support - are you sure about that?
Several NOSQL databases offer transaction support, although FoundationDB is one. It has all the features you requested, with the exception of working on Raspberry Pi, since it requires a 64-bit version.
Andy cobley
source share