This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
glossary:l [2009/12/04 05:52] tdo |
glossary:l [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ====== Glossary ====== | ||
| ===== L ===== | ===== L ===== | ||
| {{page>:glossary_bar&nofooter&noeditbtn}} | {{page>:glossary_bar&nofooter&noeditbtn}} | ||
| - | **left outer join** | + | ==== Left outer join ==== |
| + | * An outer join in which all rows from the left table in the JOIN clause are included, only rows from the right table with matching rows in the left table are included, and left table rows with no matching right table rows are matched with nulls. | ||
| - | * An outer join in which all rows from the left table in the JOIN clause are included, only rows from the right table with matching rows in the left table are included, and left table rows with no matching right table rows are matched with nulls. | + | ==== Link field ==== |
| + | * an Omnidex search by a partially specified key followed by an at sign ( @ ). Also known as a generic retrieval. | ||
| + | ==== Linked list ==== | ||
| + | * A degree of detail data in a data warehouse where "high granularity" indicates a large quantity of detail with little summarization. "Low granularity" indicates a small quantity of detail, or data greatly reduced through summarization. | ||
| - | **link field** | + | ==== Listening port ==== |
| + | * an MDK key option (;Gn) that treats several multiple keys as one logical entity. | ||
| - | * an Omnidex search by a partially specified key followed by an at sign ( @ ). Also known as a generic retrieval. | + | ==== Literal ==== |
| - | + | * A letter, group of letters, or symbol that stands for itself as opposed to a feature, function, column value in a record. | |
| - | **linked list** | + | |
| - | + | ||
| - | * a degree of detail data in a data warehouse where "high granularity" indicates a large quantity of detail with little summarization. "Low granularity" indicates a small quantity of detail, or data greatly reduced through summarization. | + | |
| - | + | ||
| - | **listening port** | + | |
| - | + | ||
| - | * an MDK key option (;Gn) that treats several multiple keys as one logical entity. | + | |
| - | + | ||
| - | **literal** | + | |
| - | + | ||
| - | * A letter, group of letters, or symbol that stands for itself as opposed to a feature, function, column value in a record. | + | |
| - | + | ||
| - | **logical link** | + | |
| - | + | ||
| - | * used in relation to Multifind, when data in two different data sets serve to create a correspondence between those records. | + | |
| - | + | ||
| - | **low cardinality** | + | |
| - | + | ||
| - | * Low table cardinality indicates few total records in a table. | + | |
| - | * Low column cardinality indicates a low number of unique values in a column. For example, a "Yes/No" column has low cardinality because it has only two possible values. | + | |
| - | * See cardinality. | + | |
| + | ==== Logical link ==== | ||
| + | * used in relation to Multifind, when data in two different data sets serve to create a correspondence between those records. | ||
| + | ==== Low cardinality ==== | ||
| + | * Low table cardinality indicates few total records in a table. | ||
| + | * Low column cardinality indicates a low number of unique values in a column. For example, a "Yes/No" column has low cardinality because it has only two possible values. | ||
| + | * See cardinality. | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||