Page 7 - E-Modul Sistem Basis Data
P. 7

6.3.2 Indeks Sekunder (Secondary Index)............................................... 121

                               6.3.3 Struktur Penyimpanan (Storage Structure) .................................... 123

                        BAB 7. Bahasa Query ....................................................................................... 128

                            7.1  Bahasa Query Formal ........................................................................... 128


                               7.1.1 Operasi Seleksi (Select) ................................................................. 129

                               7.1.2 Operasi Projeksi (Project) .............................................................. 130

                               7.1.3 Operasi Cartesian Product ............................................................. 131

                               7.1.4 Operasi Union ................................................................................ 134

                               7.1.5 Operasi Set-Diference .................................................................... 135


                               7.1.6 Operasi Rename ............................................................................. 136

                            7.2  Bahasa Query Terapan ......................................................................... 140

                               7.2.1 Struktur Dasar ................................................................................ 142

                               7.2.2 Nilai Null ........................................................................................ 143

                               7.2.3 Manipulasi Data ............................................................................. 144


                               7.2.4 Data Definition Language .............................................................. 144

                        BAB 8. Pemrosesan Query ............................................................................... 147

                            8.1  Klasifikasi Aktivitas ............................................................................. 147

                               8.1.1 Estimasi (Perkiraan) Biaya Query .................................................. 148

                               8.1.1 Pengukuran Biaya Query ............................................................... 149


                            8.1  Operasi Seleksi ..................................................................................... 150

                               8.2.1 Algoritma Dasar ............................................................................. 150

                               8.2.2 Seleksi dengan Indeks .................................................................... 152

                               8.2.3 Seleksi dengan Pembandingan (Ketidaksamaan) .......................... 154


                            8.3  Operasi Join .......................................................................................... 156

                               8.3.1 Estimasi Ukuran Join ..................................................................... 157

                            8.4  Operasi Lain ......................................................................................... 159




                                                              vii
   2   3   4   5   6   7   8   9   10   11   12