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
   3   4   5   6   7   8   9   10   11   12   13