Sunday, 11 September 2011

Will Oracle win the NoSQL competition ?

I agree this title is misleading but problem is clear: today Oracle does not provide any product can compete with new cloud computing needs and with the NoSQL movement. It is not possibile to think that actually the RAC technology of oracle can be used in a cloud environment and also a cloud service cannot be deployed over an Exadata.
The acquisition of MySQL wasn't of course the interest of Oracle in MySQL, but today MySQL might be used in a cloud environment with some tricks. Might as MySQL is not in fact a NoSQL database but can be adapted for this role. Oracle provide a plugin to integrate MySQL with Memcached that is widely used in NoSQL environment to solve the problem of data partitioning but IMHO is not enough.
A NoSQL database is not an old relational database (somebody might also complain about the real ACID compliance of MySQL) converted or readapted to support BASE properties instead ACID. The entire pattern is completely different.
Of course Oracle from its point of view try to say the NoSQL is really not needed as presented in this webcast. Moreover the famous Tom Kyte in his own blog Ask Tom answered to the topic NOSQL vs. RDBMS databases
However I can argue that the problem must be taken at a lower level. The CAP Theorem shows clearly that a standard RDBMS cannot be used in a real distributed environemnt; so there is no possibility to adapt an RDBMS for this purpose. However, with respect of CAP theorem, the missing of real consistency is a barrier for many applications...try to apply the statement eventually consistent to a deposit in your bank!