[db-wg] New free text search for RIPE Database

At 09:30 14/09/2011 +0200, Alex Le Heux wrote:
>Dear Hank,
>
> >> Have you tried using the -i flag on a regular whois query? That should 
> list all objects that reference a specific person in either tech-c, 
> admin-c, zone-c or author.
> >
> > -i requires <attribute-name> and only then  <inverse-key>.  I want a 
> free text search to find every place a string appears.  Your method 
> requires 3 seperate searches.
>
>The -i query is quite versatile.
>
>"-i pn" will query admin-c, tech-z, zone-c and author attributes, see:
>
>https://www.ripe.net/data-tools/support/documentation/ripe-database-query-reference-manual#table%202.3

Thanks,
Hank


>Best regards,
>
>Alex Le Heux
>RIPE NCC
>
> > -Hank
> >
> >
> >> MarcoH
> >>
> >> On 14 sep 2011, at 07:16, Hank Nussbacher wrote:
> >>
> >> > At 14:13 10/11/2010 +0100, Denis Walker wrote:
> >> >
> >> > Old thread:
> >> >
> >> > In the old system one could find all objects that had a specific 
> person listed.  In the new system, you state that you don't index role or 
> person objects but you also don't index the strings tech-c or admin-c 
> inside inetnum objects for example.  This makes it then impossible to 
> find what objects a person is listed on.  Imagine someone retires and you 
> want to change all his/her objects that list them - it used to be able to 
> be done with the old free text search.  The new one doesn't allow it.
> >> >
> >> > Regards,
> >> > Hank
> >> >
> >> >> Dear Hank
> >> >>
> >> >> Currently this new search is only a prototype. But it works much more
> >> >> effectively than the search you referenced below. It is more powerful,
> >> >> has more features and can be more easily scaled and adapted to changing
> >> >> underlying data. The current search, based on glimpse, is end of life.
> >> >> If the prototype meets users needs then we will replace glimpse with
> >> >> this new service.
> >> >>
> >> >> Regards
> >> >> Denis Walker
> >> >> Business Analyst
> >> >> RIPE NCC Database Group
> >> >>
> >> >> Hank Nussbacher wrote:
> >> >> > At 12:19 10/11/2010 +0100, Mirjam Kuehne wrote:
> >> >> >
> >> >> >> Dear colleagues,
> >> >> >>
> >> >> >> Our RIPE Database developers implemented a new free text search for
> >> >> >> the RIPE Database. Read details on RIPE Labs:
> >> >> >>
> >> >> >> 
> http://labs.ripe.net/Members/Paul_P_/full-text-search-in-the-ripe-database
> >> >> >>
> >> >> >
> >> >> > Is this meant to replace?:
> >> >> > http://www.ripe.net/db/whois-free.html
> >> >> >
> >> >> > Regards,
> >> >> > Hank
> >> >> >
> >> >> >
> >> >
> >> >
> >>
> >> Grtx,
> >>
> >> MarcoH
> >>
> >> --
> >> "Good tests kill flawed theories; we remain alive to guess again"
> >
> >