OT: Re: millions of routes? what module?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
>> <[hidden email]> 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
>> >> [hidden email]
>> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> >>
>> >>
>> >
>> >
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users