Searching large amounts of data in qtp

[georgia miller]

Sorry! We compared SuperDex (not SuperTool) to Omnidex.
Georgia

______________________________________________________________________________
_
To: Powerhouse ListServer
From: Hans Hendriks on Wed, May 6, 1998 1:26 PM
Subject: Re: Searching large amounts of data in qtp



Georgia Miller <georgia_miller@gfps.k12.mt.us> said: 

>............................... When we purchased 
>Omnidex, we  compared Omnidex to Supertool and chose Omnidex.  It works very 

>well for us in the HP3000, MPEix, Image, Powerhouse environment.  Omnidex 
>uses the Image TPI (3rd Party Indexing) and also has an agreement with 
>COGNOS.
>
>Sorry if this is a plug for Omnidex - just sharing what works for us.

Georgia is absolutely correct that Omnidex is a wonderful product, and we use 
it extensively for our in-house systems. However, its important to discern 
between Omnidex and Suprtool......

Omnidex is an indexing enhancement product for Image. It works around Image's 
limitation of only ever allowing indexed access via 1 key, with the full key 
value. Omnidex stores additional index information in its own data structures 
(in the same, or in a separate database), and then resolves "complex" queries 
into "simple" Image keyed accesses. The advantage is powerful and flexible 
retrieval functionality. The cost is the overhead of maintaining multiple 
index structures at update time. Effectively, you're moving the processing 
overhead from "read time" to "write time". This makes sense if you have 
fairly static data, and need fast on-line retrievals.

Suprtool is primarily a serial read tool. It excels at reading large amounts 
of data at high speed, in order to select a subset of records that it passes 
on to other applications for further processing. It doesn't rely on any 
special data structures (though it can do keyed access, either via Image or 
Omnidex (or Superdex) keys.) Suprtool reduces the overhead of your serial 
access, without any cost at update time. (Also, its price is a fraction of 
Omnidex's :-)

So the two products are really designed to address different problems. Do you 
need fast on-line access to your data? Or do you need to speed up serial 
batch processing?

/Hans
|----------------------------------------------------------------------
| Hans Hendriks                 Robelle Consulting
| http://www.robelle.com/~hans
| hans@robelle.com        personal: hans@cheerful.com




= = = = = = = = = = = = = = = = = = = 
= = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.