MySQL Database Management System Research Articles

DOTTs-Database of Therapeutic Plants against Tuberculosis: Rationalizing traditional medicine for therapeutic applications

IntroductionMycobacterium tuberculosis, a highly resistant superbug causing tuberculosis disease, contributes to one of the leading causes of death worldwide. Improved drug regimens and therapeutics have been extensively studied, but still, none is proven to be fully effective in eliminating the pathogen or its drug-resistant forms. Therefore, alternative and novel therapeutic approaches to address this problem are the need of the hour. Traditional medicine can be vital in managing tuberculosis via codified (Ayurveda, Siddha, Unani) and uncodified systems (folk medicine). In recent years, the utilization of medicinal plants for TB therapy has garnered considerable attention. Identifying underexplored plants utilized as a remedy for tuberculosis can aid in developing future treatment strategies. The current study aims to assemble the ethnobotanical literature that provides insight into the undocumented tribal/folk medicinal practices against tuberculosis in one unified platform. MethodsThe medicinal plants with therapeutic properties against tuberculosis were identified manually by screening published literature. The data is represented to the users using a user-friendly web interface developed via the PHP-HTML platform using Bootstrap Cascading Style Sheet (CSS) theme, and the database is managed by MySQL Database Management System (DBMS). ResultsDatabase of Therapeutic Plants against Tuberculosis describes the medicinal plants used traditionally in different forms against tuberculosis by various indigenous tribes and communities in India. A total of 100 plants with their local names, taxonomical classification (order and family), tribe, plant part, and formulations, as well as the anti-tubercular attributes, are provided in the database. Additional information about the plants can be retrieved from the external links provided. ConclusionThe DOTTs database provides the ethnobotanical and ethnopharmacological data of 100 Indian medicinal plants. This database will help the researchers acquire information about the plants that could be beneficial for further evaluation and discovery of potential leads in TB drug discovery. With proper investigation and advancement, it can be anticipated that TB will no longer be a serious public health risk.

DEVELOPMENT AND APPLICATION OF AN INTEGRATED INFORMATION MODEL FOR OPTIMIZING LAND USE AND FORECASTING YIELDS IN AGRICULTURAL PRODUCTION

The paper presents the development of a conceptual information model for optimizing land use and crop forecasting in agriculture, implemented using the PHP programming language, Javascript and the MYSQL database management system. The model is designed to solve optimization problems in various fields such as logistics, manufacturing, finance, etc. As part of the work, an information model was developed, which is a set of data, algorithms and software modules designed to solve optimization problems. The model is implemented based on PHP, Javascript, and MYSQL technologies. The model allows you to solve optimization problems of varying complexity using various optimization methods such as linear programming, nonlinear programming, artificial intelligence methods, etc. The model can be applied to solve optimization problems in various fields. In addition, the model allows you to solve optimization problems with a high degree of accuracy and in a short time, and also has a user-friendly interface that allows users to easily and quickly set optimization tasks. An information model has been developed that will make it possible to predict the harvest taking into account data on weather, soil, crops and historical yield data, as well as optimize land use taking into account data on soil type, climate, crop rotation and financial indicators. The developed information model can improve the efficiency and sustainability of agricultural production. The model can be used by agronomists and farmers to make more informed decisions. The model takes into account data on soil type, climate, crop rotation and financial indicators to optimize land use.

Improving Inventory Control Through a Web-Based System in a Retail Company

Background Currently, retail companies that fail to digitise their logistics processes experience difficulties in controlling stock, resulting in inaccuracies in the quantity of products and excess amounts in the warehouse. Consequently, the aim was to introduce a web-based system to enhance inventory control in retail firms within the city of Huaraz. Methods The Extreme Programming methodology was implemented in four phases. During the planning phase, roles and user stories were established. In the coding phase, Hypertext Preprocessor and JavaScript programming languages were utilised alongside the MySQL database management system. The testing phase involved evaluating each interface’s functionality to ensure that it was a part of the web system. The objective of this was to develop the web system and utilise it as an inventory control tool. Results The utilization of the web-based system within the logistics sector led to enhanced indicators, as seen through a 52.94% increase in inventory precision rate and 91.94% rise in the stock turnover rate. Conclusions The web system facilitates the minimisation of input errors in product quantity records while also enabling visualisation of such data. It further provides an illustrated representation, in the form of a bar graph, of each product’s indicator behaviour.

TRANSMISSION, STORAGE AND PREPROCESSING OF DATA RECEIVED FROM SENSORS USING LORA TECHNOLOGY

This study focuses on the use of Internet of Things technologies to monitor air quality parameters in the city. The research included the development of a system for collecting data from sensors of temperature, humidity, pressure, gases, time, GPS for various environmental parameters. The article discusses the benefits of using LoRaWAN for data transmission, highlighting its low power consumption and long-range capabilities. The presented architecture allows for system scalability, emphasizing the ability to integrate with additional devices and sensors for more complete and comprehensive environmental monitoring. The collected data is stored in a MySQL database management system and the importance of proper data structuring and normalization is emphasized to ensure accurate analysis. In addition, a data preprocessing process is described to solve the problem of heterogeneity of data obtained from different sensors. The result of the study is the obtained and preprocessed data. The work also highlights the importance of data management to ensure the successful implementation of such systems in the face of heterogeneity of information from different sensors. Thus, the article presents a comprehensive approach to air quality monitoring using IoT and highlights the importance of proper data management for subsequent accurate analysis.

Architecture and Development Framework for a Web-Based Risk Assessment and Management Platform Developed on WordPress to Address Opioid Overdose.

The number of overdose-related fatalities continues to reach historic levels across Canada, despite ongoing efforts by authorities. To reduce mortality, a clinical trajectory ranging from preventative measures to crisis intervention, skill training to treatment, and risk assessment to risk management needs to be supported. The web-based Risk Assessment and Management Platform (RAMP) was developed to realize this concept and to empower people who use drugs through an integrated tool that allows them to better understand and manage their risk of overdose. This paper outlines the architecture and development of RAMP, which is built on the WordPress platform. WordPress components are mapped onto a 3-tier architecture that consists of presentation, application, and database layers. The architecture facilitates the development of a modular software that includes several features that are independent in functionality but interact with each other in an integrated platform. The relatively low coupling and high coherence of the features may reduce the cost of maintenance and increase flexibility of future developments. RAMP's architecture comprises a user interface, conceptual framework, and backend layers. The RAMP front end effectively uses some of the WordPress' features such as HTML5, CSS, and JavaScript to create a mobile, friendly, and scalable user interface. The RAMP backend uses several standard and custom WordPress plug-ins to support risk assessment and monitoring, with the goal of mitigating the impacts and eliminating risks together. A rule-based decision support system has been hard-coded to suggest relevant modules and goals to complement each user's lifestyle and goals based on their risk assessment. Finally, the backend uses the MySQL database management system and communicates with the RAMP framework layer via the data access layer to facilitate a timely and secure handling of information. Overall, RAMP is a modular system developed to identify and manage the risk of opioid overdose in the population of people who use drugs. Its modular design uses the WordPress architecture to efficiently communicate between layers and provide a base for external plug-ins. There is potential for the current system to adopt and address other related fields such as suicide, anxiety, and trauma. Broader implementation will support this concept and lead to the next level of functionality.

IMPLEMENTASI SOCIAL CUSTOMER RELATIONSHIP MANAGEMENT DALAM MENINGKATKAN PROMOSI PRODUK

Nibra's House Sukarami Palembang is a Muslim store and marketplace that hadn’t fully used its product promotions. Based on the that statement, Social Customer Relationship Management (Social CRM) was implemented at Nibra's House Sukarami Palembang with the goal of increasing the product promotions. The system is being developed using the FAST system development methodology and makes use of social media platforms, specifically Facebook and Instagram of Nibra's House Sukarami Palembang. The study's finding is a Social CRM system built on a website using PHP programming language and MySQL database management system. It also optimizes customer relationship management via the usage of social media platforms: Facebook and Instagram of Nibra's House Sukarami Palembang. Keyword : Product Promotion, Customer, Social CRM, PHP, My SQL, Facebook, Instagram

Application of Forward Chaining and Rule-Based Reasoning Methods to Design an Expert System for Pregnant Women Disease Diagnosis in a Private Hospital

This research aims to discover how to create and implement an expert system for prenatal disease diagnosis. To prepare this study, the author employed several data collection techniques, including observation, interviews, and a literature review. The system to be designed was developed using an object-oriented paradigm and a Rapid Application Development (RAD) technique. Multiple development stages are involved in creating RAD, including requirement planning, workshop design, and implementation. Based on the study findings, it was discovered that the PHP programming language, MySQL database management system, Apache web server, UML tool, and RAD system development methodology were used to create an expert system for identifying illnesses in expectant mothers. The forward chaining method is used for this expert system, where the first stages are to create an inference tree and set rules. This system likewise computes the consistency test using the Bayes theorem method. With an 80% accuracy rate, SISPADIBU can be used as a diagnostic tool for disorders related to pregnancy. SISPADIBU can use the user-entered symptoms to present the diagnosis results. According to the survey results, 80% of users said that SISPADIBU was highly user-friendly, that the layout display was simple to use, and that it was constructive in educating users about pregnancy disorders.

Pengembangan Sistem Aplikasi Barbershop Berbasis Android untuk Meningkatkan Efisiensi dan Efektivitas Pelayanan di Barbershop

Barbershop is an innovation or development from a men's haircut to a special men's grooming place for hair. Barbershop not only provides haircut services, but many other services are presented such as shaving, coloring, etc. At this time, service order submissions are still made through the WhatsApp platform or telephone or come directly to the Barbershop and queue so that customers feel less satisfied because sometimes it is necessary to wait a long time. To solve this problem, a Barbershop service application was created that customers can use to order services and then Barbershop managers can manage these services only through the application. The application is built using the Flutter and PHP programming languages, is supported by the Laravel framework, and relies on the MySQL database management system to make database management easier. Some of the features provided by the application include booking services, choosing a barberman, and choosing a service time. Thus, this application can help services in Barbershop become more effective and efficient.

A cosmic-ray database update: CRDB v4.1

The cosmic-ray database, CRDB, has been gathering cosmic-ray data for the community since 2013. We present a new release, CRDB v4.1, providing many new quantities and data sets, with several improvements made on the code and web interface, and with new visualisation tools. CRDB relies on the MySQL database management system, jquery and table-sorter libraries for queries and sorting, and PHP web pages and AJAX protocol for displays. A REST interface enables user queries from command line or scripts. A new (pip-installable) CRDB python library is developed and extensive jupyter notebook examples are provided. This release contains cosmic-ray dipole anisotropy data, high-energy p¯/p\\documentclass[12pt]{minimal} \\usepackage{amsmath} \\usepackage{wasysym} \\usepackage{amsfonts} \\usepackage{amssymb} \\usepackage{amsbsy} \\usepackage{mathrsfs} \\usepackage{upgreek} \\setlength{\\oddsidemargin}{-69pt} \\begin{document}$$\\bar{p}/p$$\\end{document} upper limits, some unpublished LEE and AESOP lepton time series, many more ultra-high energy data, and a few missing old data sets. It also includes high-precision data from the last three years, in particular the hundreds of thousands AMS-02 and PAMELA data time series (time-dependent plots are now enabled). All these data are shown in a gallery of plots, which can be easily reproduced from the public notebook examples. CRDB contains 316,126 data points from 504 publications, in 4111 sub-experiments from 131 experiments.

Алгоритм обработки информации для прогнозирования развития технологий на примере теле- и радиовещания

Today, many Russian companies working in the field of software development for television and radio broadcasting can extract the necessary data on trends in their field of activity by analyzing information received from foreign competitors, for example, studying specialized popular science literature posted on the official websites of foreign competitors, when analyzing information obtained from exhibitions and presentations. However, the opportunity to comprehensively analyze the novelties of foreign developers patented in the world patent databases will give Russian companies competitive advantages in the formation of strategic development plans. It is proposed to develop a patent landscape based on the data of the global patent array (in English) in the field of television and radio broadcasting, analyze patent trends and predict the development of technologies in this area. The novelty of the developed method for predicting the development of technologies lies in the cooperation of USPTO (USA) patent clustering methods based on the international patent classification and forecasting technological trends using the generated time series. The developed method is implemented in Python; in parallelizing the process of parsing patents, the Multiprocessing library was used, Statsmodels was used to analyze data and carry out the forecasting process, and Matplotlib was used to visualize data. The MySQL database management system was chosen to organize information storage. There were processed 28,591 patents, the process of forecasting the development of television and radio technologies was tested based on the constructed time series in the interval of 2015–2020.

Construcción de un ecosistema digital como apoyo en la implementación del nuevo plan de estudios de la Facultad de Medicina

This article describes the process of constructing a digital ecosystem to support the implementation of the EPPENS 2022 curriculum plan, which allows for monitoring the curriculum competencies of students and teaching competencies of professors during the medical training process at the Facultad de Medicina of the Universidad Autonoma de Mexico (UNAM), with the purpose of generating and substantiating actions that are in favor of teaching, learning, evaluation, and school management processes. The platform was designed using the PHP programming language and the MySQL database management system. Keywords: TICs; digital tool; competences; students; teachers; teaching

5DMETEORA FRAMEWORK: MANAGEMENT AND WEB PUBLISHING OF CULTURAL HERITAGE DATA

Abstract. Cultural Heritage (CH) management software represents virtual information in various ways aiming either at usability and long-term preservation or interactivity and immersiveness. A single web-based framework that couples the organization of geospatial, multimedia and relational data with 4D visualization, Virtual Reality (VR) and Augmented Reality (AR) is presented in this paper (https://meteora.topo.auth.gr/5dmeteora.php). It comprises the 5dMeteora platform and the Content Management System (CMS) for uploading, processing, publishing and updating its content. The 5dMeteora platform integrates a responsive 3D viewer of high-resolution models in the basis of 3DHOP (3D Heritage Online Platform) and Nexus.js multi-resolution library. It offers data retrieval and interpretation mechanisms through navigation tools, clickable geometries in the 3D scene, named hotspots, and semantic organization of metadata. Its content and interactive services are differentiated, based on the scientific specialty or the field of interest of the users. To achieve the sense of spatial presence, VR and AR viewports are designed to give a clearer understanding of spatial bounds and context of 3D CH assets. The proposed CMS allows dynamic content management, automation of 3DHOP’s operations regarding 3D data uploading and hotspots defining, real-time preview of the 3D scene as well as extensibility at all levels (e.g., new data types). It is built upon a MySQL Database Management System and developed with PHP scripting, backend JavaScript and Ajax controllers as well as front-end web languages. The database maintains and manages the entities of every type of data supported by the platform, while encryption methods guarantee data confidentiality and integrity. The presented work is the first valid attempt of open-source software that automates the dissemination of 3D and 2D content for customized eXtented Reality (XR) experiences and reaches multiple levels of interactivity for different users (experts, non-experts). It can meet the needs of domain experts that own or manage multimodal heritage data.

Development of a Web-based Geographic Information System for Locating Medical Practices

This study aims to develop a web-based Geographic Information System (GIS) for searching medical practices. The system is designed to provide the public with easy access to information on the location of medical practices in the city. The Haversine method is used to calculate the distance between the user's location and the medical practice locations, and the system displays the nearest locations on the map. The system was developed using the PHP programming language, MySQL database management system, and Google Maps API. The user interface was designed to be simple and user-friendly, with a search bar and filters for narrowing down search results. The system's feasibility was evaluated through a questionnaire answered by 20 respondents with seven questions. The average score was 84.42%, indicating that the system is highly feasible for use. The developed system is expected to facilitate the public's access to medical practices and provide a more efficient way to find the nearest doctor.

Sistem Informasi Manajemen Inventaris Berbasis Web di SDIT Alam Biruni

SDIT Alam Biruni is a private elementary school located in Jl. Sisingamangaraja Parit 7, Air Ruai, Pemali, Bangka. In managing item inventory, they are still using spreadsheet software. Also, the process of keeping the records of borrowed items is still done manually by writing them in a record book of borrowed items. The goals of this final project are a) designing and developing a website-based inventory management information system, and b) simplify the registering process of item borrowings at SDIT Alam Biruni. The development process is done by following the Waterfall development model and the design process is done by using use case diagram, activity diagram, and entity relationship diagram. The website-based inventory management information system at SDIT Alam Biruni is developed using CodeIgniter 3 framework, Sublime Text editor, PHP programming language, and MySql Database management system. The testing methods that are used to test the system are: 1) Black Box testing method and 2) user satisfaction survey. The result of this study is a website-based inventory management information system that can simplify the registering process of item borrowings at SDIT Alam Biruni, with 82,6% result of user satisfaction survey.

Sistem Identifikasi Titik Kritis Halal Menggunakan Algoritma Forward Chaining

<p align="center"><strong>Halal products are obligatory to be used by people who are Muslim. When viewed in terms of the number of the Muslim population in the world and Indonesia, halal products have very potential economic opportunities. However, halal products have the risk of becoming non-halal if the accompanying process and storage do not follow halal rules. Therefore, it is necessary to identify the critical halal point, the point where the potential for such change occurs. So far, identification is made manually, of course there will be opportunities for identification errors to happen and it will take a relatively long time. To overcome these problems, identification can use a computer-based system. Forward chaining is an algorithm that is suitable for identifying halal points, because in SJH LPPOM MUI there is a decision tree for identifying halal critical points which is carried out in the same forward sequence as the forward chaining algorithm process flow. The development of a halal critical point identification system is carried out using the Software Development Life Cycle V-model method, the PHP programming language and the MySQL Database Management System. The system was successfully tested using Whitebox testing, including unit testing, integration testing, and overall system testing. Then testing using Blackbox testing techniques by comparing the results of identifying critical points using the system with the results of identifying critical points manually producing the same results. User satisfaction testing was also carried out using the End User Computing Satisfaction method and obtained an average satisfaction score of 86.53%.</strong></p>

Аналитический терминал для тестирования торговых стратегий

A web-application developed at the Department of Information Technologies of the Saint Petersburg State University of Architecture and Civil Engineering, which makes it possible to testing trading strategies used for stock exchange transactions, is described. The application can be categorized as business software. It allows you to significantly increase the efficiency of investment decision-making by both novice and professional investors. A new approach to writing trading strategies using templates is proposed. The ability to test an arbitrary number of strategies for an arbitrary structure investment portfolio is implemented. The application is developed by Python programming language and both Django and Django REST frameworks. Quotations data used for testing are taking from open sources. Relational data base was designed and implemented for data storage. MySQL data base management system (DBMS) is used to organize interaction with the database. The Python libraries numpy and pandas are used for data processing. The client part of the application is implemented using the TypeScript language and both React and React Router frameworks. The system does not require the installation of additional software. Access to the Internet need to use the system only. The approaches and technological solutions implemented in the application can be successfully used to create similar systems for other organizations and companies involved in similar activities.

ІНФОРМАЦІЙНА СИСТЕМА ЗБОРУ ТА НАКОПИЧЕННЯ ДАНИХ ПРО ЯКІСТЬ АТМОСФЕРНОГО ПОВІТРЯ ЗІ СТАНЦІЙ VAISALA МУНІЦИПАЛЬНОГО РІВНЯ

Today, the problem of air pollution is a pressing one, especially in Ukraine. As a result of the war and the Kakhovka hydroelectric power station disaster, as well as the relocation of certain industrial enterprises and the displacement of the population, there have been significant changes in the state of the atmospheric air in municipalities compared to the state before these changes, which was recorded by environmental monitoring stations and could be predicted for a long time. In Kremenchuk, air quality studies are carried out by a municipal enterprise of the city council. The company's automatic equipment includes several Vaisala stations that support data output via API to a subscription-based service. The basic service can store data from the stations, build graphs and output indicators in CSV format, but cannot be upgraded to generate reports according to internal document management standards and does not support the generation of reports in accordance with CMU Resolution No.827.Therefore, the purpose of this study is to develop and implement an information system for the automatic collection, accumulation, structuring of data from Vaisala stations and automated generation of reports on the state of the atmospheric air, which will reduce the time required for the operator to prepare and provide comprehensive information on possible exceedances of harmful impurities in the air to regulatory authorities based on internal document management standards. First, the study analysed similar web resources that provide data on the state of the air and are publicly available. Then we developed and implemented an information system based on Ubuntu OS, Nginx server, MySQL database management system, PHP language with PHPWord and Laravel frameworks, Vue.js and Bootstrap JavaScript libraries, and vaisala_api, SPA, and AJAX network technologies. The server has been modified to process a large amount of data from Vaisala stations, for which separate tables have been created to upload raw data and a table to convert minute readings into 20-minute, daily, monthly and annual readings.

Development of a Web Application for the management of Georeferential Information regarding Biological Traps against the Fall Armyworm of the Center for Innovation and Technological Development of the Mezquital Valley

Today information technologies in the agricultural sector are widely used and this paper presents the development of a Web application that aims to manage the information generated by the application of biological traps that are installed in plots contaminated by the worm plague. armyworm (Spodoptera Frugiperda), these are developed by the Center for Innovation and Technological Development (CiDT) and distributed to corn producers in the Mezquital Valley to combat the plague. The Web application was developed with the agile development methodology called incremental, PHP technology, the MySQL Database Management System and the Here® WeGO API for manipulating georeferenced maps. To guarantee the functionality of the Web application, unit tests were implemented, defining use cases with information provided by CiDT. This Web application represents the first stage of a Hybrid Information System whose goal is to serve CiDT as a tool for monitoring and analyzing the behavior of the fall armyworm plague.

Design and Build an Industrial Work Practice Presence Information System Using Web-Based GPS

The design of this industrial work practice attendance information system can help the SMK Model PGRI 1 Mejayan to speed up the attendance process. This system is designed and built to make it easier for the school to find out the activities and positions of students who are doing industrial work practices by locking latitude and longitude. With the construction of this information system, the attendance process will be more closely monitored and reduce attendance manipulation. The purpose of this study was to determine the design and development of an industrial work practice attendance information system using a web-based GPS (Global Positioning System) at SMK Model PGRI 1 Mejayan. This system development method uses a system development model with the Rapid Application Development method and in its design uses the UML model. The result of this research is an industrial work practice attendance information system using a web-based GPS at SMK Model PGRI 1 Mejayan, and made using the programming language PHP, HTML 5, CSS, Java Script, Code Igniter 3 framework and using the MySQL Database Management System. In making this system using the Visual Studio Code text editor.

Perancangan Sistem Digitalisasi Pengelolaan Dana Desa

This study aims to design a digitalization system for managing village funds. The method used in this research is Research and Development (R&D). The village fund management digitization system was developed using the Waterfall model. The data collection technique consists of 3, namely interviews, observation and literature study. the method used is the PIECES method (Perfomance, Information, Economic, Control, Effience, and Service). The needs analysis of the system to be built is grouped into three parts, namely hardware requirements and software requirements. system design with UML (Unified Modeling Language). The programming language used to develop applications is the PHP programming language. In addition, MySQL Database Management System (DBMS) is used for data storage. The test model implemented in the development of the village fund management digitalization system is the Black-box. the results of testing using blackbox on the features work properly and run well, it is proven from the test results that all are successful, there are no failed test results. A digitalization system for managing village funds that can provide solutions to obstacles in managing village funds that are carried out