row-level locking

row-level locking

(database)
A technique used in database management systems, where a row is locked for writing to prevent other users from accessing data being while it is being updated.

Other techniques are table locking and MVCC.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)
Mentioned in ?
References in periodicals archive ?
Row Level Locking -- To prevent race conditions, concurrent database transactions are protected by row-level locking. In this way, real-time tasks can safely share access to a database file, both reading and writing, with little interference.
-- Advanced row-level locking without requiring lock escalation for maximum read/write concurrency without compromising lock integrity
Features include row-level locking to minimize data contention and maximize performance, SQL security, encryption, multi-user JDBC connections and distributed transaction management.
A development team has been working on 'Gemini's code name for the development work to add a transactional storage engine providing row-level locking to MySQL.
It will also include new technology, called row-level locking, to enable ERP applications to run natively on the database.
Version 2.0 will also feature row-level locking, which allows for higher multi-user concurrency in deployed server environments.