Optimalisasi Query Dalam Basis Data My Sql Menggunakan Index

Authors

  • Ridho Pamungkas Universitas PGRI Madiun

DOI:

https://doi.org/10.25273/research.v1i1.2453

Abstract

Kualitas sebuah sistem informasi sangat terpengaruhi oleh kualitas desain basis data. Terkadang seorang programmer melupakan optimalisasi sebuah query di MySQL, padahal jika suatu sistem yang telah berjalan opltimalisasi sangatlah penting ketika jumlah data menjadi besar. Di dalam MySQL menyediakan fungsi index pada table dan mempercepat proses pencarian dalam suatu basis data.Index pada intinya akan berguna apabila digunakan sesuai dengan kepentingan dan kebutuhan karena apabila tidak, index yang dibuat secara sembarangan dan banyak akan membuat lambatnya akses ke database. Sehingga harus diperhatikan lagi aturan – aturan dan analisis yang baik sebelum membuat index pada database

Downloads

Download data is not yet available.

References

Raharjo, Suwanto, "Integrity Constraint Basis Data RelasionalDengan Menggunakan pl/pgsqlDan Check Constraint" in Seminar Nasional Teknik dan Manajemen Industri, Malang, 2015, pp. IV-22 - IV 27.

Bambang Hariyanto, Rekayasa Sistem Berorientasi Objek. Bandung: Informatika, Bandung, 2004.

Z.A. Hasibuan, Metodologi Penelitian pada Bidang Ilmu Komputer dan Teknologi Informasi. Jakarta, Infonesia: Fakultas Ilmu Komputer, Universitas Indonesia, 2007.

B.Rassameethes, "Analysis and Integrastion of Thailand ICT Master Plan," International Journal of Synergy and Research, p. 77, 2012.

Firdayanti Restika, "Persepsi Resiko Melakukan E-Commerce dengan Kepercayaan Konsumen dalam Membeli Produk Fashion Online," Journal of Social and Industrial Psychology, vol. I, no. 1, pp. 1-7, 2012.

Robinson Pearce, Manajemen Strategis, Formulasi Implementasi dan Pengendalian. Jakarta: Salemba Empat, 2008.

Downloads

Published

2018-04-13

How to Cite

Pamungkas, R. (2018). Optimalisasi Query Dalam Basis Data My Sql Menggunakan Index. RESEARCH : Journal of Computer, Information System & Technology Management, 1(1), 27–31. https://doi.org/10.25273/research.v1i1.2453

Issue

Vol. 1 No. 1 (2018)

Section

Articles

License

Authors who publish with this journal agree to the following terms:

Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
Crossref
Scopus
Google Scholar
Europe PMC