p-Index From 2019 - 2024
0.408
P-Index
This Author published in this journals
All Journal TEPIAN
Raissa Maringka
Amikom University

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

Found 2 Documents
Search

Improving Database Quality by Applying Consistency Aspects to Naming Fields and Tables Raissa Maringka; Aulia Khoirunnita; Rodney Maringka; Ema Utami; Kusnawi
TEPIAN Vol 2 No 1 (2021): March 2021
Publisher : Politeknik Pertanian Negeri Samarinda

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (317.497 KB) | DOI: 10.51967/tepian.v2i1.304

Abstract

The database is one of the benchmarks that affect the quality of information systems. An effective information system certainly has a quality database. Aspects that can be measured to determine the quality of the database are aspects of truth, consistency, range, level of detail, completeness, minimalism, ability to integrate and readability. One of the mistakes that are often encountered in databases is related to the consistency aspect. Consistency aspects that are not paid much attention to its application can lead to data conflicts due to ambiguity and data duplication. This study aims to improve the quality of the database by applying consistency to the naming of fields and tables. A naming method to produce consistency in standardization was applied in this study.
Android App Rating Classification on Google Play Store Using Random Forest Algorithm with SQL Server Preprocessing Raissa Maringka; Aulia Khoirunnita; Rodney Maringka; Erna Utami; Kusnawi
TEPIAN Vol 2 No 2 (2021): June 2021
Publisher : Politeknik Pertanian Negeri Samarinda

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (530.483 KB) | DOI: 10.51967/tepian.v2i2.404

Abstract

The increasing number of Android applications available on the Google Play Store with the benefits the developers get has attracted the attention of many Android application developers. To benefit from developing Android apps, one way is to know the characteristics of highly rated apps on the Google Play Store. This research will investigate the features of size, installs, reviews, type (free / paid), rating, category, content rating, and price on applications on the Google Play Store to determine the characteristics of high-rated applications. This study uses the Random Forest algorithm to identify the most influential features in high ranking applications on the Google Play Store. At the preprocessing stage, this research uses data cleaning methods and data reduction using SQL Server. This study uses feature important to find out the attributes that most influence the high ranking of Android apps on the Google Play Store. To classify high-ranking applications, the authors use 8-fold cross validation using the Random Forest algorithm and get better results than the Gradient Boost, K-NN, and Decision Tree algorithms with an accuracy of 83%. The results of the Random Forest algorithm also have better performance than the algorithm from the previous research conclusions, with a 0.8% increase in accuracy. To classify high-ranking applications, the authors use 8-fold cross validation using the Random Forest algorithm and get better results than the Gradient Boost, K-NN, and Decision Tree algorithms with an accuracy of 83%. The results of the Random Forest algorithm also have better performance than the algorithm from the previous research conclusions, with a 0.8% increase in accuracy. To classify high-ranking applications, the authors use 8-fold cross validation using the Random Forest algorithm and get better results than the Gradient Boost, K-NN, and Decision Tree algorithms with an accuracy of 83%. The results of the Random Forest algorithm also have better performance than the algorithm from the previous research conclusions, with a 0.8% increase in accuracy.