Claim Missing Document
Check
Articles

Found 35 Documents
Search

COMPARATION OF DISTRIBUTED DATABASE MODEL BY CLUSTERING METHOD IN E-GOVERNMENT SYSTEM. STUDY AT KEMENKEU RI Adinda Krida Wicaksono; Fauzie Nurrakhman; Samidi Samidi
Jurnal Teknik Informatika (Jutif) Vol. 4 No. 1 (2023): JUTIF Volume 4, Number 1, February 2023
Publisher : Informatika, Universitas Jenderal Soedirman

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52436/1.jutif.2023.4.1.629

Abstract

MySQL is one of the most popular open source database in the world based on its performance, its reliability, and its easiness that has been proved. MySQL is categorized into community version and commercial version. The commercial version has standalone architecture models and clusters.Database Clustering is one of distributed database model. The case study used is Kemenkeu Learning Center (KLC) Application which is an e-government application in Ministry of Finance. KLC application used for interactive learning media for all ASN especially ASN in Ministry of Finance. This makes the KLC application being categorized into a very high critical application, so it takes a good response time and has high availability. One of the most important factors to fulfill this need is by deciding the appropriate MySQL database architecture for KLC application. This research was conducted by creating 3 (three) database architecture models according to best practice from MySQL, namely the Standalone architecture model, InnoDB Cluster and NDB Cluster. Then tested with several different scenarios to get results in the form of response time and percentage of errors that indicate high availability capabilities. The tools used in testing are Apache JMeter. From the test results, it is found that the MySQL NDB Cluster is the right database architecture model in an effort to realize the need for database services with the best response time and high availability capabilities.
PROTOTIPE KNOWLEDGE MANAGEMENT SYSTEM (KMS) PRAKTIKUM PERBANKAN SYARIAH BERBASIS WEB DAN ANDROID DENGAN KERANGKA KERJA “TIWANA” PADA PERGURUAN TINGGI: STUDI KASUS STEI SEBI Nazori Agani; Samidi Samidi; Wirda Hilwa
Telematika MKOM Vol 6, No 2 (2014): Jurnal Telematika MKOM Vol. 6 No. 2 September 2014
Publisher : Universitas Budi Luhur

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (8203.826 KB)

Abstract

Knowledge Management System (KMS) bertujuan untuk meningkatkan kualitas SDM dalam suatu organisasi dengan memperbaiki komunikasi antara seluruh bagian organisasi dan meningkatkan penguasaan pengetahuan dengan melakukan transfer pengetahuan. Penerapan KMS dengan sebuah sistem berbasis web diharapkan dapat menjadi solusi dari kebutuhan transfer knowledge yang tidak dihalangi oleh batasan waktu dan tempat, sedangkan aplikasi mobile diharapkan dapat lebih mempermudah pengaksesan KMS oleh mahasiswa dan dosen yang mobilitas nya tinggi. Penelitian ini menggunakan kerangka kerja model Tiwana, dan untuk pemetaan knowledge organisasi menggunakan siklus KM model Zack, sedangkan untuk pembentukan knowledge menggunakan model SECI. Kualitas perangkat lunak yang dihasilkan diuji berdasarkan empat karakteristik kualitas perangkat lunak model ISO 9126. Hasil dari penelitian ini adalah prototipe KMS berbasis web dan mobile Android ini dapat diterapkan dengan baik dengan kualitas pengujian yang sangat baik sehingga dapat menjadi sebuah solusi untuk meningkatkan penguasaan pengetahuan dalam kegiatan belajar mengajar dan membuat prodi Perbankan Syariah dapat bekerja lebih cerdas dalam memanfaatkan sumber daya yang ada dari waktu ke waktu yang muaranya adalah peningkatan kualitas dan berkembangnya pengetahuan.
Performance Tuning Oracle 11g Database Melalui Inisial Paramater, Structure Database dan SQL Tuning. Studi Pada ERP SISFORBUN Dana Pensiun Perkebunan (DAPENBUN) - Samidi; - Hariyanto
Techno.Com Vol 22, No 2 (2023): Mei 2023
Publisher : LPPM Universitas Dian Nuswantoro

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33633/tc.v22i2.7831

Abstract

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.
Pemodelan Database Sistem Monitoring Kompetensi Dosen Melalui Pendekatan TOGAF ADM Riri Fajriah; - Samidi
Techno.Com Vol 22, No 2 (2023): Mei 2023
Publisher : LPPM Universitas Dian Nuswantoro

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33633/tc.v22i2.7518

Abstract

Paradigma perubahan kurikulum pembelajaran berdasarkan outcome base education pada instansi perguruan tinggi Universitas Mercu Buana akan merubah implementasi capaian pembelajaran sesuai dengan target kompetensi capaian lulusan. Dampak dari hal tersebut salah satunya adalah pemenuhan target kompetensi melalui sertifikasi pelatihan yang sesuai kepada dosen selaku pengajar yang sesuai dengan pembelajaran mata kuliah yang disampaikan kepada mahasiswa. Akan tetapi, dalam fakta yang didapatkan baru sekitar 22% dari total populasi dosen tetap pada fakultas ilmu komputer yang telah memiliki sertifikasi kompetensi yang sesuai dengan mata kuliah pengajaran, sehingga hal ini akan menjadi permasalahan ketika fakultas akan melakukan reakreditasi program studi. Oleh karena itu diperlukan suatu pemodelan database yang akan mendukung sistem monitoring kompetensi dosen dengan baik. Proses perancangan database akan menyesuaikan dengan pemodelan relasional database dengan dimulai dari tahapan konseptual, logikal sampai dengan fisikal desain serta dengan evaluasi normalisasi data pada perancangan database. Untuk mendukung pengembangan arsitektur data yang ideal maka digunakan pendekatan Framework TOGAF ADM. Tujuan dari penelitian adalah menghasilkan pemodelan database yang tepat terkait dengan rencana perancangan sistem monitoring kompetensi dosen menggunakan pendekatan TOGAF ADM. Hasil dari penelitian ini adalah pemodelan database dan enterprise architecture planning sesuai kebutuhan bisnis Fasilkom di institusi perguruan tinggi Universitas Mercu Buana.
Gradient Analysis In Implementation of B-Tree Indexing In Reporting Annual Tax Database Samidi Samidi; Shofinurdin Shofinurdin; Andra Setiadi; Danar Darmawan; Dika Andharu
Syntax Literate Jurnal Ilmiah Indonesia
Publisher : Syntax Corporation

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (205.072 KB) | DOI: 10.36418/syntax-literate.v7i3.6437

Abstract

A query is a syntax or command used in a database system to access and display data. Queries can be used to make data interact with each other. To display query results in the database, of course, requires execution time which is usually denoted in seconds. Execution time is directly proportional to the amount of data to be displayed and the level of complexity of the database. To speed up query execution time, the term database optimization is known. One of the database optimization methods is to use the b-tree indexing technique the database. This study aims to compare the execution time of databases that have not been indexed or that have been indexed with data objects in the MySQL database MPN-Info application at the Jakarta Palmerah Tax Office (KPP Pratama Jakarta Palmerah). This application was developed to supervise taxpayers which is used in almost all tax service offices throughout Indonesia. The data used is active employee status taxpayer data registered until 2020 with the reporting of Annual Personal Income Tax Returns in 2019 and 2020. The study uses an experimental method by applying a select query, then the execution time is recorded well for unindexed and indexed databases. The gradient method will be used for compare the results of the two. The results obtained are after taking the population of taxpayers registered employees up to year In 2020 at KPP Pratama Jakarta Palmerah, 31,238 data were compared with the annual reporting data, the average execution time before indexing was 255.585 seconds and the average time after indexing was 1.341 seconds and the gradient value before indexing was 0.0211 and after indexing was 0.0001. This proves that the indexing technique has a significant impact in accelerating the query execution process.
Teknik Optimasi Database dengan Logic Execution Optimization pada Microservices Architecture Isnen Hadi Al Ghozali; Mohammad Shiddiq Antarressa; Samidi Samidi
CogITo Smart Journal Vol. 9 No. 1 (2023): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v9i1.444.60-72

Abstract

Microservices architecture, a distributed framework architecture that allows changes to one module without interfering with other modules. The implementation of this architecture has its own challenges. The get-list-attachment API running on this architecture takes an average of 12.5 seconds to serve data. This needs to be considered because business processes require shorter access times to support decision making. The research objective is to obtain query response time efficiency for accounting applications. To achieve this, the research uses database optimization techniques with logic execution optimization microservices architecture. This study obtained the source of information from the Accounting Harmony Accounting Module, which has an API (get-list-attachment) with data sourced from Service Accounting (581253 records) and Service Users (2182 records). Based on a series of tests carried out, several services need to be added with APIs to improve the microservices architecture to accept bulk parameters that generate a list of objects so that data presentation is more optimal. After doing a series of engineering on microservices architecture and indexing application, query response time performance increased by 49.22% for Service Accounting module.
Pembuatan Data Warehouse secara Berjenjang dari Data Transaksi dengan ETL Script PHP Yuliana Aisyah; Syaiful Anwar; - Samidi
Techno.Com Vol 22, No 3 (2023): Agustus 2023
Publisher : LPPM Universitas Dian Nuswantoro

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33633/tc.v22i3.8084

Abstract

Setiap perusahaan payment gateway yang mendapat ijin operasional Bank Indonesia (BI), harus melaporkan data transaksinya setiap bulan ke BI . Permasalahan terjadi karena database transaksi produksi tersebar di banyak database, dimana database dipisahkan berdasarkan channel (merchant) dan payment type (Credit card, VA, retail store, e-wallet), hal ini  menyulitkan saat pembuatan laporan. Penelitian ini ditujukan untuk membuat data warehouse yang menggabungkan seluruh database  dengan menggunakan script PHP yang melakukan proses ETL (Extract, Transform, dan Load), dengan cara berjenjang  2 tahap, yaitu tahap 1 melakukan backup seluruh database dari banyak server ke satu server dengan 3 tujuan sekaligus yaitu  backup transaksi , meningkatkan  performance database production dan membantu  proses rekonsiliasi dan tahap 2 melakukan pembuatan data warehouse  dari semua database backup dari tahap 1. Penelitian yang digunakan adalah kuantitatif verifikatif terhadap table-table yang diperlukan  pada system OLTP (Online Transaction Processing). Pengujian data warehouse dilakukan  secara kuantitatif dengan membandingkan hasil summary dari data warehouse dengan gabungan summary  semua database aslinya  dan secara verifikatif oleh petugas report melalui User Acceptance Test. Hasil dari penelitian adalah sebuah script untuk backup data transaksi dari semua database dari banyak server ke satu server,   sebuah script PHP yang berfungsi sebagai pelaksana ETL dan sebuah  data warehouse.
Examining the Joint Effects of Air Quality, Socioeconomic Factors on Indonesian Health Ahmad Wijaya Kusuma; Yuwan Jumaryadi; Samidi; Richard; Anandha Fitriani
Aptisi Transactions On Technopreneurship (ATT) Vol 5 No 2sp (2023): Special Issue: Support Technopreneurship in the Medical
Publisher : Pandawan

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.34306/att.v5i2sp.338

Abstract

 This study addresses the pressing need to comprehensively manage air pollution by examining the roles of local and national public agencies from the perspective of the general public. Air quality poses a critical challenge that profoundly impacts various aspects of human life. To enhance our understanding and generate both theoretical and practical insights for public management, this research introduces several key variables: the engagement of authorities in mitigating air pollution, citizen involvement in pollution reduction efforts, financial incentives for individuals and businesses to adopt air-friendly behaviors, urban green investments, the communal consequences of air pollution, and the necessity for industrial participation. Employing Partial Least Squares Structural Equation Modeling (PLS-SEM) as the research approach, data was gathered from residents of Indonesia's largest cities, where pollution significantly affects society and governing bodies. The findings are pertinent for public managers at both local and national levels, providing valuable input to enhance strategies for curbing air pollution, enhancing air quality, and ultimately improving the well-being of inhabitants.
Eksplorasi Kerangka Manajemen Risiko Proyek untuk Perusahaan Teknologi Informasi Isnen Hadi Al Ghozali; Samidi Samidi; Andy Rio Handoko
CogITo Smart Journal Vol. 9 No. 2 (2023): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v9i2.517.266-279

Abstract

 Based on CHAOS 2020: Beyond Infinity Overview, reported by the Standish Group, only 31% of  IT projects were successfully implemented, while 50% of projects were challenged and 19% of projects failed. Many project managers less awareness about SRM and have a partial understanding of risk. The purpose of this study is to develop a project risk management framework for listing companies in the information technology sector. The sample for this study is 35 annual reports of technology companies listed on IDX. This study identified 122 types of project risks from 33 companies' annual reports. This study uses an exploratory study approach. The proposed framework includes three stages, namely the root cause, risk assessment, and performance stages. At the root cause stage, the identification of risks from elements of the business environment becomes the basis for measuring risk treatment. In the next stage, the identified risk treatment is measured through identify, analysis, and verification activities with the support of communication, documentation, and evaluation. The measurement results are classified into three major dimensions, namely cost, time, and quality. The final stage of the framework is in the form of residual performance risk and a risk mitigation action plan.
Project Management on Network and Security Development using the PMBOK Method Iqbal, Aldy Mercyano; Setiadi, Indra Tresna; Samidi, Samidi
Jurnal Sisfokom (Sistem Informasi dan Komputer) Vol 13, No 2 (2024): JULY
Publisher : ISB Atma Luhur

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32736/sisfokom.v13i2.2131

Abstract

HOSPITAL ABC is one of the companies that operates in the healthcare sector. In the construction of the hospitals, must be supported by the implementation of technology, especially network technology so that all operational devices in the hospital can be connected and communicate with each other, while still paying attention to the security factor on the network. Based on this, project management is needed in network and security development at the hospital to be built so that the development can be following the timeline and meet the expectations of all stakeholders. With the use of the PMBOK approach for network development and security in hospitals, every phase has very important activities and is related to other activities. Besides that, by using the PMBOK approach can also find out which parts are challenges in project implementation. In this project, the process of procuring/ordering devices, storing devices, and physically checking devices with BAST are critical parts and require more attention so that the project can run according to the specified time.