patternMinor
Why are NoSQL databases not ACID compliant?
Viewed 0 times
whyaciddatabasesarecompliantnotnosql
Problem
Not having ACID properties means that the database works well on clusters. But ACID is something very fundamental. How can a database work well if there is no atomicity, consistency, isolation and durability (ACID)?
Solution
Not having ACID properties means that the database works well on
clusters. But ACID is something very fundamental. How can a database
work well if there is no atomicity, consistency, isolation and
durability (ACID)?
I am not discarding anything of Vérace,Evan Carroll & Randolph West.
According to this blog, in his presentation NoSQL: Past, Present, Future Eric Brewer presents a particularly fine section on explaining the often hard to understand ideas of BASE (Basically Available, Soft State, Eventually Consistent).
I would not also say here more about that How can a NoSQL database work well if there is no atomicity, consistency, isolation and durability (ACID)?. Because it will be too early to say on this junction , as per my professional dba knowledge.
But I want to share with you the DataStax CEO Billy Bosworth's article from the InfoWorld New Tech Forum: "Top 5 misconceptions about ACID compliance in a nonrelational world." which may help you.
Misconception No. 1: You can't build an online application without
ACID compliance
Misconception No. 2: ACID is an all-or-nothing proposition
Misconception No. 3: Eventual consistency violates the "C" in "ACID"
Misconception No. 4: Databases and applications have a 1:1
relationship, so it's either/or between relational and NoSQL
technologies
Misconception No. 5: NoSQL databases are for "Web scale"
applications only; everything else uses ACID-compliant technology
Why it matters by Eric Brewer has continued to refine his understanding of the CAP (Consistency, Availability, Partition Tolerance) theorem in light of new technologies. At the same time, developers, architects, and database administrators are advancing their understandings of such trade-offs. At least, they're realizing we don't live in a one-size-fits-all world and must employ the right technologies for the right job. Those who free their minds of relational misconceptions will harness the power and opportunity provided by this new world of diverse database technologies.
For further reference:
clusters. But ACID is something very fundamental. How can a database
work well if there is no atomicity, consistency, isolation and
durability (ACID)?
I am not discarding anything of Vérace,Evan Carroll & Randolph West.
According to this blog, in his presentation NoSQL: Past, Present, Future Eric Brewer presents a particularly fine section on explaining the often hard to understand ideas of BASE (Basically Available, Soft State, Eventually Consistent).
I would not also say here more about that How can a NoSQL database work well if there is no atomicity, consistency, isolation and durability (ACID)?. Because it will be too early to say on this junction , as per my professional dba knowledge.
But I want to share with you the DataStax CEO Billy Bosworth's article from the InfoWorld New Tech Forum: "Top 5 misconceptions about ACID compliance in a nonrelational world." which may help you.
Misconception No. 1: You can't build an online application without
ACID compliance
Misconception No. 2: ACID is an all-or-nothing proposition
Misconception No. 3: Eventual consistency violates the "C" in "ACID"
Misconception No. 4: Databases and applications have a 1:1
relationship, so it's either/or between relational and NoSQL
technologies
Misconception No. 5: NoSQL databases are for "Web scale"
applications only; everything else uses ACID-compliant technology
Why it matters by Eric Brewer has continued to refine his understanding of the CAP (Consistency, Availability, Partition Tolerance) theorem in light of new technologies. At the same time, developers, architects, and database administrators are advancing their understandings of such trade-offs. At least, they're realizing we don't live in a one-size-fits-all world and must employ the right technologies for the right job. Those who free their minds of relational misconceptions will harness the power and opportunity provided by this new world of diverse database technologies.
For further reference:
- NoSQL standouts: The best document databases
- There is NoSQL with ACID
- MongoDB and ACID
Context
StackExchange Database Administrators Q#185763, answer score: 4
Revisions (0)
No revisions yet.