Until recently, this ACID compliancy wasn’t fulfilled by Hadoop transactions, but the advent of Hive 2 (June 2016) and others has changed this. Now you can have an equally valid acidity on Hadoop as you would expect on DB2.
This brings up once more the question on the relevance of DB2.
There’s good news from the IBM lab: IBM dashDB for Transactions now offers high availability plans, and offers “pay per use” plans that are billed by-the-day.
Analytics using R is often driven from client side applications such as RStudio and generally involves transmission of the large amounts of data from the database server to the clients for analysis. This method of doing the analysis can be slow given the limited resources on database client machines
How to learn more about DB2? The answer is simple: DB2 Express-C, the community edition of DB2. You can learn, experiment and develop queries and applications through this easy to use and install version of DB2.
Why do we have routines in DB2? They allow us to include custom functionality inside our databases. But why do we need them? Should we use them?