INSIGHTCLOPEDIA

Contributions welcome!

L

Latency

The time between submitting a request and the response to it. The request can be, for example, submitting a query, but also accessing a database, data warehouse, or starting an ETL process.

Library (LIB)

A library in which program components, files, standard operations, queries, etc. are stored in such a way that the content can be found quickly and easily.

Life cycle

Term used to indicate the life of an object in a data warehouse. From when to when is data valid. In a more detailed form, it can also be stated that data can have or lose a certain status or certain characteristics during its lifetime.

List of values (LOV)

A list of values from a domain. This is used to let users choose variables instead of entering the variables manually.

Lockup

Locking, for example, a system, application, database, record, etc. Is mainly used to lock records in a database during the mutation process. The aim is to prevent simultaneous mutation of the same records in order to maintain referential integrity.

Logging

Keep and record information about events, actions, transactions, etc. in log files. These files can be used, for example, for debugging purposes.

Logical

In BI terms, the addition logical usually means that it is a description in human or business terms rather than in technical or IT terms.

Logical data map

The source-to-destination reference document. This document indicates which source elements are involved in the mapping to a target element, including the initial transformations.

Logical data model (LDM)

A description of the structure and organization of data, data flows and the interrelationships in business terms.

Lookup

A term that is used in the ETL process to look up a data item according to certain criteria in one direction (horizontally, so per row, or vertically, so per column).