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.
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.
Row-level locking lets applications such as SAP's R/3 hook onto a specific row in a database rather than just a page, resulting in fewer problems when a number of people are making changes to the database.
solidDB for MySQL is designed for transactional applications and supports full ACID compliance with configurable transaction isolation levels, both optimistic and pessimistic concurrency control, Multi-Version Concurrency Control (MVCC) with non-blocking reads and writes, row-level locking, and support for foreign keys and referential integrity.
0 will also feature row-level locking, which allows for higher multi-user concurrency in deployed server environments.
1 comes from the addition of shared-row locking, an advanced technique that improves upon the row-level locking feature of previous versions and other databases.
The ForeclosuresMass MySQL application takes advantage of InnoDB, a transaction-safe, ACID-compliant database storage engine with commit, rollback, crash recovery and row-level locking capabilities.
0 binaries, adding transactions, row-level locking, and foreign key integrity -- Features to simplify migration from other databases to MySQL, such as the "Truncate Table," "Union" and "Cast" SQL syntax additions
MySQL is architected for the Web and includes key features necessary for business-critical applications, such as full support for transactions and row-level locking.
Full transaction support, with commit, rollback and crash recovery capabilities to ensure full data consistency, even if hardware fails -- Advanced row-level locking without requiring lock escalation for maximum read/write concurrency without compromising lock integrity -- Multi-versioning to provide concurrency while maintaining maximum data integrity -- Non-locking reads, consistent with Oracle's style, to enable fast reads even when the database is engaged in heavy updates