Article Per Year (5 Year)
p-Index From 2021 - 2026
8.777
P-Index
This Author published in this journals
All Journal Jurnal Ilmiah Informatika Komputer Techno.Com: Jurnal Teknologi Informasi Jurnal Informatika dan Teknik Elektro Terapan JAIS (Journal of Applied Intelligent System) SELAPARANG: Jurnal Pengabdian Masyarakat Berkemajuan Batoboh : Jurnal Pengabdian Pada Masyarakat JURIKOM (Jurnal Riset Komputer) Jurnal Manajemen Informatika Jurnal Kridatama Sains dan Teknologi Jurnal Manajemen Informatika dan Sistem Informasi JATI (Jurnal Mahasiswa Teknik Informatika) Jurnal Sistem Komputer & Kecerdasan Buatan Parameter BERNAS: Jurnal Pengabdian Kepada Masyarakat Jurnal Sistem Informasi dan Sistem Komputer Jurnal Teknik Informatika (JUTIF) Jurnal AbdiMas Nusa Mandiri JURNAL REKAYASA INFORMASI SWADHARMA (JRIS) JURNAL ELEKTRO DAN INFORMATIKA SWADHARMA (JEIS) Jurnal Pengabdian Teknologi Tepat Guna Jurnal Difusi Jurnal Pengabdian Masyarakat IPTEK Seminar Nasional Hasil Riset dan Pengabdian (SNHRP) Journal of Economic, Business and Engineering (JEBE) Jurnal Pengabdian kepada Masyarakat Desa (JPMD) Toba: Journal of Tourism, Hospitality, and Destination Dulang: Jurnal Pengabdian Kepada Masyarakat PROSISKO : Jurnal Pengembangan Riset dan observasi Rekayasa Sistem Komputer Journal of Artificial Intelligence and Engineering Applications (JAIEA) Jurnal Sains Informatika Terapan (JSIT) Jurnal Pengabdian Masyarakat Fakultas Teknik: Jurnal Abditek Abdi Makarti Jurnal Pengabdian Masyarakat Bhinneka SAINSTECH: Jurnal Penelitian dan Pengkajian Sains dan Teknologi Dharma Pengabdian Perguruan Tinggi (DEPATI) Journal of Artificial Intelligence and Digital Business Mestaka: Jurnal Pengabdian Kepada Masyarakat Innovative: Journal Of Social Science Research TAMIKA: Jurnal Tugas Akhir Manajemen Informatika & Komputerisasi Akuntansi Journal of Data Science Theory and Application AL-KARIM: Journal of Islamic and Educational Research Jurnal Pengabdian Kepada Masyarakat (JPKM) Al-Nizam: Indonesian Journal of Research and Community Service Jurnal Intelek Dan Cendikiawan Nusantara EDUJAVARE: International Journal of Educational Research Jurnal Tarreang: Tren Pengabdian Masyarakat Agrokompleks Inovasi Gagasan Abdimas & Kuliah Kerja Nyata WISDOM : Jurnal Pengabdian Kepada Masyarakat Wisdom LogicLink: Journal of Artificial Intelligence and Multimedia in Informatics Fundamentum: Jurnal Pengabdian Multidisiplin Academic Journal of Islamic Principles and Philosophy Jurnal Pengabdiaan Masyarakat Larisma Journal of Community Research & Engagement (JCRE) Jipmas : Journal Inovasi Pengabdian Masyarakat DCS: Jurnal Pengabdian Masyarakat Man-Ana Smart Humanity: Jurnal Pengabdian Masyarakat JES-TM Social and Community Service Jurnal Teknologi Pendidikan Kolaborasi Masyarakat NJCOM: Community Service Journal BHAKTI Bhinneka Al-Madrasah: Jurnal Pendidikan, Pembelajaran dan Kebudayaan
Imam Prayogo Pujiono
Universitas Islam Negeri K.H. Abdurrahman Wahid Pekalongan
Religion Agriculture, Biological Sciences & Forestry Arts Humanities Automotive Engineering Biochemistry, Genetics & Molecular Biology Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Dentistry Economics, Econometrics & Finance Education Electrical & Electronics Engineering Energy Engineering Environmental Science Health Professions Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Mathematics Mechanical Engineering Medicine & Pharmacology Neuroscience Nursing Physics Public Health Social Sciences Veterinary Other

Published : 74 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 74 Documents
Search

 4   5   6   7   8 
QUERY OPTIMIZATION ON SEMI STRUCTURED MYSQL RETAIL DATA USING GENERATED COLUMNS Adi Handika; Muqtafiy Muhammad; Muhammad Azka Bani Shalih; Nabil Yudha Syahputra; Imam Prayogo Pujiono
Jurnal Manajemen Informatika dan Sistem Informasi Vol. 9 No. 2 (2026): MISI Juni 2026
Publisher : LPPM STMIK Lombok

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.36595/misi.v9i2.2058

Abstract

This study compares query performance among three data storage models in MySQL: the relational model (retail_relational), the unoptimized JSON model (retail_json_raw), and the JSON model with generated columns and indexes (retail_json_gc). The dataset used is a public retail transaction dataset containing more than one million records with eight attributes including Invoice, StockCode, Description, Quantity, InvoiceDate, Price, Customer ID, and Country. Four query scenarios were tested: filtering by country, searching by stock code, filtering by price range, and grouping by country for revenue aggregation. Each query was executed ten times and analyzed using EXPLAIN to observe the execution plan. Results show that the JSON_GC model consistently achieves the fastest execution time across all scenarios. For the stock code filter query, JSON_GC achieves an average of 0.006 seconds compared to 1.577 seconds for the relational model and 1.950 seconds for JSON_Raw. For the GROUP BY aggregation query, JSON_GC requires only 0.002 seconds compared to more than 1.6 seconds for both other models. This performance difference is due to generated columns supporting index scans and covering indexes, preventing MySQL from performing full table scans. The JSON_Raw model is consistently the slowest due to the overhead of JSON_EXTRACT functions and the inability to be directly indexed. This study concludes that generated columns are a highly effective optimization strategy for managing semi structured JSON based data in MySQL.
OPTIMALISASI BASIS DATA SISTEM KEUANGAN UMKM PIZZAUPPS UNTUK MENGATASI REDUDANSI DAN ANOMALI DATA Muhammad Faiz; Karunia Raharjo; Muhammad Agus; Muhammad Zidni Nur; Dicky Anggriawan Nugroho; Imam Prayogo Pujiono
JRIS : Jurnal Rekayasa Informasi Swadharma Vol 6, No 1 (2026): JURNAL JRIS EDISI JANUARI 2026
Publisher : Institut Teknologi dan Bisnis (ITB) Swadharma

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.56486/jris.vol6no1.1049

Abstract

Digital financial systems are crucial for MSMEs to improve the efficiency and accuracy of record-keeping. Unfortunately, many MSMEs, including PizzaUpps, still rely on poorly structured flat-file record-keeping systems. This condition causes serious problems, such as duplication of customer and product data, and inconsistencies in transaction information, due to the lack of integrity controls in their databases. To address this, this study aims to redesign and optimize the database architecture of PizzaUpps’ financial system. Using the Waterfall model, the main methodology is database normalization, which transforms the data structure from unnormalized form (UNF) to Third Normal Form (3NF) and Boyce-Codd Normal Form (BCNF). The results show that the normalization process successfully produces a new, structured relational database design. This design consists of interconnected main tables, including Customer, Product, Transaction, and Transaction_Detail, and is supported by an Entity Relationship Diagram (ERD) and a validated physical relationship schema. Foreign keys and referential integrity constraints ensure data integrity across tables. The proposed database design proved effective in eliminating data redundancy and anomalies, significantly improving the accuracy, consistency, and integrity of PizzaUpps’ financial data. This design is highly recommended as a basis for developing a more comprehensive digital financial or accounting information system in the future.Peran sistem keuangan digital sangat krusial bagi UMKM untuk meningkatkan efisiensi dan keakuratan pencatatan. Sayangnya, banyak UMKM, termasuk PizzaUpps, masih mengandalkan sistem pencatatan flat-file yang tidak terstruktur dengan baik. Kondisi ini menyebabkan masalah serius seperti duplikasi data pelanggan dan produk, serta inkonsistensi informasi transaksi, karena tidak adanya kontrol integritas pada basis data mereka. Untuk mengatasi hal ini, penelitian ini bertujuan untuk merancang ulang dan optimalisasi arsitektur basis data sistem keuangan PizzaUpps. Menggunakan model Waterfall, metodologi utamanya adalah normalisasi basis data, yaitu mentransformasikan struktur data dari bentuk tidak ternormalisasi (UNF) menjadi Third Normal Form (3NF) dan Boyce-Codd Normal Form (BCNF). Hasil penelitian menunjukkan bahwa proses normalisasi berhasil menciptakan desain basis data relasional yang baru dan terstruktur. Desain ini terdiri dari tabel-tabel utama yang saling terhubung, seperti Pelanggan, Produk, Transaksi, dan Detail_Transaksi, dan dilengkapi dengan Entity Relationship Diagram (ERD) serta skema relasi fisik yang tervalidasi. Integritas data antar tabel dijamin melalui penggunaan foreign key dan batasan integritas referensial. Desain basis data yang diusulkan terbukti efektif dalam menghilangkan redundansi dan anomali data, secara signifikan meningkatkan akurasi, konsistensi, dan integritas data keuangan PizzaUpps. Desain ini sangat direkomendasikan sebagai dasar untuk pengembangan sistem informasi keuangan atau akuntansi digital yang lebih lengkap di masa depan.
Hybrid Cryptography-Steganography Scheme Based on Camellia-256 and LSB for Enhanced Security and Imperceptibility of Secret Messages Imam Prayogo Pujiono; Eko Hari Rachmawanto; Christy Atika Sari; Said Fachri Ariza; Isnaeni Kholifatun
Jurnal Teknik Informatika (Jutif) Vol. 7 No. 3 (2026): JUTIF Volume 7, Number 3, June 2026
Publisher : Informatika, Universitas Jenderal Soedirman

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

Abstract

The development of digital communications has increased the risk of message interception and manipulation, necessitating robust and multi-layered security solutions. This research designs, implements, and evaluates a multi-layered security scheme that integrates cryptography and steganography. The proposed method first encrypts the secret message using the Camellia-256 algorithm in Electronic Codebook (ECB) mode with PKCS#7 padding. The resulting ciphertext is then embedded into the cover image using the Least Significant Bit (LSB) steganography technique. From a practical standpoint, this design provides defense-in-depth for covert communication: encryption preserves confidentiality even if the hidden payload is detected, while steganography reduces the likelihood that the encrypted content is flagged during transmission. This combination mitigates LSB’s weakness against statistical steganalysis by encrypting the payload into ciphertext, thereby reducing structured bit patterns that may otherwise facilitate statistical detection. System performance is quantitatively evaluated using two primary metrics: the Avalanche Effect to measure cryptographic strength and the Peak Signal-to-Noise Ratio (PSNR) to measure the visual imperceptibility of the stego-image. The experimental results demonstrate excellent cryptographic strength, evidenced by an average Avalanche Rate of 54.37%, indicating that minimal changes to the input result in significant changes to the output. Furthermore, the scheme exhibits excellent visual imperceptibility with an average PSNR of 75 dB, making the stego-image visually indistinguishable from the original cover image. It is concluded that the proposed hybrid scheme offers a robust and validated solution for secure message communication, combining content confidentiality through cryptography and message obfuscation through steganography, thus providing dual protection against cybersecurity threats.
Pelatihan sistem akuaponik berbasis sumbu menggunakan limbah di Desa Simbang Wetan, Kabupaten Pekalongan: Training on a wick-based aquaponics system using waste materials in Simbang Wetan Village, Pekalongan Regency Imam Prayogo Pujiono; Kuat Ismanto; Syifa Rohmah; Arditya Prayogi; Akhmad Aufa Syukron; Suharyadi Suharyadi
Jurnal Tarreang: Tren Pengabdian Masyarakat Agrokompleks Vol. 2 No. 2 (2025): Jurnal Tarreang
Publisher : Agriculture and Forestry Faculty, Universitas Sulawesi Barat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31605/jtarreang.v2i2.5895

Abstract

Simbang Wetan Village faces a dual challenge: the accumulation of unmanaged flannel waste from the local convection industry and the need to enhance household-level food security. This community service activity aimed to transfer appropriate technology in the form of an innovative aquaponics wick system that utilizes flannel waste as a key functional component. The method employed a participatory learning approach, combining presentations, hands-on practice, and discussions. This activity was conducted on September 8, 2025, at the Simbang Wetan Village Hall, involving 24 residents. The program's success was measured quantitatively using pre-test and post-test instruments. Data analysis revealed a highly significant improvement in understanding and skills. Specific knowledge regarding the function of flannel fabric as an aquaponics wick surged dramatically from 8.3% in the pre-test to 100% in the post-test. Similarly, practical understanding of assembling the system from recycled materials increased from 4.1% to 87.5%. These results indicate that the workshop was highly effective in transferring knowledge and shifting the community's paradigm towards waste management. The broader adoption of this technology at the household level, along with continuous mentoring, is recommended to ensure program sustainability.
Co-Authors A'izatul Haira, Nala Abdi Cahya Subekti Abdul Majid Abu Hanif I. F. Adhiel, Adhiel Rahma Adi Handika Agung Bakti Agung Prihandono Agustin, Amelya Agustina, Risma Wati Agyztia Premana Ahmad Abdussalaam Ahmad Aufal Marom Ahmad Burhanuddin, Ahmad Ahmad Ta'rifin Ahmad Turmudi Aisyah Aisyah Ajib Susanto Akhmad Aufa Syukron Alfisyah, Ahmad Alfiyan Firmansyah Amanda, Salsabila Ammarulloh, Satriaji Anastasya, Lilina Dwi Andy Rachman Anugrah, Anggita Dwi Anwar, M. Shokhib Anzaini, Sayla Salma Apriani, Nadisa Ardansyah , Dawam Ardhiartha P.U., Surya Arditya Prayogi Arum, Dewi Sekar Asfahani, Asfahani Aulia Miza, Nur Ayon Diniyanto Azazi, Firly Maulana Azzahrani, Hafizhah Bagus Prasetyo Santoso Bangkit Rizka Hidayatullah Berliannanda, Anugrah F. Brilianu Sentanu Vito Christy Atika Sari Christy Atika Sari Darutama, Ardiyan Dea Karuniawati Desi Lestari, Desi Desta Adyangga Saputra Diah Puspitaningrum Dian Sukmawati Sudrajat Dicky Anggriawan Nugroho Dicky Anggriawan Nugroho Edi Suharyadi Eka Puji Rahayu Eko Hari Rachmawanto Eko Hari Rachmawanto Elvina Rizqi Emi Nurlaela Erwin Erwin Fachri Ali Fachri Ariza, Said Fadilah Zahra Dwi Kinanti Fadilah, Gita Fasyih, Muhammad Rofi Nur Fatkhatun Naela Ferida Rahmawati Fiantika Mutia Rahma Fida Maisa Hana Firda Aulia Izzati Firdausi, Muh Izzat Firdausi, Muhammad Izzat Fitroh, Qorry Aina Furqon Lanang Galang Satya Aulia Habibah, Adinda Destiani Haiqa Virly Azzahra Hakim Elkominoki, M. Lukman Hamdi Yahya, Muhammad Handika, Adi Hikmah Sofyan, Nurul Himawan, Inggil Ibnu Utomo Ihsan, Fuad Naufal Ihsanul Ahadin, Akbar Ikhsan Maulanaa Ikhsanuddin, Rohmatulloh Muhamad Imas Saffanatul Aminah Imtinan Hanazain Indra Kurniawan Irfan Ali, Muhammad Isnaeni Kholifatun Jainul Arifin Karima, Rizqi Karunia Raharjo Khotimah, Nur Kuat Ismanto Kuat Ismanto Lilik Riandita Lukman Shodik M. Adin Setyawan M. Akmal Fatkhan Rifqi M. Arsyad Alkadafi M. Azka Failandri M. Syaifuddin Maesyaroh Mochamad Iskarim Moh. Syaifuddin Mohammad Syaifuddin Mualim, Mualim Mufidah, Haniatul Muhamad Ridwan Muhammad Agus Muhammad Anifan Muhammad Azka Bani Shalih Muhammad Fabian Ardhiansyah Muhammad Faiz Muhammad Rikzam Kamal Muhammad Rikzam Kamal Muhammad Risqi Agung Pratama Muhammad Rofi Nur Fasyih Muhammad Yusuf Rusty Al Badar Muhammad Zidni Nur Muqtafiy Muhammad Musyaffa, Muhammad Zaki Mutiara Sofia Ramadhani Nabil Yudha Syahputra Nadia Faradhillah, Nadia Naila Mifrotul Ula Nazwa, Nazwa Gista Aulia Nisa , Nabila Luthfiyatun Noorma Fitriana M. Zain Nugroho, Dicky Anggriawan Nur Fatikhatul Jannah Nur Fatmaluna, Shabina Nuril Lutvi Azizah Nurul Hikmah Sofyan Nurwijayanti Oktaviani, Linda Pasha Ferbitama Pasha Ferbitama Perdana, Firdaus Prabowo, Dimas Setiaji Pratomo Cahyo Kurniawan Purnamasari, Nafisa Putri, Adhystha Az-Zahra Putri, Pramesti Fadhila Pamuji Qurrota A’yun Raharjo, Karunia rahayu, eka puji Rahmawan Bagus Trianto Rakhiel Ghina Suraya Rangga Dzikri Fardiarsyah Rhischa Assabet Shilla Rhischa Assabet Shilla, Rhischa Assabet Riandita, Lilik Richa Qonitatin Lazaba Riki Nasrullah Riki Nasrullah Riki Nasrullah Riyadi, Ridho Rizal, Muhamad Rizaludin Rizki Ramadani Rofiah, Nurul Hidayati Rohmad Abidin Rohmah, Syifa Rohmatulloh Muhamad Ikhsanuddin Sabrina, Arum Rahma Putri Saffanatul Aminah, Imas Safinatunaja , Dhifa Said Fachri Ariza Saizi, Muhammad Salman Salma, Salma Aulia Shofiani, Rissa Singgih Setiawan Singgih Setiawan Singgih Setiawan Sofia, Lailatul Sofiana, Sofa Sopiah, Sopiah suharyadi suharyadi Sulistia, Fira Syaifuddin, Moh Syaifuddin, Moh. Syifa Rohmah Sylva Fahri Nailannaja Syukron, Akhmad Aufa Tiara Ananda Maulidia Tsalisa Yuliyanti Turmudi, Ahmad Ummy Fatimah Utomo, Surya Ardhiartha Putro Vierri Daffa Alief Widodo Hami Widodo Hami Wijanarto Wijanarto Winarsih, Nurul Anisa Sri Yasmin, Nazhifa Naura Yoga Religia Zahwa Arizza Arthamevia Zuhrufillah, Khafifah Zulmi Aulia Azhari Abbas