Omnidex Overview
Omnidex is a sophisticated indexing solution for your data management
system, similar to an index in a book, but much more powerful. For example,
one way to learn all about the Oracle database is to read the Oracle reference
manual cover to cover. This is called a serial read. If, on the other
hand, you only want to read about triggers, you can look for “triggers”
in the book’s index and read only those pages. This is called an
indexed read. Using the index to pinpoint information is much faster than
reading the whole manual, and this is exactly what Omnidex does.
Most data management systems offer some form of indexing, but Omnidex
indexes provide speed and flexibility not available anywhere else, even
with the most expensive RDBMS'. As the amount of data stored in a database
increases, retrieval time through the data management system also increases.
This is not the case with Omnidex. In fact, the larger the database, the
bigger the performance gain will be when Omnidex is installed.
Omnidex is not a database replacement, but rather a database enhancement.
It uses your existing data to create external index files, and then resolves
all queries within the indexes, accessing the database only when necessary,
eliminating costly database I/O.
Multi-Dimensional Keyword Indexes (MDK)
One of Omnidex’s most popular features is its ability to find rows
based on words that appear anywhere in an indexed field. For example,
given the search criterion "INFORMATION" - upper or lower case
-against a COMPANY_NAME index, you would find all rows where the company
name contains the word "information", no matter where it occurs
in the name, as the following example demonstrates:
SELECT COMPANY_NAME, STATE FROM CUSTOMERS WHERE COMPANY_NAME='INFORMATION'
ORDER BY STATE
COMPANY_NAME |
STATE |
Dynamic Information Systems Corporation |
CO |
Information Express |
MN |
Dun and Bradstreet Information Services |
CO |
Aggregation/Sorted Key Indexes (ASK)
Omnidex Aggregation Indexes provide fast, dynamic data summarizations.
They can perform a standard SUM, AVERAGE, MINIMUM, MAXIMUM, COUNT or a
combination, and enable fast grouping and sorting. Aggregation Indexes
allow you to summarize numeric amounts such as sales, purchasing dollars,
costs and quantities without reading the actual data records or building
summary tables. They can also handle calculations and functions.
> select product_no, sum(quantity) AS qty, sum(total) AS
tot from orders group by product_no
PROD QTY TOT
---- ---------- -------------
3DST 19.000000 44.459999
3MTP 3.000000 2.580000
3P23 1.000000 4.680000
3RGS 12.000000 9.360000
3SAD 2.000000 14.040000
A940 36.000000 64008.000000
AAWP 1.000000 3.120000
ACPC 1.000000 0.780000
ADLB 1.000000 4.500000
AEWP 1.000000 8.100000
AQPP 1.000000 1.560000
B190 9.000000 1524.000000
B290 40.000000 7830.000000
B390 16.000000 3744.000000
B455 12.000000 7394.400146
BMED 1.000000 312.000000
BMLF 1.000000 270.000000
BRSP 2.000000 1.560000
BTCT 1.000000 24.959999
C478 3.000000 6201.000000
...
Top
|
