> MarkLogic > ACID vs. BASE: The Question of Database Transaction Processing

ACID vs. BASE: The Question of Database Transaction Processing

White Paper Published By: MarkLogic
Published:  Jun 16, 2013
Type:  White Paper
Length:  18 pages

Imagine a world where CAP Theorem is wrong. Database engineers and application designers now have absolute control over every transaction, at all times, across the entire planet, no matter how many distributed nodes an enterprise has. Relational systems are now happily married to the aggregate of any and all non-relational designs. It no longer matters if an enterprise wants to employ a range of SQL-centric databases within its burgeoning collection of Key-Value, Document, Column-Oriented, and Graph stores they all fit together like fine wine and aged French cheese. Their BI applications work together to collect data in a timely fashion from every platform, they have achieved 99.999% uptime, nodes are quickly and easily added with barely the click of a button, every transaction is consistent within itself all the time with no soft states, eventualities, or latencies, the world is a better place. If you want strong consistency, with high availability, over a distributed network of 100,000 cheap, commodity servers, with total ACID compliance, then you are in luck!

The anecdote above is meant to present a utopian vision that were it entirely true in all cases would make the lives of everyone in the database and application design fields much easier. They could design cheap, perfect systems that just worked and worked, for everyone, all the time. On the downside, it would also make many of their jobs redundant. Luckily for the numerous organizations involved in such industries, the utopian fantasy is far from a reality. But how far is it, really? Are there not some platforms available that provide complete transactional integrity within non-relational systems? Are there not intercessions between competing models that meet somewhere in between?

Tags : 
data, data management, unstructured data, nosql, database, acid, base, database transactioning

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept