Sales guy - "Hey! Are you guys just stuck with SQL Databases?" and the reply "Yes ..." leaves the sales guys with a thought of plenteous opportunities and weirdy expressions as if he is talking to someone from stone age. Surely the trends are moving from ACID to BASE i.e. SQL to NoSQL (Not only SQL) but the question is should the business adopt? Which solution should they adopt.
There can be multiple answers but my simple take is "Yes, but only if the business needs it and it is making the transformation to the existing business.".
Most of us know but trying to make the point again that No-SQL have nothing to do with the SQL or query language but it is just related to the transaction processing side i.e. reads and writes of the system. Therefore I am considering ACID (Atomicity, Consistency, Isolation, Durability) for the SQL databases and BASE (Basically Available, Soft state, Eventual consistency) for the No-SQL database.
Another big debate can start on "Is the whole planet moving from ACID to BASE?" And the answer is "Noooo !". We are not throwing away whatever we learnt from ACID theories and an excellent example can be Spanner. A planet scale database with ACID properties. Yes I know the CAP (Consistency, Availability, Partition tolerance) theorem and having my fingers crossed for Spanner.
Best wishes for a very-2 happy new year 2015.
No comments:
Post a Comment