Article Per Year (5 Year)
p-Index From 2019 - 2024
0.751
P-Index
This Author published in this journals
All Journal Jurnal Pengabdian Nasional ROUTERS: Jurnal Sistem dan Teknologi Informasi
Supriyatna, Agiska Ria
Unknown Affiliation
Agriculture, Biological Sciences & Forestry Computer Science & IT Control & Systems Engineering Economics, Econometrics & Finance Electrical & Electronics Engineering Environmental Science Industrial & Manufacturing Engineering Library & Information Science Social Sciences

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

Found 3 Documents
Search
Journal : ROUTERS: Jurnal Sistem dan Teknologi Informasi

 1 
Migrasi Database, MySQL, Postgre Migrasi Database Mysql Ke Postgresql Pada Aplikasi Sistem Evaluasi Dosen Oleh Mahasiswa (EDOM) Jurusan Ekonomi Dan Bisnis Muhammad Irfan Lutfi; Asrowardi, Imam; Supriyatna, Agiska Ria
ROUTERS: Jurnal Sistem dan Teknologi Informasi Vol. 1 No. 1, Februari 2023
Publisher : Program Studi Teknologi Rekayasa Internet, Politeknik Negeri Lampung

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (672.344 KB) | DOI: 10.25181/rt.v1i1.2699

Abstract

Implementation of Filling Out Lecturer Evaluations by Students (EDOM) which is carried out at the end of each semester during the Semester Final Examination (UAS) activities, has been developed into an online computerized information system using a MySQL database. As the amount of data in the EDOM information system increases, data storage that has a high complexity is needed, so that from the database side it must have high performance and can handle large amounts of data. For the needs of the EDOM information system, MySQL is no longer able to provide its best performance in handling large amounts of data, so a database that has better performance is needed. The purpose of this final project is to Migrate MySQL Database to PostgreSQL on Application System (Evaluation of Lecturers by Students) EDOM Department of Economics and Business, in order to overcome the problem of MySQL database which is no longer able to provide its best performance in handling large amounts of data. The system development method used is the SDLC method. Based on the results of tests carried out by testing query performance on both dbms, PostgreSQL has a stable performance compared to MySQL, at the same amount of data MySQL excels in regular updates and selects without additional clauses. Meanwhile PostgreSQL excels at creating, deleting data and complex join clauses. The next test is carried out on the application using the php function, namely microtime by writing a script at the beginning of the body and before closing the body of the html page on applications that use MySQL and PostgreSQL dbms, carried out to test the speed in loading data in EDOM system applications, the result is that the use of PostgreSQL dbms is faster in load data, because the data is presented using complex join clauses. This is because PostgreSQL supports locking at a lower level, namely row so that it becomes one of the advantages in doing database migration because the business processes in the EDOM System Application are made more effective.
Aplikasi Diagnosa Penyakit Pada Tanaman Kelapa Sawit Berbasis Android Ramadhan, Ahmat Riski; Mustofa, Dimas Ade; Ainuddin, Fadil; Supriyatna, Agiska Ria
ROUTERS: Jurnal Sistem dan Teknologi Informasi Vol. 1 No. 2, Juli 2023
Publisher : Program Studi Teknologi Rekayasa Internet, Politeknik Negeri Lampung

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (769.809 KB) | DOI: 10.25181/rt.v1i2.3069

Abstract

Efforts to boost oil palm production have so far encountered many obstacles, because every plant that grows has the potential to be threatened by pests and diseases, including oil palm plants. The aggressiveness of this disease most often occurs in seedlings transferred to main nurseries. Consulting someone who is an expert in the industry in terms of problem solving is the best way to get answers, but to find someone who is competent in the field is very difficult especially in rural areas. An application to diagnose oil palm diseases was developed to help detect and control oil palm diseases. This application is a program that can replicate the reasoning of an experienced expert in a particular field of knowledge to solve problems like an expert. This application has a goal to be able to help professionals act as experienced and knowledgeable assistants. Data collection techniques for making this application are carried out by consulting literature studies. With this application, it can help oil palm farmers to take early prevention of diseases that attack their plants.
Autentikasi User Dengan Metode Single Sign-On Berbasis Windows Active Directory Pada PT. XYZ Kemas, Kemas Ocha Khairi Saputra; Supriyatna, Agiska Ria; Putra, Septafiansyah Dwi
ROUTERS: Jurnal Sistem dan Teknologi Informasi Vol. 2 No. 2, Juli 2024
Publisher : Program Studi Teknologi Rekayasa Internet, Politeknik Negeri Lampung

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.25181/rt.v2i2.3328

Abstract

To connect to the company network, a WPA2-PSK-based security system is in place, requiring users to input the company Wi-Fi password. One of the issues that arises is the difficulty in identifying the status of users attempting to access the network. Apart from security concerns regarding the network, the use of this security key allows non-employees to connect to the network using personal devices. As a solution to enhance the existing authentication system, security systems like RADIUS can be utilized. This system operates to mitigate threats to the network security. The process undertaken through the implementation of this NDLC method commences with identifying and designing network security authentication, progressing through the implementation phase until the design can be regularly utilized. With the introduction of a user authentication system employing a single sign-on method based on Windows Active Directory at XYZ Inc., users will find it easier to connect to the wireless network. With WPA2-Enterprise, access to the network will be restricted.
Co-Authors Ainuddin, Fadil Asrowardi, Imam Kemas, Kemas Ocha Khairi Saputra Muhammad Irfan Lutfi Mustofa, Dimas Ade Nurul Qomariyah Putra, Septafiansyah Dwi Ramadhan, Ahmat Riski Ridwansyah, Eksa Zuriati, Zuriati