Arcitech: Journal of Computer Science and Artificial Intelligence
To process data in RDBMS, it is commonly used what is called SQL. This SQL can be simple or compl... more To process data in RDBMS, it is commonly used what is called SQL. This SQL can be simple or complex depending on the join statement, the tables involved, filter statement, and many more. If it is complex and burdensome to the system, then the performance of the database as a whole will decrease and SQL execution will not finish. That's why it's important to know, what components are involved when executing SQL through the SQL Execution Plan. The components in the SQL Execution Plan can be very diverse, so artificial intelligence is used to help analyze and conclude what factors have the most role in determining performance. Furthermore, these factors are called feature engineering. The purpose of this research is to formulate what features exist in the SQL Execution Plan when we send SQL commands to the system. The research method used is the Prototyping process model.
Arcitech: Journal of Computer Science and Artificial Intelligence
A collection of data stored in a database, so the longer the data, the bigger the data, because t... more A collection of data stored in a database, so the longer the data, the bigger the data, because the data processed is very large, processing time in Apache Spark can take up to a dozen or tens of hours. Sometimes, the Apache Spark application even fails. Therefore, to minimize the waiting time that could have been avoided or reduced, artificial intelligence through Machine Learning will be used to detect whether an Apache Spark application will fail or run smoothly. Factors to determine this failure are called features and are generated through the feature engineering process. The purpose of this research is to design Machine Learning so that it is able to find out what features will determine the success or failure of the Apache Spark application. The research method used is the Prototyping process model.
Arcitech: Journal of Computer Science and Artificial Intelligence, 2021
In a condition the administration / admin of the company found problems with data at the time of ... more In a condition the administration / admin of the company found problems with data at the time of data collection, problems that arose related to the complexity of making monthly reports that contained data duplication, the occurrence of loss of outlet goods, selection of goods that took a long time to make reports. The purpose of this study is to design a web-based and android-based stock zoning application system with the waterfall method so that it is expected to make it easier for admins and technicians in administrative problems, especially in stock zoning and lost goods. The method in this study uses the waterfall model and uses the Unified Modeling Language (UML) to visualize the modeling. The results achieved in this research include searching for goods, which contains data on goods/outlet devices, then there is retrieval of goods where both internal technicians/vendors carry out goods retrieval transactions when handling disturbances, the return menu of goods which is used to input goods/data. the device is returned, installed, unplugged and features if there is a loss which is useful for reporting item/device data in the event of a loss problem.
Arcitech: Journal of Computer Science and Artificial Intelligence
To process data in RDBMS, it is commonly used what is called SQL. This SQL can be simple or compl... more To process data in RDBMS, it is commonly used what is called SQL. This SQL can be simple or complex depending on the join statement, the tables involved, filter statement, and many more. If it is complex and burdensome to the system, then the performance of the database as a whole will decrease and SQL execution will not finish. That's why it's important to know, what components are involved when executing SQL through the SQL Execution Plan. The components in the SQL Execution Plan can be very diverse, so artificial intelligence is used to help analyze and conclude what factors have the most role in determining performance. Furthermore, these factors are called feature engineering. The purpose of this research is to formulate what features exist in the SQL Execution Plan when we send SQL commands to the system. The research method used is the Prototyping process model.
Arcitech: Journal of Computer Science and Artificial Intelligence
A collection of data stored in a database, so the longer the data, the bigger the data, because t... more A collection of data stored in a database, so the longer the data, the bigger the data, because the data processed is very large, processing time in Apache Spark can take up to a dozen or tens of hours. Sometimes, the Apache Spark application even fails. Therefore, to minimize the waiting time that could have been avoided or reduced, artificial intelligence through Machine Learning will be used to detect whether an Apache Spark application will fail or run smoothly. Factors to determine this failure are called features and are generated through the feature engineering process. The purpose of this research is to design Machine Learning so that it is able to find out what features will determine the success or failure of the Apache Spark application. The research method used is the Prototyping process model.
Arcitech: Journal of Computer Science and Artificial Intelligence, 2021
In a condition the administration / admin of the company found problems with data at the time of ... more In a condition the administration / admin of the company found problems with data at the time of data collection, problems that arose related to the complexity of making monthly reports that contained data duplication, the occurrence of loss of outlet goods, selection of goods that took a long time to make reports. The purpose of this study is to design a web-based and android-based stock zoning application system with the waterfall method so that it is expected to make it easier for admins and technicians in administrative problems, especially in stock zoning and lost goods. The method in this study uses the waterfall model and uses the Unified Modeling Language (UML) to visualize the modeling. The results achieved in this research include searching for goods, which contains data on goods/outlet devices, then there is retrieval of goods where both internal technicians/vendors carry out goods retrieval transactions when handling disturbances, the return menu of goods which is used to input goods/data. the device is returned, installed, unplugged and features if there is a loss which is useful for reporting item/device data in the event of a loss problem.
Uploads
Papers by Eri Dariato