Big Data

SQL alike systems achieving parallel ACID transactions?

I find these debates start up frequently with a cloud/bigdata/foss themewash – but personally I have never seen one outrun the constraints of ACID + CAP. Very keen to hear from anyone ‘doing it’ though.

I guess it all depends if ‘close’ is good enough though – normally find for genuinely transactional DB’s – it is not. But for decision support, research, analytics it often is.

http://en.wikipedia.org/wiki/CAP_theorem

(strong, light, cheap trade off as ever?)

It’s interesting that some of these techniques/techs are used in health informatics – but I also understand this is exploratory vs diagnostic/critical.

Edit: Hive, CLoudera + a few others give SQL like API to Hadoop. Did anyone think it means it’s now an SQL alike system though (I wonder).

Interesting topic and some great comments!

I don’t think you can compare hadoop etc to an rdbms. Not really the same thing at all.

That’s not what the hadoop vendors will have you believe molgrips. The new technology opens up some great opportunities to provide business value, but is also disruptive as vendors make unrealistic claims on what their technology can do, and teccies wanting to kick tyres and get all the latest buzzwords on their linked-in profile.

I agree.

To me it’s = sht and shinola – to others it may be labelled a mere quibble from the jurassic specialists though …

After the dust settles the requests to ACID’ify the cloudwashed solution – using infrastructure magic (TM) – might even start a whole new round for ’emerging’ ACID compliant RDBMS tech solutions – anyone care to coin some phrases/TLA’s/buzzwords at this early alpha phase? Whilst we go round the buoy again..

Data wrangling seems to be a current buzzword doing the rounds bonchance.

I mentioned @BigDataBoart(Learnings of Big Data for Make Nation of Kazakhstan #1 Leading Data Scientist Nation) eralier in the thread, and I particularly like this tweet:

Vendor tell me they are ANSI SQL compliant: They comply with every part that was easy to implement.

That’s not what the hadoop vendors will have you believe molgrips.

Lol quite.. Salesmen in bullshit shocker.. Glad I don’t deal with them 🙂