MANAJEMEN KUOTA dan SISTEM BILLING BERBASIS CISCO UNIFIED COMMUNICATION MANAGER ( CUCM )
SKRIPSI
Oleh
Dendy Aryaga
1301054953
Aditya Yosa Putera
1301055483
Putu Raditya Astika Putra
1301055634
Universitas Bina Nusantara Jakarta 2013
MANAJEMEN KUOTA dan SISTEM BILLING BERBASIS CISCO UNIFIED COMMUNICATION MANAGER ( CUCM )
diajukan sebagai salah satu syarat untuk gelar kesarjanaan pada Jurusan Teknik Informatika Program Studi Jaringan Jenjang Pendidikan Strata-1 Oleh
Dendy Aryaga
1301054953
Aditya Yosa Putera
1301055483
Putu Raditya Astika Putra
1301055634
Universitas Bina Nusantara Jakarta 2013
DAFTAR ISI Halaman Judul Luar Halaman Judul Dalam ....................................................................................... i Persetujuan Hard Cover .................................................................................... ii Pernyataan Dewan Penguji Pemberian Hak Cipta Non-eksklusif ................................................................. iii Abstrak .............................................................................................................. vi Prakata ............................................................................................................. vii Daftar Isi .......................................................................................................... ix Daftar Tabel ..................................................................................................... xv Daftar Gambar .................................................................................................. xviii Daftar Lampiran ............................................................................................... xxv BAB 1 PENDAHULUAN 1.1. Latar Belakang ............................................................................... 1 1.2. Ruang Lingkup ............................................................................... 2 1.3. Perumusan Masalah ........................................................................ 2 1.4. Luaran yang di Harapkan ............................................................... 2 1.5. Tujuan ............................................................................................ 3 1.5. Manfaat .......................................................................................... 3 1.6. Metedologi ..................................................................................... 3 BAB 2 LANDASAN TEORI 2.1. Teori Umum ................................................................................... 5 2.1.1. Basis Data ............................................................................ 5 2.1.1.1. Pengertian Data ........................................................ 5 2.1.1.2. Pengertian Database ................................................. 6
2.1.1.3. Pengertian Database Relational .............................. 6 2.1.1.4. Database Management System ................................. 7 2.1.1.5. DB2 ......................................................................... 8 2.1.1.5.1. Produk DB2 ........................................... 8 2.1.1.5.2. Konsep dan Teknologi DB2 .................... 8 2.1.1.5.3. DB2 Express-C ....................................... 11 2.1.1.6. Structured Query Language ................................... 12 2.1.1.7. Entity Relational Diagram ...................................... 12 2.1.2. Internet ................................................................................ 16 2.1.2.1. Pengertian Internet .................................................. 16 2.1.2.2. Sejarah Internet ....................................................... 17 2.1.3. HTTP ................................................................................... 18 2.1.4. Uniform Resource Language ................................................ 18 2.1.5. World Wide Web .................................................................. 18 2.1.5.1. Web Server .............................................................. 19 2.1.5.2. Server Side Scripting ................................................ 19 2.1.5.3. Browser Web ............................................................ 20 2.1.6. Sistem Informasi .................................................................. 21 2.1.6.1. Pengertian Sistem .................................................... 21 2.1.6.2. Pengertian Informasi ............................................... 22 2.1.6.3. Pengertian Sistem Informasi .................................... 22 2.1.6.4. Siklus Pengembangan Sistem ................................. 22 2.2. Teori Khusus ................................................................................. 23 2.2.1. Sistem Billing ...................................................................... 23
2.2.1.1. Definisi Sistem Billing ........................................... 23 2.2.1.2. Mekanisme Sistem Billing ...................................... 24 2.2.1.3. Manfaat Sistem Billing ............................................ 25 2.2.2. Teknologi Telepon .............................................................. 26 2.2.2.1. Cisco Unified Communication Manager .................. 29 2.2.2.2. IP-Telephony ..................................................... 30 2.2.2.3. VoIP ................................................................. 30 2.2.3. Call Detailed Record ............................................................ 31 2.2.3.1. Pengertian Call Detailed Record ............................. 31 2.2.3.2. Karakteristik Call Detailed Record .......................... 31 2.2.4. Teknologi yang digunakan ................................................... 32 2.2.4.1. XAMPP .................................................................. 32 2.2.4.2. Perl ......................................................................... 32 2.2.4.2.1 Strawberry Perl ........................................ 32 2.2.4.3. PHP ......................................................................... 33 2.2.4.4. Hyper Text Markup Language ................................ 34 2.2.4.5. Cascading Style Sheet ............................................. 34 2.2.4.6. Secure Shell ............................................................ 36 2.2.4.6.1. Definisi Secure Shell ............................... 36 2.2.4.6.2. Fitur-fitur Secure Shell ............................ 37 2.2.4.7. Adobe Dreamweaver .............................................. 38 2.2.5. Unified Modeling Language ................................................. 38 2.2.5.1. Definisi Unified Modeling Language ....................... 38 2.2.5.2. Use Case Diagram .................................................. 39 2.2.5.2.1. Include dan Enxtend Relation .................. 41
2.2.5.3. Class Diagram ........................................................ 43 2.2.5.3.1. Hubungan Antar Class ............................ 44 2.2.5.4. Sequence Diagram .................................................. 48 2.2.5.4.1. Object .................................................... 49 2.2.5.4.2. Message .................................................. 49 2.2.5.5. Activity Diagram ..................................................... 51 BAB 3 ANALISIS DAN PERANCANGAN SISTEM 3.1. Profil Perusahaan .......................................................................... 54 3.1.1. Riwayat Perusahaan ............................................................ 54 3.1.2. Struktur Organisasi .............................................................. 59 3.2. Sistem yang Sedang Berjalan ......................................................... 59 3.2.1. Prosedur yang Sedang Berjalan ........................................... 59 3.3. Hasil Wawancara .......................................................................... 61 3.4. Analisis Kebutuhan User ................................................................ 63 3.5. Analisis Permasalahan ................................................................... 64 3.6. Usulan Pemecahan Masalah .......................................................... 65 3.7. Use Case Diagram ......................................................................... 69 3.7.1. Penjelasan Aktor ................................................................. 70 3.7.2. Penjelasan Case .................................................................. 71 3.8. Class Diagrams ............................................................................. 83 3.9. Sequence Diagram ......................................................................... 84 3.10. Perancangan Database .................................................................. 97 3.10.1. ERD ................................................................................... 97 3.10.2. Sepesifikasi Database ......................................................... 98 3.10.2.1. Sepesifikasi tabel ...................................................... 98
3.11. Navigation Map ........................................................................... 113 3.12. Rancangan Layar ......................................................................... 114 BAB 4 IMPLEMENTASI DAN EVALUASI 4.1. Spesifikasi Sistem ........................................................................... 125 4.1.1. Spesifikasi Perangkat Keras ................................................. 125 4.1.2. Spesifikasi Perangkat Lunak ................................................. 126 4.2. Prosedur Operasional .................................................................... 127 4.2.1. Instalasi VMware Workstation 8 .......................................... 127 4.2.2. Instalasi Cisco Unified Call Manager dan VMware workstation ...................................................... 128 4.2.3. Instalasi DB2 ...................................................................... 131 4.2.4. Instalasi XAMPP .................................................................. 133 4.2.4.1. Instalasi Drive PHP dan DB2 pada XAMPP .............. 135 4.2.5. Instalasi Stawberry Perl ........................................................ 135 4.2.5.1. Instalasi Modul Strawberry Perl ................................. 136 4.2.6. Konfigurasi Sistem Cisco Unified Call Manager .................. 137 4.2.7. Konfigurasi IP Phone untuk Cisco IP Communicator Software .............................................................................. 138
4.2.8. Konfigurasi Planet SIP VOIP gateway pada Jaringan
CUCM ................................................................................ 139
4.3. Rencana Implementasi ................................................................... 140
4.4. Tampilan Layar ............................................................................. 142 4.5. Evaluasi ........................................................................................ 164 BAB 5 SIMPULAN DAN SARAN 5.1. Simpulan ...................................................................................... 179 5.2. Saran ........................................................................................... 180 DAFTAR PUSTAKA ....................................................................................... 181 RIWAYAT HIDUP LAMPIRAN - LAMPIRAN SURAT SURVEY
DAFTAR TABEL Tabel 3.1 Tabel Aktor spesifikasi untuk Admin ............................................... 70 Tabel 3.2 Tabel Aktor spesifikasi untuk Manager ............................................. 70 Tabel 3.3 Tabel Aktor spesifikasi untuk Admin ................................................ 71 Tabel 3.4 Tabel Spesifikasi untuk Case Configure Pricing System .................... 71 Tabel 3.5 Tabel Spesifikasi untuk Case Manage Holiday .................................. 72 Tabel 3.6 Tabel Spesifikasi untuk Case Manage Pricing Parameter ................... 72 Tabel 3.7 Tabel Spesifikasi untuk Case Manage Country List ........................... 73 Tabel 3.8 Tabel Spesifikasi untuk Case Manage City List ................................. 73 Tabel 3.9 Tabel Spesifikasi untuk Case Manage PSTN Providers ..................... 74 Tabel 3.10 Tabel Spesifikasi untuk Case Configure Pattern .............................. 74 Tabel 3.11 Tabel Spesifikasi untuk Case Manage Previleges ............................ 75 Tabel 3.12 Tabel Spesifikasi untuk Case Configure Web User .......................... 75 Tabel 3.13 Tabel Spesifikasi untuk Case Manage Phone User ........................... 76 Tabel 3.14 Tabel Spesifikasi untuk Case Manage Items .................................... 76 Tabel 3.15 Tabel Spesifikasi untuk Case Manage Phone ................................... 77 Tabel 3.16 Tabel Spesifikasi untuk Case Configure Extension .......................... 77 Tabel 3.17 Tabel Spesifikasi untuk Case Manage Item Ownership .................... 78
Tabel 3.18 Tabel Spesifikasi untuk Case Calling Process .................................. 78 Tabel 3.19 Tabel Spesifikasi untuk Case Check FAC ........................................ 79 Tabel 3.20 Tabel Spesifikasi untuk Case Validate Quota .................................. 80 Tabel 3.21 Tabel Spesifikasi untuk Case Update Level ..................................... 80 Tabel 3.22 Tabel Spesifikasi untuk Case Generate CDR ................................... 81 Tabel 3.23 Tabel Spesifikasi untuk Case Log-in to Web ................................... 81 Tabel 3.24 Tabel Spesifikasi untuk Case View Call Report ............................... 82 Tabel 3.25 Tabel spesifikasi MsGroup .............................................................. 98 Tabel 3.26 Tabel Spesifikasi Msphone .............................................................. 98 Tabel 3.27 Tabel Spesifikasi Msextension ........................................................ 99 Tabel 3.28 Tabel Spesifikasi MsProvider .......................................................... 99 Tabel 3.29 Tabel Spesifikasi ActionList ............................................................ 100 Tabel 3.30 Tabel Spesifikasi MsCountry .......................................................... 100 Tabel 3.31 Tabel Spesifikasi MsCallType ......................................................... 101 Tabel 3.32 Tabel Spesifikasi MsHoliday ........................................................... 101 Tabel 3.33 Tabel Spesifikasi MsCity ................................................................ 102 Tabel 3.34 Tabel Spesifikasi MsPhoneUser ...................................................... 102 Tabel 3.35 Tabel Spesifikasi MsGroupLeader ................................................... 104
Tabel 3.36 Tabel Spesifikasi MsPhoneOwner ................................................... 105 Tabel 3.37 Tabel Spesifikasi ExtensionOwner .................................................. 105 Tabel 3.38 Tabel Spesifikasi MsWebUser ......................................................... 106 Tabel 3.39 Tabel Spesifikasi MsNews .............................................................. 106 Tabel 3.40 Tabel Spesifikasi UpdateCUCM ...................................................... 107 Tabel 3.41 Tabel Spesifikasi MsCallPattern ...................................................... 108 Tabel 3.42 Tabel Spesifikasi TrCallDetail ......................................................... 108 Tabel 3.43 Tabel Spesifikasi TrCallHeader ....................................................... 109 Tabel 3.44 Tabel Spesifikasi CountryCall ......................................................... 110 Tabel 3.45 Tabel Spesifikasi CityCall ............................................................... 110 Tabel 3.46 Tabel Spesifikasi MsPrice ............................................................... 111 Tabel 3.47 Tabel Spesifikasi MsPriceDay ......................................................... 112
DAFTAR GAMBAR Gambar 2.1 Proses Server Side Scripting .......................................................... 20 Gambar 2.2 Replika Phonograph ..................................................................... 27 Gambar 2.3 Contoh hasil Variasi Suara ............................................................ 27 Gambar 2.4 Contoh Perubahan sinyal analog menjadi digital ............................ 29 Gambar 2.5 Contoh Actor ................................................................................ 39 Gambar 2.6 Contoh Case ................................................................................. 40 Gambar 2.7 Contoh Use Case Diagrams ........................................................... 40 Gambar 2.8 Contoh penggunaan include ........................................................... 41 Gambar 2.9 Contoh penggunaan extends .......................................................... 42 Gambar 2.10 Contoh class ................................................................................ 43 Gambar 2.11 Contoh Class Diagram ................................................................. 43 Gambar 2.12 Contoh Hubungan Association .................................................... 45 Gambar 2.13 Contoh Hubungan Generalization ................................................ 46 Gambar 2.14 Contoh Hubungan Aggregation ................................................... 47 Gambar 2.15 Contoh Hubungan Compotition ................................................... 48 Gambar 2.16 Contoh Sequence Diagram .......................................................... 49 Gambar 2.17 Penggambaran Message pada Sequence Diagram ........................ 50
Gambar 2.18 Contoh Action State .................................................................... 51 Gambar 2.19 Contoh Initial dan Final Nodes .................................................... 51 Gambar 2.20 Contoh Decision dan Merge Node ............................................... 52 Gambar 2.21 Contoh Activity Diagram ............................................................. 53 Gambar 3.1 Struktur Organisasi PT. Prologic Solusindo ................................... 59 Gambar 3.2 Activity Diagram Sistem yang Sedang Berjalan ............................. 60 Gambar 3.3 Activity Diagram Usulan Pemecahan Masalah .............................. 67 Gambar 3.4 Use Case Diagram Manajemen Kuota dan Sistem Billing .............. 69 Gambar 3.5 Class Diagram Manajemen Kuota dan Sistem Billing .................... 83 Gambar 3.6 Sequence Diagram web login Manajemen Kuota dan Sistem Billing CUCM ........................................................................................ 84 Gambar 3.7 Sequence Diagram View Call Report Manajemen Kuota dan Sistem Billing CUCM .............................................................................. 84 Gambar 3.8 Sequence Diagram Configure Extension Manajemen Kuota dan Sistem Billing CUCM .................................................................. 85 Gambar 3.9 Sequence Diagram Manage Item Ownership Extension Manajemen Kuota dan Sistem Billing CUCM ................................................. 86 Gambar 3.10 Sequence diagram Manage item ownership phone Manajemen
kuota dan Sistem Billing CUCM ................................................. 87
Gambar 3.11 Sequence Diagram Manage Phone User Manajemen Kuota dan Sistem Billing CUCM ............................................................... 88 Gambar 3.12 Sequence Diagram Configure web user Manajemen Kuota dan Sistem Billing CUCM ............................................................... 89 Gambar 3.13 Sequence Diagram Manage Phone User Manajemen Kuota dan Sistem Billing CUCM ............................................................... 90 Gambar 3.14 Sequence Diagram Configure Call Pattern Manajemen Kuota dan Sistem Billing CUCM .......................................................... 91 Gambar 3.15 Sequence Diagram Manage City Manajemen Kuota dan Sistem Billing CUCM ........................................................................... 92 Gambar 3.16 Sequence Diagram Manage Country Manajemen Kuota dan Sistem Billing CUCM ............................................................... 93 Gambar 3.17 Sequence Diagram Manage Holiday Manajemen Kuota dan Sistem Billing CUCM ............................................................... 94 Gambar 3.18 Sequence Diagram Manage Provider Manajemen Kuota dan Sistem Billing CUCM .............................................................. 95
Gambar 3.19 Sequence Diagram Call Pricing Manajemen Kuota dan Sistem Billing CUCM ............................................................... 96 Gambar 3.20 ERD Manajemen Kuota dan Sistem Billing CUCM ..................... 97 Gambar 3.21 Navigasi Map Manajemen Kuota dan Sistem Billing ................... 113 Gambar 3.22 Rancangan Layar Log-in ............................................................. 114 Gambar 3.23 Rancangan Layar View Report .................................................... 114 Gambar 3.24 Rancangan Layar User ................................................................. 115 Gambar 3.25 Rancangan Layar User Detail ...................................................... 115 Gambar 3.26 Rancangan Layar Group .............................................................. 116 Gambar 3.27 Rancangan Layar Group Detail .................................................... 116 Gambar 3.28 Rancangan Layar Number ........................................................... 117 Gambar 3.29 Rancangan Layar Price List ......................................................... 117 Gambar 3.30 Rancangan Layar SLJJ Rate ........................................................ 118 Gambar 3.31 Rancangan Layar SLI Rate .......................................................... 118 Gambar 3.32 Rancangan Layar Mobile Rate ..................................................... 119 Gambar 3.33 Rancangan Layar Extension ......................................................... 119 Gambar 3.34 Rancangan Layar Phone .............................................................. 120 Gambar 3.35 Rancangan Layar Holiday ............................................................ 120
Gambar 3.36 Rancangan Layar Provider ........................................................... 121 Gambar 3.37 Rancangan Layar City ................................................................. 121 Gambar 3.38 Rancangan Layar Country ........................................................... 122 Gambar 3.39 Rancangan Layar News ............................................................... 122 Gambar 3.40 Rancangan Layar Report ............................................................. 123 Gambar 3.41 Rancangan Layar Group Report ................................................... 123 Gambar 3.42 Rancangan Layar User Report ..................................................... 124 Gambar 3.43 Rancangan Layar All Report ........................................................ 124 Gambar 4.1 Tampilan Layar Log-in .................................................................. 142 Gambar 4.2 Tampilan Layar User List .............................................................. 143 Gambar 4.3 Tampilan Layar User Detail ........................................................... 144 Gambar 4.4 Tampilan Layar Group List ........................................................... 145 Gambar 4.5 Tampilan Layar Group Detail ........................................................ 146 Gambar 4.6 Tampilan Layar Number List ......................................................... 147 Gambar 4.7 Tampilan Layar Price .................................................................... 148 Gambar 4.8 Tampilan Layar SLJJ Price ............................................................ 149 Gambar 4.9 Tampilan Layar SLI Price .............................................................. 150 Gambar 4.10 Tampilan Layar Mobile Price ...................................................... 151
Gambar 4.11 Tampilan Layar Extension ........................................................... 152 Gambar 4.12 Tampilan Layar Phone ................................................................. 153 Gambar 4.13 Tampilan Layar Holiday .............................................................. 154 Gambar 4.14 Tampilan Provider ....................................................................... 155 Gambar 4.15 Tampilan Layar City .................................................................... 156 Gambar 4.16 Tampilan Layar Country .............................................................. 157 Gambar 4.17 Tampilan Layar News .................................................................. 158 Gambar 4.18 Tampilan Layar Report ................................................................ 159 Gambar 4.19 Tampilan Layar Group Report ..................................................... 160 Gambar 4.20 Tampilan Layar User Report ........................................................ 161 Gambar 4.21 Tampilan Layar All Report .......................................................... 162 Gambar 4.22 Tampilan Layar viewreport .......................................................... 163 Gambar 4.23 Hasil Evaluasi Yslow ................................................................... 164 Gambar 4.24 Hasil Evaluasi Halaman Login Page Speed ................................. 166 Gambar 4.25 Hasil Evaluasi Halaman User List Page Speed ............................. 167 Gambar 4.26 Hasil Evaluasi Halaman Group List Page Speed .......................... 168 Gambar 4.27 Hasil Evaluasi Halaman Number List Page Speed ....................... 169 Gambar 4.28 Hasil Evaluasi Halaman Price List Page Speed ............................ 170
Gambar 4.29 Hasil Evaluasi Halaman Extension List Page Speed ..................... 171 Gambar 4.30 Hasil Evaluasi Halaman Phone List Page Speed .......................... 172 Gambar 4.31 Hasil Evaluasi Halaman Provider List Page Speed ....................... 173 Gambar 4.32 Hasil Evaluasi Halaman City List Page Speed ............................. 174 Gambar 4.33 Hasil Evaluasi Halaman Country List Page Speed ....................... 175 Gambar 4.34 Hasil Evaluasi Halaman News List Page Speed ........................... 176 Gambar 4.35 Hasil Evaluasi Halaman Call Report Page Speed ......................... 177
DAFTAR LAMPIRAN Contoh Call Detail Record ................................................................................ L1 Tabel Penjelasan CDR (Call Detail Record) ...................................................... L3 Tabel Tarif Telepon SLJJ MOBILE SLI ........................................................... L19 Data Survey
PRAKATA
Puji syukur penulis panjatkan kepada Tuhan Yang Maha Esa karena berkat dan rahmat-Nya, penulis dapat menyelesaikan penulisan skripsi ini dengan baik dan tepat pada waktunya. Penulisan skripsi ini merupakan hasil dari penyelesaian tugas akhir dengan judul “Manajemen Kuota dan Sistem Billing Berbasis Cisco Unified Communication Manager (CUCM)”. Tujuan dari penulisan skripsi yang telah disusun oleh penulis bertujuan untuk memenuhi syarat guna memperoleh gelar kesarjanaan pada jenjang Strata 1, Jurusan Teknik Informatika, Fakultas Ilmu Komputer di Universitas Bina Nusantara. Penulis juga mengucapkan terima kasih atas bantuan berupa dukungan, saran, petunjuk, dan kesempatan yang telah diberikan selama penulisan skripsi ini hingga selesai. Kami mengucapkan terima kasih terutama kepada: 1. Bapak Prof. Dr. Ir. Harjanto Prabowo, MM., selaku Rektor Universitas Bina Nusantara
yang
telah
memberikan
kesempatan
dan
kepercayaan
menyelesaikan skripsi ini. 2. Bapak Fredy Purnomo, S.Kom, M.Kom., selaku Head School of Computer Science yang telah memberikan fasilitas dan kesempatan pada penulisan skripsi ini. 3. Ibu Yen Lina Prasetio, S.Kom., M.CompSc, selaku Deputy Head of Computer Science School – Academic & Operation di Universitas Bina Nusantara 4. Bapak Michael Yoseph Ricky, S.Kom., MM, selaku Deputy Head of Computer Science School – Student & Alumni di Universitas Bina Nusantara
5. Ibu Cuk Tho, S.Kom.,MM.,M.Comm(IS) selaku dosen pembimbing kami yang telah membimbing kami dalam pengarahan, kritik, dan saran selama penulisan skripsi ini sehingga terselesaikan dengan baik. 6. Bapak Prabandana Listyanto ST Msc, selaku Director of Training dari PT. PROLOGIC SOLUSINDO. 7. Orang tua dan keluarga penulis yang telah banyak memberikan dukungan, baik spiritual maupun material selama penulisan skripsi ini. 8. Teman-teman yang telah memberikan dukungan moral dan doa dalam penyusunan skripsi ini, serta pihak-pihak lain yang tidak dapat disebutkan satu per satu yang turut membantu penyusunan skripsi ini baik secara langsung maupun tidak langsung.
Harapan penulis, semoga skripsi yang telah disusun ini dapat memeberikan sumbangan yang berarti dan berguna bagi PT. PROLOGIC SOLUSINDO, para pembaca sekalian, dan terutama bagi Universitas Bina Nusantara. Penulis menyadari, bahwa sususan yang terkandung dalam penulisan skripsi ini masih jauh dari kesempurnaan. Oleh karena itu, penulis terus mengharapkan saran dan kritik yang bersifat membangun. Akhir kata penulis mengucapkan terima kasih sebesar-besarnya kepada semua pihak yang membantu hingga terselesaikannya penulisan skripsi ini.
Jakarta, Maret 2013
Penulis
