Query Accelerator - Web Applications
Folks - This isn't strictly an Informix question, but I thought there'd be many people here who had some direct Informix experience: We have a large-ish IDS/Solaris database, consisting of relatively few tables which contain in excess of 12+ million records each. You can consider the data to be similar to a personnel database, i.e., name, address, city, state, zip, phone, etc. We are interested in delivering high-speed semi-freeform query access to a web application, i.e., we need 100 - 200 millisecond-range performance on queries that logically "AND" any combination of these properties ("where city = c and state = s and name contains (n) and zip = z"). In addition, we may need some tokenized access to the name, so that I could find "Robert Jones" if I only knew "R Jones", or could find "McDonald's Restaurants" if I only had "McDonalds". I'm pretty aware of the kinds of parsing, tokenizing, and indexing I could do with IDS 7.30, but don't believe it will deliver the kind of performance we need.. Has anyone used any commerically-available query optimizers (such as OMNIDEX that use optimized in-memory indexing, for example) or any other search or search engine technology to provide these kinds of capabilities? I would also offer that I am not familiar with Informix's Advanced Decision Support or Parallel Query features. Many thanks! -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com
Richard, The type and speed of query access you describe is exactly what the OMNIDEX database search engine is designed to do. It delivers instant access to any number of fields, columns or properties, including name, address, etc., against any number of data records. You can locate words anywhere in a name using full or partial words. For example, you could use "R* Jones" to find "Robert Jones" or even use "mcdonald*" or "restaurants" to find "McDonald's Restaurants". We have thousands of customers and millions of users using this advanced indexing technology, and we would be happy to provide you with more information. Please contact: Cheryl Grandy Marketing Manager, DISC 303 444-4000 cgrandy@disc.com And feel free to check out our web site, www.disc.com/home In article <3846EF45.16FB1E6@airflash.com>, Richard Auslander <rich@airflash.com> wrote: > This is a multi-part message in MIME format. > --------------310A7D38DA76B48CBE1FB430 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Folks - > > This isn't strictly an Informix question, but I thought there'd be many > people here who had some direct Informix experience: > > We have a large-ish IDS/Solaris database, consisting of relatively few > tables which contain in excess of 12+ million records each. You can > consider the data to be similar to a personnel database, i.e., name, > address, city, state, zip, phone, etc. > > We are interested in delivering high-speed semi-freeform query access to > a web application, i.e., we need 100 - 200 millisecond-range performance > on queries that logically "AND" any combination of these properties > ("where city = c and state = s and name contains (n) and zip = z"). In > addition, we may need some tokenized access to the name, so that I could > find "Robert Jones" if I only knew "R Jones", or could find "McDonald's > Restaurants" if I only had "McDonalds". > > I'm pretty aware of the kinds of parsing, tokenizing, and indexing I > could do with IDS 7.30, but don't believe it will deliver the kind of > performance we need.. > > Has anyone used any commerically-available query optimizers (such as > OMNIDEX that use optimized in-memory indexing, for example) or any other > search or search engine technology to provide these kinds of > capabilities? I would also offer that I am not familiar with Informix's > Advanced Decision Support or Parallel Query features. > > Many thanks! > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com > > --------------310A7D38DA76B48CBE1FB430 > Content-Type: text/x-vcard; charset=us-ascii; > name="rich.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Richard Auslander > Content-Disposition: attachment; > filename="rich.vcf" > > begin:vcard > n:Auslander;Richard > tel;fax:650-556-7930 > tel;work:650-556-7928 > x-mozilla-html:FALSE > url:http://www.airflash.com > org:AirFlash, Inc. > adr:;;1733 Woodside Road, Suite 110;Redwood City;CA;94061;USA > version:2.1 > email;internet:rich@airflash.com > title:Manager of Database Services > fn:Richard Auslander > end:vcard > > --------------310A7D38DA76B48CBE1FB430-- > > Sent via Deja.com http://www.deja.com/ Before you buy.