DRAFT

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

  • Aggregation Sorted Keywork Index.

ASK Index

  • See Aggregation/Sorted Key Index

ASK Order By Optimization

ASE

  • Account Support Engineer.

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.
 
Back to top
glossary/a.txt ยท Last modified: 2012/10/26 14:24 (external edit)