PRIMARY QUERY ANALYSIS ON SQL DATABASE RESTRUCTURING IN GEOGRAPHIC INFORMATION SYSTEMS

Ridwan Ilyas, Wina Witanti, Fildzah Syarafina

Abstract


Database restructuring is a crucial process aimed at enhancing data management and access efficiency by modifying the existing data structure. This research focuses on improving a Geographic Information System (GIS) for taxation by migrating and restructuring an inefficient and redundant database. The study conducts a comparative performance evaluation of the old and restructured databases using benchmarking tests with varying numbers of threads and ramp-ups. The results reveal a significant increase in average throughput (24.60%) following the restructuring, indicating a substantial improvement in the database's data processing capacity. However, there is also an average increase in response time (21.65%), suggesting a trade-off between enhanced throughput and slower response times. This increase in response time indicates that while the system can handle more data, it requires more time to process each query. Overall, the restructured database demonstrates enhanced performance and efficiency, though further optimization is necessary to achieve consistent throughput across different workloads and to mitigate the increased response times

Full Text:

PDF

References


G. O. Arocena and A. O. Mendelzon, “Restructuring documents, databases, and webs,” Theory Pract. Object Syst., vol. 5, no. 3, pp. 127–141, 1999, doi: 10.1002/(SICI)1096-9942(1999)5:3<127::AID-TAPO2>3.0.CO;2-X.

G. Wiro Sasmito, “Penerapan Metode Waterfall Pada Desain Sistem Informasi Geografis Industri Kabupaten Tegal,” J. Inform. J. Pengemb. IT, vol. 2, no. 1, pp. 6–12, 2017, doi: 10.30591/jpit.v2i1.435.

D. P. S. M. A. Yosi Yulia, Ronni Andri Wijaya, “Pengaruh Pengetahuan Perpajakan, Kesadaran Wajib Pajak, Tingkat Pendidikan Dan Sosialisasi Perpajakan Terhadap Kepatuhan Wajib Pajak Pada Umkm Dikota Padang,” Sist. Inf., vol. 1, no. September, pp. 60–69, 2018, doi: 10.31933/JEMSI.

A. Singh et al., “Designing Geographic Information System Based Property Tax Assessment in India,” Smart Cities, vol. 5, no. 1, pp. 364–381, 2022, doi: 10.3390/smartcities5010021.

E. Domínguez, J. Lloret, Á. L. Rubio, and M. A. Zapata, “When and how to restructure a view-based relational database (extended version),” CEUR Workshop Proc., vol. 639, no. September, pp. 137–150, 2010, doi: 10.1007/978-3-642-15576-5.

I. Y. Andhica and D. Irwan, “Performa Kinerja Web Server Berbasis Ubuntu Linux Dan Turnkey Linux,” PIKSEL Penelit. Ilmu Komput. Sist. Embed. Log., vol. 5, no. 2, pp. 68–78, 2018, doi: 10.33558/piksel.v5i2.269.

Z. X. and X. W. and Y.-C. Tu, “Power-Aware Throughput Control for Database Management Systems,” Icac, pp. 315–324, 2013, [Online]. Available: https://www.usenix.org/conference/icac13/technical-sessions/presentation/xu_zichen

I. Gorton, J. Klein, and A. Nurgaliev, “Architecture Knowledge for Evaluating Scalable Databases,” Proc. - 12th Work. IEEE/IFIP Conf. Softw. Archit. WICSA 2015, pp. 95–104, 2015, doi: 10.1109/WICSA.2015.26.

Q. Wu and Y. Wang, “Performance testing and optimization of J2EE-based web applications,” 2nd Int. Work. Educ. Technol. Comput. Sci. ETCS 2010, vol. 2, pp. 681–683, 2010, doi: 10.1109/ETCS.2010.583.

M. Mardiana, “Implementasi User Satisfaction Model Dalam Mengukur Kualitas Website,” MATRIK J. Manajemen, Tek. Inform. dan Rekayasa Komput., vol. 19, no. 2, pp. 266–272, 2020, doi: 10.30812/matrik.v19i2.711.

O. M. I. Tavares, S. M. Rangkoly, S. B. Desy Bawan, E. Utami, and M. S. Mustafa, “Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2.27 dan NoSQL MongoDB,” J. Teknol. Inf., vol. 4, no. 2, pp. 303–313, 2020, doi: 10.36294/jurti.v4i2.1695.

Apache, “Apache JMeter - Apache JMeterTM,” 2014. https://jmeter.apache.org/#:~:text=Apache JMeter may be used,performance under different load types.

J. Wang and J. Wu, “Research on performance automation testing technology based on JMeter,” Proc. - 2019 Int. Conf. Robot. Intell. Syst. ICRIS 2019, pp. 55–58, 2019, doi: 10.1109/ICRIS.2019.00023.

Apache Software Foundation, “Apache JMeter Glossary.” https://jmeter.apache.org/usermanual/glossary.html#:~:text=Throughput is calculated as requests,) %2F (total time).

K. D. Kang, J. Oh, and S. H. Son, “Chronos: Feedback control of a real database system performance,” Proc. - Real-Time Syst. Symp., no. January 2008, pp. 267–276, 2007, doi: 10.1109/RTSS.2007.16.

H. W. Maalouf and M. K. Gurcan, “Minimisation of the update response time in a distributed database system,” Perform. Eval., vol. 50, no. 4, pp. 245–266, 2002, doi: 10.1016/S0166-5316(02)00085-8.

S. Sen, A. Dutta, A. Cortesi, and N. Chaki, “A new scale for attribute dependency in large database systems,” Lect. Notes Comput. Sci. (including Subser. Lect. Notes Artif. Intell. Lect. Notes Bioinformatics), vol. 7564 LNCS, pp. 266–277, 2012, doi: 10.1007/978-3-642-33260-9_23.

M. V. Mannino, P. Chu, and T. Sager, “Statistical Profile Estimation in Database Systems,” ACM Comput. Surv., vol. 20, no. 3, pp. 191–221, 1988, doi: 10.1145/62061.62063.

O. W. Purbo, Sriyanto, Suhendro, R. A. Aziz, and R. Herwanto, “Benchmark and comparison between hyperledger and MySQL,” Telkomnika (Telecommunication Comput. Electron. Control., vol. 18, no. 2, pp. 705–715, 2020, doi: 10.12928/TELKOMNIKA.v18i2.13743.

N. Khamphakdee, N. Benjamas, and S. Saiyod, “Performance Evaluation of Big Data Technology on Designing Big Network Traffic Data Analysis System,” Proc. - 2016 Jt. 8th Int. Conf. Soft Comput. Intell. Syst. 2016 17th Int. Symp. Adv. Intell. Syst. SCIS-ISIS 2016, no. November 2017, pp. 454–459, 2016, doi: 10.1109/SCIS-ISIS.2016.0103.

J. L. Lo, L. A. Barroso, S. J. Eggers, K. Gharachorloo, H. M. Levy, and S. S. Parekh, “Analysis of database workload performance on simultaneous multithreaded processors,” Conf. Proc. - Annu. Int. Symp. Comput. Archit. ISCA, pp. 39–50, 1998, doi: 10.1145/279361.279367.




DOI: https://doi.org/10.33387/jiko.v7i2.8565

Refbacks

  • There are currently no refbacks.