Claim Missing Document
Check
Articles

Found 40 Documents
Search

Database Tuning in Hospital Applications Using Table Indexing and Query Optimization Samidi, Samidi; Iskandar, Daniel; Fachruroji, Muhamad; Septyo Wibowo, Wahyu Adi; Khaerani A, Afifah
Jurnal Pendidikan Tambusai Vol. 6 No. 1 (2022): April 2022
Publisher : LPPM Universitas Pahlawan Tuanku Tambusai, Riau, Indonesia

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

Abstract

RDBMS telah menjadi kebutuhan mendasar bagi semua perusahaan dan diharapkan dapat memberikan informasi secara tepat waktu, akurat, dan andal. Sayangnya, pertumbuhan data yang eksponensial biasanya menyebabkan masalah kinerja database, yaitu waktu eksekusi kueri yang lambat sebagai salah satu masalah utama. Pilihan untuk meningkatkan kinerja database adalah dengan melakukan penyetelan database menggunakan pengindeksan tabel dan optimisasi kueri. Tujuan utama dari penelitian eksperimental ini adalah untuk membandingkan waktu respon database sebelum dan sesudah proses tuning database. Kami memilih Sistem Informasi Rumah Sakit sebagai objek kami di mana kami mengerjakan jutaan data dan mengeksekusi beberapa kueri SQL untuk melihat perbedaan waktu respons sebelum dan sesudah penyetelan basis data. Akibatnya, untuk mengambil 1.039.852 baris data Patient Care dibutuhkan 743 detik sebelum penyetelan, dan hanya 46 detik setelah penyetelan.
Optimasi Database dengan Metode Index dan Partisi Tabel Database Postgresql pada Aplikasi E-Commerce. Studi pada Aplikasi Tokopintar Samidi, Samidi; Fadly, Fadly; Virmansyah, Yusuf; Suladi, Ronal Yulyanto; Lesmana, Ario Bambang
Jurnal Pendidikan Tambusai Vol. 6 No. 1 (2022): April 2022
Publisher : LPPM Universitas Pahlawan Tuanku Tambusai, Riau, Indonesia

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

Abstract

Efektifitas dan juga efisiensi waktu dalam mengakses dan pengambilan data sangatlah penting bagi sebuah perusahaan retail berbasis online yang memiliki jumlah data transaksi kegiatan sangat besar setiap harinya, sepertihalnya yang terjadi pada Aplikasi E-Commerce Toko Pintar dalam sebuah aktivitas transaksi mutasi. Dalam penelitian ini, dilakukan sebuah optimasi database untuk mengoptimalkan kinerja database guna menunjang performa dari database itu sendiri. Optimasi yang dilakukan dalam penelitian ini bertujuan untuk mengatasi dan memperoleh informasi sekaligus solusi masalah waktu eksekusi dan waktu respon query jika data pada database yang akan diproses sangat besar yang berdampak pada lamanya proses query itu sendiri. Adapun cara yang digunakan untuk melakukan optimalisasi database dalam penelitian ini adalah dengan metode Index dan Prtition Table. Index adalah sebuah objek dalam sistem database yang dapat mempercepat proses pencarian (query) data. Dari hasil eksperimen dengan dataset sebesar 2.248.590 data didapatkan sebuah hasil yang sangat memuaskan dimana terdapat perbedaan waktu query yang signifikan sebelum dan sesudah menggunakan index dan partition table, dimana Database sebelum diberi Index dan Partition Table akan memakan waktu yang lama dibanding setelah menggunakan Index dan Partition Table. Kelemahan Index dan Partition Table terjadi hanya pada kondisi tertentu yaitu padasaat melakukan insert data kedalam table.
Implementation of Database Distributed Sharding Horizontal Partition in MySQL. Case Study of Application of Food Serving On Kemkes Samidi Samidi; Ronal Yulyanto Suladi; Ario Bambang Lesmana
JURNAL SISFOTEK GLOBAL Vol 12, No 1 (2022): JURNAL SISFOTEK GLOBAL
Publisher : Institut Teknologi dan Bisnis Bina Sarana Global

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.38101/sisfotek.v12i1.477

Abstract

In today's digital era, database systems are becoming a mandatory thing that is used in every industry field to improve the performance of the industry, over time with the increasing need for databases, single databases and single servers are considered less capable in handling data that continues to increase in number, so it often leads to a decline in performance. Therefore came the idea of centralized data storage that can be modified to accommodate the availability, scalability, reliability, and management of data. One way that can be done is to apply Distribute Database using Sharding Horizontal Partition technique and experimental methods using mariadb and spider engine. The test was carried out on the database of food processing sites (TPP) in the TPP application at the ministry of health. The test results prove that although in some journals about Sharding, more sharding is implemented on NoSQL DBMS such as MongoDB, influx dB. In this study it can be proven that sharding can also be done in relational DBMS such as MariaDB and MySQL, data can be distribute and load process too, test result successful although the performance of time query response is still better single database than distribute database.
Pengembangan Sumber Daya Manusia di RW 10 Kelurahan Meruya Utara Melalui Pelatihan Microsoft Office Devit Setiono; Samidi Samidi; Sofian Lusa
Abditeknika Jurnal Pengabdian Masyarakat Vol. 2 No. 1 (2022): April 2022
Publisher : LPPM Universitas Bina Sarana Informatika

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31294/abditeknika.v2i1.1010

Abstract

Di era kemajuan teknologi saat ini, keterampilan dalam menggunakan komputer sangat diperlukan, termasuk dalam bidang pemerintahan. Hampir semua kegiatan pemerintahan, mulai dari pembuatan dokumen sampai dengan pelaporan kegiatan sudah mulai menggunakan komputer agar lebih praktis dan efisien. Salah satu contonya adalah penggunaan Microsoft Office sebagai media pembuatan laporan kegiatan di tingkat kelurahan, namun yang menjadi kendala adalah belum mahirnya dalam pembuatan laporan menggunakan Microsft Office menjadikan adanya ketidakpuasan dalam proses pelayanan. Pelatihan keberlanjutan Microsoft Office yang meliputi Microsft word, Power Point dan Excel, ditujukan untuk membantu dalam proses penyelesaian permasalahan dalam pelaporan kegiatan. Pelatihan ini ditujukan untuk meningkatkan kemampuan para peserta dalam hal pengoperasian Microsoft office guna menunjang tugas dan kegiatan. Pada pelatihan ini menggunakan metode sosialisai, pelatihan secara intensif dan pendampingan serta evaluasi di akhir pelatihan. Hasil dari kegiatan ini adalah peserta lebih memahami dan semakin mahir dalam menggunakan Microsoft Office sebagai media pembuatan laporan kegiatan.
PROTOTIPE SISTEM INFORMASI SUMBER DAYA INVESTASI : STUDI KASUS BALAI SUMBER DAYA INVESTASI PUSAT PEMBINAAN SUMBER DAYA INVESTASI BADAN PEMBINAAN KONSTRUKSI KEMENTERIAN PEKERJAAN UMUM Hepi Nuryadi; Moedjiono Moedjiono; Samidi Samidi
JSI (Jurnal sistem Informasi) Universitas Suryadarma Vol 4, No 1 (2017): JSI (Jurnal sistem Informasi) Universitas Suryadarma
Publisher : Universitas Dirgantara Marsekal Suryadarma

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35968/jsi.v4i1.70

Abstract

Development investment resources information systems can mean developing a new system to replace the old system or improve the existing system in a company, institutions or government agencies, including Balai Sumber Daya Investasi (Balai SDI) is supervised by Pusat Pembinaan Sumber Daya Investasi, which is one Eselon II in Badan Pembinaan Konstruksi Ministry of Public Works which has the duty to formulate policies based resource infrastructure investment policies that have been established. ). Since its establishment until now Balai SDI hasn’t had a system of integrated applications that manage the construction market data, materials and construction equipment throughout Indonesia. The scope of the Investment Resource Information System developed include: construction market data, market potential data construction, material data, the data of AMP (Asphalt Mixing Plant), Quarry data, cement Statistics data, the data of Pt Pertamina petroleum asphalt, and construction equipment. This research is type of Applied Research (Applied Research). Information systems development method using Prototype model. Methods of data collection by observation, sampling data, literature, and interviews with a selected sample using purposive sampling method. The method used in analyzing and designing a system is a method of Object Oriented Analysis and Design (Object Oriented Analysis and Design) using Unified Modeling Language (UML). System testing techniques with black-box testing approach. Validation testing using the Focus Group Discussion. The quality of the resulting software was tested by four models of software quality characteristics of ISO 9126, namely: functionality, reliability, usability, and efficiency using the questionnaire method. The results are in the form of websites Sistem Informasi Sumber daya Investasi that have a very good level of quality and function can provide construction market information in order to increase competitiveness and investment in the construction sector in Indonesia
Online Based Memorandum of Understanding (MOU) Data Exchange System Design with EDI Method Inge Virdyna; Samidi Samidi
Journal of Integrated and Advanced Engineering (JIAE) Vol 1, No 2 (2021)
Publisher : Asosiasi Staf Akademik Perguruan Tinggi Seluruh Indonesia (ASASI)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51662/jiae.v1i2.19

Abstract

During the Covid 19 pandemic, every individual is required to be more creative in carrying out every activity and not make a distance as the reason an activity cannot be carried out. Documentation data, which is usually sent manually by post, will experience difficulties at this time. This research will discuss other ways that can be done to ensure the data exchange process of the Memorandum of Understanding (MOU) between PT. Bank XYZ with partners. The solution that can be implemented is to use the Electronic Data Interchange (EDI) method. EDI is an online-based data exchange method. In other words, the method of exchanging data via postal service is not necessary. Based on this research, the EDI method can meet users' needs in terms of exchanging or sending documentary data on the MOU between PT. Bank XYZ with partners. The method used in building this system design is analyzing the running system and designing the system with UML tools. The final result of the validation test of the system design through the FGD method states that the e-approval system application design of the MOU is by the specifications of the functional requirements required by the user.
Prototipe Sistem Absensi Berbasis Web Dan Mobile Dengan Metode Rapid Aplication Development (Rad) Fried Sinlae; Samidi
Prosiding SISFOTEK Vol 5 No 1 (2021): SISFOTEK V 2021
Publisher : Ikatan Ahli Informatika Indonesia

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

Abstract

Web and Mobile-Based Attendance System Design at PT. Bintang Millennium Perkasa, the author tries to do research to design a web-based information system for PT. Mighty Millennium Star. The main problem of this research is the difficulty of calculating food and transportation fees because there is no real-time recording of attendance. The system development method uses RAD and ISO 9126 testing and system security testing tools with Acunetix, Loic tools, and Hoic tools. By using the Research Methodology Rapid Application Development (RAD). The author's goal is to create an information system that makes it easier for the Human Resources Management (HRD) section to manage employee administration to the company, as a tool for the HRD section and employees to carry out employee administrative processes for the company. As well as displaying employee data, leave and attendance on this website. The result of this research is a Web and Mobile-based attendance system with the main modules are employee data, leave management, and attendance management. The test results with ISO 9126 are good and the acunetix test results are good, Loic is good, Xoic is also good. So it can be concluded that the resulting value still shows the feasibility of the system to be implemented in accordance with the real system in the design of the Human Resource Management information system web and the administrative management of employees towards the company.
Sistem Informasi Inventory Toko Murah PT. Rudy Soetadi Fried Sinlae; Samidi
Prosiding SISFOTEK Vol 5 No 1 (2021): SISFOTEK V 2021
Publisher : Ikatan Ahli Informatika Indonesia

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

Abstract

Designing Web-Based Shop Inventory Information System at PT. Rudy Soetadi, the writer tries to do research to make a web based desktop information system design for PT. Rudy Soetadi. The data collection method used by the authors in this study is to use the method of literature study, interviews and observation. By using the RAD Research Methodology. The aim of the author is to reduce the problems that exist in the research area, as a tool for cheap shop administrators to see information on all transactions in low-cost stores. As well as income and expense reports on this desktop website. The results of this study indicate that this desktop web can make it easier for low-cost shopkeepers to do bookkeeping and manage low-cost stores. So it can be concluded that the resulting value still shows the feasibility of the system to be implemented in accordance with the real system for web desktop web design and low-cost store inventory management.
Sistem Penentuan Paket Penjualan dengan Algoritma FP-Growth Serta Metode Up dan Cross Selling Febriantho Febriantho; Samidi Samidi; Gregorius Mikael; Endang Saputra
JURNAL MEDIA INFORMATIKA BUDIDARMA Vol 6, No 4 (2022): Oktober 2022
Publisher : Universitas Budi Darma

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30865/mib.v6i4.4800

Abstract

The Car Spare Part Shop is one of the Car Spare Parts Shops in Tangerang Regency. Based on interviews conducted with shop owners at the Car Spare Parts Store, it was stated that there was a decrease in sales income every month, so there was limited capital in purchasing car spare parts products which resulted in difficulties in choosing which car spare parts products to order. The purpose of this study is to create a system to process and utilize sales transaction data using the FP-Growth algorithm as well as up selling and cross selling methods which will later be used to sell car spare parts that are purchased simultaneously in a sales package determination system. The sales transaction data used is 6,674 transaction data for 1 year of operation of the Car Spare Part Shop (July 2021 - June 2022) with 30,956 records in Microsoft Excel format. The prototype system uses the Python framework flask and mysql database. Validation test results ensure that the software that has been made is in accordance with the expected functional requirements specifications. The results of the system quality test with ISO 9126 can be concluded in the criteria of Very Good with a value of 98.59%. With the results of the Functionality aspect of 99.25%, the results of the Reliability aspect of 98.13%, the results of the Usability aspect of 98.33% and the results of the Efficiency aspect of 98.66%. The results of system security testing with Acunetix and LOIC software have been carried out and the system is still stable and the system is declared safe when used.
Implementasi Metode Indexing dan Penggunaan Subquery untuk Optimalisasi Database Rawat Jalan Rumah Sakit Menggunakan Mysql Wilsen Grivin Mokodaser; Monica Dwijayanti; Samidi Samidi
CogITo Smart Journal Vol. 8 No. 2 (2022): Cogito Smart Journal
Publisher : Fakultas Ilmu Komputer, Universitas Klabat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31154/cogito.v8i2.415.335-345

Abstract

The need for outpatient hospital services that can be accessed quickly by the community is a very important aspect. By looking at the downturn caused by the Covid-19 pandemic that has hit the world since 2019 and has an impact on various economic aspects including hospital services, digitizing the hospital system must be implemented to be a solution in providing fast services for patients who come for treatment. The information system is not without problems, as the amount of data increases so that the selection of the right database including the use of appropriate queries can help provide accurate and fast output. indexing method can be applied to tables with a large number of databases. the use of subqueries as with previous research shows an increase in data access performance.
Co-Authors - Hariyanto Adinda Krida Wicaksono Ahmad Wijaya Kusuma Akbar, Ipal Anandha Fitriani Andharu, Dika Andra Setiadi Andy Rio Handoko Ario Bambang Lesmana Azlina Ahmad Bagus Priambodo Baihaqi Yogie Prasetyo Carmel Novella Henni Danar Darmawan Deska, Amat Devit Setiono Dijerja, Gahara Dika Andharu Eka W, Samuel Yusach Eko Aprianto Endang Saputra Fachruroji, Muhamad Fadly Fadly Fatmawati, Devy Fauzie Nurrakhman Febriantho Febriantho Fried Sinlae Gatot Tri Pranoto Gregorius Mikael Gufron, Dian Muhammad Gushelmi Henny Henny Indra Nugraha Inge Virdyna Iqbal, Aldy Mercyano Iqbal, Moh Himam Irma Yuningsih Iskandar, Daniel Isnen Hadi Al Ghozali Jumaryadi, Yuwan Khaerani A, Afifah Lesmana, Ario Bambang M Harviandi Rachman Maya Asmita Moedjiono Moedjiono Mohammad Shiddiq Antarressa Mohammad Syafrullah Monica Dwijayanti Muhammad Royani Nazori AZ Nugraha Abdullah, Indra Nuryadi, Hepi Purwanto Purwanto Rabiah Abdul Kadir Ramadhon, Muhammad Ramdhani Hidayat, Ramdhani Ratna Kusumawardani Ratna Kusumawardani, Ratna Richard Riri Fajriah Ronal Yulyanto Suladi Ruci Meiyanti Ruwirohi, Jan Everhard Safitri, Rahayu Saputro, Wahyu Ragil Septyo Wibowo, Wahyu Adi Setiadi, Indra Tresna Shofinurdin Shofinurdin Soepriadi, Raden Sofian Lusa Sri Wahyuningsih Suladi, Ronal Yulyanto Syafran Nurrahman Syahdinullah S, Sutan Syaiful Anwar Tjahjanto, Tjahjanto Triana Anggraini Tutik Sri Susilowati Vasthu Imaniar Ivanoti Virmansyah, Yusuf Widi Santoso Widyarto, Fajar Wilsen Grivin Mokodaser Wirda Hilwa Yuliana Aisyah