MySQL Forums
Forum List  »  Newbie

my brain hurts
Posted by: Ron Walker
Date: August 11, 2005 11:57AM

Hello all,

This one has been teasing my brain for months, I currently have a solution, but it's well, klugey(?) a better (faster, cleaner, less klugey) solution there must be.

Problem:
matching dialied numbers (telephone) to dial code tables (country prefix and city codes) for purposes of rateing or pricing telephone calls.

Each carrier we use, supplies us with a dial code list, consisting of about 4000 possible termination destinations. for the sake of simplicity, assume we are using one lis, from a single supplier.

the problem(s)

the dialcodes are non-standard lengths, 3-9 digits (then the phone number)
the dialcodes overlap as in a country dialcode may be used for some termination numbers, and some termination numbers have combiniation of the same country code and a city code then the termination number.

CDR record shows the call was placed to south korea telepone number for example

0118234567890

Dial code table;
0118234 south korea land line
01182345 south korea mobile
011823456 another south korea mobile exchange

the dialed number would match all three of the above dial codes, and would be 'correct' but i need it to match only on the 3rd one as it is the most accurate.

any thoughts?

Options: ReplyQuote


Subject
Written By
Posted
my brain hurts
August 11, 2005 11:57AM
August 11, 2005 07:55PM
August 12, 2005 08:38AM
August 12, 2005 08:48AM
August 11, 2005 07:57PM
August 12, 2005 08:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.