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

21 comments:

  1. I was recommended this web site by means of my cousin.
    I am now not certain whether this post is written through him as nobody else recognise such precise about my difficulty. You're amazing! Thank you!

    Selenium training in bangalore
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training

    ReplyDelete
  2. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Java Training in Chennai
    Java Training in Coimbatore
    Java Training in Bangalore

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

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

    ReplyDelete
  5. Great blog thanks for sharing Masters of building brands, Adhuntt Media is making waves in the Chennai digital market! Known for their out of their box ideas, if a creative overhaul for your brand is what you need, you’ve come to the right place. Right from Search Engine Optimization-SEO to Social Media Marketing, Adhuntt Media is your pitstop for original brand identity creation from scratch. Let’s boost your sales right now at Adhuntt Media.
    digital marketing company in chennai

    ReplyDelete
  6. Nice blog thanks for sharing Say no to unethical ways for growing plants fast. We at Karuna Nursery Gardens stick to traditional and environment friendly methods of caring and growing therefore enabling us to showcase the largest collection on organic plants in Chennai.
    plant nursery in chennai

    ReplyDelete
  7. 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
  8. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete

Popular Posts

 

Translate

My Calendar