[OpenSIPS-Users] OT: Re: millions of routes? what module?

[Brett Nemeroff]

Yes you do have to pay..
For North American destinations, the TRA (Traffic Routing Administation)
maintains a database called LERG (Local Exchange Routing Guide). This has a
lot more information than you really need, but in the very first and seventh
of the database tables (they are numbered) you can match NPA/NXX/X with the
OCN and carrier name.


For portability, you have to perform a database dip, which traditionally is
a SS7 lookup to the LIDB database. You send a DID and they return a LRN
(which looks like a DID. That DID then can be looked up in the LERG to
determine the actual carrier and from an LCR perspective, it's send the DID
to the LRN's route instead of the DID's route. Unless, of course, the LRN is
your own LRN, then you route on the DID.

There are a number of providers out there that offer LNP dipping service.
I've seen it both in SIP variants and XML variants. Typically the LIDB
providers don't allow caching of this data. And for what it's worth, it's
not a good idea to cache the data since it's dynamic. If you are thinking
"wow, a dip for every call? that's alot", yes you are right. There is a ton
of revenue in that.
-Brett


On Wed, Feb 18, 2009 at 12:37 PM, Noel R. Morais <noelrocha at gmail.com>wrote:

> Hi Brett,
>
> I'm out of topic here.
>
> I'm curious about local number portability in US.
>
> How do I know what the provider of a number is? Do I have to pay to know
> that?
>
> Thanks,
>
> Noel
> On Wed, Feb 18, 2009 at 12:24 PM, Brett Nemeroff <brett at nemeroff.com>
> wrote:
> > So are you putting in full DIDs for the ported numbers?
> >
> > In the US, the incumbant providers perform the LNP (Local Number
> > Portability)  lookups and there are large national databases that store
> this
> > information. I've worked with a couple of independent LNP data providers
> to
> > route based on an XML query for LNP results.
> >
> > Static LNP data loaded into a LCR table seems like it would give you
> > constant issues with customers moving around, canceling service, etc.  In
> > general, if portability is implemented properly, you shouldn' thave to
> think
> > about it.
> >
> >
> > On Wed, Feb 18, 2009 at 9:09 AM, Noel R. Morais <noelrocha at gmail.com>
> wrote:
> >>
> >> I'm pretty sure.
> >>
> >> I'm from Brazil and here we have number portability "feature".
> >>
> >> Today we have 140 millions of cell phone numbers and 100 millions of
> >> landline numbers, so, 240 millions of numbers that can be ported to
> >> another provider.
> >>
> >> if only 5% of the people decide to port their numbers, I will end with
> >> 12 millions of ported numbers and I need to have this route rules ...
> >> put on this bag the normal routing rules ...
> >>
> >> So, it's insane, I think that there is no shortcut, any ideias? :D
> >>
> >>
> >> so, drouting seems to be The Guy .... I'll try it today and send the
> >> results ...  :D
> >>
> >> Cheers,
> >>
> >> Noel
> >>
> >> On Wed, Feb 18, 2009 at 12:05 PM, Bogdan-Andrei Iancu
> >> <bogdan at voice-system.ro> wrote:
> >> > Hi Noel,
> >> >
> >> > As Brett already recommended, use the Drouting module as it is the
> only
> >> > one
> >> > able to cope with so large amount of data in an efficient way. See
> here
> >> > some
> >> > performance considerations:
> >> >
> http://www.opensips.org/html/docs/modules/devel/drouting.html#id227252
> >> >
> >> >
> >> > Actually there was a guy on the IRC channel (#opensips) testing even
> >> > with 1M
> >> > of rules and the memory scaled linearly (less than  180M  shared mem
> for
> >> > 1M
> >> > of rules)
> >> >
> >> > So, you may need something like 2G of mem for 10M rules :).
> >> >
> >> > Regards,
> >> > Bogdan
> >> >
> >> > Noel R. Morais wrote:
> >> >>
> >> >> Hi Guys,
> >> >>
> >> >> I need to build a proxy that should be able to handle millions of
> >> >> routes, something near 10 millions :D
> >> >>
> >> >> What is the best module to use in this case? carrierroute or droute?
> >> >>
> >> >> does anybody have experience in installations like that?
> >> >>
> >> >> thanks,
> >> >>
> >> >>
> >> >> Noel
> >> >>
> >> >> _______________________________________________
> >> >> Users mailing list
> >> >> Users at lists.opensips.org
> >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090218/a5cec5a4/attachment.htm