Re: Phone Numbers

My company had to do a job like this for the phone company in England. I found that the fastest way to process the list data was to extract it from Oracle completely and lock it into a structure in memory that was then processed entirely using C code. This avoided any Oracle overheads like physical reads from disk or the need to parse SQL code.

Are you just looking for a yes or no answer regarding whether a number is on the do-not-call list (e.g. for cleaning the lists of marketing companies)?

It's possible that the code I have could be adapted for your needs. If you'd be willing to supply a small subset of your data, I will check. Please send me an e-mail if you are interested.

Regards,

Richard

"v5034" <v5034_at_vm.vm.co> wrote in message news:vs8e245g15qgd4_at_news.supernews.com...
> Richard wrote:
>
> > Do you need to search on the whole phone number, e.g. to identify an
> > individual subscriber or do you just need to identify the 'location' of
the
> > phone number, e.g. to identify which exchange or charge group it is
> > associated with?
>
> I need to search the whole number just to see if it exists
> (do-not-call-list). I would prefer to keep area code in a separate
> column though - unless you think this is a bad idea. I also do not have
> Oracle EE, just SE - so I don't have access to bitmapped indexes. Also
> there are no updates and very rare deletes. So mostly (98%) reads.
>
>
> >
> > Regards,
> >
> > Richard
> >
> > "v5034" <v5034_at_vm.vm.co> wrote in message
> > news:vs80klekuf1pb3_at_news.supernews.com...
> >
> >>What is the best way to store, index and search N. American phone
> >>numbers for maximum search efficiency? Should they be broken up and
> >>stored as area code columns and number columns? How should they be
> >>indexed? I have a standard Oracle database - not EE.
> >>How should they be searched for efficiency?
> >>
> >>Thanks
> >>
> >
> >
> >
>
Received on Wed Nov 26 2003 - 10:26:57 CST