Claim Missing Document
Check
Articles

Found 19 Documents
Search

Optimasi Query Sistem Informasi Menggunakan Stored Procedure Tri Hastono
Jurnal Dinamika Informatika Vol 8 No 2 (2019): Jurnal Dinamika Informatika
Publisher : Universitas PGRI Yogyakarta

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

Abstract

Queries are used for operations on information systems that use a database as data storage. The importance of queries should be a major concern at the application design stage. Generally the application designer ignores it so applications that are made will have poor performance when the data in the database is getting bigger. To overcome the decline in application performance because of neglecting query design, query optimization is performed. This study provides a solution to the declining performance of information systems by optimizing query information systems using stores procedures. The database in this study is designed by using MySQL Server 5 with 12 tables. The store procedure chosen in this study is function. There are 13 functions created with 12 functions for each table and 1 function to capture the status of the database operation processes.
Penerapan Pl/SQL Untuk Menentukan Pola Data Latih Pada Aplikasi Berbasis Neural Network Tri Hastono; Prahenusa Wahyu Ciptadi
Jurnal Dinamika Informatika Vol 10 No 2 (2021): Jurnal Dinamika Informatika Vol.10 No.2
Publisher : Universitas PGRI Yogyakarta

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

Abstract

Stock stability in business activities is an important component. One way to maintain the stability of the stock of durian fruit is to estimate the amount of consumer demand for durian fruit. Predicting the amount of durian fruit customers need can be done by looking at the patterns formed from sales transactions. However, if the prediction is done manually, it will take a long time and be prone to errors. The solution to overcome this problem is the need for a tool in the form of software in which there is already an accurate calculation method. One method that can be used to calculate customer durian needs is the Adaline artificial neural network. And the training data used is durian fruit sales data. Training data is divided into 2 groups, namely input data and target data. The focus of this research is the pl/sql design to determine the data input pattern automatically for the application of predicting the number of customer's durian fruit needs. The types of pl/sql used in this study are procedure and function
Sistem Pakar Diagnosis Gangguan Obsessive Compulsive Disorder Menggunakan Metode Forward Chaining Berbasis Web Sefti Rohana; Tri Hastono; Sunggito Oyama
Jurnal Dinamika Informatika Vol 11 No 1 (2022): Jurnal Dinamika Informatika Vol.11 No.1
Publisher : Universitas PGRI Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Anxiety disorder is one of the diseases are often encountered in psychology. Anxiety disorders can cause people into try to avoid situations that trigger or worsen their symptoms. There are several types of anxiety disorders, including Obsessive Compulsive Disorder. Obsessive Compulsive Disorder (OCD) is a disorder in witch people have recurring, unwaned thoughts, ideas or sensations (obsessions) that make them feel driven to do something repetitively (compulsions). The repetitive behaviors, such as hand washing and checking the door, can significantly interfere with a person’s daily avtivities and social interactions. Diagnosing what type of obsessive compulsive disorder do people have requires expert especially in psychology. An expert system is a system that requires the knowledge of an expert. This technology will help detecting the tendency of an obsessive compulsive disorder so people can enable to overcome and treat them appropriately. This system implements Forward Chaining to trace the knowledge base, which is consist of the type disorders, symptoms, and the rule. The expert system created by the author is based on a website using the PHP programming language and MySQL database. The output of this program is the name of one of the obsessive compulsive disorder and its solusions. It is hoped the expert system can facilitate and help the public to diagnose obsessive compulsive disorder
Penentuan Penyewa Tanah Kas Desa Potorono Menggunakan Metode Oreste dan Besson-Rank Berbasis Android Adikka Yudha Bintang Ramadan; Tri Hastono; Nurirwan Saputra
Jurnal Dinamika Informatika Vol 9 No 2 (2020): Jurnal Dinamika Informatika
Publisher : Universitas PGRI Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Potorono Village is one of the villages located in Banguntapan District, Bantul Regency, DIY. Potorono Village has a total area of ​​435.46 ha. Potorono Village has several village land treasuries that can be rented by residents and certain agencies. This land lease is managed by a team of intensification of land leases in Potorono Village. The rental system has been done manually so far, so the recording and documentation is very poor. This condition is exacerbated by the determination of village treasury land tenants who are determined arbitrarily, without taking into account the agreed criteria. The transparency of the village treasury land rental is also questionable. This research provides a solution to the problem of renting village treasury land. In this study, a land rental recording system was built and the determination of village treasury land tenants was built. The method used in this research is the Oreste and Besson-Rank methods. The platform used in the research is based on Android and the programming language used is the PHP programming language. The database on the proposed system is built using MySql
SISTEM MONITORING KWH METER DIGITAL BERBASIS IOT PADA LABORATORIUM PERALATAN MEDIS Danang Widyawarman; Tri Hastono
JOURNAL ONLINE OF PHYSICS Vol. 8 No. 3 (2023): JOP (Journal Online of Physics) Vol 8 No 3
Publisher : Prodi Fisika FST UNJA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.22437/jop.v8i3.26931

Abstract

The educational process, which is supported by adequate laboratory facilities and infrastructure, will produce professional higher education tri-dharma outputs, both for students and lecturers. The Medical Equipment Laboratory is a place where experimental studies with various equipment and devices, analyses, and observations are carried out. The amount of electrical energy used by a university can be measured using an electric energy meter, namely the kWh meter, but the university cannot monitor which building or room uses the most electrical energy because it only knows the amount of power used each month. Given these problems, a digital kWh Meter monitoring tool based on the Internet of Things (IoT) is designed to measure the amount of current, voltage, power, and costs that must be incurred while using medical equipment and can then be monitored in real time using the Blynk application as the server. The implementation system for monitoring the kwh meter using the PZEM-004T sensor has a very good accuracy rate of 99.52% for measuring voltage and 99.87% for measuring current on medical equipment in the medical equipment laboratory at the PGRI Yogyakarta University. It was found that the greater the applied load value, the more the impact on data outputs such as current and voltage would affect the size of the monthly electricity bill. The monitoring system can be carried out within a radius of 20 meters as long as the smartphone is connected to a WiFi connection. Monitoring activities and electrical device control activities can be carried out.
Penerapan Metode Logika Fuzzy Mamdani Untuk Menentukan Jumlah Pendapatan Penjualan Produk Umpan Pancing Binurilfatikhah, Barikna; Tri Hastono; Tyas Sulistyawati
Jurnal Publikasi Ilmu Komputer dan Multimedia Vol 3 No 1 (2024): Jurnal Publikasi Ilmu Komputer dan Multimedia
Publisher : Pusat Riset dan Inovasi Nasional

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55606/jupikom.v3i1.2485

Abstract

Anugerah Jaya Finishing Store 99 is one of the online stores that sells fishing bait. Fishing bait is a crucial factor in improving the efficiency of fish capture, and there are two types of fishing bait : artificial bait and natural bait. Income is the money generated from the sale of goods or services to costumers and is the most important aspect in determining the smooth operation of a business. To determine the amount of income in this study, one of the fuzzy logic methods, namely mamdani fuzzy logic, was used. Mamdani fuzzy logic was chosen because it is the method that is most similar to human logic.
AVOCADO STOCK PREDICTION IN BANTUL CITY USING MAMDANI FUZZY LOGIC Wisnu Setiawan; Tri Hastono; Gunawan, Riyan Fahmi; Rama Sona
Jurnal Publikasi Ilmu Komputer dan Multimedia Vol 3 No 1 (2024): Jurnal Publikasi Ilmu Komputer dan Multimedia
Publisher : Pusat Riset dan Inovasi Nasional

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55606/jupikom.v3i1.2524

Abstract

This journal discusses the development of an avocado stock prediction model in Bantul City using the Mamdani fuzzy logic approach. In this context, fuzzy logic is used to address the uncertainty and complexity associated with factors affecting avocado supplies, such as stock variability, demand and price variables. The Mamdani approach is applied to formulate fuzzy rules based on a combination of expert knowledge and historical avocado stock data. This method aims to produce avocado stock predictions that are more accurate and adaptive to market dynamics. Through a series of experiments, the results show that the Mamdani fuzzy logic model has a significant level of accuracy, outperforming traditional stock prediction methods. The results obtained show the potential of this model in improving the efficiency of avocado inventory management at the local level. This research makes an important contribution especially in the context of agribusiness, providing a foundation for a more sophisticated and adaptive prediction approach to avocado fruit stock management. The implications are widely applicable in the agribusiness sector and provide a basis for the development of similar prediction systems for other agricultural commodities.
Application of the Fuzzy Mamdani Method for Predicting Rainfall in the City of Yogyakarta Rohman, Abdul; Tri Hastono; Andri Prisda Tyaka
Jurnal Publikasi Ilmu Komputer dan Multimedia Vol 3 No 1 (2024): Jurnal Publikasi Ilmu Komputer dan Multimedia
Publisher : Pusat Riset dan Inovasi Nasional

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55606/jupikom.v3i1.2544

Abstract

Weather and climate play an important role in everyday life, influencing various aspects of society and the environment. The city of Yogyakarta as a cultural center cannot be separated from the impacts of climate change, including rainfall patterns which can have significant effectiveness on daily activities, agriculture and infrastructure. This research uses a fuzzy logic methodology approach with the Mamdani method to predict rainfall. Fuzzy logic has proven to be effective in cold situations and is able to overcome the challenges of missing or incomplete data. The data used in this research was obtained from Bappeda DIY. The implementation for predicting rainfall levels uses Matlab by utilizing the provided Fuzzy Logic Matlab Toolbox. Based on research conducted using a fuzzy logic test to calculate all research accuracy data, an average error value in RMSE was obtained of 39.88%. These results indicate that there is significant error in these predictions, indicating that the fuzzy logic control model is not completely accurate. Therefore, it is necessary to review the data used in this prediction to ensure its accuracy.
Menerapkan Konsep Logika Fuzzy Dalam Meningkatkan Efisiensi Persediaan Barang Dengan Menggunakan Metode Mamdani Galih Yudhistira; Pika Aliya Widiastuti; Rahyuni; Tri Hastono
Jurnal Publikasi Ilmu Komputer dan Multimedia Vol 3 No 1 (2024): Jurnal Publikasi Ilmu Komputer dan Multimedia
Publisher : Pusat Riset dan Inovasi Nasional

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55606/jupikom.v3i1.2557

Abstract

Jars are one of the handicrafts used as a tool to fulfill daily life, and have social, ritual and artistic values. With good prospects to be developed considering the market potential that is increasingly widespread in its use. So that a good promotional strategy is needed to improve the urn product industry. The method used in this research is Fuzzy Logic Mamdani which can overcome uncertainty and complexity of information in decisions. For data collection in this study, namely by survey or asking directly to the urn seller. The objectives of this study include the application of Mamdani calculations, prediction of urn stock, and guidelines for determining the optimal amount of production. From the calculations obtained, demand increased by (0.029), products sold a lot by (0.105) and inventory increased by (0.222).
Penerapan Logika Fuzzy Sugeno Dalam Memprediksi Besar Komisi Penghasilan Pada Toko Karunia Ijo Di Malang Dimas Maulana Hakim; Tri Hastono; Yanuar Arifia Ranggana
Jurnal Publikasi Ilmu Komputer dan Multimedia Vol 3 No 1 (2024): Jurnal Publikasi Ilmu Komputer dan Multimedia
Publisher : Pusat Riset dan Inovasi Nasional

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55606/jupikom.v3i1.2583

Abstract

Abstract. Karunia Ijo sewing equipment shop in Malang is a place that has an important role in supporting the creative industry, especially in the fields of fashion and handicrafts. In this shop, we find various kinds of sewing equipment that are really needed by professional tailors, hobbyists and convection business people. This research aims to determine the amount of commission at the Karunia Ijo sewing equipment shop in Malang by considering the factors that influence the amount of commission on purchases. This research was conducted using the Sugeno method of fuzzy logic by determining the price of goods, purchase time, and volume of goods as the input, and the amount of commission as the output. The steps taken in this research are determining the degree of membership of each set of input variables which is referred to as fuzzyfication, then determining fuzzy rules, and carrying out fuzzification to get the final value in the form of the output of the purchase commission amount. The test result using Matlab was 5 while the result from manual calculations was 4.81. There is a slight difference, namely a difference of 0.19 but it is still in the large output category.