Claim Missing Document
Check
Articles

Found 12 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.
Pelatihan Pemanfaatan Google Classrom Sebagai Media E-Learning Sekolah Tri Hastono; Ari Kusuma Wardana; Firdiyan Syah; Gunawan Gunawan; Ramdan Harjana
Nusantara: Jurnal Pengabdian kepada Masyarakat Vol. 1 No. 1 (2021): Februari: Jurnal Pengabdian Kepada Masyarakat
Publisher : Pusat Riset dan Inovasi Nasional

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (256.379 KB) | DOI: 10.55606/nusantara.v1i1.237

Abstract

The use of information technology in the world of education looks better. With the ease of getting this information, cases of parents who do not know the status of their children's education are increasingly rare. The use of technology in the world of education in teaching and learning activities cannot be done by one party alone. It takes the involvement of all, especially teachers and students. If you look at the age of the teachers, of course, not a few of them can be considered old. This is what makes not a few of the teachers still rigid with technology. But it's a different story with today's school students. The year of birth of school students is currently in the generation Z category, where technology is their lifestyle. The method of transferring knowledge from teachers to students must be changed so that knowledge can be well absorbed by students. This community service aims to provide training on the use of Google Classroom as one of the school's e-learning at SMP N 2 Kasihan.
PELATIHAN E-COMMERSE PADA KELOMPOK WANITA TANI RUKUN SARI, MALANGAN, SRIGADING, BANTUL Tri Hastono; Purnama, Bayu Gilang; Widyawarman, Danang; Pambudi, Brevi Istu
Jurnal Widya Laksmi: Jurnal Pengabdian Kepada Masyarakat Vol. 5 No. 1 (2025): Jurnal WIDYA LAKSMI (Jurnal Pengabdian Kepada Masyarakat) - Inpress
Publisher : Yayasan Lavandaia Dharma Bali

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.59458/jwl.v5i1.119

Abstract

Pengabdian kepada masyarakat ini dilaksanakan di Kelompok Wanita Tani (KWT) Rukunsari, Malangan, Sanden, Bantul, dengan tujuan untuk meningkatkan pengetahuan anggota mengenai strategi penjualan online serta menciptakan toko online yang mendukung pemasaran produk jahe instan. Masalah utama yang dihadapi oleh KWT Rukunsari adalah terbatasnya metode pemasaran yang hanya melalui status WhatsApp, yang menyebabkan jangkauan pasar menjadi sangat terbatas. Metode pelaksanaan kegiatan ini dilakukan melalui pelatihan e-commerce. Pelatihan meliputi pengenalan platform online untuk penjualan, pembuatan toko online, dan cara meningkatkan visibilitas produk melalui media sosial serta platform e-commerce. Pendekatan partisipatif digunakan selama pelatihan, sehingga anggota KWT dapat langsung mempraktikkan pembuatan akun dan toko online. Hasil kegiatan menunjukkan peningkatan pengetahuan dan keterampilan anggota dalam strategi pemasaran online. Selain itu, KWT berhasil menciptakan toko online untuk memasarkan produk jahe instan mereka, yang diharapkan dapat meningkatkan penjualan dan memperluas jangkauan pasar mereka. Dengan adanya toko online ini, produk jahe instan KWT Rukunsari kini lebih mudah diakses oleh konsumen di luar lingkup lokal.
APPLICATION OF FUZZY LOGIC OF THE SUGENO METHOD TO DETERMINE THE AMOUNT OF PRODUCTION OF DRY POTATO SAMBAL Ayup Panjaitan Wicaksana; Tri Hastono; Mirna Septianingrum Solikhah
JTH: Journal of Technology and Health Vol. 2 No. 1 (2024): July: JTH: Journal of Technology and Health
Publisher : CV. Fahr Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.61677/jth.v2i1.121

Abstract

Home industry has become the primary choice in the entrepreneurial world. One example of a home industry is Putro Prasojo's dried cassava chili paste. In the realm of production, this capability involves the skill of planning or determining the production volume. The goal is to ensure that market demand is met accurately while also considering inventory levels to achieve maximum profit. Several factors are considered in determining the production volume, involving an evaluation of the existing inventory and consideration of the demand levels. Facing these challenges, determining the right production volume to meet consumer demand requires alternatives. Applying the Sugeno Fuzzy Method using the MATLAB toolbox. This research is expected to establish an optimal production design. The Sugeno Fuzzy Logic Method used to determine the production volume of Putro Prasojo's dried cassava chili paste based on inventory and demand data can be an effective decision-making tool for the company. This method provides truth values to the decisions made, with a truth value reaching 82.787%.
MOTO BELONG LOSJOYO PRODUCTION QUANTITY PREDICTION SYSTEM USING THE WEB BASED FUZZY TSUKAMOTO METHOD Anjas, Anjas Ari Irawan; Tri Hastono; Fahmi Azkarizal Astrian
JTH: Journal of Technology and Health Vol. 1 No. 3 (2024): January: JTH: Journal of Technology and Health
Publisher : CV. Fahr Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.61677/jth.v2i1.125

Abstract

The Moto Belong Losjoyo factory currently still relies on estimates of production quantities without clear calculations and has not utilized computer technology to process production calculation data. Therefore, the use of the web-based Tsukamoto fuzzy method calculation system is expected to reduce losses due to mismatches in production quantities with market share. This research aims to help the Moto Belong Losjoyo factory in estimating daily production quantities in accordance with market needs. The test results using the Mean Absolute Percentage Error (MAPE) have shown that the system calculation accuracy level is 93.91%, with an error value of 6.09, confirming that the interpretation of the MAPE value shows a high level of accuracy.
SENTIMENT ANALYSIS OF COFFEE SHOP REVIEWS USING RANDOM FOREST CLASSIFIER METHOD Berliana Nur Isnayni; Nurirwan Saputra; Tri Hastono
JTH: Journal of Technology and Health Vol. 1 No. 4 (2024): April: JTH: Journal of Technology and Health
Publisher : CV. Fahr Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.61677/jth.v2i2.152

Abstract

A Coffee shop is a place that serves drinks made from processed coffee grains, various drinks and various snacks to accompany coffee to consumers. Coffee shop reviews can help owners to find out how the community responds to the coffee shop and its services. The data used in this study was 2000 data taken on the old Google Maps Kopi Ampirono by sraping data using Instant Data Sraper. From the abundance of review data, it takes a long time to fully understand the polarity of positive, negative, and neutral reviews manually. Because of this, an accurate sentiment analysis model is needed to classify customer reviews into positive, negative, or neutral reviews. In this study, sentiment analysis used coffee shop reviews using the Random Forest Classifier method. The Preprocessing stage involves the process of case folding, tokenization, stopword removal and stemming. The results of this study are coffee shop reviews of the Random Forest Classifier method classification with an accuracy rate of 79% and a Precision value of 81%, Recall of 97% and while the F1 Score of 88%.