This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
glossary:a [2009/12/04 20:36] tdo |
glossary:a [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 22: | Line 22: | ||
| ==== Aggregation table ==== | ==== Aggregation table ==== | ||
| * See Summary Table | * See Summary Table | ||
| - | |||
| ==== Aggregation/Sorted Key Index (ASK) ==== | ==== 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. | * 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. | + | * 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 ==== | ==== Aggregations ==== | ||
| * Summarizations of data, e.g., AVG, MIN, MAX, SUM, COUNT | * 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. | + | * The process of summarzation (sum), averaging (AVG), finding the minimum (MIN) or maximum (MAX) values. |
| ==== AND criteria ==== | ==== AND criteria ==== | ||