Performance Analysis and Optimization Techniques for Oracle Relational Databases

Almeida, Fernando; Araújo, Fernando Borba de

doi:10.2478/cait-2019-0019

Cited by 4 publications

(2 citation statements)

References 15 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“… SQL databases . As one of the most widely used databases supporting the relational model, SQL database (e.g., MySQL [ 25 ], Oracle [ 26 ]) is usually used to store structured data which is highly-organized and formatted. Therefore, SQL databases can comply with atomicity, consistency, isolation and persistence.…”

Section: Preliminariesmentioning

confidence: 99%

A Survey on the Integration of Blockchains and Databases

Zhu

Zhong

et al. 2023

Data Sci. Eng.

View full text Add to dashboard Cite

The success of blockchain technology in cryptocurrencies reveals its potential in the data management field. Recently, there is a trend in the database community to integrate blockchains and traditional databases to obtain security, efficiency, and privacy from the two distinctive but related systems. In this survey, we discuss the use of blockchain technology in the data management field and focus on the fusion system of blockchains and databases. We first classify existing blockchain-related data management technologies by their locations on the blockchain-database spectrum. Based on the taxonomy, we discuss three types of fusion systems and analyze their design spaces and trade-offs. Then, by further investigating the typical systems and techniques of each type of fusion system and comparing the solutions, we provide insights of each fusion model. Finally, we outline the unsolved challenges and promising directions in this field and believe that fusion systems will take a more important role in data management tasks. We hope this survey can help both academia and industry to better understand the advantages and limitations of blockchain-related data management systems and develop fusion systems that meet various requirements in practice.

show abstract

Section: Preliminariesmentioning

confidence: 99%

A Survey on the Integration of Blockchains and Databases

Zhu

Zhong

et al. 2023

Data Sci. Eng.

View full text Add to dashboard Cite

show abstract

“…Salah satu cara yang dilakukan untuk optimasi sebuah database adalah Performance Tuning. PerformanceTuning adalah kegiatan menganalisis dan meningkatkan kinerja sistem dalam DBMS [5] [6]. Proses performance tuning ini meliputi perubahan struktur data, parameter system database, konfigurasi Sistem Operasi atau termasuk perangkat keras.…”

Section: Pendahuluanunclassified

Performance Tuning Oracle 11g Database Melalui Inisial Paramater, Structure Database dan SQL Tuning. Studi Pada ERP SISFORBUN Dana Pensiun Perkebunan (DAPENBUN)

Samidi

Hariyanto

2023

View full text Add to dashboard Cite

Dana Pensiun Perkebunan (DAPENBUN) sebagai pengelola manfaat pensiun bagi karyawan PTPN seluruh Indonesia beserta lembaga afiliasi dengan jumlah peserta per 31 Desember 2021 sebanyak 284.934 orang. Aplikasi SISFORBUN ini digunakan untuk memproses manfaat pensiun bagi seluruh peserta. Aplikasi berbasis web ini menggunakan database Oracle 11g dan sudah digunakan sejak tahun 2013, dengan seiring berjalanya waktu perkembangan data semakin banyak dengan jumlah record terbesar dalam satu table sebesar 26.696.667 record data, sehingga performa proses data semakin menurun. Atas dasar permasalahan tersebut perlu dilakukan penelitian untuk meningkat performa dari Aplikasi. Penelitian ini menggunakan metode SQL Tuning, Strukturing Object dan Initial Parameter Database. Setelah dilakukan pengujian dengan melakukan proses pembayaran Manfaat Pensiun pada laporan manajemen nomor 18 (LM18), penulis dapat menyimpulkan bahwa setelah dilakukan optimasi, waktu yang diperlukan untuk proses pembayaran Manfaat Pensiun (LM18) menjadi lebih cepat dibandingkan sebelum dilakukan optimasi.

show abstract