single-record transactions

« Back to Glossary Index

single-record transactions

What are single-record transactions?

A single-record transaction is, as it sounds, a database transaction which functions on a single record at a time, as opposed to multi-record transaction. A single-record transaction is an atomic transaction that executes database operations (read, write, update, delete) on a single data record or document in the database. A multi-record transaction by contrast executes multiple operations that may affect more than a single data record or document.

Both transaction methods are designed to provide reliable units of work that allow the right recovery from a failure without changing anything in the database.