Database Glossary – L
Useful Terms For Working With Data

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

L

Language, Nonprocedural

For example, SQL; a computer language in which the programmer cannot dictate in what order a procedure will process its contained commands.

Language, Procedural

A computer language that solves a problem by sequentially executing steps in either a linear or loop back procedure (or both) until the operation is completed.

Language, Query

A computer language that enables an end-user to create and run queries that interact directly with a DBMS to retrieve, and possibly modify, the data it contains.

Left Outer Join

See: Join, Left Outer.

Link

A connection between two tables that have related data.

Linking Field

See: Field, Linking.

Linking Key

See: Key, Linking.

Lock, Read

An imposed access barrier that allows a user to query and view all or part of a database, but not to modify it. Some database management systems will allow many users to have simultaneous read locks.

Lock, Write

A lock that allows the user to read and to modify the database. Write locks almost always simply exclusive control of the database so that other users will not be allowed to have either active read or write locks as long as one write lock is operational.

Lock; Locking

Reserving the use of a database, table, record, or other collection of data for access by one user at any one time to prevent the resulting anomalous database behavior when, for example, one user reads or modifies data in a record which is in the process of being modified by another user.