Analisis dan Penerapan Metode Tuning pada Basis Data Funding
DOI:
https://doi.org/10.21512/comtech.v6i1.2299Keywords:
Database, Tuning, Funding, Analytical ReportAbstract
The purpose of this research is to analyze, design, and implement tuning for the funding database, which include data mart processing that will be used in the formation of analytical reports. The research method used is literature study from a variety of journals, books, e-books, and articles on the internet. Fact finding
techniques are also done by analyzing, collecting, and examining the documents, interviews, and observations. Other the research methods are also used to analyze and design database such as SQL tuning, Partitioning, and Indexing. The results obtained from this research is an implementation tuning for the funding database, in which if it is implemented, it will improve performance significantly. The conclusion is by implementing tuning for the funding database, it can help the bank to improve the performance of database system and decrease time to produce analytical reports.
Plum Analytics
References
Anonim1. (2007). Partioning in Oracle Database 11g. USA: Oracle Corporation.
Cecilia, C., Mihai, G. (2011). Increasing Database Performance using Indexes. Database Systems Journal, II(2):13.
Chan & Immanuel. (2008). 2 days + Performance Tuning Guide 10g Release 2 (10.2). USA: Oracle Corporation.
Connolly, T., Begg, C. (2010). Database System; a Practical Approach to design, Implementation and Management (5 ed.). England: Pearson Education.
Hitesh, K. S., Aditya, S., Ranjit, B. (2012). A Framework for Automated Database TuningUsing Dynamic SGA Parameters and Basic Operating System Utilities. Database Systems Journal, III(4): 25.
Indrajani. (2011). Bedah Kilat 1 Jam – Pengantar dan Sistem Basis Data. Jakarta, Jakarta, Indonesia: Elex Media Computindo.
______. (2011). Perancangan Basis Data Dalam All In 1. Jakarta, Jakarta, Indonesia: Elex Media Computindo.
______. (2014). Rancang Bangun Model Aplikasi Tuning Pada Unit Bisnis Kredit Konsumer. In C. L. Bandung (Ed.). Bandung: JBPTITBPP.
Indrajani, Wihendro, & Safan. (2013). Rancang Bangun Konseptual Basis Data Klinik 24 Jam. Seminar Nasional Teknologi Informasi & Multimedia 2013. Yogyakarta: STMIK AMIKOM.
Millsap & Garry. (2008). Optimizing Oracle Performance: A Practitioner’s Guide to Optimizing Response Time. Cambridge: O’Reilly.
Downloads
Published
Issue
Section
License
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. 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 acknowledgment of its initial publication in this journal.
c. 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.
USER RIGHTS
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: