This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
glossary:h [2009/12/04 05:47] tdo |
glossary:h [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== H ======= | + | {{page>:top_add&nofooter&noeditbtn}} |
| + | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ====== Glossary ======= | ||
| + | ===== H ===== | ||
| {{page>:glossary_bar&nofooter&noeditbtn}} | {{page>:glossary_bar&nofooter&noeditbtn}} | ||
| - | ===== hashed key ===== | ||
| - | * a database key facilitating direct access to data on a storage device. See key and direct access. | + | ==== Hashed key ==== |
| + | * a database key facilitating direct access to data on a storage device. See key and direct access. | ||
| - | ===== hashing ===== | + | ==== Hashing ==== |
| + | * An indexing technique where an algorithm is used to calculate the location of a row or record, requiring a full key look-up and an exact match, including upper and lower case characters, spaces, and punctuation. | ||
| - | * an indexing technique where an algorithm is used to calculate the location of a row or record, requiring a full key look-up and an exact match, including upper and lower case characters, spaces, and punctuation. | + | ==== Having ==== |
| + | * An SQL statement clause that allows additional criteria to be applied to an SQL statement after the WHERE and GROUP BY clauses have been processed. The HAVING clause is generally used to apply criteria to an aggregation as in "SUM(ORDERS.TOTAL)>10". | ||
| - | ===== having ===== | + | ==== High cardinality ==== |
| + | * (1) High table cardinality indicates a large number of records in a table, a Sales Fact table for example. | ||
| + | * (2) High column cadinality indicates many possible unique values in a column. For example, names, addresses, account balances, product inventories, etc. See cardinality. | ||
| - | * An SQL statement clause that allows additional criteria to be applied to an SQL statement after the WHERE and GROUP BY clauses have been processed. The HAVING clause is generally used to apply criteria to an aggregation as in "SUM(ORDERS.TOTAL)>10". | + | ==== Hints ==== |
| + | * A method of forcing the Omnidex Optimizer to use a particular retrieval method, in a star schema database environment, for example. | ||
| - | ===== high cardinality ===== | + | ==== Host ==== |
| + | * A generic term for any device that allows communication from an outside source. | ||
| - | * (1) High table cardinality indicates a large number of records in a table, a Sales Fact table for example. | + | ==== Hybrid DR ==== |
| - | * (2) High column cadinality indicates many possible unique values in a column. For example, names, addresses, account balances, product inventories, etc. See cardinality. | + | * Hybrid Detail Record; a variation of a multi-domain child, providing the ability to index a child table as a DR domain or in an SI domain. See DR domain and SI domain. |
| + | {{page>:bottom_add&nofooter&noeditbtn}} | ||
| - | ===== hints ===== | ||
| - | |||
| - | * a method of forcing the Omnidex Optimizer to use a particular retrieval method, in a star schema database environment, for example. | ||
| - | |||
| - | ===== host ===== | ||
| - | |||
| - | * a generic term for any device that allows communication from an outside source. | ||
| - | |||
| - | |||
| - | ===== Hybrid DR ===== | ||
| - | |||
| - | |||
| - | * Hybrid Detail Record; a variation of a multi-domain child, providing the ability to index a child table as a DR domain or in an SI domain. See DR domain and SI domain. | ||
| - | |||
| - | |||
| - | ====== Quick Links ====== | ||
| - | {{page>:quicklinks&nofooter&noeditbtn}} | ||