Soal!Diketahui data suatu sistem dikelola menggunakan struktur sequential dengan parameter sbb :Jumlah record file (n) = 1000000 recordJumlah field (a) = 8 byteJumlah rata-rata nilai (V) = 25 byteParameter harddiskPutaran disk = 8000 rpmSeek time (s) = 5 msTransfer rate (t) = 2048 byte/sTRW = 2 msParameter penyimpananUkuran block (B) = 4096 byteUkuran pointer block (P) = 8 byteUkuran interblock gap...
Thursday, July 20, 2017
Latihan Soal Organisasi File Sequential
Soal!Parameter harddiskPutaran disk = 8000 rpmSeek time (s) = 5 msTransfer rate (t) = 2048 byte/sTRW = 2 msParameter penyimpananMetode blocking = fixed blockingUkuran block (B) = 4096 byteUkuran pointer block (P) = 8 byteUkuran interblock gap (G) = 1024 byteParameter fileJumlah record file (n) = 100000 recordJumlah field (a) = 8 byteJumlah nilai (V) = 25 byteParameter reorganisasiFile log transaksi...
Latihan Soal File Pile
Soal!Parameter harddiskPutaran disk = 6000 rpmSeek time (s) = 5 msTransfer rate (t) = 2048 byte/sTRW = 2 msParameter penyimpananMetode blocking = variable length spanned blockingUkuran block (B) = 1024 byteUkuran pointer block (P) = 8 byteUkuran interblock gap (G) = 512 byteParameter fileJumlah record difile (n) = 10600 recordJumlah rata-rata atribut (a') = 5 byteJumlah rata-rata field (A) = 7 byteJumlah...
Latihan Soal Penyimpanan Sekunder
Soal! Diketahui :Seek time (s) = 10 msKecepatan putar harddsik = 3000 rpmTransfer rate (t) = 1024 byte/sUkuran blok (B) = 2048 byteUkuran record (R) = 128 byteUkuran gap (G) = 64 byteUkuran pointer (P) = 10Cari r, Bfr, TR, Btt, W dan t'! (Menggunakan metode fixed blocking, spanned blocking dan unspanned blocking!)Jawaban : r = 1/2 * ((60 * 1000)/RPM)r = 1/2 * ((60 * 1000)/3000)r = 10 sBfr Fixed BlockingBfr...
Wednesday, July 19, 2017
Index Sequential File
"Merupakan perpaduan terbaik dari teknik sequential dan random file"Contoh : CDParameter IndeksRasio fan out Y, jumlah indeks di satu blok indeks.y = (B) / (V + P) Keterangan :B = ukuran blokV = ukuran field kunci (atribut/nilainya)P = ukuran field pointerHeight(x), kedalaman indeks (Banyak level indek)x = ylog (n/Bfr) Keterangan :n = jumlah record dalam satu filey = fanoutBfr = blocking factorUkuran...
Organisasi File Sequential
"Sequential adalah proses mengakses data secara berurut." Contoh : Tape.Karakteristik :Atribut data dikategorikanRecord data terurutUkuran Record (R)R = a.V Keterangan :a = jumlah atribut (field) pada satu recordV = panjang rata-rata nilai atribut (byte) Waktu Pengambilan Record Tertentu (TF)Pencarian menggunakan atribut non-kunciBelum ada file logTF = 1/2 waktu pencarian blokTF = 1/2b * (B/t') =...
Tuesday, July 18, 2017
File Pile
Record Size (R)R = a' (A + V + 2) Keterangan :a' = rata-rata jumlah atributA = ukuran rata-rata atributv = ukuran rata-rata nilai2 = nilai separator/konstanta pemisah antar file/recordWaktu Pengambilan Record Tertentu (TF)TF = 1/2n (R / t') Keterangan :n = jumlah recordR = banyak recordt' = bulk transfer timeWaktu Pengambilan Record Berikutnya (TN)TN = TFWaktu Penyisipan Record/Insert Record (TI)TI...