-
Query Game 2.0: Improvement of a Web-Based Query Game for Cavite State University Main Campus
Authors:
Mark Philip M. Sy,
Christian James M. Historillo,
Allen Cris T. Conde,
Ma. Yvonne Czarina R. Costelo
Abstract:
Purpose: The study aimed to improve the previous study covering a web-based query game for Cavite State University. The study created a new mechanic and gameplay for the students to learn Structured Query Language (SQL). The enhancements also focused on the interactions of one or more students playing the game.
Method: The researchers used iterative development process methodology in the develop…
▽ More
Purpose: The study aimed to improve the previous study covering a web-based query game for Cavite State University. The study created a new mechanic and gameplay for the students to learn Structured Query Language (SQL). The enhancements also focused on the interactions of one or more students playing the game.
Method: The researchers used iterative development process methodology in the development of the study. The system was assessed and evaluated using different testing methods: unit, integration, and system testing. After passing the tests, 90 students of Information Technology and Computer Science program along with 10 IT experts evaluated the system.
Results: The respondents were classified into technical and non-technical respondents and the study garnered an evaluation score of 4.69 and 4.70 respectively. The overall interpretation of the results of the evaluation is Excellent.
Conclusion: The study created a system where the user can read and watch lectures and experience the tutorial. Instructors and students may communicate in the system, hence, promoting better relations and healthy competition between students.
Recommendations: Based on the conclusions of the study, the system can be used as a supplementary tool in teaching courses with Database Management. To enhance the analysis of query construction of the students, it is recommended to add a module that can analyze the pattern of creating queries and answering questions for every user.
△ Less
Submitted 21 November, 2020;
originally announced December 2020.
-
A review on outlier/anomaly detection in time series data
Authors:
Ane Blázquez-García,
Angel Conde,
Usue Mori,
Jose A. Lozano
Abstract:
Recent advances in technology have brought major breakthroughs in data collection, enabling a large amount of data to be gathered over time and thus generating time series. Mining this data has become an important task for researchers and practitioners in the past few years, including the detection of outliers or anomalies that may represent errors or events of interest. This review aims to provid…
▽ More
Recent advances in technology have brought major breakthroughs in data collection, enabling a large amount of data to be gathered over time and thus generating time series. Mining this data has become an important task for researchers and practitioners in the past few years, including the detection of outliers or anomalies that may represent errors or events of interest. This review aims to provide a structured and comprehensive state-of-the-art on outlier detection techniques in the context of time series. To this end, a taxonomy is presented based on the main aspects that characterize an outlier detection technique.
△ Less
Submitted 11 February, 2020;
originally announced February 2020.
-
Real-time predictive maintenance for wind turbines using Big Data frameworks
Authors:
Mikel Canizo,
Enrique Onieva,
Angel Conde,
Santiago Charramendieta,
Salvador Trujillo
Abstract:
This work presents the evolution of a solution for predictive maintenance to a Big Data environment. The proposed adaptation aims for predicting failures on wind turbines using a data-driven solution deployed in the cloud and which is composed by three main modules. (i) A predictive model generator which generates predictive models for each monitored wind turbine by means of Random Forest algorith…
▽ More
This work presents the evolution of a solution for predictive maintenance to a Big Data environment. The proposed adaptation aims for predicting failures on wind turbines using a data-driven solution deployed in the cloud and which is composed by three main modules. (i) A predictive model generator which generates predictive models for each monitored wind turbine by means of Random Forest algorithm. (ii) A monitoring agent that makes predictions every 10 minutes about failures in wind turbines during the next hour. Finally, (iii) a dashboard where given predictions can be visualized. To implement the solution Apache Spark, Apache Kafka, Apache Mesos and HDFS have been used. Therefore, we have improved the previous work in terms of data process speed, scalability and automation. In addition, we have provided fault-tolerant functionality with a centralized access point from where the status of all the wind turbines of a company localized all over the world can be monitored, reducing O&M costs.
△ Less
Submitted 21 September, 2017;
originally announced September 2017.