MySQL Relational Database Research Articles

MUDA: dynamic geophysical and geochemical MUltiparametric DAtabase

Abstract. In this paper, the new dynamic geophysical and geochemical MUltiparametric DAtabase (MUDA) is presented. MUDA is a new infrastructure of the National Institute of Geophysics and Volcanology (INGV), published online in December 2023, with the aim of archiving and disseminating multiparametric data collected by multidisciplinary monitoring networks. MUDA is a MySQL relational database with a web interface developed in PHP, aimed at investigating possible correlations between seismic phenomena and variations in endogenous and environmental parameters in quasi real time. At present, MUDA collects data from different types of sensors such as hydrogeochemical probes for physical–chemical parameters in waters, meteorological stations, detectors of air radon concentration, diffusive flux of carbon dioxide (CO2) and seismometers belonging both to the National Seismic Network of INGV and to temporary networks installed in the framework of multidisciplinary research projects. MUDA publishes data daily, updated to the previous day, and offers the chance to view and download multiparametric time series selected for different time periods. The resultant dataset provides broad perspectives in the framework of future high-frequency and continuous multiparametric monitoring as a starting point to identify possible seismic precursors for short-term earthquake forecasting. MUDA can be accessed at https://doi.org/10.13127/muda (Massa et al., 2023).

Artificial Intelligence Based Essay Grading System

There are quite a number of challenges faced by teaching staff which if ameliorated can help reduce the quality of time spent on monotonous task associated with students essays grading More so, these days in Nigeria and other related parts of the world institutions deal with a large number of students. These however make grading time consuming and costly, therefore an automated system that can handle the tasks is highly desirable. The developed automated essay grading system in this research is restricted to grading of short and structured essay responses. Java programming language was used for the implementation and MySQL relational database system with WAMPSERVER as the back end. The results showed the user-friendly modules which enable users to navigate through various interfaces easily and work as required. The developed system has an Exact Agreement rate of 0.4 and a Pearson Correlation of 0.93 with human graders.

Design of Safety Evaluation and Risk Traceability System for Agricultural Product Quality

The quality and safety of agricultural products involve a variety of risk factors, a large amount of risk information data, and multiple circulation and disposal processes, making it difficult to accurately trace the source of risks. To achieve precise traceability of agricultural product quality and safety, the monitoring and supervision level of agricultural product traceability systems needs to be improved. In this paper, the agricultural product quality- and safety-related detection data are taken as the research object, the agricultural product supply chain and business process are sorted out, the agricultural product risk factors under the influence of heavy metals are analyzed, and the agricultural product quality and safety risk evaluation model is established. The agricultural product risk traceability system was designed based on the six-layer architecture of the equipment layer, data layer, service layer, application layer, display layer, and user layer. Combined with the agricultural product quality and safety risk evaluation model, the system data were stored and modified by using the MySQL relational database, and the agricultural product risk traceability system was developed, which realized the accurate traceability of the risk link of the quality and safety of agricultural products. The research results of this paper provide an effective information means for the quality and safety supervision of agricultural products, and provide a technical reference for the development of a traceability system of risk factors related to agricultural products, which has good practical significance.

Improving web-oriented information systems efficiency using Redis caching mechanisms

The responsiveness of a web application with minimum latency time and maximum web pages loading speed is determined by its overall performance. When dealing with a large number of users and amount of data, the performance of web applications is significantly affected by ways of data processing, storage and access. This paper identifies the significance of data caching process to speed up access to relational database. The study examines approaches to improve the performance of web applications through the joint use of MySQL relational database management system (DBMS) and Redis NoSQL DBMS. The practical part of the study presents a description of a web application built based on Java and Spring Boot framework. The paper proposes the implementation of the caching strategies that take into account the principles of aspect-oriented programming. Made experiments on performance testing of the developed web application with and without caching are presented. The presented results of the study allowed us to conclude that it is possible to improve the performance of web applications by the optimal use of caching strategies when performing database queries.

The global volcano monitoring infrastructure database (GVMID)

Monitoring volcanoes is of the most importance in volcano risk mitigation to safeguard lives and economies. Thanks to recent technological advances, both on-ground and in space, our understanding of volcanic processes has improved significantly. Though there is no one-system-fits-all, optimizing infrastructure for efficient monitoring stands as key objective. The impacts of volcanic hazards can span from local to global scales, affecting us both in the short and long term. This highlights the worldwide significance of improving volcano monitoring. Previously reliant on local ground-based instruments, today’s monitoring approach is enhanced by remote and space-based techniques such as satellite remote sensing, scanning-Differential Optical Absorption Spectroscopy (DOAS), and infrasound. Designing an effective monitoring infrastructure for volcano observatories involves careful consideration of various factors such as network coverage, type of sensors, data transmission, and power supply to ensure that the targeted parameters meet the specific needs of each volcano (e.g., type of activities, early warning systems). Additionally, fostering collaboration and information sharing within the global scientific community is essential for addressing the current challenges in volcanology. In line with this, we’ve established the Global Volcano Monitoring Infrastructure Database (GVMID) to compile data from volcano monitoring across the globe. Global Volcano Monitoring Infrastructure Database serves as an integral component of WOVOdat, the global volcano unrest database, aiming to enhance our understanding of eruptive processes and improve eruption forecasts. The database incorporates monitoring metadata comprising networks, stations, and instruments, all standardized and managed using a MySQL relational database management system. Accessed through a web-based interface (https://wovodat.org/gvmid/home.php), GVMID offers an informative snapshot and foundational overview of the techniques and instruments in place at diverse volcanoes. This interactive platform allows for queries, visualizations, and downloads, serving as a valuable resource for the volcano community. GVMID can assist observatories in various ways, by: (a) Facilitating the setup or enhancement of monitoring systems for specific volcanoes. (b) Providing insights into the latest monitoring technologies and instrumentation. (c) Identifying existing monitoring gaps that could be addressed through remote sensing infrastructure and future instrument deployments. We extend an invitation to the global volcano community to actively participate in the development and enrichment of GVMID. Our aim is for it to become a continually updated and indispensable resource that caters to diverse needs within the volcanology community.

Оценка пожарного риска на производственных объектах в информационно-аналитической системе «Probit»

Purpose. The article substantiates the need to develop the information and analytical system (IAS) “Probit” designed to justify the sufficiency or development of additional systems for ensuring fire safety of industrial facilities based on the calculated determination of fire risk values. The capabilities and features of the program are described. Methods. The methodology for determining the computed values of fire risk at production facilities, approved by the Order of EMERCOM of Russia dated July 10, 2009 No. 404. served as a methodological and regulatory base for writing the IAS “Probit”. The programming languages JavaScript, PHP, Vue.js and Laravel frameworks were used directly for the development of the IAS as well as a MySQL relational database. Findings. The proposed scientific approach allows not only evaluating the effectiveness of using a particular fire protection system on the same equipment, but also comparing fire hazard of different process equipment, that is, to predict, for example, how many times a tank is more dangerous than a distillation column, and a distillation column than a pump or compressor etc. This approach can be used not only to assess the technological equipment fire hazard, but also when insuring production facilities. Research application field. The IAS “Probit” is intended to be used in the activities of EMERCOM of Russia, expert organizations, research and design institutes, as well as higher educational institutions and other educational organizations, when dealing with the issues of confirming the compliance of industrial objects protection with the required level of fire safety, including implementation of final qualifying works, the development of technical specification and company standards. Conclusions. The “Probit” information and analytical system application in educational process can significantly improve the quality of training specialists who are competent in the following areas: methods for assessing the compliance of the object under protection with the requirements of regulations and normative documents; methods for determining fire risk estimated values; fire safety systems for protecting facilities aimed at reducing fire risk.

Research on the influence of new media on the ideological and political education of college students in the background of the Internet and countermeasures

Abstract This paper constructs a new media for college students’ ideological and political education cloud platform based on the Internet background to enrich the ideological and political education content of college students. Firstly, the online teaching system is realized through the semi-structured database HBASE module and relational database MySQL module to use; secondly, the BP algorithm is used to inform the management data of college students, and the serial mode and batch mode in the BP algorithm is used to improve the data mining efficiency, and finally, the system is tested for data. The results show that the cloud platform education system constructed in this paper can reach the highest score of 6.4 for teachers’ teaching orientation, teaching programs, and students’ recognition, with 82.4%. And the average scores of the students in the experimental group in the professional course and the Civic Science test are 10% and 20% higher than those in the control class, respectively, and the average score can reach 45.9 on the dynamics of teaching behavior. Thus, it can be seen that the cloud platform constructed in this paper helps to promote the high-quality development of the teaching of Civics for college students and effectively improve the teaching effectiveness of Civics.

Development of electronic learning system for automation of educational process

The state of modern LMS systems was studied on the example of samples of foreign and Ukrainian online education systems, which made it possible to study the structure of the electronic educational environment, available tools (available functionality), advantages and disadvantages of various types of electronic learning systems. The analysis of existing LMS systems and the state of Ukrainian online education showed the need and relevance of developing a global Ukrainian free LMS system that would allow to effectively organize the educational process and conduct training in accordance with the standards of the Ministry of Education and developed educational programs on a remote basis. As a result, the "LearnUA" e-learning system was developed. It was created using the Microsoft Visual Studio Code (VS Code) source code editor, the XAMPP cross-platform package, the PHP scripting language, the object-oriented prototyping language JavaScript (JS), and the MySQL relational database management system. The "LearnUA" e-learning system is focused on managing users and courses, supporting and creating educational content, ensuring effective electronic document flow. It is able to combine the organization of planning, implementation and evaluation of the learning process. The main component of the created LMS system are courses that can be created within the informational educational environment of an educational institution or in a corporate environment for the organization of distance learning for staff of a network company. To access the main functionality of "LearnUA", the user is given the opportunity to log in to the system. The system provides for a clear division of roles: the administrator – manages the system, provides the initial password for entering the system to the user (student, teacher) during authorization; teachers/mentors – course owners who create and manage them; pupils/students – participants who are involved to an existing course using a course invitation link. The course owner must have access to the context menu (create, edit courses and tasks, attract participants to an existing course, conduct evaluations, view reports, event log). Information on a specific course should be located on several tabs (sections) depending on the role of the user (owner or participant): a list of all available tasks, course settings, a list of course participants, evaluations, etc. The developed LMS system is of great practical importance, as it allows you to organize effective management of users and courses through a local server. In the future, the system is planned to be improved by adding new functionality.

The Importance of Developing Preventive Techniques for SQL Injection Attacks

Many intentionally vulnerable web applications are circulating on the Internet that serve as a legal test ground for practicing SQL injection attacks. For demonstration purposes the attacks will target an Acunetix test web application created using PHP programming language and MySQL relational database. In the practical part, the execution of the attack itself largely depends on the database management system, so the displayed syntax is intended only for the MySQL database management system. Example of an automated attack will be executed on SQLmap in a Linux Kali virtualized environment. Security guidelines with a purpose of protecting databases are also discussed.

Specimods: A web-based tool for producing Genbank submission files for sequenced museum specimens

The expectation of published sequence data on Genbank and other sequence databases is not only a requirement for journal publication, but is incredibly valuable for continuing research in organismal evolution and ecology. The process of formatting and submitting sequence data from vouchered specimens is burdensome and tedious. Improperly formatted submissions lead to lengthy delays and frustrations on behalf of the submitters and reviewers. Specimods*1 is a new tool that utilizes the Global Biodiversity Information Facility (GBIF) API to produce formatted source modifier files that will facilitate the batch upload of specimen sequences to Genbank, using the sequence submission platform. Once a template CSV is populated with the specimen catalog numbers, institution codes, SeqID, sequence descriptions, and the sequences, Specimods will pull specimen metadata from GBIF to produce two files: a FASTA file with a complete definition line (SeqID, organism name, sequence title) and the sequences as well as a source modifier file containing specimen metadata. Currently, Specimods supports Internal Transcribed Spacer (ITS) (1, 2, or both), SSUrRNA_18s, and LSUrRNA_28s sequences. The application*2 uses an Express server and Node.js with data linked to a user account stored in a MySQL relational database. This presentation will demonstrate the tool using data from fungal specimens and show how submitting dozens of sequences with metadata can be accomplished in a matter of minutes.

A neuro-genetic fuzzy system for the prediction of student’s academic performance

The Nigerian education sector has over the years being facing serious problems of producing half-baked graduates or what others termed to be “educated illiterates” in various fields of human endeavour. The root cause of this issue is traced to poor academic performance evaluation of students seeking admission into tertiary institutions. The current model for evaluating the academic performance of admission seekers encompasses the Joint Admission and Matriculation Board (JAMB) and the West African Senior School Certificate Examinations (WASSCE), National Examination Council (NECO) or even National Board of Technical Education Council (NBTE). However, it has being argued that rather than JAMB and WASSCE or its equivalent, to evaluate admission seekers based on excellent correlated academic performances, the model has now become a citadel of bribery, corruption and gross academic malpractices. A model was developed to address this problem using tree based ensemble machine learning algorithms but we discovered that it did not sufficiently address the problem. In this work, we developed an Enhanced Neuro-Genetic Fuzzy Model for predicting students’ academic performance using structured analysis and design methodology. The Neuro-Genetic was used for training and optimizing the proposed model. Furthermore, we utilized 1000 datasets of which 60%, @0% and 20% was used for training testing and validation of the proposed model. We implemented the proposed system with Java programming language and MySQL relational database as backend. Our obtained result showed better Grand Mean (x) of users’ satisfaction when compared to the existing system result in terms of graphical user interface, accuracy of the prediction process, speed of the prediction process, speed in user validation and security. The proposed system Grand Mean obtained after comparative analysis are 2.74%, 1.78%, 2.71%, 1.67%, and 2.57% respectively, while those obtained by the existing system are 2.59%, 0.78%, 2.68%, 0.67%, and 2.52% respectively. In addition, the study also recommended the need for more application of machine-learning concepts to the prediction of student's academic performance. Machine learning techniques such as neuro-genetic fuzzy have proven to be efficient in predicting the academic performance of students.

Incorporating Environmental Protection Requirement in Industrial IoT Access Control Security Using Arduino Technology MQ2 and DHT11 Sensor Networks

This paper presents the development of environmental monitoring mechanism based on Arduino Sensor Technology for Industrial Internet of Things (Industrial IoT) Critical Infrastructure (CI) Protection in an Access Control role. Access control of hazardous substances is one of the most vulnerable aspects of Industrial IoT CI. The idea behind this study is to harden environmental security through live ecological monitoring of Temperature, Humidity and emitted hazardous substances or gases due to Industrial activities and processes in Smart CI places such as Nuclear Processing Plant, Thermal Generation Power Industries, Fossil Processing Plant, Military Chemical warfare plant, food processing factory, Agriculture Chemical Manufacturing Plant and many other CI industries. Live monitoring is one of the most important security requirements for any cyber-Access Control Mechanism. The literature revealed that similar systems were developed and implemented in different organizations and with different System Requirements and specifications. However, most CI industries have not automated environmental monitoring requirements and integrated the requirement into a broad institution security continuum. The consequence of neglecting environmental security is climate change. Furthermore, Toxic gas pollution affects millions of people around the world and contributes to about 5.4 percent of deaths worldwide. Pollution kills more people than the combination of malaria, AIDS, and tuberculosis hence the development of security mechanisms to monitor pollutants in the atmosphere. The main objective of this study was to develop a computer-based application for monitoring environmental hazardous substances such as extreme temperature, humidity, carbon dioxide (CO2), carbon monoxide (CO), and Smoke in the atmosphere surrounding Industrial IoT CI Industries. The system development approach employed was the Arduino engineering process model. To achieve this objective, cheaper ecological sensor Networks that include MQ2 and DHT11 Arduino Sensors are connected to Arduino Uno Microcontroller through a solderless breadboard Arduino component. The backend database was MySQL Relational database management system. The developed prototype application produced a number of results including live monitoring of temperature, humidity, CO2, CO, Smoke, and many others. A system evaluation process was conducted and the result indicated 99.999% accuracy levels. The results, it evidence that the developed prototype application can improve environmental security in Industrial IoT CI institutions.

ПРОЕКТИРОВАНИЕ ИНТЕЛЛЕКТУАЛЬНОЙ СИСТЕМЫ КОНТРОЛЯ ТЕХНИЧЕСКОГО СОСТОЯНИЯ ПАРКА МОБИЛЬНЫХ МАШИН

At the moment, there is no comprehensive solution for the remote monitoring of the technical condition, location and other parameters of the machine fleet. One of the promising areas in repair and diagnostics is proactive diagnostics and improvement of diagnostics systems. To solve this problem, web-service is offered, which can help control location of machinery units, technical condition, and other parameters. The JavaScript programming language with asynchronous AJAX-requests is suitable for user-website interaction. For data storage, the authors proposed a cloud server accessed through the MySQL relational database management system. When transferred to the server, all data are converted into JSON format by means of the Apache server, which is the means of communication between the operator’s screen and the server. A cross-platform local XAMPP server is used to communicate all systems. The Slack messenger is used to send messages and establish fast communication between operators, mechaniс components, and drivers. To remotely monitor the technical condition of a combustion engine, the system has a diagnostic algorithm that allows monitoring the condition of mechanical systems taking into account the analysis of data received from the electronic control system. The electronic control system can be connected via a single OBD-2 connector to read out standard information about the technical condition of the vehicle. The applicability of the developed diagnostic algorithm has been confirmed on a pilot plant with an IVECOF4HE diesel engine with modern electronic means of control. The conducted economic analysis has proved the effectiveness of the implementation of a remote control system during vehicle operation at the enterprise. The next stage in the development of an intelligent diagnostic system is to improve the algorithm for diagnosing the technical condition and expanding control over the other vehicle parts.

AutoCell Systematic Evolution of Ligands by Exponential Enrichment: The Software Designed and Developed for the Automated Screening System of Nucleic Acid Aptamers.

Aptamers are a new kind of nano-probes for bioassays and drug delivery, etc. In this paper, software has been developed as an automatic control center for the automated aptamer selecting system which realized the high integration of aptamer selection, data acquisition and processing. This software, applied in windows system, is developed by C# with the Microsoft Visual Studio 2015 integrated developing environment and the database used in this software is implemented using open source relational database MYSQL. According to the requirement analysis, this software realized various important necessary functions including feasible experiment design, auto-control of the hardware, real time process monitoring and efficient data management which perfectly satisfies the users' demands. During the actual experiment operation, this software worked smoothly and assumed stable serial port communication between it and the hardware, meanwhile, the interaction between the software and MYSQL remained good stability. As a consequence, it is practical and reasonable to apply this software to the automated aptamer selecting system for research.

SISTEMA IOT INDUSTRIAL PARA MONITORAMENTO DE VIBRAÇÕES DE MÁQUINAS ROTATIVAS

Industrial IoT systems have been used to collect and analyze data from industrial processes. In this paper, we describe the development of a system containing IoT technologies to perform vibration monitoring of rotating machines for use in predictive maintenance systems. A two-axis vibration attached to a motor is used to generate the signal which is sent to a programmable logic controller using Modbus RTU protocol. Measurement history is stored in a MySQL relational database and presented through a dashboard using Grafana. Connection between controller and database is done by means a flow developed in Node-RED using OPC-UA protocol. Initial analysis were carried out using ranges of values in accordance with technical standards to establish tolerable levels of vibration. The system was successfully deployed and tested in a workbench; the methodology and results are reported in this paper.

Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases

Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.

A WEB-BASED PLATFORM FOR MANAGEMENT AND VISUALIZATION OF GEOMETRIC DOCUMENTATION PRODUCTS OF CULTURAL HERITAGE SITES

Abstract. The mission of digital Cultural Heritage (CH) repositories goes beyond engagement and dissemination; their research data should be approached and correlated spatially and semantically in the service of conservation and accessibility. Therefore, a flexible system is needed to expand, reuse and repurpose their content, addressing online collaboration, real time progress and ease of use. Towards this direction, the “METEORA” web-based platform is a novel and holistic approach to the organization, management and visualization of the 3D and 2D documentation products of CH sites. It integrates a multi-scale 3D viewer based on the 3DHOP framework, personalized information access and interactive tools for data retrieval and presentation. Emphasis is given in the development of a mid-level interface for creating, updating and maintaining 3DHOP’s functionalities and customizing information based on the user’s scientific specialty and field of interest. The proposed admin control panel updates the state of the current visualization, allows the integration of 3D models and multimedia and automates the creation of clickable points of interest on top of the 3D surfaces. It is based on a MySQL Relational Database Management System (RDBMS) that supports the back-end User Interface (UI) with create, read, update and delete (CRUD) management functions of a typical RESTful service. Moreover, all the control mechanisms as well as the procedures of authentication, authorization and encryption of the credentials of the certified users are configured through the PHP scripting language and JSON files. The resulting platform achieves maximum adaptability in digital archiving of heterogeneous datasets and has increasing efficiency in representing all types of data supported by 3DHOP.

Radiation Data Portal: Integration of Radiation Measurements at the Aviation Altitudes and Solar‐Terrestrial Environment Observations

AbstractThe impact of radiation dramatically increases at high altitudes in the Earth's atmosphere and in space. Therefore, monitoring and access to radiation environment measurements are critical for estimating the radiation exposure risks of aircraft and spacecraft crews and the impact of space weather disturbances on electronics. Addressing these needs requires convenient access to multisource radiation environment data and enhancement of visualization and search capabilities. The Radiation Data Portal represents an interactive web‐based application for search and visualization of in‐flight radiation measurements. The portal enhances the exploration capabilities of various properties of the radiation environment and provides measurements of dose rates along with information on space weather‐related conditions. The Radiation Data Portal back‐end is a MySQL relational database that contains the radiation measurements obtained from the Automated Radiation Measurements for Aerospace Safety (ARMAS) device and the soft X‐ray and proton flux measurements from the Geostationary Operational Environmental Satellite. The implemented application programming interface and Python routines allow a user to retrieve the database records without interaction with the web interface. As a use case of the Radiation Data Portal, we examine ARMAS measurements during an enhancement of the solar proton (SP) fluxes, known as solar proton events, and compare them to measurements during SP‐quiet periods.

Development of a web resource for safe job search in a Covid-19 pandemic

The work describes the main steps, the structure, and the result of web resource for job search, which is relevant in the context of a pandemic and employment loss of a large number of citizens. The focus is on the development of a platform with enhanced protection from the point of view of a job seeker, who can analyze data about the employer, and leave a real feedback both at the job search stage and after employment. For this purpose different user profiles and a real opportunity to leave feedback are provided. A platform is developed using PHP with PDO extension for database connection. MySQL relational database is used as a database. All phases of resource development, from architectural and database planning to the development of layouts and interfaces, are described in details. Special attention to the protection of information transmitted by both employers and job seekers is paid. The functionality of the developed system is analyzed. The received resource has been tested and it has been established that it can be used effectively for both employers and job seekers with the appropriate functionality, the ability to post, edit, delete vacancies and comments about the company. This, in turn, makes it possible to avoid fraud and cybercrime by checking the veracity of the information provided by the employer and forming an employer’s rating based on real feedback from persons who work or have worked there.

Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework

Many database implementations are supported by application frameworks that can affect their performance. The paper presents a comparison of the performance of SQL Server, MySQL and PostgreSQL relational databases based on an application written in PHP using the Laravel framework. The time of performance for various types of queries, both simple and using column and table concatenation was evaluated. The obtained results for the same database structures differed depending on the operations performed on the databases. Looking at the entirety of the research conducted, it can be concluded that in the case of databases in which the number of records is not too large (up to 1000 records) and the technical parameters of the device on which the database is running are of low or medium class, MySQL performs very well.