Claim Missing Document
Check
Articles

Implementasi Algoritma K-Nearest Neighbor Pada Database Menggunakan Bahasa SQL Shafira Margaretta; Issa Arwani; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 4 No 7 (2020): Juli 2020
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

Increasing the amount of data stored in the DBMS, resulting in data mining processes less efficiently implemented through machine learning applications. In general, the data mining process is carried out by implementing a number of work steps starting from data cleaning, data integration, data selection, data transformation and then data mining. In this series of steps, there is a process whereby data stored in a database is taken then exported for analysis. Exporting data from a database allows data to be insecure. Implementation of data mining algorithms in the database, is one solution to overcome these problems. In addition, implementing a data mining process on a DBMS can guarantee data security. The Faculty of Computer Science, Universitas Brawijaya has used the DBMS to store and manage student data. The application of data mining processes to predict the success of studies in the academic data of the Faculty of Computer Science is done by replicating the database. In implementing the K-Nearest Neighbor algorithm in the database, the table design stage is carried out by mapping each algorithm using SQL operations. At the design stage, SQL operations are stored in stored procedures. The results of stored procedure execution were tested by comparing the results of the MySQL DBMS system and the results of the WEKA application, obtaining an accuracy of the classification results of 96,94% using a MySQL DBMS and 96,84% using a WEKA.
Pengembangan Data Warehouse untuk Evaluasi Pembelajaran Matakuliah Berdasarkan Data Kuesioner Mahasiswa di SIAM dan Rekapitulasi Presensi Dosen (Studi Kasus Teknologi Informasi Fakultas Ilmu Komputer) Juan Michel Hesekiel; Issa Arwani; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 4 No 7 (2020): Juli 2020
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

In order to make sure the quality of the learning process at Brawijaya University, students are asked to filling out some questionnaire. The questionnaire is filled out by students at the end of the semester online, at the University of Brawijaya (SIAM UB). Data from the questionnaire given by the head of the study program. The recapitulation data of teaching lecturers is also given by the head of the study program. But if you want to analyzed them the processing is still done manually. To obtain this information, a data collection mechanism from 2 or more integrated sources is needed. The data set will then be analyzed to be used as a source of reporting. The results of the analysis can be used as an evaluation for a study program. Therefore we need a solution that help the study program to analyzed data to the maximum. The solution that can be used for handling this kind of problems is data warehouse. To be able to have quality data that will be data warehouse, it needs the Extract, Transform, Loading (ETL) process. There are various kinds of software that handle ETL, one of them is Talend Open Studio. After the ETL is complete, using data visualization tool named Tableau a dashboard will be created. Based on the test results, verification of the ETL in the data warehouse tables was successfully done. The results of validation testing on the dashboard within the data warehouse also display valid status. Then also performed time testing on the ETL. The average time needed to execute ETL with a total of 4,625 rows is + 7 seconds.
Pengembangan Sistem Informasi Pemesanan Paket Wisata (Studi Kasus : Agen Wisata Liburan Sekolah) Rodiah Rodiah; Buce Trias Hanggara; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 4 No 8 (2020): Agustus 2020
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

Liburan sekolah is a travel agency engaged in services, which offer tour packages and guide tourists in visiting the Thousand Islands tours. To make a tour package booking, visitors must contact customer service via telephone or whatsApp and customer service records each order entered manually. This becomes less effective because customer service must reply to every order that comes in and checks every transaction made by a visitor. Based on this we need an information system that can facilitate visitors and customer service in the process of ordering and registering orders. In the process of developing a system used a method that is carried out sequentially or commonly known as the waterfall method. The results of the needs analysis yielded 15 functional needs which were described in the use of case diagrams and the results of system design were described in sequence diagrams, activity diagrams and database modeling. In the process of implementing the system, the Laravel and mysql framework are used for database storage, at this stage 6 controllers are generated. Based on the results of black box testing shows all functions can run well and is declared valid and based on the results of the User Acceptance Testing (UAT) test with 10 respondents producing an index value of 89.6% can conclude the system can be accepted. Based on the results of this study produced a tour package booking information system that can facilitate tourists and admins and the transaction process
Pengembangan Aplikasi Cashless Payment menggunakan Teknologi QR Code berbasis Android pada Kantin Dharma Wanita Filkom UB Kelvin Anggatanata; Widhy Hayuhardhika Nugraha Putra; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 4 No 8 (2020): Agustus 2020
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

Cashless payments are now starting to become a trend that is widely used in various places to make transactions. Cashless payments provide various advantages of cash payments, practical and convenient, time efficiency, no need to count change, easy recording of transactions, and many other advantages of non-cash cash payers. This study aims to develop methods of android-based non-cash payment systems using QR Code in the FILKOM UB canteen. QR Code is data information that has been made into two-dimensional images that can display data in the form of text developed by Denso Wave. QR Code can display information with its users. The Waterfall method is used in system development, which is implemented on the Android platform. The system was developed through several stages that discussed problems, literature study, needs analysis, and system design with the Unified Modeling Language, the implementation of the results of preparations made to Android using the Android SDK, React-native framework, real Firebase database. System testing is done using validation testing with the black box testing method and compatibility testing. The results of this test, obtained a validity level of 100% for 9 functional requirements and applications can be run on different versions of Android.
Pengembangan Website Penjualan Alat Terapi (Studi Kasus: Klinik Physiostore Tulungagung) Norma Desitasari; Buce Trias Hanggara; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 4 No 10 (2020): Oktober 2020
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

Physiostore clinic is a therapy clinic offering therapy services and selling several therapy products. From the beginning, this clinic does not store sales data where every transaction to be recorded manually and ordering products only by phone and there was no recording of patient data coming in for therapy. From these problems, a web-based system that can make it easier for the manager to store patient data and product sales data was created. But also, customers can easily place an order on the website. This website was developed using the laravel framework, the programming language PHP, MySQL, CSS, and javascript. The system development stage starts from the requirement analysis through interviews with the owner of Physiostore where the results of the requirement analysis are illustrated by the use case diagram, use case scenario, and activity diagram. The system design is illustrated by the sequence diagram, class diagram, and physical data model. The website implementation used shipping charges and chatting API. Validation testing of the system gets a percentage 100% valid results where the system complies with the requirements specifications and usability testing was done using the system usability testing (SUS) get an average value 82 where the system categorized on Good with B on value scale and the acceptability range is on acceptable category.
Pemanfaatan Teknologi RESTFul Web Service pada Pengembangan Sistem Informasi Pencatatan Nilai Kelulusan PK2MABA di Fakultas Ilmu Komputer Universitas Brawijaya Khairi Ubaidah; Issa Arwani; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 5 No 1 (2021): Januari 2021
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

New students orientation (PKKMB) is an activity carried out to help new students to be oriented towards new levels of education in college life. Faculty of Computer Science (FILKOM) Universitas Brawijaya through Article 27 Guidelines of regulations which obliges students to take part in the PKKMB series and makes student graduation from the PKKMB series a requirement to be able to measure the thesis exam. With the urgency related to the PKKMB passing status which is so crucial, an information system is needed to manage the PKKMB scores. However, the current condition of the PKKMB value management information system is still not optimal. Because the scores archiving process is done manually by sending it on the Google Sheets application page. In addition, the existing data is still not well organized, making it difficult to validate the PKKMB graduation status. From these problems, this research was carried out with the aim of recording information systems PK2MABA passing scores by utilizing RESTful Web Service technology. By using Laravel as a system development framework on the web platform and Lumen as a REST API development framework, the system has been developed and tested with the Blackbox testing method which produces a proportion of 100%, as well as testing the System Usability Scale with a value of 88.75 which means this system is in on a scale of value B with the category of Excellence.
Pemanfaatan Teknologi RESTFul Web Service pada Pengembangan Sistem Informasi Penilaian Probinmaba (Startup Academy) (Studi Kasus: Fakultas Ilmu Komputer Universitas Brawijaya) Alfa Fadlilah; Issa Arwani; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 5 No 1 (2021): Januari 2021
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

The New Student Development Program (Startup Academy) is an introduction to campus life in the Faculty of Computer Science (FILKOM). Students who do not pass the Startup Academy cannot become members or administrators of Student Organizations in the Faculty of Computer Science. The difficulty in accessing this data has caused several institutions to continue recruiting students who did not pass Probinmaba (Startup Academy) because they did not know their graduation status. This caused the values ​​that were expected to be conveyed to new students in the Student Orientation to be meaningless and many laws were violated by the organization management and the new students themselves. Based on these problems, one effort that can be done is to build a system as an assessment information center that can help institutional administrators in accessing student graduation data. The system built also aims to make it easier for the executive committee to manage assessment data from year to year and general students to find out the details of the value and archive of their graduation certificates. The API that was built is intended for institutions that want to integrate the admission selection system for the management with existing graduation data. To test whether the system being developed meets the needs, a REST API, functionality, compatibility and usability test is carried out. The success rate of the test is 100% valid. This system is acceptable and according to user requirements.
Klusterisasi Popularitas Artist pada Playlist Today's Top Hits Menggunakan Metode K-Means dengan Integrasi Spotify Web API dan Teknologi Amazon SageMaker Buchori Anantya Firdaus; Dian Eka Ratnawati; Buce Trias Hanggara
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 5 No 1 (2021): Januari 2021
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

In a high-volume market like Spotify, it's important to understand what makes an artist valuable. One way to measure the success of a song or album is to check the rankings and charts. Spotify, for example, publishes several charts. Notably, Today's Top Hits, the first number one playlist in the Spotify ecosystem, has 18.2 million followers (about 7.5 million more than the second place playlist, Spotify Global Top 50), and has about 2.5 million daily active listeners. The use of the K-Means Algorithm because this method can handle large music data effectively. The results of the clustering are expected to be used for Record Labels in showing the proportion of Artist popularity that is included in the Today's Top Hits Playlist which is expected to find out what percentage of an Artist who has a certain followers and popularity to enter the Playlist, or maybe to find out the Artist segmentation on the Playlist. As a result, in the clustering process using the K-Means method, it was found that the proportion of artists on Today's Top Hits Playlist was 28.79% for Very Popular, 42.42% for Popular, 28.79% for Unpopular. Meanwhile, in the cluster testing process using the Silhouette Coefficient, the value is 0.536, which means that the results of the cluster are well formed. Meanwhile, using the Davies-Bouldin Index shows the value is 0.554, which means that the results of the cluster are well formed too.
Analisis Sentimen Pada Media Sosial Twitter Terhadap Undang-Undang Cipta Kerja Menggunakan Algoritma Backpropagation dan Term Frequency-Inverse Document Frequency Muhammad Kevin Sandryan; Bayu Rahayudi; Dian Eka Ratnawati
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 5 No 2 (2021): Februari 2021
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

Social media is a platform for people to sharing their views on certain things or events. One of the things discussed on social media is the Job Creation Law (UU Cipta Kerja). The Job Creation Law is a law that simplifies regulations related to licensing activities in starting a business and investing with the aim of increasing Indonesia's economic growth. Twitter is a social media where many users share their opinions regarding the Job Creation Law. Therefore, Twitter can be a source for analyzing user opinions regarding the Job Creation Law. This research was conducted to analyze the sentiment on tweets (a term for content uploaded to Twitter) regarding the Job Creation Law by classifying tweets into two categories, positive and negative sentiment. The classification process is done by implementing an Artificial Neural Network (ANN) trained by Backpropagation algorithm and term weighting using Term Frequency-Inverse Document Frequency (TF-IDF) method into Python. There are several stages in this study, there are data scrapping, data labeling, preprocessing, term weighting, training, testing, and performance evaluation. The best performance obtained by the ANN is 95% accuracy, 98% precision, 92.4% recall, and 95.1% f-measure. This value was obtained when the ANN trained with 1500 epochs, 1 hidden layer with 50 hidden nodes, and 0.2 learning rate
Klasifikasi Fungsi Senyawa Aktif berdasarkan Notasi Simplified Molecular Input Line Entry System (SMILES) menggunakan Metode Random Forest Faiz Anggiananta Winantoro; Dian Eka Ratnawati; Syaiful Anam
Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Vol 5 No 4 (2021): April 2021
Publisher : Fakultas Ilmu Komputer (FILKOM), Universitas Brawijaya

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

Abstract

A compound is a single substance composed of two or more elements that form chemical bonds. There are two types of compounds, namely active compounds and inactive compounds. Active compounds are compounds that have physiological effects on other organisms. In Indonesia, there are still many active compounds whose function is unknown. Therefore, a classification method is needed to help determine the function of the active compound. Classification is done with data written in SMILES notation. From the SMILES notation, features such as the number of atoms B, C, N, O, P, S, F, Cl, Br, I, OH, =, #, @, -, +, COC, C = C, are taken. O-], N +, C = O, and () go through the preprocessing process. Before being used for the classification process, all these features are divided by the length of the SMILES notation to get their value. This research was conducted to classify the function of active compounds by applying the Random Forest (RF) method with the SMILES data object with 4 classes of compound functions. RF was chosen because this method has almost no overfitting conditions, is able to handle data with many features, and this method is not affected by datasets that have missing values. The best accuracy resulted in testing with 4 class data is 69% and the best average in testing with the K-Fold Cross Validation method is 63%. Then, on the data with 3 classes of compound functions, the best accuracy is 76% and the best average in testing with the K-Fold Cross Validation method is 70%. Finally, testing data with 2 classes of compound functions produces the highest accuracy of 86% and the best average of 80%.
Co-Authors Abdurrahman Airlangga, Aria Abhiram, Muhammad Tegar Achmad Arwan Achmad Ridok Achmad, Riza Putra Adhitya, I Made Yoga Adrian Firmansah, Dani Afif Ridhwan Afrida Djulya Ika Pratiwi Agus Wahyu Widodo Agustin Kartikasari Ahmad Afif Supianto Akbar, Rozaq Aldy Satria Alfa Fadlilah Alifah, Syafira Almira Syawli, Almira Alvian Akmal Nabhan Amonito, Kurnia Ana Mariyam Puspitasari Anak Agung Bagus Arisetiawan Anam, Syaiful Ardhiansyah, Muhammad Hanif Arief Andy Soebroto Arif Pratama Asmoro, Priandhita Sukowidyanti Asroru Maula Romadlon Audia Refanda Permatasari Ayu Dwi Lestari, Cynthia Ayulianita A. Boestari Azizul Hanifah Hadi Bayu Rahayudi Bayu Satriawan, Eka Bayu Septyo Adi Bella Krisanda Easterita Bening Herwijayanti Berton, Freddy Toranggi Buce Trias Hanggara Buce Trias Hanggara Buchori Anantya Firdaus Budi Darma Setiawan Cahyo Gusti Indrayanto Candra Dewi Dany Primanita Kartikasari Darma Setiawan, Budi Darmawan, Riski Davia Werdiastu Denny Manuel Yeremia Sinurat Deny Tisna Amijaya, Fidia Devi Nazhifa Nur Husnina Dewi Yanti Liliana Dhiva Mustikananda Dimas Diandra Audiansyah Dimas Fachrurrozi Azam diniyah, zubaidah Diva, Zahra Djoko Pramono Dwi Ari Suryaningrum Dwi Febry Indarwati Dwi Purwono, Prayoga Dwija Wisnu Brata Dyva Pandhu Adwandha Dzulkarnain, Tsania Dzulkarnain, Tsania - Easterita, Bella Krisanda Edgar Maulana Thoriq Edy Santoso Elfa Fatimah Ema Agasta Entra Betlin Ladauw Eva Agustina Ompusunggu Fadhil, Muhammad Farrasseka Fadila, Putri Nur Faiz Anggiananta Winantoro Fanka Angelina Larasati Fathin Al Ghifari Fatthul Iman Fauzan Dwi Kurniawan, Fauzan Dwi Fauzidan Iqbal Ghiffari Figgy Rosaliana Firdaus, Muhammad Fariz Fitra Abdurrachman Bachtiar Fitri Dwi Astuti Fitria Yesisca Fitria, Tharessa Ghani Fikri Baihaqi glenando Gusti Ngurah Wisnu Paramartha Hadi Wijoyo, Satrio Hamas, radityo Hana Chyntia Morama Hanggara, Buce Trias Hanifa Maulani Ramadhan Haris Haris, Haris Harris Imam Fathoni Hasibuan, Herida Hafni Hasibuan, Raka Ardiansyah Heru Nurwasito Hilal, Khaliffman Rahmat Hilmy Ramadhan, Achmad Zhafran Huda Minhajur Rosyidin I Dewa Gede Ngurah Bramasta Darmawan Ibnu Aqli Ibnu Aqli, Ibnu Ibrahim Kusuma Ilyas, Muhaimin Imam Cholissodin Imam Cholissodin Imam Cholissodin Immanuel Tri Putra Sihaloho Indriati ., Indriati Indriati Indriati Ismiarta Aknuranda Issa Arwani Issa Arwani Isti Marlisa Fitriani Izza, Aisyah Nurul Jesika Silviana Situmorang Jibril Averroes, Muhammad Juan Michel Hesekiel Kartika, Annisa Wuri Kelvin Anggatanata Kevin Renjiro Khairi Ubaidah Khoba, Ahmad Faiz Khofifatunnabilah, Khofifatunnabilah Kirana, Urdha Egha Krishna Febianda Kusuma, Salsabila Azzahra' Zulfa Lailil Muflikhah Leonardo, Ryan Luqman Rizky Dharmawan M. Ali Fauzi Madjid, Marchenda Fayza Maghfiroh, Sofita Hidayatul Mahendra Data Mahendra Data Mala Nurhidayati Maliha Athiya Rahmani Marji . Marji Marji Marji Marji Marji Marji Maulana Syahril Ramadhan Hardiono Michael Eggi Bastian Mochammad Iskandar Ardiyansyah Rochman Moh Fadel Asikin Muh. Arif Rahman MUHAJIR Muhammad Iqbal Mustofa Muhammad Kevin Sandryan Muhammad Reza Utama Pulungan Muhammad Tanzil Furqon Muhyidin Ubaiddillah Muslimah, Fakhriyyatum Muthia Maharani Nabilah Iftah Nella Naily Zakiyatil Ilahiyah Nanang Yudi Setiawan Nanang Yudi Setiawan Nanda Alifiya Santoso Putri Nanda Petty Wahyuningtyas Nilna Fadhila Ganies Norma Desitasari Novirra Dwi Asri Nugraha Perdana, Aditya Nugraheni, Miftakhul Fitria Nur Adli Ari Darmawand Nur Khilmiyatul Ilmiyah Nuraini Anitasari Nuralam, Inggang Perwangsa Nurul Hidayat Nyimas Ayu Widi Indriana Oceandra Audrey Pandu Adikara, Putra Pangestu Ari Wijaya Panjaitan, RE. Miracle Prahesti, Suherni Prakoso, Ricky Pratomo Adinegoro Priyono, Mochammad Fajri Rahmatullah Rendra Puji Indah Lestari Purnomo, Welly Putra Pandu Adikara Putra, Alland Rifqy Putri, Nindy Alya Rachmad, Zikfikri Yulfiandi Raden Rizky Widdie Tigusti Rahma, Dzakiyyah Afifah Rahmah, Yusriyah Raisha, Serefika Raja Farhan Ramadha Pohan Rama Humam Syarokha Randy Cahya Wihandika Rani Metivianis Ratih Diah Puspitasari RE. Miracle Panjaitan Rekyan Regasari Mardi Putri, Rekyan Regasari Mardi Retno Indah Rokhmawati, Retno Indah Revi Anistia Masykuroh Rifqi Irfansyah, Nandana Rizal Setya Perdana Rizal Setya Perdana Robiata Tsania Salsabila Aditya Putri Rodiah Rodiah Ryan Leonardo Salsabillah, Dinar Fairus Saparila Worokinasih Saputro, Dimas Sarie, Riza Athaya Rania Satriawan, Eka Bayu Satrio Agung Wicaksono Satrio Hadi Wijoyo Sema Yuni Fraticasari Setiawan, Alexander Christo Setya Perdana, Rizal Setyowati, Andri Shafira Margaretta Sherly Witanto Sherryl Sugiono Sindarto Sigit Pangestu Silvia Ikmalia Fernanda Siregar, Fauziah Syifa R. Siti Fatimah Al Uswah Sobakhul Munir Siroj Sormin, Hartati Penta Angelina Sri Indrayani, Sri Suhhy Ramzini Sukmawati, A'inun Sutrisno Sutrisno Sutrisno, Sutrisno Syaiful Anam Syifa Namira Neztigaty Thifal Fadiyah Basar Titis Sari Kusuma Ulfa Lina Wulandari Utomo, Yoga Cahyo Vina Adelina Welly Purnomo Wibowo, Shinta Dewi Putri Widhy Hayuhardhika Nugraha Putra Wijanarko, Rizqi Winda Fitri Astiti Winurputra, Raihan Wiratama Paramasatya Yahya, Faiz Yolanda Nailil Ula Yudi Setiawan, Nanang Yuita Arum Sari Yunita Dwi Alfiyanti Yure Firdaus Arifin Zahra, Wardah