Some other tools are in the citations.
MonetDB uses radix partitioned join algorithm in hash join.
Cannot find the default isolation level. However it supports set the isolation level to be SERIALIZABLE.
The query will be compiled to MonetDB Assembly Language(MAL).