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

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

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"
> 
>