Abstract
Database is a collection of data that forming an information that useful for managers in an organization to facilitate data management process to become more effective and safely guarantee. A good database has fast and accurate response time performance in data execution processing. To manage the database, it requires a special language or query known as Structure Query Language (SQL). Increase need for fast information, will need a proper SQL as well. Therefore, through this research, a test analysis will be used to optimize the query response time in database management system commonly used today, namely the My Structured Query Language (MySQL) using PHP version of 7.2.27 relational database which will be tested on the Oebufu Village Aspiration and Information Service System (SELMA) that acessed from localhost panels with a total of 1000 test data records. The test is devoted to the effectiveness of using SELECT queries in calling and displaying data through restructuring the use of clauses. This study aims to help improve data management by providing the results of the comparative analysis of response times between the general query model and the optimized query results in order to determine the correct and efficient query structure. The result is proven by doing query optimization, it is found that the presentation of time optimization is significant, which is 78% much faster than the initial query, through this test it can be concluded that optimization plays an important role in streamlining the response time of database queries.
Highlights
Saat ini penggunaan teknologi basis data sangat berperan penting dalam memudahkan proses pengelolaan data dengan beragam jumlah dan kebutuhan dari pengelolanya
This study aims to help improve data management by providing the results of the comparative analysis of response times between the general query model and the optimized query results in order to determine the correct and efficient query structure
Adapun untuk eksekusi klausa NOT IN berdasarkan pengujian yang dilakukan tidak begitu optimal dan efisien karena bekerja dengan membaca seluruh data yang ada dalam tabel-tabel sebelumnya
Summary
Saat ini penggunaan teknologi basis data sangat berperan penting dalam memudahkan proses pengelolaan data dengan beragam jumlah dan kebutuhan dari pengelolanya. Proses optimalisasi kueri ini akan dilakukan dengan melihat model struktur kueri yang paling sesuai dan optimal dilihat dari kecepatan waktu eksekusi data yang dihasilkan menggunakan klausa-klausa yang akan diujikan pada fungsi SELECT tersebut. Selain itu pada penelitian ini optimasi akan dilakukan untuk model manajemen basis data MySQL dengan mengujikan hasil restrukturisasi kueri menggunakan 8 model klausa pendukung fungsi SELECT dengan susunan yang beragam dan berbeda dengan penelitian-penelitian sebelumnya agar dapat diperoleh hasil yang jauh lebih tepat dan akurat dengan menambahkan lebih banyak bentuk pengujian tentunya akan memberikan kebaharuan yang bernilai dalam penelitian terkait optimasi kueri basis data
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
