ABSTRAK. Kata kunci: data mining, customer relationship management, association rules, promosi, WEKA. vii. Universitas Kristen Maranatha

ABSTRAK PT Berdikari Indo Super Grosir adalah salah satu perusahaan yang menyediakan jasa one stop shopping, khususnya bagi pembelian kebutuhan pembangunan rumah dan perabotan rumah tangga. Salah satu permasalahan yang dialami oleh PT. Berdikari Indo Super Grosir adalah ketidakmampuan memanfaatkan data-data penjualan yang ada untuk melakukan promosi karena masih dikelola secara manual. Dalam penelitian tugas akhir ini dikembangkan sebuah aplikasi web yang diberi nama SCMINING dengan menerapkan algoritma association rules guna mengatasi masalah ini. Keluaran dari algoritma tersebut akan dimanfaatkan untuk meningkatkan hubungan baik dengan pelanggan melalui penerapan Customer Relationship Management (CRM). Pendekatan CRM memungkinkan adanya pengelolaan hubungan yang baik dengan pelanggan karena data penjualan yang ada digunakan untuk memberikan promosi yang tepat kepada setiap segmen pelanggan. Terdapat empat macam segmen pelanggan yang diteliti dalam proyek tugas akhir ini, yaitu: umur, pekerjaan, jenis kelamin, dan agama. Hasil penelitian menunjukkan bahwa algoritma association rules telah dapat menunjukkan potensinya sebagai alat untuk mempelajari kaitan antara segmen pelanggan dan pola belanja dalam masing-masing tersebut.

Kata kunci: data mining, customer relationship management, association rules, promosi , WEKA

vii

Universitas Kristen Maranatha

ABSTRACT PT Berdikari Indo Super Grosir is company which provide one stop shopping experience, especially in providing household and hardwares. Due to manual management of transactional data, there are some managerial problems exist. One of the problem is to provide effective marketing program for existing customers. In this final project a Cusomer Relationship Management (CRM) datamining web-based application is proposed to overcome the problem. The association rules algorithm is applied to construct relational promotional programs for various customer profiles. There are four customer profiles are explored in this project, i.e.: age, occupation, sex, and religion. Experimental results show that the association rules algorithm has a high potential to learnt customers' behaviour and is very promising as the backbone of the company's marketing system.

Keyword: data mining, customer relationship management, association rules, promotion , WEKA .

viii


DAFTAR ISI

BAB I PENDAHULUAN ...................................................................................... 1 1.1

Latar Belakang ........................................................................................... 1

1.2

Rumusan Masalah ...................................................................................... 2

1.3

Tujuan ........................................................................................................ 3

1.4

Batasan Masalah ........................................................................................ 3

1.5

Sistematika Pembahasan ............................................................................ 3

BAB II LANDASAN TEORI ............................................................................... 5 2.1

Data mining ............................................................................................... 5

2.1.1

Faktor Pendorong Kemajuan Data mining ......................................... 5

2.1.2

Pemanfaatan Data mining ................................................................... 6

2.1.3

Hubungan Data mining dengan Pembelajaran Mesin ......................... 7

2.2

Association rules ........................................................................................ 7

2.2.1

Cara Kerja Association Rules .............................................................. 8

2.2.2

Tree ................................................................................................... 13

2.2.3

Perbandingan Hasil Idtree dan Association rules Menggunakan

WEKA 13 2.3

Customer Relationship Management(CRM) ............................................ 17

2.4

Cross-Selling............................................................................................ 19

2.5

Web .......................................................................................................... 20

2.6

XAMPP.................................................................................................... 20

2.7

Glassfish................................................................................................... 20

2.8

HTML ...................................................................................................... 21

2.9

PHP .......................................................................................................... 21

2.10

Java Server Page .................................................................................. 21

2.11

JavaScript ............................................................................................. 21

2.12

CSS ....................................................................................................... 22

2.13

DFD (Data Flow Diagram) .................................................................. 22

2.13.1 2.14

Kamus Data.................................................................................... 22 ERD (Entity Relationship Diagram) .................................................... 23 ix


2.14.1

Entitas ............................................................................................ 23

2.14.2

Atribut ............................................................................................ 23

2.14.3

Relasi ............................................................................................. 23

2.14.4

Kardinalitas .................................................................................... 23

2.15

Database ............................................................................................... 25

2.16

MySQL .................................................................................................. 25

2.17

SMS Gateway ....................................................................................... 25

BAB III ANALISIS DAN DESAIN ................................................................... 26 3.1

Analisis .................................................................................................... 26

3.1.1

Pembelian .......................................................................................... 26

3.1.2

Penjualan ........................................................................................... 26

3.1.3

Analisis Situasi dan Tawaran Situasi ................................................ 28

3.2

Gambaran Keseluruhan............................................................................ 29

3.2.1

Persyaratan Antarmuka Eksternal ..................................................... 30

3.2.2

Antarmuka dengan Pengguna ........................................................... 31

3.2.3

Antarmuka Perangkat Keras ............................................................. 31

3.2.4

Antarmuka Perangkat Lunak............................................................. 31

3.2.5

Antarmuka Komunikasi .................................................................... 32

3.2.6

Fitur-fitur Produk Perangkat Lunak .................................................. 32

3.3

Disain Perangkat Lunak ........................................................................... 77

3.3.1

Permodelan Perangkat Lunak ........................................................... 77

3.3.2

Disain Penyimpanan Data ............................................................... 132

Entitas

learning_associate,

learning_dependet_detail

dan

learning_indepent_detail merupakan entitas yang paling penting karena ketiga entitas tersebut merupakan tempat penyimpanan hasil pembelajaran. ......... 134 3.3.3

Disain Antarmuka ........................................................................... 134

BAB IV PENGEMBANGAN PERANGKAT LUNAK ................................. 149 4.1

Implementasi Class/Modul .................................................................... 149

4.1.1

Implementasi Sistem Utama ........................................................... 149

4.1.2

Implementasi Sistem Pemesanan Melalui SMS .............................. 164

4.1.3

Impelementasi Pembelajaran Keseluruhan ..................................... 165

4.2

Implementasi Penyimpanan Data .......................................................... 172 x


4.2.1

Implementasi Penyimpanan Data Keseluruhan .............................. 173

4.2.2

Implementasi Penyimpanan Data Gammu ...................................... 173

4.3

Implementasi Antarmuka ....................................................................... 174

4.3.1

Implementasi Antarmuka Admin .................................................... 174

4.3.2

Implementasi Antarmuka User ....................................................... 256

4.4

Implementasi CRM ................................................................................ 268

4.5

Impelementasi Data Mining .................................................................. 270

4.5.1

Preprocessing .................................................................................. 270

4.5.2

Proses Penggalian Data (Mining) .................................................... 270

4.5.3

Penyimpanan pengetahuan (Knowledge Storing) ........................... 270

4.5.4

Penggunaan Pengetahuan ................................................................ 270

BAB V TESTING DAN EVALUASI SISTEM .............................................. 273 5.1

Rencana Pengujian................................................................................. 273

5.2

Pelaksanaan Pengujian........................................................................... 273

5.2.1

Rencana Pengujian Login................................................................ 273

5.2.2

Rencana Pengujian Logout.............................................................. 274

5.2.3

Rencana Pengujian Change password ............................................ 274

5.2.4

Rencana Pengujian User ................................................................. 275

5.2.5

Perancangan Pengujian Kategori .................................................... 290

5.2.6

Perancangan Pengujian Barang ....................................................... 294

5.2.7

Perancangan Pengujian Order Massal ............................................. 299

5.2.8

Perancangan Pengujian Pemesanan ................................................ 304

5.2.9

Perancangan Pengujian Pemesanan Detail...................................... 308

5.2.10

Perancangan Pengujian Pembelajaran ......................................... 312

5.2.11

Perancangan Pengujian Promosi .................................................. 314

5.2.12

Perancangan Pengujian Reporting ............................................... 318

5.2.13

Perancangan Pengujian SMS ....................................................... 319

5.2.14

Perancangan Pengujian History SMS .......................................... 319

5.3

Evaluasi.................................................................................................. 321

BAB VI KESIMPULAN DAN SARAN........................................................... 324 6.1

Kesimpulan ............................................................................................ 324

6.2

Saran ...................................................................................................... 324 xi


DAFTAR PUSTAKA ........................................................................................ 326

xii


DAFTAR GAMBAR Gambar 2.1 Relus Hasil Asosiasi 1 (Ian, Frank, & Mark, 2011) ............................ 9 Gambar 2.2 Rules Hasil Asosiasi 2 (Ian, Frank, & Mark, 2011) .......................... 10 Gambar 2.3 Hasil Association Rule 1(Ian, Frank, & Mark, 2011) ....................... 11 Gambar 2.4 Hasil Association Rule 2 (Ian, Frank, & Mark, 2011) ...................... 12 Gambar 2.5 Contoh Decision Tree (WEKA) ........................................................ 14 Gambar 2.6 Contoh Hasil Adtree (WEKA) .......................................................... 15 Gambar 2.7 Hasil Association rules (WEKA) ...................................................... 16 Gambar 2.8 Knowledge-Based CRM Framework (Winer, 2001) ......................... 17 Gambar 3.1 Flowchart Pembelian ......................................................................... 27 Gambar 3.2 Flowchart Penjualan .......................................................................... 28 Gambar 3.3 Gambaran Rancangan Keseluruhan Sistem ...................................... 30 Gambar 3.4 DFD Level 0 ...................................................................................... 78 Gambar 3.5 DFD Level 1 ...................................................................................... 78 Gambar 3.6 DFD Level 2 Proses Order................................................................ 79 Gambar 3.7 DFD Level 2 Proses Promosi ............................................................ 79 Gambar 3.8 DFD Level 2 User ............................................................................. 80 Gambar 3.9 DFD Level 2 Proses Kategori ........................................................... 80 Gambar 3.10 DFD Level 2 Proses Barang ............................................................ 81 Gambar 3.11 DFD Level 2 Proses Pemesanan ..................................................... 81 Gambar 3.12 DFD Level 2 Proses Pemesanan Detail........................................... 82 Gambar 3.13 DFD Level 2 Proses Pembelajaran ................................................. 82 Gambar 3.14 DFD Level 2 Proses Reporting ....................................................... 83 Gambar 3.15 ERD Sistem SCMINING .............................................................. 133 Gambar 3.16 Halaman Login Admin .................................................................. 134 Gambar 3.17 Halaman Home Admin.................................................................. 134 Gambar 3.18 Halaman User Admin.................................................................... 135 Gambar 3.19 Halaman Insert User Admin ......................................................... 135 Gambar 3.20 Halaman Update User Admin ....................................................... 136 Gambar 3.21 Halaman Kategori Admin ............................................................. 136 Gambar 3.22 Halaman Insert Kategori Admin ................................................... 137 xiii


Gambar 3.23 Halaman Update Kategori Admin................................................. 137 Gambar 3.24 Halaman Barang Admin ................................................................ 137 Gambar 3.25 Halaman Insert Barang Admin ..................................................... 138 Gambar 3.26 Halaman Update Barang Admin ................................................... 138 Gambar 3.27 Halaman Order Masal Admin ....................................................... 138 Gambar 3.28 Halaman Insert Order Masal......................................................... 139 Gambar 3.29 Halaman View Order Masal Admin ............................................. 139 Gambar 3.30 Halaman Pemesanan Admin ......................................................... 140 Gambar 3.31 Halaman Insert Pemesanan Admin ............................................... 140 Gambar 3.32 Halaman Update Pemesanan Admin............................................. 141 Gambar 3.33 Halaman Pemesanan Detail Admin............................................... 141 Gambar 3.34 Halaman Insert Pemesanan Detail Admin .................................... 142 Gambar 3.35 Halaman Update Pemesanan Detail Admin .................................. 142 Gambar 3.36 Halaman Pembelajaran Admin...................................................... 142 Gambar 3.37 Halaman Promosi Admin .............................................................. 143 Gambar 3.38 Halaman Insert Promosi Admin.................................................... 143 Gambar 3.39 Halaman Reporting Admin ........................................................... 144 Gambar 3.40 Halaman SMS Admin ................................................................... 144 Gambar 3.41 Halaman History SMS Admin ...................................................... 145 Gambar 3.42 Halaman Change password Admin .............................................. 145 Gambar 3.43 Halaman Login User ..................................................................... 146 Gambar 3.44 Halaman Home User ..................................................................... 146 Gambar 3.45 Halaman insert Order Massal User .............................................. 147 Gambar 3.46 Halaman Insert Order Massal User .............................................. 147 Gambar 3.47 Halaman Change password User .................................................. 148 Gambar 4.1 Impementasi Sistem Keseluruhan ................................................... 150 Gambar 4.2 Implementasi Sistem Pemesanan Melalui SMS .............................. 164 Gambar 4.3 Implementasi Penyimpanan Data Keseluruhan ............................... 173 Gambar 4.4 Implementasi Penyimpanan Data Gammu ...................................... 174 Gambar 4.5 Langkah Awal Untuk Masuk ke Halaman Login ............................ 175 Gambar 4.6 Proses Login Untuk Masuk Sistem Utama ...................................... 175 Gambar 4.7 Pemberitahuan Login Gagal ............................................................ 176 xiv


Gambar 4.8 Halaman Home Admin.................................................................... 176 Gambar 4.9 Halaman User Admin...................................................................... 177 Gambar 4.10 Halaman Insert User Admin ......................................................... 178 Gambar 4.11 Pesan Kesalahan Insert User Admin ............................................. 179 Gambar 4.12 Proses Insert User Admin ............................................................. 180 Gambar 4.13 Data User Baru Berhasil Dimasukan ............................................ 180 Gambar 4.14 Proses Update Data User .............................................................. 181 Gambar 4.15 Form Update Tabel User .............................................................. 181 Gambar 4.16 Keterangan Update Pada Form User ............................................ 182 Gambar 4.17 Data Untuk Update Sudah Sesuai ................................................. 182 Gambar 4.18 Update User Berhasil Dilakukan .................................................. 183 Gambar 4.19 Proses Delete User ........................................................................ 183 Gambar 4.20 Konfirmasi Delete User ................................................................ 184 Gambar 4.21 Data User Berhasil Dihapus .......................................................... 184 Gambar 4.22 form Search User .......................................................................... 185 Gambar 4.23 Inputan Data Search Yang Diminta .............................................. 185 Gambar 4.24 Proses Search User........................................................................ 186 Gambar 4.25 Proses Search User Berhasil ......................................................... 186 Gambar 4.26 Clear query Search User ............................................................... 187 Gambar 4.27 Data User Kembali Seperti Semula .............................................. 187 Gambar 4.28 Halaman Kategori Admin ............................................................. 188 Gambar 4.29 Proses Insert Kategori ................................................................... 188 Gambar 4.30 Form Insert Kategori ..................................................................... 189 Gambar 4.31 Keterangan Kesalahan Insert Kategori ......................................... 189 Gambar 4.32 Proses Insert Data Kategori........................................................... 190 Gambar 4.33 Insert Kategori Berhasil Dilakukan............................................... 190 Gambar 4.34 Proses Update Kategori ................................................................. 191 Gambar 4.35 Form Update Kategori .................................................................. 191 Gambar 4.36 Keterangn Update Kategori .......................................................... 191 Gambar 4.37 Proses Update Data Kategori ........................................................ 192 Gambar 4.38 Proses Update Kategori Berhasil Dilakukan ................................. 192 Gambar 4.39 Proses Delete Kategori .................................................................. 192 xv


Gambar 4.40 Konfirmasi Delete Tabel Kategori ................................................ 193 Gambar 4.41 Delete Data Kategori berhasil ....................................................... 193 Gambar 4.42 Form Search Kategori ................................................................... 194 Gambar 4.43 Opsi Pencarian Search Kategori ................................................... 194 Gambar 4.44 Nama Kolom Search Kategori ...................................................... 195 Gambar 4.45 Proses Search Data Kategori ......................................................... 195 Gambar 4.46 Proses Search Kategori Berhasil ................................................... 196 Gambar 4.47 Clear Query Tabel Kategori .......................................................... 196 Gambar 4.48 Tabel Kategori Kembali Seperti Semula ....................................... 197 Gambar 4.49 Page per view Tabel Kategori ....................................................... 197 Gambar 4.50 Halaman Barang Admin ................................................................ 198 Gambar 4.51 Proses Insert barang ...................................................................... 198 Gambar 4.52 Form Insert Barang ....................................................................... 199 Gambar 4.53 Keterangan Insert Barang.............................................................. 199 Gambar 4.54 Proses Insert Data Barang ............................................................. 200 Gambar 4.55 Proses Insert Barang Berhasil ....................................................... 200 Gambar 4.56 Proses Update Barang ................................................................... 201 Gambar 4.57 Form Update Barang ..................................................................... 201 Gambar 4.58 Keterangan Update Barang ........................................................... 201 Gambar 4.59 Proses Update Data Barang........................................................... 202 Gambar 4.60 Update Data Barang Berhasil ........................................................ 202 Gambar 4.61 Proses Delete Barang .................................................................... 202 Gambar 4.62 Konfirmasi Delete Data Barang .................................................... 203 Gambar 4.63 Proses Delete Data Barang Berhasil.............................................. 203 Gambar 4.64 Proses Search Barang .................................................................... 204 Gambar 4.65 Masukan Search Barang................................................................ 204 Gambar 4.66 Opsi Pencarian Search Barang ...................................................... 205 Gambar 4.67 Proses Search Data Barang ........................................................... 205 Gambar 4.68 Search Tabel Barang Berhasil ....................................................... 206 Gambar 4.69 Clear Query Tabel Barang ............................................................ 206 Gambar 4.70 Page per view Tabel Barang ......................................................... 207 Gambar 4.71 Halaman Order Massal .................................................................. 207 xvi


Gambar 4.72 Proses Insert Order Massal ........................................................... 208 Gambar 4.73 Form Insert Order Massal ............................................................. 208 Gambar 4.74 Proses Insert Data Order ............................................................... 209 Gambar 4.75 Insert Order Berhasil Dilakukan ................................................... 209 Gambar 4.76 View Order Detail......................................................................... 210 Gambar 4.77 Order Detail .................................................................................. 210 Gambar 4.78 Proses Delete Order Masal ........................................................... 211 Gambar 4.79 Konfirmasi Delete Order Masal.................................................... 211 Gambar 4.80 Proses Delete Order Berhasil ........................................................ 212 Gambar 4.81 Form Search Tabel Order ............................................................. 212 Gambar 4.82 Data Search Order Masal.............................................................. 213 Gambar 4.83 Nama Kolom Search Order .......................................................... 213 Gambar 4.84 Proses Search Data Order ............................................................. 214 Gambar 4.85 Search Data Order Berhasil .......................................................... 214 Gambar 4.86 Clear query Order Masal .............................................................. 215 Gambar 4.87 Cleaer Query Berhasil Dilakukan ................................................. 215 Gambar 4.88 Pages Per View Order ................................................................... 216 Gambar 4.89 Halaman Pemesanan Admin ......................................................... 216 Gambar 4.90 Proses Insert Pemesanan ............................................................... 217 Gambar 4.91 Form Insert Pemesanan................................................................. 217 Gambar 4.92 Keterangan Insert Data Pemesanan............................................... 218 Gambar 4.93 Proses Insert Data Pemesanan....................................................... 218 Gambar 4.94 Proses Insert Data Pemesanan Berhasil ........................................ 219 Gambar 4.95 Proses Update Pemesanan............................................................. 219 Gambar 4.96 Form Update Pemesanan .............................................................. 220 Gambar 4.97 Keterangan Update Pemesanan..................................................... 220 Gambar 4.98 Proses Update Data Pemesanan .................................................... 220 Gambar 4.99 Proses Update Data Pemesanan Berhasil ...................................... 221 Gambar 4.100 Proses Delete Pemesanan ............................................................ 221 Gambar 4.101 Konfirmasi Delete Data Pemesanan............................................ 222 Gambar 4.102 Proses Delete Data Pemesanan Berhasil ..................................... 222 Gambar 4.103 Form Search Data Pemesanan .................................................... 223 xvii


Gambar 4.104 Masukan Search Pemesanan ....................................................... 223 Gambar 4.105 Nama Kolom Search Pemesanan ................................................ 224 Gambar 4.106 Proses Search Data Pemesanan ................................................... 224 Gambar 4.107 Proses Search Data Pemesanan Berhasil .................................... 225 Gambar 4.108 Clear query Tabel Pemesanan..................................................... 225 Gambar 4.109 Tabel Pemesanan Kembali Seperti Semula ................................. 226 Gambar 4.110 Page per view Pemesanan ........................................................... 226 Gambar 4.111 Halaman Pemesanan Detail ......................................................... 227 Gambar 4.112 Proses Insert Pemesanan detail ................................................... 227 Gambar 4.113 Form Insert Pemesanan Detail .................................................... 228 Gambar 4.114 Keterangan Insert Data Pemesanan Detail .................................. 228 Gambar 4.115 Proses Insert Data Pemesanan Detail .......................................... 229 Gambar 4.116 Proses Insert Pemesanan Detail Berhasil .................................... 229 Gambar 4.117 Proses Update Pemesanan Detail ................................................ 230 Gambar 4.118 Form Update Pemesanan Detail ................................................. 230 Gambar 4.119 Keterangan Update Pemesanan Detail ........................................ 230 Gambar 4.120 Proses Update Data Pemesanan Detail ....................................... 231 Gambar 4.121 Update Data Pemesanan Detail Berhasil .................................... 231 Gambar 4.122 Proses Delete Data Pemesanan Detail ......................................... 231 Gambar 4.123 Konfirmasi Delete Data Pemesanan Detail ................................. 232 Gambar 4.124 Proses Delete Data Pemesanan Detail Berhasil .......................... 232 Gambar 4.125 Proses Search Pemesanan Detail................................................. 233 Gambar 4.126 Form Search Pemesanan Detail .................................................. 233 Gambar 4.127 Kelengkapan Data Search Pemesanan Detail ............................. 234 Gambar 4.128 Proses Search Data Pemesanan Detail ........................................ 234 Gambar 4.129 Clear query Pemesanan Detail .................................................... 235 Gambar 4.130 Clear query Berhasil Dilakukan.................................................. 235 Gambar 4.131 Pages Per View Pemesanan Detail .............................................. 236 Gambar 4.132 Halaman Pembelajaran Admin.................................................... 236 Gambar 4.133 Form Insert Data Pembelajaran .................................................. 237 Gambar 4.134 Tabel Pembelajaran Yang DIhasilkan ......................................... 237 Gambar 4.135 Fitur Download Pembelajaran ..................................................... 238 xviii


Gambar 4.136 Excel Hasil Pembelajaran............................................................ 238 Gambar 4.137 Pages Per View Tabel Pembelajaran ........................................... 239 Gambar 4.138 Halaman Promosi ........................................................................ 239 Gambar 4.139 Proses Insert Promosi .................................................................. 240 Gambar 4.140 Form Insert Data Promosi ........................................................... 240 Gambar 4.141 Keterangan Insert Data Promosi ................................................. 241 Gambar 4.142 Proses Insert Data Promosi ......................................................... 241 Gambar 4.143 Proses Insert Data Promosi Berhasil ........................................... 242 Gambar 4.144 Proses Delete Data Promosi ........................................................ 242 Gambar 4.145 Konfirmasi Delete Data Promosi ................................................ 243 Gambar 4.146 Proses Delete Data Promosi Berhasil .......................................... 243 Gambar 4.147 Proses Search Data Promosi ....................................................... 244 Gambar 4.148 Form Search Promosi.................................................................. 244 Gambar 4.149 Proses Search data Promosi ........................................................ 245 Gambar 4.150 Proses Search Promosi Berhasil .................................................. 245 Gambar 4.151 Clear Query Tabel Promosi ........................................................ 246 Gambar 4.152 Clear Query Promosi Berhasil .................................................... 246 Gambar 4.153 Pola Pembelajaran Halaman Promosi ......................................... 247 Gambar 4.154 Tabel Pembelajaran Pada Halaman Promosi .............................. 247 Gambar 4.155 Pages Per View Promosi ............................................................. 248 Gambar 4.156 Halaman Reporting ..................................................................... 248 Gambar 4.157 Proses Memulai Reporting .......................................................... 249 Gambar 4.158 Proses Reporting Berhasil ........................................................... 249 Gambar 4.159 Halaman SMS Admin ................................................................. 250 Gambar 4.160 Tipe SMS Konsumen .................................................................. 250 Gambar 4.161 Proses Pengiriman SMS .............................................................. 251 Gambar 4.162 Pola Pembelajaran Pada Halaman SMS ...................................... 251 Gambar 4.163 Tabel Pembelajaran Pada Halaman SMS .................................... 252 Gambar 4.164 Halaman History SMS ................................................................. 252 Gambar 4.165 Proses Search History SMS ........................................................ 253 Gambar 4.166 Form Search History SMS .......................................................... 253 Gambar 4.167 Proses Search Data History SMS ................................................ 254 xix


Gambar 4.168 Proses Search History SMS Berhasil .......................................... 254 Gambar 4.169 Clear Query History SMS ........................................................... 255 Gambar 4.170 Clear query History SMS Berhasil ............................................. 255 Gambar 4.171 Pages Per View History SMS ..................................................... 256 Gambar 4.172 Halaman Login User ................................................................... 256 Gambar 4.173 Konfirmasi Login User................................................................ 257 Gambar 4.174 Halaman Home User ................................................................... 257 Gambar 4.175 Halaman Order Massal User ....................................................... 258 Gambar 4.176 Proses Insert Order Massal User................................................. 258 Gambar 4.177 Form Insert Order Massal User .................................................. 259 Gambar 4.178 Proses Insert Data Order Baru .................................................... 259 Gambar 4.179 Proses Insert Order User Berhasil .............................................. 260 Gambar 4.180 View Order User ......................................................................... 260 Gambar 4.181 Detail Order User........................................................................ 261 Gambar 4.182 Proses Search Order.................................................................... 261 Gambar 4.183 Baris Pencarian Order User ........................................................ 262 Gambar 4.184 Form Search Order User ............................................................ 262 Gambar 4.185 Proses Search Data Order User .................................................. 263 Gambar 4.186 Search Order User Berhasil ........................................................ 263 Gambar 4.187 Clear query Order User .............................................................. 264 Gambar 4.188 Clear query Order User Berhasil ................................................ 264 Gambar 4.189 Page per view Order User .......................................................... 265 Gambar 4.190 Change password User ............................................................... 265 Gambar 4.191 Form Change password User ..................................................... 266 Gambar 4.192 Prose Change password User ..................................................... 266 Gambar 4.193 Proses Change Passowrd User Berhasil ...................................... 267 Gambar 4.194 Proses Change password Gagal .................................................. 267 Gambar 4.195 Link Logout User......................................................................... 268 Gambar 4.196 Hasil Pembelajaran dengan Asosiasi WEKA.............................. 271 Gambar 4.197 Hasil Promosi untuk User Jakobus ............................................. 271 Gambar 4.198 Hasil Promosi untuk User Erni Herlina ...................................... 272 Gambar 4.199 Hasil Promosi untuk User Andrian ............................................. 272 xx


DAFTAR TABEL Tabel 2.1 Data Set Playtennis (Ian, Frank, & Mark, 2011) .................................... 8 Tabel 2.2 Perhitungan Akurasi (Ian, Frank, & Mark, 2011) ................................. 11 Tabel 3.1 Kamus Data Login ................................................................................ 83 Tabel 3.2 Kamus Data Logout .............................................................................. 83 Tabel 3.3 Kamus Data Change Password............................................................. 84 Tabel 3.4 Kamus Data SMS .................................................................................. 84 Tabel 3.5 Kamus Data History SMS ..................................................................... 84 Tabel 3.6 Data Log SMS ....................................................................................... 85 Tabel 3.7 Kamus Data Order (C).......................................................................... 85 Tabel 3.8 Kamus Data Order ................................................................................ 86 Tabel 3.9 Kamus Data Order (R).......................................................................... 86 Tabel 3.10 Kamus Data Order (D) ....................................................................... 87 Tabel 3.11 Kamus Data Order (S) ........................................................................ 87 Tabel 3.12 Kamus Data Promosi (C) .................................................................... 87 Tabel 3.13 Kamus Data Promosi .......................................................................... 88 Tabel 3.14 Kamus Data Promosi (R) .................................................................... 88 Tabel 3.15 Kamus Data Promosi (D) .................................................................... 88 Tabel 3.16 Kamus Data Promosi (S)..................................................................... 89 Tabel 3.17 Kamus Data User (C).......................................................................... 89 Tabel 3.18 Kamus Data User ................................................................................ 91 Tabel 3.19 Kamus Data User (U) ......................................................................... 92 Tabel 3.20 Kamus Data User (R).......................................................................... 94 Tabel 3.21 Kamus Data User (D) ......................................................................... 94 Tabel 3.22 Kamus Data User (S) .......................................................................... 95 Tabel 3.23 Kamus Data Kategori (C) ................................................................... 95 Tabel 3.24 Kamus Data Kategori .......................................................................... 95 Tabel 3.25 Kamus Data Kategori (U) ................................................................... 96 Tabel 3.26 Kamus Data Kategori (R) ................................................................... 96 Tabel 3.27 Kamus Data Kategori (D) ................................................................... 97 Tabel 3.28 Kamus Data Kategori (S) .................................................................... 97 xxi


Tabel 3.29 Kamus Data Barang (C) ...................................................................... 97 Tabel 3.30 Kamus Data Barang ............................................................................ 98 Tabel 3.31 Kamus Data Barang (U) ...................................................................... 98 Tabel 3.32 Kamus Data Barang (R) ...................................................................... 99 Tabel 3.33 Kamus Data Barang (D) ...................................................................... 99 Tabel 3.34 Kamus Data Barang (S) ...................................................................... 99 Tabel 3.35 Kamus Data Pemesanan (C) ............................................................. 100 Tabel 3.36 Kamus Data Pemesanan .................................................................... 100 Tabel 3.37 Kamus Data Pemesanan (U) ............................................................. 101 Tabel 3.38 Kamus Data Pemesanan (R) ............................................................. 102 Tabel 3.39 Kamus Data Pemesanan (D) ............................................................. 102 Tabel 3.40 Kamus Data Pemesanan (S) .............................................................. 102 Tabel 3.41 Kamus Data Pemesanan Detail (C) ................................................... 102 Tabel 3.42 Kamus Data Pemesanan Detail ......................................................... 103 Tabel 3.43 Kamus Data Pemesanan Detail (U) .................................................. 104 Tabel 3.44 Kamus Data Pemesanan Detail (R) ................................................... 104 Tabel 3.45 Kamus Data Pemesanan Detail (D) .................................................. 105 Tabel 3.46 Kamus Data Pemesanan Detail (S) ................................................... 105 Tabel 3.47 Kamus Data Pembelajaran ................................................................ 105 Tabel 3.48 Kamus Data Mentah Pembelajaran ................................................... 105 Tabel 3.49 Kamus Data Awal Pembelajaran ...................................................... 106 Tabel 3.50 Kamus Data Hasil Pembelajaran....................................................... 107 Tabel 3.51 Kamus Data Hasil Pembelajaran Utama ........................................... 108 Tabel 3.52 Kamus Data Hasil Pembelajaran Dependent .................................... 108 Tabel 3.53 Kamus Data Hasil Pembelajaran Independent .................................. 109 Tabel 3.54 Kamus Data Reporting ...................................................................... 109 Tabel 3.55 Kamus Data Mentah Reporting......................................................... 109 Tabel 3.56 Kamus Data Awal Reporting ............................................................ 110 Tabel 3.57 Kamus Data Lihat Hasil Pembelajaran ............................................. 111 Tabel 3.58 Kamus Data SMS Order ................................................................... 111 Tabel 3.59 PSPEC Proses Login ......................................................................... 112 Tabel 3.60 PSPEC Proses Logout ....................................................................... 112 xxii


Tabel 3.61 PSPEC Proses Change Password ..................................................... 112 Tabel 3.62 PSPEC Proses Awal Order (C,R,S) .................................................. 112 Tabel 3.63 PSPEC Proses Awal Order (D) ........................................................ 113 Tabel 3.64 PSPEC Create Order ........................................................................ 113 Tabel 3.65 PSPEC Read Order ........................................................................... 113 Tabel 3.66 PSPEC Search Order ........................................................................ 114 Tabel 3.67 PSPEC Delete Order......................................................................... 114 Tabel 3.68 PSPEC Proses Akhir Order .............................................................. 114 Tabel 3.69 PSPEC Proses Awal Promosi (C,D,S) .............................................. 115 Tabel 3.70 PSPEC Proses Awal Promosi (R) ..................................................... 115 Tabel 3.71 PSPEC Create Promosi..................................................................... 115 Tabel 3.72 PSPEC Delete Promosi ..................................................................... 116 Tabel 3.73 PSPEC Search Promosi .................................................................... 116 Tabel 3.74 PSPEC Read Promosi ....................................................................... 116 Tabel 3.75 PSPEC Proses Akhir Promosi ........................................................... 117 Tabel 3.76 PSPEC Proses Awal User ................................................................. 117 Tabel 3.77 PSPEC Create User .......................................................................... 117 Tabel 3.78 PSPEC Read Promosi ....................................................................... 118 Tabel 3.79 PSPEC Update User ......................................................................... 118 Tabel 3.80 PSPEC Delete User........................................................................... 118 Tabel 3.81 PSPEC Search User .......................................................................... 119 Tabel 3.82 PSPEC Proses Akhir User ................................................................ 119 Tabel 3.83 PSPEC Proses Awal Kategori ........................................................... 119 Tabel 3.84 PSPEC Create Kategori .................................................................... 120 Tabel 3.85 PSPEC Read Kategori....................................................................... 120 Tabel 3.86 PSPEC Update Kategori ................................................................... 120 Tabel 3.87 PSPEC Delete Kategori .................................................................... 121 Tabel 3.88 PSPEC Search Kategori .................................................................... 121 Tabel 3.89 PSPEC Proses Akhir Kategori .......................................................... 121 Tabel 3.90 PSPEC Proses Awal Barang ............................................................. 122 Tabel 3.91 PSPEC Create Barang ...................................................................... 122 Tabel 3.92 PSPEC Read Barang ......................................................................... 122 xxiii


Tabel 3.93 PSPEC Update Barang...................................................................... 123 Tabel 3.94 PSPEC Delete Barang ....................................................................... 123 Tabel 3.95 PSPEC Search Barang ...................................................................... 123 Tabel 3.96 PSPEC Proses Akhir Barang............................................................. 124 Tabel 3.97 PSPEC Proses Awal Pemesanan ....................................................... 124 Tabel 3.98 PSPEC Create Pemesanan ................................................................ 124 Tabel 3.99 PSPEC Read Pemesanan................................................................... 125 Tabel 3.100 PSPEC Update Pemesanan ............................................................. 125 Tabel 3.101 PSPEC Delete Pemesanan .............................................................. 125 Tabel 3.102 PSPEC Search Pemesanan .............................................................. 126 Tabel 3.103 PSPEC Proses Akhir Pemesanan .................................................... 126 Tabel 3.104 PSPEC Proses Awal Pemesanan Detail .......................................... 126 Tabel 3.105 PSPEC Create Pemesanan Detail ................................................... 127 Tabel 3.106 PSPEC Read Pemesanan Detail ...................................................... 127 Tabel 3.107 PSPEC Update Pemesanan Detail .................................................. 127 Tabel 3.108 PSPEC Delete Pemesanan Detail.................................................... 128 Tabel 3.109 PSPEC Search Pemesanan Detail ................................................... 128 Tabel 3.110 PSPEC Proses Akhir Pemesanan Detail ......................................... 129 Tabel 3.111 PSPEC Proses Pengambilan Data ................................................... 129 Tabel 3.112 PSPEC Proses Pembelajaran........................................................... 129 Tabel 3.113 PSPEC Proses Penyimpanan Data .................................................. 130 Tabel 3.114 PSPEC Proses Awal Data Reporting .............................................. 130 Tabel 3.115 PSPEC Proses Olah Data Reporting ............................................... 130 Tabel 3.116 PSPEC Proses SMS ........................................................................ 131 Tabel 3.117 PSPEC Proses History SMS ........................................................... 131 Tabel 3.118 PSPEC Order SMS ......................................................................... 131 Tabel 3.119 PSPEC Proses Hasil Pembelajaran ................................................. 132 Tabel 4.1 Source Code Promosi .......................................................................... 158 Tabel 4.2 Source Code Ajax untuk Promosi ....................................................... 161 Tabel 4.3 Source Code Jsp_pembelajaran.php ................................................... 163 Tabel 4.4 Source Code Index.jsp ........................................................................ 163 Tabel 4.5 Source Code Insert Pembelajaran ....................................................... 165 xxiv


Tabel 4.6 Source Code Jsp_Pembelajaran.php ................................................... 169 Tabel 4.7 Source Code Weka_controller.jsp....................................................... 170 Tabel 4.8 Source Code Pengambilan Data Pembelajaran ................................... 171 Tabel 4.9 Source Code untuk Redirect ke Halaman PHP ................................... 172 Tabel 5.1 Tabel Pengujian Login ........................................................................ 273 Tabel 5.2 Tabel Pengujian Logout ...................................................................... 274 Tabel 5.3 Tabel Pengujian Change password ..................................................... 274 Tabel 5.4 Tabel Pengujian Insert User ............................................................... 275 Tabel 5.5 Tabel Pengujian Update User ............................................................. 281 Tabel 5.6 Tabel Pengujian Delete User .............................................................. 287 Tabel 5.7 Tabel Pengujian Search User.............................................................. 288 Tabel 5.8 Tabel Pengujian Page per view User .................................................. 289 Tabel 5.9 Tabel Pengujian Insert Kategori ......................................................... 290 Tabel 5.10 Tabel Pengujian Update Kategori ..................................................... 291 Tabel 5.11 Tabel Pengujian Delete Kategori ...................................................... 292 Tabel 5.12 Tabel Pengujian Search Kategori ..................................................... 292 Tabel 5.13 Tabel Pengujian Page per view Kategori .......................................... 294 Tabel 5.14 Tabel Pengujian Insert Barang.......................................................... 295 Tabel 5.15 Tabel Pengujian Update Barang ....................................................... 295 Tabel 5.16 Tabel Pengujian Delete Barang......................................................... 296 Tabel 5.17 Tabel Pengujian Search Barang ........................................................ 297 Tabel 5.18 Tabel Pengujian Page per view Barang ............................................ 298 Tabel 5.19 Tabel Pengujian Insert Order ........................................................... 299 Tabel 5.20 Tabel Pengujian View Detail Order ................................................. 301 Tabel 5.21 Tabel Pengujian Delete Order .......................................................... 301 Tabel 5.22 Tabel Pengujian Search Order.......................................................... 302 Tabel 5.23 Tabel Pengujian Page per view Order .............................................. 303 Tabel 5.24Tabel Pengujian Insert Pemesanan .................................................... 304 Tabel 5.25 Tabel Pengujian Update Pemesanan ................................................. 305 Tabel 5.26 Tabel Pengujian Delete Pemesanan .................................................. 305 Tabel 5.27 Tabel Pengujian Search Pemesanan ................................................. 306 Tabel 5.28 Tabel Pengujian Page per view Pemesanan...................................... 308 xxv


Tabel 5.29 Tabel Pengujian Insert Pemesanan Detail ........................................ 308 Tabel 5.30 Tabel Pengujian Update Pemesanan Detail ...................................... 309 Tabel 5.31 Tabel Pengujian Delete Pemesanan Detail ....................................... 309 Tabel 5.32 Tabel Pengujian Search Pemesanan Detail ....................................... 310 Tabel 5.33 Tabel Pengujian Page per view Pemesanan Detail ........................... 311 Tabel 5.34 Tabel Pengujian Insert Pembelajaran ............................................... 312 Tabel 5.35 Tabel Pengujian Download Pembelajaran ........................................ 313 Tabel 5.36 Tabel Pengujian Page per view Pembelajaran .................................. 314 Tabel 5.37 Tabel Pengujian Insert Promosi ........................................................ 314 Tabel 5.38 Tabel Pengujian Delete Promosi ....................................................... 315 Tabel 5.39 Tabel Pengujian Search Promosi ...................................................... 316 Tabel 5.40 Tabel Pengujian Page per view Promosi .......................................... 318 Tabel 5.41 Tabel Pengujian Reporting................................................................ 318 Tabel 5.42 Tabel Pengujian SMS........................................................................ 319 Tabel 5.43 Tabel Pengujian History Search SMS ............................................... 319 Tabel 5.44 Tabel Pengujian Page per view History SMS ................................... 321 Tabel 5.45 Tabel Hasil Pembelajaran ................................................................. 322

xxvi


DAFTAR SIMBOL KAMUS DATA

Simbol

Arti

=

Terdiri atas

+

Dan

()

Opsional

[]

Memilih salah satu alternative

**

Komentar

@

Identifikasi atribut kunci

|

Pemisah alternative simbol

xxvii


DAFTAR SIMBOL ENTITY RELATIONSHIP MANAGEMENT

Simbol Entitas / entity

Arti Entitas merupakan data inti yang akan disimpan; bakal table pada basis data.

Atribut

Field atau kolom data yang butuh disimpan dalam suatu entitas

Atribut kunci primer

Field atau kolom data yang butuh disimpan dalam suatu entitas dan digunakan sebagai kunci akses record yang diinginkan; biasanya berupa id

Atribut multinilai/multivalue

Field atau kolom data yang butuh disimpan dalam suatu entitas yang dapat memiliki nilai lebih dari satu.

Relasi

Relasi

yang

menghubungkan

antarentitas; biasanya diawali dengan kata kerja

Asosiasi / association

Pendukung antara relasi dan entitas dimana dikedua ujungnya memiliki multiplicity

kemungkinan

jumlah

pemakai

xxviii


ABSTRAK. Kata kunci: data mining, customer relationship management, association rules, promosi, WEKA. vii. Universitas Kristen Maranatha

Recommend Documents