Masalahnya yang digitnya cuma 1 itu paling sedikit kemungkinan langsung ketemunya. Sedangkan 3 digit paling sering, jadi kemungkinan langsung dapat jawabannya > 70% of the time. Kalo mulai dari 1 digit, 70% of the time harus query baru ketemu jawabannya. Kalau mau lebih efisien lagi, cari 2 digit. Cukup 1 x query sudah tahu persis jawabannya.
Special lookup itu memang didesain seperti itu khusus untuk telco. Traditionally, sewaktu sistemnya masih pake sentral doeloe, setiap nomor yang dipencet akan tersambung ke sentral telpon di wilayah tertentu. Kalau mau pake database, ga perlu mulai dari awal digit supaya lebih efisien. Best regards, YY On Fri, May 7, 2010 at 8:07 PM, Adelwin, Adelwin <adelwin.adel...@sc.com>wrote: > > > Bukan search 3 digit… > > Search nya dari 1 digit dulu… > > Kalo kagak nemu baru jadiin 2 digit… > > Kalo kagak nemu lagi baru jadiin 3 digit… > > Jangan maen tebak2an… > > > > *Adelwin Handoyo** | Senior Consultant - Wholesale Bank* > *Standard Chartered Bank* > 7, Changi Business Park Cresent, Level 3. Singapore (486028) > > *T* : (65) 659 61395 |* **E* adelwin.adel...@sc.com > > > > > ------------------------------ > > *From:* jug-indonesia@yahoogroups.com [mailto: > jug-indone...@yahoogroups.com] *On Behalf Of *Y. Yudhistira > *Sent:* Friday, May 07, 2010 10:42 PM > > *To:* jug-indonesia@yahoogroups.com > *Subject:* Re: [JUG-Indonesia] Re: Get Phone Number Prefix Country > > > > > > Ini berarti databasenya ga komplit mas, ga ada negara2 di karibia. > > Anyway, kalo negara2 karibia ini ga penting, bisa mulai search dari 3 digit > dulu > > misalnya nomor yang akan di cari +233815912xxx > Cari dulu dari 3 digit : 233. Kalo ga ada di database cari 023. Kalo ga ada > juga cari 002. > > Atau kalo mau lebih efisien lagi, buang semua nol dari database. (artinya > maks cuma ada 3 digit kode negara) > Pertama, cari "like 23%". > ---> Kalo hasilnya lebih dari 1, pasti "like 233". > ---> Kalo hasilnya cuma 1, pasti +23 > ---> Kalo ga ada hasilnya pasti +2 > > Best regards, > YY > > 2010/5/7 yurie_riyu <junat...@gmail.com> > > > > sebenarnya di database sistem sudah ada tabel country yg menyimpan no > prefix dgn format 3 digit. contoh : > -amerika "001" > -indonesia "062" > > yg saya cari adalah gimana agar dr no tlp yg masuk saya bisa meng-query ke > tabel tersebut? > > > > > --- In jug-indonesia@yahoogroups.com <jug-indonesia%40yahoogroups.com>, > Daniel Baktiar <dbakt...@...> wrote: > > > > ok, cara yg sophisticated, simpan table country number ke dalam struktur > > "Trie" (http://en.wikipedia.org/wiki/Trie), lalu traverse sampai dapat. > > > > misalnya: > > > > root > > +-- "1" => U.S. > > | > > +-- "6" > > | +-- "0" => Malaysia > > | | > > | +-- "1" => Australia > > | | > > | +-- "2" => Indonesia > > | > > ... > > > > tabel country call prefix itu memang sudah dirancang untuk di-parse > dengan > > cara seperti itu. > > > > > > > > This email and any attachments are confidential and may also be privileged. > If you are not the addressee, do not disclose, copy, circulate or in any > other way use or rely on the information contained in this email or any > attachments. If received in error, notify the sender immediately and delete > this email and any attachments from your system. Emails cannot be guaranteed > to be secure or error free as the message and any attachments could be > intercepted, corrupted, lost, delayed, incomplete or amended. Standard > Chartered PLC and its subsidiaries do not accept liability for damage caused > by this email or any attachments and may monitor email traffic. > > > > Standard Chartered PLC is incorporated in England with limited liability > under company number 966425 and has its registered office at 1 Aldermanbury > Square, London, EC2V 7SB. > > > > Standard Chartered Bank ("SCB") is incorporated in England with limited > liability by Royal Charter 1853, under reference ZC18. The Principal Office > of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In > the United Kingdom, SCB is authorised and regulated by the Financial Services > Authority under FSA register number 114276. > > > > If you are receiving this email from SCB outside the UK, please click > http://www.standardchartered.com/global/email_disclaimer.html to refer to the > information on other jurisdictions. > > > >
