Performance Tuning Oracle 11g Database Melalui Inisial Paramater, Structure Database dan SQL Tuning. Studi Pada ERP SISFORBUN Dana Pensiun Perkebunan (DAPENBUN)
Abstract
Keywords
Full Text:
PDFReferences
A. Bachhav, V. Kharat, and M. Shelar, “Query Optimization for Databases in Cloud Environment: A Survey,” International Journal of Database Theory and Application, vol. 10, no. 6, pp. 1–12, Jun. 2017, doi: 10.14257/ijdta.2017.10.6.01.
R. Elmasri and S. B. Navathe, “Database Systems SEVENTH EDITION,” 2016.
A. Abbas and K. Ahmad, “Query Performance in Database Operations.”
www.dapenbun.co.id, “AR 2021,” pp. 66–74, 2021, Accessed: Nov. 03, 2022. [Online]. Available: https://dapenbun.co.id/laporan-tahunan
F. Almeida, P. Silva, and F. Araújo, “Performance analysis and optimization techniques for Oracle Relational Databases,” Cybernetics and Information Technologies, vol. 19, no. 2, pp. 117–132, Jun. 2019, doi: 10.2478/cait-2019-0019.
D. Colley and C. Stanier, “Identifying New Directions in Database Performance Tuning,” in Procedia Computer Science, 2017, vol. 121, pp. 260–265. doi: 10.1016/j.procs.2017.11.036.
Y. Virmansyah, R. Yulyanto Suladi, A. Bambang Lesmana, F. Teknologi Informasi, and U. Budi Luhur, “Optimasi Database dengan Metode Index dan Partisi Tabel Database Postgresql pada Aplikasi E-Commerce. Studi pada Aplikasi Tokopintar.”
O. M. I. Tavares, S. M. Rangkoly, S. B. D. Bawan, K. B. Ahmad, E. Utami, and M. S. Mustafa, “ANALYSIS OF QUERY RESTRUCTURIZATION MODELS IN OPTIMIZING DATA EXECUTION RESPONSE TIME ON MYSQL PHP 7.2.27 RELATIONAL DATABASES,” Jurnal Komputer dan Informatika, vol. 9, no. 1, pp. 1–10, Feb. 2021, doi: 10.35508/jicon.v9i1.3598.
S. Indah Nurhafida et al., “Optimasi Query Database Web Scraping Pada Jurnal SINTA,” 2022. [Online]. Available: http://jurnal.mdp.ac.id
J. M. Medina, C. D. Barranco, and O. Pons, “Evaluation of Indexing Strategies for Possibilistic Queries Based on Indexing Techniques Available in Traditional RDBMS,” International Journal of Intelligent Systems, vol. 31, no. 12, pp. 1135–1165, Dec. 2016, doi: 10.1002/int.21820.
G. Guzun and G. Canahuate, “Hybrid query optimization for hard-to-compress bit-vectors,” VLDB Journal, vol. 25, no. 3, pp. 339–354, Jun. 2016, doi: 10.1007/s00778-015-0419-9.
G. Wood, U. Shaft, and J. Beresniewicz, “Performance Fundamentals for Oracle Database 10g and 11g,” 2008.
Q. Li, H. Xu, and G. Yan, “Research on performance optimization and implementation of oracle database,” in 3rd International Symposium on Intelligent Information Technology Application, IITA 2009, 2009, vol. 3, pp. 520–523. doi: 10.1109/IITA.2009.7.
S. C. Yao, “Optimization design scheme of oracle database,” in Applied Mechanics and Materials, 2014, vol. 608–609, pp. 589–592. doi: 10.4028/www.scientific.net/AMM.608-609.589.
L. Yingcheng and L. Ling, “RESEARCH ON SPATIAL DATABASE DESIGN AND TUNING BASED ON ORACLE AND ARCSDE.”
P. L. Bajaj, “A Survey on Query Performance Optimization by Index Recommendation,” 2015.
DOI: https://doi.org/10.33633/tc.v22i2.7831
Article Metrics
Abstract view : 145 timesPDF - 87 times
Refbacks
- There are currently no refbacks.
Diterbitkan Oleh :
Jurnal Techno.Com terindex di :
Jurnal Teknologi Informasi Techno.Com (p-ISSN : 1412-2693, e-ISSN : 2356-2579) diterbitkan oleh LPPM Universitas Dian Nuswantoro Semarang. Jurnal ini di bawah lisensi Creative Commons Attribution 4.0 International License.