Pengoptimalan Performa Database Pada Proses Transformasi Data Pada SQL Server

Optimizing Database Performance in the Data Transformation Process in SQL Server ​

Authors

  • Desi Setiya Budi Universitas Budi Luhur
  • Hadi Syahrial Universitas Budi Luhur

DOI:

https://doi.org/10.33050/tmj.v8i3.2167

Abstract

A database itself is generally a collection of data stored systematically on a computer that can be processed or manipulated using software (application programs) to produce information. Defining a database includes specifications in the form of data types, data structures and also limitations on the data to be stored. One tool that is often used is SQL Server. Data processing itself takes a lot of time through various stages. During the data processing stage there is something called data transformation and data transfer. Which means data is sent from process A to Process B and changed. In this case, it is not information from data, but what is changed is not the content or value contained in it, but changes it into a form of information that can be easily received and read by readers of the information. In the transformation and transfer process, there were several obstacles experienced. What often happens is a matter of time. Time refers to the speed of the data process itself. Because if each process has a very slow speed it will take a lot of time, even though there are still many other processes that have to run. In this research, the techniques of  Indexing, Temporary Table and a combination of the two were used. In order to get results which one is faster to use. This research uses the True Experiment Design method with a repeated measurement design. In this research there will be several treatments, and carried out in more than one experiment.

References

X. Niu et al., “Provenance-aware query optimization,” in 2017 IEEE 33rd International Conference on Data Engineering (ICDE), IEEE, 2017, pp. 473–484.

I. Indrajani, “Analisis dan Penerapan Metode Tuning pada Basis Data Funding,” ComTech: Computer, Mathematics and Engineering Applications, vol. 6, no. 1, pp. 143–153, 2015.

R. Schiesser, IT Systems Management: IT Systems Management _c2. Pearson Education, 2010.

J. R. Lourenço, B. Cabral, J. Bernardino, and M. Vieira, “Comparing NoSQL databases with a relational database: performance and space,” International Journal of Big Data, vol. 2, no. 1, pp. 1–14, 2015.

S. A. T. Mpinda, L. C. Ferreira, M. X. Ribeiro, and M. T. P. Santos, “Evaluation of graph databases performance through indexing techniques,” International Journal of Artificial Intelligence & Applications (IJAIA), vol. 6, no. 5, pp. 87–98, 2015.

C. Fehily, SQL Database Programming. Questing Vole Press, 2014.

D. M. Ibrahim, R. Primananda, and M. Data, “Perbandingan Performa Database Apache HBase dan Apache Cassandra Sebagai Media Penyimpanan Data Sensor Internet of Things,” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 2, no. 8, pp. 2943–2949, 2018.

S. Perkassa, “IMPLEMENTASI ETL (EXTRACT, TRANSFORM, LOAD) PADA PERANCANGAN SISTEM DATA WAREHOUSE UNIVERSITAS WIDYATAMA,” 2016.

H. Kurniawan and H. HERMANTO, “Otorisasi Pengguna Laboratorium IBI Darmajaya Berbasis Client Server,” Expert, vol. 7, no. 2, p. 346053, 2017.

E. M. Kuszera12, L. M. Peres, and M. D. Del Fabro, “Metamorfose: a data transformation framework based on Apache Spark,” 2018.

C. G. Corlăţan, M. M. Lazăr, V. Luca, and O. T. Petricică, “Query Optimization Techniques in Microsoft SQL Server.,” Database Systems Journal, vol. 5, no. 2, 2014.

D. Setiawan, Buku sakti pemrograman web: html, css, php, mysql & javascript. Anak Hebat Indonesia, 2017.

A. S. Kusumo, Administrasi SQL Server 2014. Elex Media Komputindo, 2016.

Y. Chen, “Research of Data Storage and Querying Methods Based on Ring Distributed Hash,” The Open Automation and Control Systems Journal, vol. 7, no. 1, 2015.

S. H. Situmorang, I. Muda, M. Doli, and F. S. Fadli, Analisis data untuk riset manajemen dan bisnis. USUpress, 2010.

F. Alharbi and O. Smadi, “Database Development for Pavement Performance Modeling,” International Journal of Advanced Engineering, Management and Science, vol. 3, no. 9, p. 239914.

Z. Kedah, “Use of E-Commerce in The World of Business,” Startupreneur Bisnis Digital (SABDA, vol. 2, no. 1, 2023, doi: 10.34306/sabda.v2i1.273.

V. Meilinda, S. A. Anjani, and M. Ridwan, “A Platform Based Business Revolution Activates Indonesia’s Digital Economy,” Startupreneur Business Digital (SABDA Journal), vol. 2, no. 2, pp. 155–174, 2023.

S. Kosasi, U. Rahardja, N. Lutfiani, E. P. Harahap, and S. N. Sari, “Blockchain Technology - Emerging Research Themes Opportunities in Higher Education,” in 2022 International Conference on Science and Technology, ICOSTECH 2022, Institute of Electrical and Electronics Engineers Inc., 2022. doi: 10.1109/ICOSTECH54296.2022.9829053.

U. Rahardja, A. Ngadi, S. Millah, E. P. Harahap, and Q. Aini, “Blockchain Application in Educational Certificates and Verification Compliant with General Data Protection Regulations.”

N. Lutfiani and L. Meria, “Utilization of Big Data in Educational Technology Research,” International Transactions on Education Technology (ITEE), vol. 1, no. 1, pp. 73–83, 2022.

N. Lutfiani, P. A. Sunarya, S. Millah, and S. Aulia Anjani, “Penerapan Gamifikasi Blockchain dalam Pendidikan iLearning,” Technomedia Journal, vol. 7, no. 3, pp. 399–407, Dec. 2022, doi: 10.33050/tmj.v7i3.1958.

U. Rahardja, “Penerapan Teknologi Blockchain Dalam Pendidikan Kooperatif Berbasis E-Portfolio,” Technomedia Journal, vol. 7, no. 3, pp. 354–363, Dec. 2022, doi: 10.33050/tmj.v7i3.1957.

S. Zebua and M. Heru Riza Chakim, “Effect of Human Resources Quality, Performance Evaluation, and Incentives on Employee Productivity at Raharja High School,” APTISI Transactions on Management (ATM), vol. 7, no. 1, pp. 1–8, 2023, doi: 10.34306.

R. Muthia, “Structured Data Management for Investigating an Optimum Reactive Distillation Design,” ADI Journal on Recent Innovation (AJRI), vol. 5, no. 1, pp. 34–42, Mar. 2023, doi: 10.34306/ajri.v5i1.899.

N. P. A. Mentayani, I. P. Satwika, I. G. A. Pramesti Dwi Putri, A. A. I. I. Paramitha, and T. Tiawan, “Analisis Dan Perancangan User Interface Sistem Informasi Pembayaran Mahasiswa STMIK Primakara Berbasis Web,” Technomedia Journal, vol. 7, no. 1, pp. 78–89, Apr. 2022, doi: 10.33050/tmj.v7i1.1850.

I. Hidayat and F. O. S. Dewi, “Effect of Liquidity, Leverage, and Working Capital Turn on Profitability,” APTISI Transactions on Management (ATM), vol. 7, no. 1, pp. 60–68, Feb. 2022, doi: 10.33050/atm.v7i1.1832.

Q. Aini, I. Handayani, and F. H. N. Lestari, “Utilization Of Scientific Publication Media To Improve The Quality Of Scientific Work,” Aptisi Transactions on Management (ATM), vol. 4, no. 1, pp. 1–12, 2020.

N. M. Nila Febrianti and G. S. Darma, “Millennials’ Intention to Invest through Securities Crowdfunding Platform,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 1, pp. 19–30, Jan. 2023, doi: 10.34306/att.v5i1.280.

Gleny and I. Bernardo, “Research on the Intention to Purchase of Fabric Saints : Based on the Theory of Consumption Value, Green Purchase Intention, and Green Purchase Behaviour,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 1, pp. 31–39, Jan. 2023, doi: 10.34306/att.v5i1.287.

Published

2023-11-28

How to Cite

Setiya Budi, D., & Syahrial, H. . (2023). Pengoptimalan Performa Database Pada Proses Transformasi Data Pada SQL Server: Optimizing Database Performance in the Data Transformation Process in SQL Server ​. Technomedia Journal, 8(3 Februari), 407–419. https://doi.org/10.33050/tmj.v8i3.2167