Database Reference
In-Depth Information
Trafodion - transactional SQL on HBase
The latest development in the world of transactions for HBase is
Trafodion
. It claims
to fill the missing gap in the Hadoop infrastructure, that is, transactions. More
specifically, it offers the following:
• Fully functional ANSI SQL language support
• JDBC/ODBC connectivity for Linux/Windows clients
• ACID distributed transaction protection across multiple statements, tables,
and rows
• Support for large data sets using a parallel-aware query optimizer
Thus, it presents a major competitor to the Phoenix driver and an aspiration to
Google's large transactional database called
Spanner
, which is not yet available
as open source. In the early stages of adoption, at the time when this topic goes to
print, Trafodion might nevertheless be a game changer, and we plan to provide the
examples of its use in our repository as well as write about it on the topic's site at
Summary
In this chapter, we looked at very advanced real-world design problems in the
NoSQL world, with HBase as a solution platform. We saw the common patterns,
and with this, we are ready to tackle most of the NoSQL/HBase projects.
We thus leave the highfalutin world of NoSQL design. In the words of Shakespeare,
"Thus have I, Wall, my part discharged so; And, being done, thus Wall away
doth go."
In the next chapter, we will address another kind of real-word problem, HBase
performance and monitoring.