This is an old revision of the document!


Glossary

A

Index 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 $ Glossary

access method

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

Account Support Engineer

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

active cursor

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

address

A numerical identifier for distinguishing one network node from another.

aggregation index

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

aggregation table

See Summary Table

Aggregation/Sorted Key Index (ASK)

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.

aggregations

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.

AND criteria

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

API

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

ASK

ASK Index

See Aggregation/Sorted Key Index

ASK Order By Optimization

ASE

asynchronous process

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

atomic data

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

AUTOPSEUDOCOLUMNS

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

Aggregationa

 
Back to top
glossary/a.1259945413.txt.gz ยท Last modified: 2012/10/26 14:20 (external edit)