Tuesday, July 31, 2018



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


  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

  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

  3. This comment has been removed by the author.

  4. This comment has been removed by the author.

  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

  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

  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

  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

  9. You have provided a nice article, Thank you very much for this one. And I hope this will be useful for many people. And I am waiting for your next post keep on updating these kinds of knowledgeable things
    Android Training in Chennai
    Android Course in Chennai
    Android Training in Bangalore
    Android Course in Bangalore
    Android Training in Coimbatore
    Android Course in Coimbatore
    Android Training in Madurai

  10. Great Article. Thank you for sharing! Really an awesome post for every one.
    Digital Marketing Course In Kolkata
    Web Design Course In Kolkata


  11. 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

  12. Good Post! it was so good to read and useful to improve my knowledge as an updated one, keep blogging. After seeing your article I want to say that also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts like this.
    AngularJS Training in Pune

  13. Thanks for sharing information to our knowledge, it helps me plenty keep sharing…

    Python Training In Pune
    python training institute in pune


Popular Posts



My Calendar