Database Maintenance Research Articles

Fertigungsprozessanalyse eines mittels Innenhochdruck-Umformung hergestellten Bauteils

Abstract Series manufacturers in the field of hydroforming do not always have the necessary database for predictive maintenance, especially for the production of complex hydroformed components. Small and medium-sized companies in particular often lack the resources to acquire, process and profitably utilize these data sets under production conditions. The IHU processes that occur in practice are usually highly complex, both in terms of geometry and against the background of additional process steps (punching, plunging). This results in large amounts of data and complex data analyses, which are reflected in the data processing costs. A data analysis is to be carried out on the basis of a complex hydroforming process and its additional benefit for quality management and predictive maintenance is to be explained.

Monitoring Coastal Evolution and Geomorphological Processes Using Time-Series Remote Sensing and Geospatial Analysis: Application Between Cape Serrat and Kef Abbed, Northern Tunisia

The monitoring of coastal evolution (coastline and associated geomorphological features) caused by episodic and persistent processes associated with climatic and anthropic activities is required for coastal management decisions. The availability of open access, remotely sensed data with increasing spatial, temporal, and spectral resolutions, is promising in this context. The coastline of Northern Tunisia is currently showing geomorphic process, such as increasing erosion associated with lateral sedimentation. This study aims to investigate the potential of time-series optical data, namely Landsat (from 1985–2019) and Google Earth® satellite imagery (from 2007 to 2023), to analyze shoreline changes and morphosedimentary and geomorphological processes between Cape Serrat and Kef Abbed, Northern Tunisia. The Digital Shoreline Analysis System (DSAS) was used to quantify the multitemporal rates of shoreline using two metrics: the net shoreline movement (NSM) and the end-point rate (EPR). Erosion was observed around the tombolo and near river mouths, exacerbated by the presence of surrounding dams, where the NSM is up to −8.31 m/year. Despite a total NSM of −15 m, seasonal dynamics revealed a maximum erosion in winter (71% negative NSM) and accretion in spring (57% positive NSM). The effects of currents, winds, and dams on dune dynamics were studied using historical images of Google Earth®. In the period from 1994 to 2023, the area is marked by dune face retreat and removal in more than 40% of the site, showing the increasing erosion. At finer spatial resolution and according to the synergy of field observations and photointerpretation, four key geomorphic processes shaping the coastline were identified: wave/tide action, wind transport, pedogenesis, and deposition. Given the frequent changes in coastal areas, this method facilitates the maintenance and updating of coastline databases, which are essential for analyzing the impacts of the sea level rise in the southern Mediterranean region. Furthermore, the developed approach could be implemented with a range of forecast scenarios to simulate the impacts of a higher future sea-level enhanced climate change.

Everything, everywhere, and all at once: A blueprint for supra‐organization of core facilities

AbstractCore facilities are crucial for cutting‐edge scientific research in academic institutions, yet they place a significant financial burden on budgets. The viability of these facilities can be improved through cross‐institutional collaborations, although initiating and sustaining such partnerships poses challenges. Insights from Israel's recent nationwide organization of core facilities could offer valuable lessons for fostering similar cooperation elsewhere. Despite the chronic shortfall in public research funding, Israeli research institutions were slow to fully embrace infrastructure sharing. This gap led to the creation of the Israel Research Core Facilities (IRCF) in 2022, which linked core facilities across the country through a bottom‐up approach. IRCF facilitated the formation of numerous specialized nation‐wide networks for intellectual exchange, and supported training workshops and meetings aimed at core technology providers. These initiatives serve dual purposes: they ensure the ongoing advancement of technological capabilities across facilities, regardless of their size or location, and they strengthen the commitment to the IRCF mission by motivating the maintenance of the IRCF database. As a result, a model of “capacity sharing” emerged, connecting all of Israel's core facility centers. This model enhances infrastructure use, supports strategic planning, and fosters growth. With over 450 core experts offering over 1100 scientific services consolidated into a publicly accessible database, IRCF supports research in universities, hospitals, government, and industry. This strategy could act as a model for creating regional core facility organizations to elevate research quality and ensure efficient infrastructure development.

An Improved Routing Protocol for Optimum Quality of Service in Device-to-Device and Energy Efficiency in 5G/B5G

Some challenges when implementing the optimized link state routing (OLSR) protocol on real-life devices and simulators are unmanageable: link quality, rapid energy depletion, and high processor loads. The causes of these challenges are link state processing, unsuitable multipoint relay (MPR) nodes, and information base maintenance. This paper proposes a structured, energy-efficient link sensing and database maintenance technique. The improved OLSR in the paper replaces the OLSRv2’s HELLO, HELLO, and Topology Control (TC) message sequence with a new sequence. MPR nodes are not mandated to broadcast TC messages if the number of nodes and their OLSRv2 addresses remain unchanged after subsequent broadcasts or if no node reported 2-hop symmetric connections. The paper further proposes an MPR selection technique that considers four parameters: node battery level, mobility speed, node degree, and connection to the base station for optimum relay selection. It combines the four parameters into one metric to reduce energy dissipation and control routing overhead. The modifications were implemented in NS-3, and the simulation results show that our improved OLSR outperforms the existing OLSR, OLSRv2 and other improved routing protocols in energy consumption, routing overhead, the packet delivery ratio and end-to-end delay, as compared to the related literature.

Optimizing medication guidance support for patients with cancer pain: development and evaluation of a pharmaceutical care system for healthcare professionals.

Effective management of cancer pain critically depends on timely medication administration and adherence to precise medication guidelines. In the context of limited time and a busy healthcare environment, tailoring the optimal medication schedule for each patient with cancer pain presents a significant challenge for physicians and clinical pharmacists. To address this challenge, we conducted a comprehensive analysis of healthcare professionals' needs in guiding cancer pain medication. By developing core features based on key user needs and continuously updating them, we have created the Universal Medication Schedule System (UMSS). We invited 20 physicians and pharmacists specializing in oncology or cancer pain to trial the system and assessed UMSS usage through distributed questionnaires. We identified five key needs of healthcare professionals in cancer pain medication guidance. Based on these needs, we (1) constructed a comprehensive drug information database, including basic information for 1135 drugs, 130,590 drug interaction data entries, and 1409 individual medication timing constraints, and (2) developed a web-based system that provides essential reference information such as drug interactions and dietary restrictions. It can create medication schedules and provide medication education tailored to the patient's daily routine. Participating evaluators unanimously agreed (100%) that the system aids in accurately assessing the risks of polypharmacy and quickly scheduling medication regimens. UMSS, by offering personalized medication schedule support, assists healthcare professionals in better managing patients' medication treatment plans. However, further improvements are needed in the automation of database updates and maintenance, as well as in integrating it with electronic health records.

TypeQL: A Type-Theoretic & Polymorphic Query Language

Relational data modeling can often be restrictive as it provides no direct facility for modeling polymorphic types, reified relations, multi-valued attributes, and other common high-level structures in data. This creates many challenges in data modeling and engineering tasks, and has led to the rise of more flexible NoSQL databases, such as graph and document databases. In the absence of structured schemas, however, we can neither express nor validate the intention of data models, making long-term maintenance of databases substantially more difficult. To resolve this dilemma, we argue that, parallel to the role of classical predicate logic for relational algebra, contemporary foundations of mathematics rooted in type theory can guide us in the development of powerful new high-level data models and query languages. To this end, we introduce a new polymorphic entity-relation-attribute (PERA) data model, grounded in type-theoretic principles and accessible through classical conceptual modeling, with a near-natural query language: TypeQL. We illustrate the syntax of TypeQL as well as its denotation in the PERA model, formalize our model as an algebraic theory with dependent types, and describe its stratified semantics.

A MongoDB Document Reconstruction Support System Using Natural Language Processing

Document-oriented databases, a type of Not Only SQL (NoSQL) database, are gaining popularity owing to their flexibility in data handling and performance for large-scale data. MongoDB, a typical document-oriented database, is a database that stores data in the JSON format, where the upper field involves lower fields and fields with the same related parent. One feature of this document-oriented database is that data are dynamically stored in an arbitrary location without explicitly defining a schema in advance. This flexibility violates the above property and causes difficulties for application program readability and database maintenance. To address these issues, we propose a reconstruction support method for document structures in MongoDB. The method uses the strength of the Has-A relationship between the parent and child fields, as well as the similarity of field names in the MongoDB documents in natural language processing, to reconstruct the data structure in MongoDB. As a result, the method transforms the parent and child fields into more coherent data structures. We evaluated our methods using real-world data and demonstrated their effectiveness.

Evaluation of Centrifugal Pump Availability Trends and Analysis

Centrifugal pumps are essential elements in industrial systems, facilitating fluid transfer and pressure generation across various applications. This study explores the vital task of evaluating centrifugal pump availability trends, focusing on three United Pumps crude delivery centrifugal pumps (P-90A, P-90B, and P-90C) over a span of seven years (2009-2015). With the use of derived equations and annual run-hours data from the facility's operations and maintenance database, the study ascertained the availability of the pumps. The findings and analysis showed that pumps P-90A and P-90B had significant decline in availability over the evaluation period (2009-2015), with P-90A finally failing in 2014. P-90C on the other hand, demonstrated relatively higher availability levels even though it was trending downward. The main cause of the decline in availability is attributed to the Original Equipment Manufacturers' decision to discontinue production of the pump model and its spares, which led to the substitution of locally made components for OEM parts. The study highlights the critical role, OEM support and its genuine spare parts play in optimising pump availability, reliability, and continuous operation—all of which prolong the pump's operating lifespan. It suggests improved methods, regular inspections, preventive maintenance, re-evaluating the quality of spare parts, and investigating replacement options. The study provides recommendations for improving pumping station performance and efficiency, based on empirical data and analysis, to industry stakeholders involved in crude oil delivery operations.

First outcomes of a therapeutic platform for drug resistant epilepsy based on transcutaneous electrical vagus nerve stimulation

Aim: The aim of this paper is to discuss the main features and first outcomes of a therapeutic platform proposed to implement a public health therapeutic service for patients suffering refractory epilepsy. Methods: The proposal is a three-layer system composed by a new portable therapy device and two software applications. The therapy is transcutaneous electrical vagus nerve stimulation, known as tVNS. The primary layer is composed of tVNS devices, configured for each patient according to the instructions provided by the specialists. The middle layer is named “hospital data collector” (HDC), its main tasks are the patient enrollment, the device setup, and the database maintenance to store therapeutic parameters and session events together with the information cited previously. Each hospital center runs a HDC that is connected to a cloud application named “system cloud application (SCA)” which concentrates all the data supplied by the HDCs. Artificial intelligence methods are integrated in the SCA to predict the treatment effectiveness for every new patient based on the accumulated knowledge from the enrolled previously. Results: A version of the proposed system is running at the Institute of Neurology and Neurosurgery. The sensitivity of the therapeutic device with the proposed treatment protocol reaches 83.33% in the 18-patient pilot trial carried out. Conclusions: The proposed approach seems a useful therapeutic tool based on the pilot trial outcomes. The developed device is comfortable and suitable for the intended use. The proposed system has created the essential conditions to feed and grow a knowledge, a basic element to predict the treatment effectiveness for each new patient. It is a promising option for a refractory epilepsy therapy service.

A Reflective Study of Computerized Database Application Technology and Maintenance

In the era of digitalization, computer databases have become an indispensable technological support across various industries. They not only house a vast amount of data but also enable efficient management and swift retrieval of this information. Concurrently, advancements in database application technology and maintenance have become crucial in ensuring the stable operation of information systems. However, contemporary computer database technology still faces numerous challenges such as data compatibility, automation levels, and flexibility in data transmission. Therefore, this study focuses on the key application techniques and maintenance mechanisms of computer databases, exploring measures to enhance data compatibility, improve production automation, strengthen the flexibility of data transmission, and bolster technical support. These efforts aim to drive the development of computer databases towards efficiency, stability, and security, thus laying a solid data foundation for the sustainable development of the entire information society.

MOODLE MANUAL UPGRADE METHODOLOGY

This abstract outlines a systematic four-step methodology for upgrading Moodle from version 3.6.5 to 3.9.9. The process begins with comprehensive backup and preparation, followed by the replacement of the Moodle codebase and execution of the upgrade script. Post-upgrade checks are performed to ensure the smooth functioning of core and third-party components. Additionally, the abstract explores the actions and functions of the cron script, emphasizing its role in executing scheduled tasks critical for Moodle's operation.
 Furthermore, the document sheds light on common reasons behind slow Moodle operation and provides practical tips for enhancing system speed. Recommendations include optimizing server resources, database maintenance, strategic caching implementation, and the judicious use of content delivery networks (CDNs). The importance of upgrading PHP and database versions is highlighted, alongside the benefits of disabling unused features and employing server monitoring tools. The abstract emphasizes the significance of staying abreast of Moodle updates for continued performance improvements and bug fixes, offering a holistic guide for upgrading and optimizing Moodle systems.

Resource management system database maintenance in cloud computing

The Resource Management System (RMS) is a comprehensive solution designed to optimize resource allocation, enhance project efficiency, and streamline customer interactions within a dynamic business environment. The system encompasses four key components: projects, resources, customers, and business units. It offers a range of functionalities including create, update, retrieve, and delete operations to facilitate seamless operations and data management. The RMS is built using Spring Boot (Java) for the backend, providing a robust and scalable foundation. The front end is developed using React, ensuring a modern and user-friendly interface. Data is managed in a MySQL database, offering reliability and data integrity. Communication between frontend and backend is achieved through RESTful APIs. Resource Management system typically manage and allocate non-human resources and as well human resources throughout an organization, However, if we choose to pursue human resources management, we will recruit, hire, train, manage employees and staff which is also a variation of resources. It provides comprehensive solution designed to optimize resource allocation, enhance project efficiency, and streamline customer interactions within a dynamic business environment.

Quality Management in GIS

This paper centers on the crucial elements of quality control (QC) and quality assurance (QA) in the domain of geographic information systems (GIS). A dependable and resilient GIS database is at the core of any spatial system, and it is of utmost significance across a wide range of fields, including Hajj, Umrah, tourism, real estate, and natural resource management. Given the inherent intricacy of spatial databases and their requirement for specialized technical upkeep, applications that depend on them also necessitate specialized technical expertise. To address inconsistencies within the database, best practices for database maintenance are implemented. This paper presents a systematic approach to the updating of comprehensive spatial databases and provides an overview of the quality procedures that are essential to this process. It also discusses the various safeguard mechanisms that are employed to enhance data consistency, completeness, integrity, and other qualitative aspects. The primary objective is to establish a customer-focused quality standard for spatial databases. Considering the broad definition of quality as "the extent to which project deliverables meet requirements," GIS projects face the challenge of precisely defining specifications and relevant quality standards that are tailored to specific project types and deliverables. The increasing demand for digital maps and GIS applications in Egypt emphasizes the urgent need for quality control and quality assurance procedures. This paper describes the implementation of these procedures in the creation of ten geological maps of Egypt at a scale of 1:500,000. This collaborative effort involves Cairo University and the Ministry of Water Resources and Irrigation in Egypt. Additionally, this project provides an internship opportunity for students in the College of Engineering, Civil Department, enabling them to gain practical experience in the field.

Сравнительный анализ использования электронных технологий Интернета вещей в сфере здравоохранения зарубежных стран и России.

The development of digital and information and communication technologies contributes to fundamental changes in all spheres of human life. Thanks to the Internet of Things technologies, medicine has moved to a new level of efficiency, convenience and quality of providing electronic medical services. The problems of the introduction of electronic services in the context of the development of e-governance require special consideration, potential threats in the collection, processing and storage of data in the field of healthcare are of particular concern. P u r p o s e o f t h e s t u d y is to conduct a comparative analysis of the use of modern trends in the introduction of electronic services in the healthcare sector of foreign countries and Russia with the use of Internet of Things technologies in the conditions of digitalization of the industry. M a t e r i a l s a n d m e t h o d s . The following methods were used in the work: analysis – when searching and familiarizing with various web resources, relevant programs and portals on electronic management and the Internet of Things; comparison – when comparing the stages and mechanisms of using Internet of Things technologies in the development of digitalization of healthcare in the world; analogy and extrapolation – to determine the possibilities, implementation of foreign experience. R e s u l t s . The best foreign practices of providing electronic services in the field of healthcare with the use of Internet of Things technologies were revealed. A trend has been established for the appearance and use of various devices using Internet of Things technology that are used to provide medical services, in particular those that have the functions of medical equipment and help to conduct an online examination. The US experience in the introduction of electronic medical records and the maintenance of relevant databases is disclosed. Separately, attention is focused on the experience of countries that are trying to prevent excessive personalization and identification of data. С o n c l u s i o n s . Thus, electronic services are services that are provided in electronic format online. In Russia, they are regulated by a significant list of regulatory legal acts. At the same time, for the effective use of Internet of Things technologies in the provision of electronic medical services, first of all, it is necessary to solve the problem of de-identification (depersonalization) of data that is collected to meet this service.

TaiCOL Scientific Names Management Tool: Rebuilding the National Checklist in Taiwan Based on References

Many checklist databases encounter common challenges. While they may fulfill the requirements of scientific name collection and species inquiries successfully, they often fall short in recording and presenting diverse opinions on scientific name usage over time and among different scholars. Moreover, due to the rapidity of classification changes and limited workforce for database maintenance, these checklists usually cannot be updated promptly. Last but not least, exchanging checklists poses a complex challenge such as name matching for synonym, homonym, orthographic variations and misapplied names. Therefore, an ideal database design should maintain neutrality and objectivity by recording comprehensive taxonomic history information of scientific names. The database can then present multiple views on scientific name usage after integrating data, allowing users to judge and interpret for themselves. “Catalogue of Life in Taiwan” (TaiCOL*1) is the national database established in 2003 aiming to provide the most updated species checklist of Taiwan. However, it faces the challenges aforementioned. To design the database model, we conducted a method study to investigate how taxonomy works. Our findings identified key concepts (e.g., scientific name, name usage, similarities or differences in name usage, and namespace) for building the database structure to connect and interpret nomenclatural and taxonomic information. Furthermore, to effectively manage the vast amount of complex taxonomic history, we aim to develop a tool as the core for TaiCOL data management, enabling taxonomy researchers to assist in enriching the content of the database while completing scientific names management and research work. Additionally, we surveyed the nomenclature codes (Ride 1999, Turland 2018) and interviewed taxonomists in zoological and botanical fields to understand their working methods, processes, and writing conventions. This ensured that our tool aligns with the taxonomy research workflow and meets the needs of various biological disciplines. “Scientific Names Management Tool”*2 is now available for use and undergoing continuous optimization. It is not limited to use in Taiwan, but only scientific names labeled as "existing in Taiwan" will be integrated into the TaiCOL portal. For public use, the taxa are generated or updated for the TaiCOL portal through logical processing based on the latest classification results from the tool. Although the TaiCOL portal currently presents only one taxonomic view, the different usages of scientific names and various species information can be traced by giving the references. As for checklist exchange, in case of discrepancies or conflicts, alternative usages will be provided during name matching. In the future, users can have the option to choose references to obtain different taxonomic views of checklists.

Peculiarities of information and analytical support in conducting epidemiological surveillance in the public health system

Objective. The purpose of this study was to determine the features of information and analytical support in the conduct of epidemiological surveillance in the system of public health institutions. Methods. The research was performed on the basis of the following methods: dialectical - to determine the essence of information and analytical support of public health institutions; functional, comparative analysis - to analyze the activities of the State Institution "Kirovohrad Regional Center for Disease Control and Prevention of the Ministry of Health of Ukraine"; model, integrated approaches - to develop a model of information and analytical support for the activities of public health institutions and measures for its implementation in practice; methods of statistical analysis - to determine the features of research on environmental objects and the dynamics of infectious diseases. Results and discussion. A study of the functioning of public health institutions, in particular the Kirovohrad Regional Center for Disease Control and Prevention of the Ministry of Health of Ukraine, identified general areas for development and implementation to improve public health. Conclusions : In the process of improving the information and analytical support of the activities of epidemiological surveillance institutions in the public health system, its key aspects of development were presented. More detailed solutions to public health problems were suggested. Tasks have been formulated to improve the information and analytical support of the activities of epidemiological surveillance institutions in the public health system. It is established that all these aspects, which are related to improving the information and analytical function of public health institutions, for full use must be integrated into a single automated system with the creation and maintenance of information databases and information exchange functions, including real time. The structure of the model of information and analytical support for the activities of public health institutions has been developed. The main elements of the information-analytical system of epidemiological surveillance institutions in the public health system should be: databases of necessary information, system of indicators of public health, state of the environment, data processing system, communication system, transmission, information protection, system forecasting changes in public health indicators, the base of standard management decisions in certain circumstances (combinations of indicators), equipped with digital user workstations.

Discovering Water- and Fuel-System Maintenance Requirements Using Historic Work Order Cost Data: Data and Text-Mining Approach

Ensuring reliable facility services with aging infrastructure and growing deferred maintenance backlogs in water and fuel systems requires properly managing the maintenance of these critical systems. Dormitories safeguard the comfort and health of their occupants, but they rely on proactive management of and response to infrastructure failures. This study employed a data and text-mining approach to analyze 43,704 water and fuel work orders queried from a military maintenance database to identify the most common and costly failure types and the components that most frequently fail in dormitories. Statistical and correlation analysis indicated that leaks, clogs, and temperature regulation are problems that cost the most and occur most frequently, and toilets, sinks, and showers are the components that most often need repair. This study provides an intellectual framework for analyzing past maintenance work orders to reveal trends in failure types and components. The study contributes to the practice of infrastructure management by revealing that design and maintenance management should focus on preventing and repairing these common and costly failures.

Ambient air pollution exposure linked to long COVID among young adults: a nested survey in a population-based cohort inSweden.

Post COVID-19 conditions, also known as long COVID, are of public health concern, but little is known about their underlying risk factors. We aimed to investigate associations of air pollution exposure with long COVID among Swedish young adults. We used data from the BAMSE (Children, Allergy, Environment, Stockholm, Epidemiology [in Swedish]) cohort. From October 2021 to February 2022 participants answered a web-questionnaire focusing on persistent symptoms following acute SARS-CoV-2 infection. Long COVID was defined as symptoms after confirmed infection with SARS-CoV-2 lasting for two months or longer. Ambient air pollution levels (particulate matter ≤2.5μm [PM2.5], ≤10μm [PM10], black carbon [BC] and nitrogen oxides [NOx]) at individual-level addresses were estimated using dispersion modelling. A total of 753 participants with SARS-CoV-2 infection were included of whom 116 (15.4%) reported having long COVID. The most common symptoms were altered smell/taste (n=80, 10.6%), dyspnea (n=36, 4.8%) and fatigue (n=34, 4.5%). Median annual PM2.5 exposure in 2019 (pre-pandemic) was 6.39 (interquartile range [IQR] 6.06-6.71) μg/m3. Adjusted Odds Ratios (95% confidence intervals) of PM2.5 per IQR increase were 1.28 (1.02-1.60) for long COVID, 1.65 (1.09-2.50) for dyspnea symptoms and 1.29 (0.97-1.70) for altered smell/taste. Positive associations were found for the other air pollutants and remained consistent across sensitivity analyses. Associations tended to be stronger among participants with asthma, and those having had COVID during 2020 (versus 2021). Ambient long-term PM2.5 exposure may affect the risk of long COVID in young adults, supporting efforts for continuously improving air quality. The study received funding from the Swedish Research Council (grant no. 2020-01886, 2022-06340), the Swedish Research Council for Health, Working life and Welfare (FORTE grant no. 2017-01146), the Swedish Heart-Lung Foundation, Karolinska Institute (no. 2022-01807) and Region Stockholm (ALF project for cohort and database maintenance).

IWFUCIA: An integrated model for Wi-Fi fingerprints radio map updating and localization on changed impact analysis

In Wi-Fi fingerprinting indoor localization, automating radio map database maintenance is one of the crucial issues, as it is a labour-intensive and long-term task for collecting and filtering samples to keep an up-to-date and accurate database. In particular, those access points (APs) newly installed in the environment should update radio maps and be included in the database to improve localization performance. This study presents an IWFUCIA system that automates indoor radio map database maintenance (RMapDM) using crowdsourced samples without accurate location annotation. The IWFUCIA incorporates the newly installed APs detection and identification, the significant APs feature selection, fingerprint integration updating, and online localization algorithms. After collecting new crowdsourced samples, we apply Willmott’s index of agreement (WIA) based on the Supported Vector Machine (SVM) regression to detect and identify a newly installed AP and the original existing ones. After getting the new APs, we propose a correlated coefficient and t-test score algorithm to select only those significant AP-based feature samples. We also proposed a fingerprint integration model to fuse original existing and new APs to update the database. Extensive experiments have been conducted in our teaching building to validate and evaluate the effectiveness of IWFUCIA. The results show that our IWFUCIA is robust for long-term maintenance and updating the outdated radio map database server. The average localization accuracy achieves 0.466 m, which significantly outperforms the localization positioning approaches with the original radio map by 84.96%, outdated radio maps by the changed APs powers removed, increased and decreased by 26.32%, 55.36%, and 73.14%, respectively.

Exploring structural database use in crystallography: a workshop series of the U.S. National Committee for Crystallography

The U.S. National Committee for Crystallography (USNC/Cr) of the National Academies of Sciences, Engineering, and Medicine provided an online workshop series for researchers on the use, development, and maintenance of crystallographic and structural databases in the Spring of 2022. Encompassing macromolecular, small molecule, and powder diffraction information, the series included 11 modules each meeting for 1 or 2 days. Graduate students, postdoctoral fellows, faculty members and researchers in any of the crystallographic, diffraction, and imaging sciences affiliated with the International Union of Crystallography (IUCr) were encouraged to register and participate in the training sessions that interest them.