Page 8 - E-Modul Sistem Basis Data
P. 8
8.4.1 Penghilangan Duplikasi Baris Data ............................................... 159
8.4.2 Operasi Projeksi ............................................................................. 160
8.5 Struktur Sistem Basis Data ................................................................... 160
8.6 Struktur DBMS untuk Pemrosesan Query ........................................... 161
BAB 9. Pengamanan Basis Data ...................................................................... 163
9.1 Pengamanan Basis Data (Database Security) ...................................... 163
9.1.1 Pemberian Otoritas ......................................................................... 166
9.1.2 Perintah SQL untuk Pengamanan Basis Data ................................ 168
9.1.3 Penyandian (Enkripsi) .................................................................... 168
9.1 Pemeliharaan Integritas Basis Data (Database Integrity) .................... 170
9.2.1 Jenis-jenis Integritas Basis Data..................................................... 170
BAB 10. Basis Data Terdistribusi .................................................................... 172
10.1 Struktur Basis Data Terdistribusi ......................................................... 172
10.1.1 Keuntungan dan Kerugian Basis Data Terdistribusi .................... 173
10.1.2 Desain Basis Data Terdistribusi ................................................... 175
10.2 Pemrosesan Query dalam Sistem Terdistribusi .................................... 175
10.2.1 Transformasi Query ..................................................................... 176
10.2.2 Operasi Join Sederhana ................................................................ 178
10.3 Recovery dalam Sistem Terdistribusi ................................................... 180
10.3.1 Keandaalan Sistem ....................................................................... 182
10.3.2 Commit Protocol .......................................................................... 184
10.3.3 Penanganan Kerusakan/Kegagalan .............................................. 186
viii