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.
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.