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

50 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. 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
  7. 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
  8. 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

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

    ReplyDelete

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

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

    Python Training In Pune
    python training institute in pune

    ReplyDelete
  13. Excellent blog thanks for sharing the valuable information..it becomes easy to read and easily understand the information.
    Useful article which was very helpful. also interesting and contains good information.
    to know about python training course , use the below link.

    Python Training in chennai

    Python Course in chennai




    ReplyDelete
  14. 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
  15. 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
  16. Great web site. A lot of useful information here. I’m sending it to several friends ans also sharing in delicious. And obviously, thanks in your effort! 야설
    Feel free to visit my blog :
    야설

    ReplyDelete
  17. Very good information. Lucky me I recently found your website by accident I have book marked it for later!
    일본야동
    Feel free to visit my blog : 일본야동

    ReplyDelete
  18. This blog is very informative the stuff you provide I really enjoyed reading 국산야동
    Feel free to visit my blog : 국산야동

    ReplyDelete
  19. 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
  20. 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

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

 

Translate

My Calendar