Glossary

The process of operating in a database to store or retrieve data The movement of physical data to and from a computer and its storage devices

• The DISC representative, also known as an ASE, involved in pre-sales customer support, providing early Omnidex design, administration and integration consulting services.

• The current internal Omnidex Access work space. See also: CURSOR.

• A numerical identifier for distinguishing one network node from another.

• Keys to data based on the SQL functions COUNT, SUM, MIN, and MAX. See also: Aggregation/Sorted Key Index.

• See Summary Table

• A type of Omnidex index that facilitates extremely high speed aggregations used primarily in OLAP and data warehousing applications. Aggregation/Sorted Key Indexes are commonly referred to as ASK Indexes.

ASK Indexes generally combine multiple criteria fields along with one or more metric fields into a single composite index. ASK Indexes can also be used to provide sorted and linkage access to data files such as flat files that do not provide native sorted indexes.

• Summarizations of data, e.g., AVG, MIN, MAX, SUM, COUNT

The process of summarzation (sum), averaging (AVG), finding the minimum (MIN) or maximum (MAX) values.

• Multiple criteria values or predicates that rows must match all or will not qualify.

• Application Programming Interface: A collection of callable routines providing specific functions. Omnidex provides two different APIs.

Omnidex supports four different API Interfaces:

• ODBC - Open Data Base Connectivity
• JDBC - Jave Data Base Connectivity
• OA - OmniAccess
• CLOA - Client Omnidex Access

• Aggregation Sorted Keywork Index.

• See Aggregation/Sorted Key Index

• Account Support Engineer.

• A process whose execution proceeds independently of other processes, e.g. as a background process.

• Information at the most simple level of detail, having low granularity. See also: granularity.

• AUTOPSEUDOCOLUMNS causes Omnidex to automatically construct pseudocolumns from MDK composite keys.