Pages

Tuesday, July 31, 2018

JURNAL : OPTIMASI QUERY MENGGUNAKAN ALGORITMA INGRES PADA PORTAL LUMBUNG DATA PENDIDIKAN JAWA TENGAH

Abstrak

Portal web Lumbung Data Pendidikan Jawa Tengah memiliki jumlah data record yang besar yaitu 46.442.378 record, dan terdapat tabel sebanyak 31, untuk mendapatkan informasi yang diinginkan diperlukan relasi tabel yang banyak sehingga diperlukan waktu lebih lama dalam memproses query, dikarenakan tidak menggunakan metode khusus dalam melakukan query atau hanya menggunakan teknik query konvensional hasilnya waktu yang dibutuhkan untuk memproses query menjadi relatif lambat. Tujuan penelitian ini untuk mengoptimalkan query menggunakan algoritma INGRES yang nantinya akan diuji dan dibandingkan hasilnya dengan query konvensional untuk mengetahui sejauh mana pemrosesan query dapat dipercepat. Hasil eksperimen yang dilakukan menunjukkan bahwa algoritma INGRES dapat mempercepat proses eksekusi akan tetapi masih memiliki kekurangan, pada pemrosesan awal penggunaan algoritma INGRES justru mengakibatkan penurunan kecepatan hingga 122%, akan tetapi pada proses berikutnya dapat menaikkan kecepatan hingga 60%. Hal ini dikarenakan pada pemrosesan query dengan menerapkan algoritma INGRES diperlukan pemecahan query dan pengeksekusian secara berurutan yang hasilnya ditampung ke dalam temporary tabel terlebih dahulu, hingga didapatkan query akhir yang paling optimal.

Kata kunci : Optimasi Query, INGRES, Optimasi Query Basis Data Tersentralisasi

Download klik di sini. #semuanyaajib

24 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Excellent blog thanks for shairng It’s very important to have the best beauty parlour equipment to run a successful salon. Pixies Beauty Shop is the best place in Chennai to get high quality imported top brands at the best price.
    Cosmetics Shop in Chennai

    ReplyDelete

  4. Thanks of sharing this post…Python is the fastest growing language that helps to get your dream job in a developing area. It says every fundamental in a programming, so if you want to become an expertise in python get some training






    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery






    ReplyDelete
  5. Thanks for sharing the view from which i gather knowledge about the related topic. Your way of writing is easy to understand and expecting your next post

    Java Training in Chennai

    Java Course in Chennai

    ReplyDelete
  6. Interested in playing online casino Or want to know new online casino promotions lighterandlocal Online casino reviews Answer every casino you want to kno ecommerce marketing

    ReplyDelete
  7. You added such an extraordinary piece to recover, giving totally part of portion of circumstance edification for us to benefit assessment. gratitude for sharing such recommend when us due to which my few standards were cleared. X Force Keygen Software Free Download

    ReplyDelete
  8. I could following to appreciation for the undertakings you have made recorded as a printed copy this leaflet. I'm trusting the thesame fine take diversion doings from you inside the thinking of as capably. thankful to you...
    Bitdefender Total Security Crack

    ReplyDelete

  9. So, it happens to be your boyfriend’s birth anniversary? A line or two of birthday wishes wouldn’t be enough nor befitting for his status, you also think.Birthday Card Messages For Him

    ReplyDelete

Popular Posts