[db-wg] rpsl to arin format conversion

On Wed, 18 Feb 2004, Engin Gunduz wrote:

> Hi,
> 
> On 2004-02-17 19:49:30 -0600, terry l. ridder wrote:
> > On Sun, 15 Feb 2004, terry l. ridder wrote:
> > 
> > > hello;
> > > 
> > > i am doing some research on the rir databases.
> > > for my purposes having all data in, what i call 'arin' format, would be
> > > the simplest for processing.
> > > 
> > > are there any software utilities available for converting from rpsl to
> > > 'arin' format?
> > > 
> > > if no software utilities are available is there a mapping description
> > > available from rpsl to 'arin' format?
> 
> The syntax and meanings of attributes (fields) of RIPE Whois object can
> be found in the RIPE DB Reference Manual:
> 
> http://www.ripe.net/ripe/docs/databaseref-manual.html
> 
> You must be able to figure out a (close) mapping if a similar
> document exists for ARIN DB as well.
>

as far as i am able to determine there is no arin db documentation
available. 

> 
> 
> > well, we bit the bullet and spent today writing an rpsl-to-arin
> > conversion program. works rather well except for orgid: and parent:
> > fields. obviously, orgid:, we will have a create our own.
> > 
> > i do have a question concerning parent:.
> > 
> > i am do not have an indepth knowledge of rpsl, so please bare with the
> > question.
> > 
> > does rpsl have a concept of parent?
> > if rpsl does have a concept of parent would someone direct me to the
> > document/documents which explain it?
> 
> 'parent' information is not buried in other objects in RIPE Whois Database
> (unlike ARIN DB).  You need to perform queries to find the parents/children
> of an object.  The relevant query flags are -l, -L, -m, -M. See

lacnic's modified rpsl db also includes parent information.
lacnic's modified rpsl db also includes org    information.

arin and lacnic have org and parent.
apnic and ripencc do not have org and parent.

we are not doing queries we are doing, hopefully, a one-time mass
conversion of apnic db and ripe db from rpsl to arin format. right
now we just need a snapshot of apnic db and ripe db. we may need
to update at some time in the future. that depends on where the
research leads us.

> 
> http://www.ripe.net/ripe/docs/databaseref-manual.html#2.2
> 
> for IP Address Lookups in RIPE DB.
> 
> A parent is sometimes called 'one level less specific inetnum' in RIPE DB.
> 

sorry i was not clear with my above questions.

without my having to read the ripe whoisd source code to determine
what is taking place when a query is issued with the -l, -L, -m, or -M flags
is there a document which explains rpsl 'parent' concept?

it is late here 0340 am so i will pick this up again later today after i
get some sleep.


-- 
terry l. ridder ><>