The new website for MarkLogic is Visit it.
Don't Settle for Anything Less Than 100% Trusted

ACID Transactions

If you’re running an operational and transactional system, then you need a database with all of the ACID properties (atomicity, consistency, isolation, and durability). These properties ensure that your enterprise-grade system never encounters issues like data corruption, stale reads, and inconsistent data. When it comes to mission-critical applications, ACID properties are not a “nice-to-have,” they are an absolute requirement for transactional consistency.

ACID compliance is a standard in relational databases, but MarkLogic is unique among almost all NoSQL databases because we support transactions that are 100% ACID compliant, whereas others have relaxed or even non-existent standards. MarkLogic’s ACID properties also apply to multi-document, multi-statement, and XA transactions (transactions between clusters), providing the unique reliability to run large-scale, operational systems for mission-critical use cases.

Dig Into the Specifics

What Does ACID Stand For?

ACID is an acronym representing four key properties that guarantee your database transactions are reliably processed.

  • A is for Atomicity: The database must execute the whole transaction and not just part of it – all or nothing.
  • C is for Consistency: The database must enforce the system rules, for example, you can’t put a value in a field, if that value is not allowed.
  • I is for Isolation: If multiple transactions are running at the same time they’ll run independently and the end result will be as if they were executed one after the other.
  • D is for Durability: Once a transaction is done, it stays done (even if the system crashes thereafter).

Customer Highlights

ABN AMRO needed to respond quickly to changing regulatory requirements. MarkLogic’s multi-model database and associated features such as security and ACID transactions were compelling.

Learn More

Healthcare.Gov Logo

CMS launched on MarkLogic within 18 months, achieving over 5,500 transactions per second and enabling over 8 million people to sign up for health insurance in its first year of operation.

Learn More

A Top Five Investment Bank runs its operational trade store on MarkLogic, processing over 100,000 complex trades each day that typically result in about 32 million live deals in the system at any one time.

Learn More

Features That Make ACID Transactions Possible

Document Locks

Document locks to protect data during updates and keep transactions from conflicting with one another

Timestamps on documents that ensure a query only sees copies of documents that are valid at the time the query is run (also known as Multi-Version Concurrency Control)

Journaling of updates before they are committed to ensure transactions can be replayed in the face of system failures

commit process to ensure changed data is changed all at once or not at all, even across multiple hosts

Related Resources

Guide to Understanding Transactions in MarkLogic

View Resource

Developer Blog Post
How MarkLogic Supports ACID Transactions

View Resource

MarkLogic CTO on Why You Need ACID Transactions

View Resource