Database Program Research Articles

A tool for integrating agrometeorological observation data for digital agriculture: A Minnesota case study

AbstractAgrometeorological data are essential for understanding production using digital agriculture techniques. However, integrating agrometerological observations from multiple sources remains a challenge. Often, digital agriculture scientists download and clean the same datasets many times. We present a prototype system that simplifies the process of collecting, cleaning, integrating, and aggregating data from meteorological data sources by providing a simplified user interface, database, and application programming interface. The prototype provides a standard interface for querying multiple geospatial formats (raster and vector) and integrates observation networks including the National Oceanic and Atmospheric Administration Global Historical Climatology Network (NOAA GHCN), NOAA NClim‐Grid (NOAA's Gridded Climate Normals), and Ameriflux BASE. The system automatically checks and updates data, saving storage space and processing time, and allows users to summarize data spatially and temporally. Provided as open source code and browser‐based user interface, the application and integration system can be run across Windows, Linux, and Mac environments to support broader use of multi‐source agrometeorology data.

Using active learning methodologies to teach sequence analysis and molecular phylogeny.

The great development of high-throughput molecular biology techniques and the consequent generation of massive data have made Bioinformatics essential for undergraduate Bioscience students. The importance of this scientific discipline is evidenced by the huge number of specialized publications, tools, and databases available. Training in Bioinformatics equips undergraduates with transferable skills that can be applied in all fields of Biology, such as programming abilities, data analysis, database management, biological knowledge, statistics, problem solving, and interdisciplinary collaboration. Over the past decade, there has been a notable increase in the number of higher education institutions worldwide that have adopted a competency-based curricula. This approach places a significant emphasis on the actions and skills that students are expected to develop, rather than merely focusing on the information, they are required to memorize. In this educational context, the use of active learning strategies has been demonstrated to enhance student comprehension and competency development. This paper describes the implementation of an active learning approach in a hands-on lesson performed by undergraduate students of Biology at the University of Malaga (Spain). Its main objective is to introduce students to molecular databases and information search systems on genes, proteins, and phylogeny. This is achieved within the framework of a smart campus, which integrates technological and sustainable resources to promote a positive and productive learning environment for the university community. This work presents the content and procedure of this practical activity, as well as the evaluation method and the results of a student survey to assess their opinions.

Emulating target trials of postexposure vaccines using observational data.

Postexposure vaccination has the potential to prevent or modify the course of clinical disease among those exposed to a pathogen. However, due to logistical constraints, postexposure vaccine trials have been difficult to implement in practice. In place of trials, investigators have used observational data to estimate the effectiveness or optimal timing window for postexposure vaccines, but the relationship between these analyses and those that would be conducted in a trial is often unclear. Here, we define several possible target trials for postexposure vaccination and show how, under certain conditions, they can be emulated using observational data. We emphasize the importance of the incubation period and the timing of vaccination in trial design and emulation. As an example, we specify a protocol for postexposure vaccination against mpox and provide a step-by-step description of how to emulate it using data from a healthcare database or contact tracing program. We further illustrate some of the benefits of the target trial approach through simulation.

Analisis Bibliometrik Industri Kreatif Berkelanjutan di Indonesia

This paper aims at providing an overview and synthesis of the existing body of knowledge about Creative Industry in Indonesia. Special attention is paid to the articles directly linked with sustainability creative industries in Indonesia. Design/methodology/approach – A bibliometric analysis was performed over 925 documents extracted from the Google Scholar database, using PoP, Zotero, and VOS viewer software programs. Findings – Publications related to the sustainable creative industry are still very minimal. The publication mainly reviews case studies and analyzes of the phenomena of creative industry activities in a narrow, local and thematic way. There have not been many publications regarding the theory, direction and future of sustainable industries globally. Social implications – The development of scientific knowledge about sustainability of creative industry puts this social claim on the spotlight of business management studies, helping bussinesmen and to reduce the environmental impact of corporate activities. Studying sustainability will help to reduce its frequency and, therefore, heal the planet. Conclusion - Facing the increasingly threat of damage due to developments in human needs, the sustainable industrial sector absolutely needs attention. Likewise in the creative industry sector. More attention is needed from the government and creative industry players to place greater emphasis on environmentally friendly and socially friendly industries. Thus, Scientific studies that examine sustainable creative industries must be increased and become a concern for all of us

Development of a database program for managing genotype information and simulating segregation patterns of horticulturally important genes in apple

Development of a database program for managing genotype information and simulating segregation patterns of horticulturally important genes in apple

Survival in patients with rheumatoid arthritis and early breast cancer treated with tumor necrosis factor inhibitors.

There have been concerns about the use of tumor necrosis factor inhibitors (TNFi) for autoimmune disease in patients with recently diagnosed cancer. We assessed the survival of patients with rheumatoid arthritis (RA) and newly diagnosed early breast cancer (BC) treated with TNFi in the first two years after BC diagnosis. We identified patients in two datasets: (1) Optum's de-identified Clinformatics® Data Mart Database (CDM), (2) Surveillance, Epidemiology, and End Results program (SEER) and Texas Cancer Registry (TCR) Medicare-linked cohort. We grouped patients according to whether they received TNFi, conventional synthetic disease-modifying antirheumatic drugs (csDMARDs) only, or no DMARDs within 2years after BC. Outcomes were overall survival (OS) and BC-specific survival (BCSS). We conducted landmark analyses at years 1 and 2, with multivariable Cox regressions using propensity scores for adjustment. In the first year after BC, 165/970 (17.0%) and 201/1246 (16.1%) patients received TNFi in CDM and SEER/TCR-Medicare respectively. In the 1year landmark, no significant differences in OS were observed between patients treated with TNFi and patients treated with csDMARDs only in CDM (hazard ratio [HR] = 0.77, 95% confidence interval [CI] 0.42-1.40) or SEER/TCR-Medicare (HR = 0.84, 95% CI 0.54-1.31). BCSS (SEER/TCR-Medicare) was better in patients receiving TNFi than in those receiving csDMARDs only (HR = 0.28, 95% CI 0.08-0.98). In CDM, glucocorticoid therapy had worse OS than those without glucocorticoids (HR = 2.18, 95% CI 1.13-4.18). This was also observed in SEER/TCR-Medicare (not statistically significant). Similar results were observed for the 2year landmark. TNFi treatment during the first two years after early BC was not associated with worse survival.

Exploring the role of a microlearning instructional approach in an introductory database programming course: an exploratory case study

Exploring the role of a microlearning instructional approach in an introductory database programming course: an exploratory case study

Using Technology in Science Education:A Bibliometric Analysis

The aim of this study is to reveal the bibliometric profile of articles published in the field of science education and technology. In the study, in which descriptive research model was used, bibliometric analysis method was preferred in order to reveal and examine the research trends of scientific publications on science education and technology. In the study, Web of Science Core Collection was preferred as the database and VOSviewer program was preferred as the bibliometric network analysis program. In the Web of Science Core Collection database, 2485 articles were accessed after searching with the keywords “science educat*” and “technology*”. As a result of the research, it was determined that the first article in the relevant subject area was published in 1980 and the most articles were published in 2022. The country with the highest number of publications in the related field is the USA. The researcher who published the most in the related field is Franz Xaver Bogner. The most publications were published in the Journal of Science Education. Most frequently used keyword in the related articles is science education. The study is important in terms of revealing the research trend of science education and technology articles.

RADIOTHERAPY 3D ISODOSEZONES GRAPHICAL OPTIMIZATION FOR HYPERFRACTIONATED TREATMENT PLANNING DOSIMETRY IN LUNG AND HEAD-NECK TUMORS WITH BIOLOGICAL EFFECTIVE DOSE MODEL

In recent lung and prostate cancer-radiotherapy contributions, [101-5], 3D imaging-processing Isodosezones [ Casesnoves, 2022 ], delimited by 3D Isodoselines were explained in lung cancer and other tumor types, such as prostate or lung. The radiotherapy model applied was the classical BED one algorithm. Modern biological-model-based Treatment Planning Optimization can get objective improvements by using Isodosezones/lines when selecting the optimal dose delivery/schedule for any personalized treatment. Improved programming, from [ Casesnoves, May 7th, 2024 ], and engineered software is perfectioned-developed for numerical hyperfractionated 3D TPO lung and head-neck cancer imaging-processing with upgraded previous database. Mathematical algorithms are explained-detailed. Developed programming patters and arrays are briefed. A series of imaging-processing graphics results obtained with the 3D Isodosezones Pareto-Multiobjective Optimization programming database are shown and explained in detailed. Applications in radiotherapy-oncology medical physics are subsequently briefed.

SISTEM INFORMASI MONITORING ADMINISTRASI SURAT BERBASIS WEBSITE PADA BADAN AMIL ZAKAT NASIONAL PROVINSI JAWA TIMUR

This study aims to develop a website-based mail administration monitoring information system at the National Amil Zakat Board of East Java Province. This website is to track the distribution of letters to these institutions so that they can be controlled properly with the help of a tracking system. The National Amil Zakat Agency (BAZNAS) of East Java Province follows a systematic research process which includes identifying problems and user needs through data collection, system analysis, system design, building systems using PHP programming and MySQL databases, system testing using Blackbox, and documentation and reports .

Immunotherapy-based therapy versus chemotherapy for the neoadjuvant treatment of locally advanced dMMR/MSI-H gastric cancer.

e16121 Background: Growing evidences have suggested that immunotherapy represents a promising treatment for the neoadjuvant treatment of mismatch repair-deficient (dMMR)/microsatellite instability-high (MSI-H) gastric cancer. The study aimed to compare the efficacy of neoadjuvant chemotherapy and immune checkpoint inhibitor (ICI)-based therapy in locally advanced, dMMR/MSI-H gastric cancer. Methods: Patients with MSI-H/dMMR locally advanced gastric cancer who received neoadjuvant chemotherapy, or ICI-based therapy between December 2018 and June 2023 at West China Hospital, Sichuan University were included. Patient data were collected from the prospectively database program of gastric cancer at our Hospital. Demographic and clinicopathologic data of patients were collected, including age, sex, ECOG performance status, primary tumor site, tumor staging, Lauren’s classification, tumor response, tumor regression grade (TRG), R0 resection, disease-free survival (DFS) and overall survival (OS). Results: A total of 21 patients treated with ICIs-based regimens and 18 patients treated with chemotherapy were included. In the ICI-based therapy group, 10 patients (47.6%) received dual PD-1 and CTLA-4 blockade, 1 patient (4.8%) received PD-1 blockade, and 10 patients (47.6%) received PD-1 blockade combined with chemotherapy. The median age of chemotherapy group and ICI-based group were 63 years (range, 36-76 years) and 59 years (range, 34-74 years), respectively. The rates of T4b and limited metastases were significantly higher in the ICI-based therapy group compared to chemotherapy group (T4b: 11.1% vs. 23.8%; limited metastases: 0% vs. 19.0%). 17 patients (94.4%) in the chemotherapy group and 20 patients (95.2%) in the ICI-based therapy group underwent R0 radical gastrectomy. One patient in the chemotherapy group did not undergo surgery due to disease progression. One patient in the ICI-based therapy group refused radical gastrectomy. For patients undergoing surgery, TRG 0-1 rate was obviously lower in patients receiving chemotherapy compared to those treated with ICI-based regimen (0.0% vs. 78.9%). The pCR rates in the chemotherapy group and ICI-based group were 0.0% and 57.9%, respectively. The pCR rates in patients treated with dual PD-1/CTLA-4 blockade and PD-1 blockade with chemotherapy were 66.6% and 50.0% (P = 0.65). Median DFS and OS have not yet been achieved due to the short follow-up time. Conclusions: Improvements in TRG 0-1 rate and pCR rate suggested that ICI-based treatments are favorable in the neoadjuvant setting of locally advanced, dMMR/MSI-H gastric cancer compared to chemotherapy. However, within the overall favorable group, there was no differences between dual PD-1/CTLA-4 blockade and PD-1 blockade with chemotherapy in term of pCR rate. Whether high pCR rates can translate into long-term survival benefits requires longer follow-up time.

Distributions and bootstrap for data-based stochastic programming

Distributions and bootstrap for data-based stochastic programming

WEBSITE DESIGN INFORMATION SYSTEM OF RECORDING OFFENS AND PUNISHMENT STUDENTS SMK MUHAMMADIYAH 8 SILIRAGUNG USE WATERFALL DEVELOPMENT METHOD

Educational institutions as learning centers are prepared so they keep up through developments, especially regarding the use of information systems which are expected to facilitate the completion of work effectively and in an efficient time so institutions can improve their quality achievements. In this case, SMK Muhammadiyah 8 Siliragung experienced issues in the counselling division regarding recording violations and sanctions which required plenty of time to process and search for the required documents manually. To overcome issues, an information system for recording, as well as storing the history of violations carried out in a computerized manner efficiently to search for history data. This system development uses waterfall development methodology with a MySQL storage database and WEB-based PHP programming language. This research succeeded in identifying the needs through data collection methods, analysis of needs planning and observation meanwhile the system is equipped with a login and logout, a student data, a record, an administration letter, as well as a problematic student data report feature with a violation filter. This information system have been to overcome the issues.

HOSPITAL MANAGEMENT SYSTEM BASED ON WEB

Hospital Management Systems (HMS) represent a key advancement in healthcare technology designed to revolutionize operational efficiency, raise standards of patient care and ensure compliance with regulatory protocols. This paper explores the multifaceted functions of HMS, highlighting its role in automating administrative tasks, supporting real-time access to patient data, and facilitating seamless communication between healthcare professionals. Drawing on current research and practical implementations, we delve into the transformative potential of HMS, particularly in the context of recent innovations in telemedicine, data analytics, and remote monitoring systems. In our research, we present SIMRS, a robust hospital management information system developed using the waterfall method, strategically focused on the systematic improvement of hospital operations. By automating key processes such as patient registration, appointment scheduling, payment and inventory management, SIMRS optimizes hospital workflows and ultimately improves patient care delivery. In addition, we examine the empirical evidence that shows the significant impact of management systems and leadership traits on the quality of care in hospital settings, and highlight the indispensable role of effective leadership and management frameworks. Next, we discuss the technical foundations of HMS and highlight the integration of various programming languages and database management systems such as HTML, CSS, JavaScript, PHP, MySQL, and MongoDB. This cross-disciplinary approach underscores the synergy between technological innovation and healthcare management, paving the way for a more efficient patient- centered healthcare ecosystem. In summary, this research illuminates the transformative potential of HMS to revolutionize healthcare operations, improve patient outcomes and optimize resource allocation, advocating for its widespread adoption to shape the future of healthcare delivery. Key Words: JavaScript, MySql, HMS, Electronic Health Records, Telehealth

Development of Virtual Classes and Laboratories with Remote Access

When comparing a few decades ago to now, the educational system has undergone various technological revolutions, particularly with the usage of Virtual Learning Environments (VLEs), which have changed the process of teaching and learning. VLEs with internet services play a major role in the storage of information and its dissemination. With the use of VLEs, there emerges the challenge of bringing practical classes online, engaging the students in practical sessions as it is in traditional laboratories. Though, there have been various simulators but they are not geared towards educational sessions but practically for industrial use and are not curriculum-based, this has been a major concern in engaging the students practically at a distance level according to the instructor’s plan. Hence, in this work, a robust VLE has been designed and implemented. The system has an evaluated model that was developed with MySQL and PHP, which served as the database and server-side programming, respectively. The proposed VLE offers an interactive web-enabled approach for online learning and practice, practical recordings are uploaded, and practical simulations are handled. Qualitative assessments were carried out on the gathered data from the 100 respondents through the use of the questionnaire. Performance metrics such as response time, latency, availability, reliability and scalability were used to conduct a comparative analysis between the existing VLEs and the developed VLE. The findings of the study showed that the utilisation of the proposed VLE has the potential to cause a positive transformation and a paradigm shift in educational institutions.

Design of Information System for Pajjaiang Makassar Clinic Based on Web and Mobile

The role of information technology is currently developed according to the current rapid development of the times. The most developed types of information technology are web-based and mobile devices. Web-based and mobile devices are used to facilitate daily activities along with technological advances. One of the important things for everyday life by utilizing technological advances is in the field of health services, especially services at health clinics. In this regard, a web-based and mobile information system was designed at the Pajjaiang Makassar clinic to facilitate service. Making this system uses the waterfall method which is often used in the development of information systems or software. This system consists of 4 actors, namely patients, admins, doctors, and pharmacists. Patients are connected to the mobile application, while admins, doctors, and pharmacists are connected on the web side. The patient registers for the examination, the admin manages the patient's data, the doctor conducts the examination, and the pharmacist manages the available drugs. Everything is interconnected using mysql database as the database and Application Programming Interface (API) to connect it. With this web-based and mobile information system is a form of digitalization process in the field of health services.

Designing an information system for recapitulating goods received transactions

This research aims to design and implement an information system to recapitulate goods receipt and delivery transactions. Previously, this process used Microsoft Excel, which required manual data copying, took a long time, and required daily, weekly, and monthly printing and reporting. In addition, the application used was not stored in a database and was not integrated with the network, making data processing inefficient. In order to overcome this problem, the research developed a database programming-based information system with the waterfall method for the design stage. System modelling is done with the Unified Modeling Language (UML). This research produces a needs analysis, system design using UML, and nine tables supporting the system. Testing is done with black box testing and direct trials by users involved in data management, showing satisfactory results. Implementing the system using PHP programming and MySQL database resulted in a web-based application that accelerates the recapitulation process, stores data in the database, and is integrated with the network. This application is proven to speed up data processing. The application needs to be improved with more complex technology and compatible with various smartphones for further development. In addition, the app needs a dashboard feature to display the number of daily monthly deliveries, as well as the income of each officer. Increasing the number of human resources capable of maintaining the system is also important to ensure its sustainability and efficiency.

Design of a web-based information system for domestic sea transportation services for limited liability company goods

This research aims to design and implement a web-based information system for domestic sea transportation services of goods owned by a Limited Liability Company. Currently, the Limited Liability Company faces challenges in administrating goods due to the time-consuming recording process and using Excel applications that are prone to manual errors, accompanied by inaccuracies due to the absence of an integrated database system. The information system developed uses the waterfall approach for system design and the Unified Modeling Language (UML) for modelling, resulting in a requirements analysis, UML-based system design, and eight database tables that support system functionality. The use of PHP programming and MySQL database in the system implementation resulted in a web application that allows PT NSE to manage administration in a timely and accurately, with reports stored in the database. To enhance the executive dashboard of the domestic sea transportation service information system for goods, revamping the display for more visual and informative data presentation is essential. Additionally, integrating an Excel export feature will facilitate further data processing by relevant parties. Adequate resources must be allocated to maintain and manage the system effectively, ensuring seamless and sustainable operation. By implementing this information system, the Limited Liability Company is expected to boost administrative efficiency and accuracy, thereby solidifying its position in Indonesia's logistics service industry.

Analysis of information flow security using software implementing business logic based on stored database program blocks

Objectives. Verification of software security is typically performed using dynamic and static analysis tools. The corresponding types of analysis do not usually consider the business logic of the software and do not rely on data access control policies. A modern approach to resolving this problem is to implement language-based information flow control. Despite a large amount of research, mechanisms for information flow control in software are not widely used in practice. This is because they are complex and impose increased demands on developers. The aim of the work is to transfer information flow control from the language level to the level of formal verification. This will enable the functions of controlling data integrity and confidentiality in software to be isolated into a separate task, which can be resolved by information security analysts.Methods. The research is based on general formal security methods for computer systems and formal verification methods. The algorithm developed by the author for checking security specifications and resolving security violations uses temporal logic of actions.Results. The technology is presented as a step-by-step approach to resolving specific tasks, including the following: designing a database (DB) for storing and processing sensitive information; analyzing dependencies and identifying relevant sets of program blocks in the DB; generating TLA+ specifications for the identified program blocks; labeling specifications according to global security policy rules and additional constraints; applying the specification verification algorithm, and resolving security violations while providing recommendations for software developers. The procedure also involves analyzing labeled data, in order to control the spread of verified program block output values in external software modules.Conclusions. The technology presented herein does not require developers to include redundant annotations describing security policy rules. The function of analyzing information flows with reference to predefined access restrictions is moved to a separate stage of the software development life cycle.

Data-Based Robust Adaptive Dynamic Programming for Balancing Control Performance and Energy Consumption in Wastewater Treatment Process

Data-Based Robust Adaptive Dynamic Programming for Balancing Control Performance and Energy Consumption in Wastewater Treatment Process