Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

Appendix

Glossary - H

hashed access

hashed key

hashing

having

high cardinality

high-water mark

hints

host

hosts file

HPPA

Hybrid DR

 

Appendix

 

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

 

hashed access
  • See direct access.

hashed key
  • a database key facilitating direct access to data on a storage device. See key and direct access.
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.
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".
high cardinality
  • (1) High table cardinality indicates a large number of records in a table, a Sales Fact table for example.
  • (2) High column cardinality indicates many possible unique values in a column. For example, names, addresses, account balances, product inventories, etc. See cardinality.
high-water mark
  • See serial read.
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.
hosts file
  • a file containing a cross reference between names for computers in a network and their physical network addresses, resident on the computer specified as the domain name server. See domain name server.
HPPA
  • Hewlett Packard Precision Architecture; a RISC architecture used in series 9nn computers.
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.

 

 

 

Top