record locking


Also found in: Wikipedia.

record locking

[′rek·ərd ‚läk·iŋ]
(computer science)
Action of a computer system that makes a record that is being processed by one user unavailable to other users, to prevent more than one user from attempting to update the same information simultaneously.
McGraw-Hill Dictionary of Scientific & Technical Terms, 6E, Copyright © 2003 by The McGraw-Hill Companies, Inc.

file and record locking

A first-come, first-served technique for managing data in a multiuser environment. The first user to access the file or data record prevents, or locks out, other users from accessing it. After the file or record is updated, it is unlocked and available. File and record locking is an essential part of every database management system (DBMS), document management system and any other system that allows data to be updated by multiple users or applications. See also lock down.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
* Full support for MySQL, DB2, and DB2/400 (the AS/400 version of DB2 from IBM), to include functionality such as record locking, optimization, and other database-specific features.
It offers full versioning, change tracking, record locking and disaster recovery.
Implement the same file protection and record locking strategies you would use on a non-RAID system.
Compaq Computer Corp claims that Sun Microsystems Inc's recent TPC-C performance record of 115,395 tpmC on a single 64-way StarFire server running a single copy of Oracle indicates that the company can't handle the kind of distributed record locking it achieves with Tru64 Unix and TruCluster system software.
Implementing record locking so that large databases can be accessed by multiple users at the same time, is complex on a single server; across multiple servers.
A multiuser version, with record locking capabilities, is due out later this year.
Hardware and software compatibility, ease of installation and maintenance, file and record locking, security, reliability, bridge and gateway availability, and user interface quality are others.
It provides full versioning and tracking of all changes, in addition to robust record locking and disaster-recovery features.
For example, Unix clients running NFSv2 and NFSv3 support only advisory record locking, while Windows clients running SMB/CIFS support mandatory file and record locks, as well as advisory cache locks.
On a local area network, Library Master allows multiple-user databases, with record locking to enable several users to edit and search a database at once.