Database Design Research Articles

Design and requirements of a hydrogen component reliability database (HyCReD)

Hydrogen technologies are expected to play a key role in the decarbonization of several sectors including energy storage and transportation. Rigorous investigation and quantification of the risk and reliability issues associated with hydrogen technologies will be critical to ensuring both their wider adoption and safe, economical operations. Quantitative risk assessment (QRA) is an important tool that has been used to enable the safe deployment of many engineering systems, including hydrogen fueling stations and hydrogen storage systems. However, QRA studies require reliability data which is currently lacking for expanding applications of hydrogen systems. To address this gap, we present a new structure for a hydrogen component reliability database (HyCReD) that can be used to generate reliability data to be used in QRA, reliability, safety studies, maintenance planning, and more. Building on our previous work examining four major hydrogen safety data collection tools (West et al., 2022) [1], our approach in this work was to consult scientific literature on reliability data collection as well as a number of existing reliability engineering databases in the oil & gas, chemical processing, and nuclear power plant sectors. The evaluation of these databases led to identifying best practices to be implemented in a data collection framework for a hydrogen component reliability database. Based on these best practices, a set of 24 requirements for the proposed database are presented, covering its characteristics and the types of data to be collected. We define the structure of the HyCReD database and 25 data elements to be collected, spanning system description, failure, shutdown, or near-miss events, and maintenance events. The data elements are then defined according to international standards used in the safety and reliability practice and potential choice lists are provided for each field. Since this database is being piloted for hydrogen fueling stations, a generic station component hierarchy developed by West (2021) [2] is used to standardize system data. Finally, we demonstrate populating the database with information extracted from five narrative reports on hydrogen fueling station incidents.

Data-based design of multi-model inferential sensors

This paper deals with the problem of inferential (soft) sensor design. The nonlinear character of industrial processes is usually the main limitation to designing simple linear inferential sensors with sufficient accuracy. In order to increase the inferential sensor predictive performance and yet to maintain its linear structure, multi-model inferential sensors represent a straightforward option. In this contribution, we propose two novel approaches for the design of multi-model inferential sensors aiming to mitigate some drawbacks of the state-of-the-art approaches. For a demonstration of the developed techniques, we design inferential sensors for a Vacuum Gasoil Hydrogenation unit, which is a real-world petrochemical refinery unit. The performance of the multi-model inferential sensor is compared against various single-model inferential sensors and the current (referential) inferential sensor used in the refinery. The results show substantial improvements over the state-of-the-art design techniques for single-/multi-model inferential sensors.

UAV Design and Configuration Aerodynamics - An ADE Experience

UAVs are becoming an essential part of the modern defense forces world over in the recent years. They are widely used for surveillance, reconnaissance, target for missiles and combat. They are available in various weight classes from few kilograms to tons. Apart from design of aircraft, establishing an accurate aero data base for control law design for the aircraft is a main challenge in itself. Aeronautical Development Establishment (ADE) is involved in the design and development of many UAVs for the last 30 plus years and has experienced several challenging design and engineering problems. Over the years, various UAVs like Ulka, Sparrow, Lakshya, and Nishant for different mission requirements have been designed and developed. The evolution of design methodology in ADE and the present configuration design activities of UAVs and aircraft stores separation studies with a focus on CFD are discussed in this paper.

Retracted: Design and Management of Comprehensive Art Student Information Database from the Perspective of Internet plus Education

Retracted: Design and Management of Comprehensive Art Student Information Database from the Perspective of Internet plus Education

Diversity data in oncology electronic data capture and database design: A global overview, gap analysis and recommendations for industry from the imCORE network, a worldwide research network designed to connect members in an open environment of shared information, expertise, and decisions.

101 Background: The importance of enrolling diverse and inclusive patient populations in clinical trials has never been more critical however the implementation of measures to ensure inclusive clinical trials remains inconsistent and challenging industry wide. One key mechanism for tracking diversity in clinical trials is the database design of patient demographic classifications. Methods: In this paper we utilize the global reach of the imCORE network to explore the current trends in clinical trial database design for demographic data. We collect and review data on the design of electronic database systems from a diversity of sources including Roche Genentech clinical trial database frameworks and databases at our imCORE sites. We then provide a global electronic database demographic data classification overview and gap analysis. Results: Findings related to electronic database design, demographic data collection process, barriers to capturing diversity and demographic data are presented. Conclusions: Based on our findings we make recommendations from the site and sponsor perspective for an improved future state of electronic demographic diversity data collection in clinical trials with the goal of ultimately leading to meaningful change toward fully inclusive and equitable clinical trials.

Providing Access Isolation to Information in the Database

Most modern database management systems (DBMS) provide the ability to restrict user access to database objects. The problems of restricting access to individual records are arising increasingly in connection with the growing need for flexibility in restricting access in modern databases, including when using them to store information classified as state or commercial secrets. Currently, these tasks are solved individually, and there are no commonly formalized approaches to designing such access restrictions. The study aims to reduce the design time for database schemes when it is necessary to restrict access to individual records of the database tables and improve the quality of the designed schemes by using the proposed algorithms. Questions about the design of the protected databases with the use of access restrictions to separate records are considered. Both restriction of illegal access to records, and granting false camouflage information instead of required is considered. The proposed software package will consist of 2 main parts: a database and a client application. To differentiate access, the study proposed the use of a record-protecting lock.

Databases on Modern Networks: A Decade of Research That Now Comes into Practice

Modern cloud networks are a fundamental pillar of data-intensive applications. They provide high-speed transaction (packet) rates and low overhead, enabling, for instance, truly scalable database designs. These networks, however, are fundamentally different from conventional ones. Arguably, the two key discerning technologies are RDMA and programmable network devices. Today, these technologies are not niche technologies anymore and are widely deployed across all major cloud vendors. The question is thus not if but how a new breed of data-intensive applications can benefit from modern networks, given the perceived difficulty in using and programming them. This tutorial addresses these challenges by exposing how the underlying principles changed as the network evolved and by presenting the new system design opportunities they opened. In the process, we also discuss several hard-earned lessons accumulated by making the transition first-hand.

Risk of atrial fibrillation in individuals with dysglycemia and diabetes

ObjectiveDiabetes is a risk factor for atrial fibrillation (AF), and increases the risk of thromboembolic events in persons with AF. However, the link between the two conditions is not fully elucidated. Few studies have investigated the association of dysglycemia and incident AF. We investigated the risk of incident AF and prognosis according to diabetes status. Research design and methodsThe Copenhagen Primary Care Laboratory Database was merged with data on medical prescriptions, in- and outpatient contacts and vital status. The risk of AF according to diabetes status was investigated by use of Cox regression models. ResultsOf 354.807 individuals with a hemoglobin A1c (HbA1c) measurement, 28.541 (8 %) had known diabetes, 13.038 (4 %) had new onset diabetes and 27.754 (8 %) had prediabetes (HbA1c 42-47 mmol/mol). Persons with dysglycemia (HbA1c > 42 mmol/mol) and diabetes were older, more were men, they had lower level of education and were more likely to be living alone. We observed a gradual increase in risk of developing AF from HbA1c levels of 40 to 60 mmol/mol. In adjusted analyses we found a stepwise increase in hazard of AF from normoglycemia over prediabetes to persons with diabetes (no diabetes: 1.00 [ref.]; prediabetes: 1.12 [1.08–1.16]; new-onset diabetes: 1.16 [1.10–1.22]; known diabetes: 1.15 [1.11–1.20]). Persons with known diabetes had a significant higher hazard of stroke, cardiovascular and all-cause mortality. ConclusionIncreasing levels of HbA1c were associated with an increased hazard of developing AF. Persons with new onset of diabetes and those with known diabetes had similar hazard of developing AF, however persons with known diabetes had a significant higher hazard of stroke, cardiovascular- and all-cause mortality.

Penerapan Sistem Informasi Berbasis Web Untuk Pengelolaan dan Pengarsipan Dokumen

The web-based document archiving information system is an information system that is useful for managing archive storage where the information system created will assist in the process of storing and managing documents. Dr. Hazairin in order to improve the quality of the document archiving process, a web-based document archiving information system was designed, in order to avoid damage and also reduce the storage space for archives and the process of searching for archives can be done anywhere. The document archiving information system was created using the codeinether framework while the method stages carried out in this research process started from field studies, literature studies, interviews, system design and software where at this stage the database design system was used using MySQL, then system implementation and testing and the final stage is system integration and testing. After system integration and testing, the system can be applied to universities where access rights to the system will be divided into 7 parts, namely rectorate access requirements, faculty access requirements, institutional access requirements, bureau access requirements, study program access requirements, unit access requirements, and access requirements super admin

Introduction: Content, Design and Structure of Major Databases with Historical Longitudinal Population Data

In recent years the development of historical databases reconstructing the lives of large populations accelerated. These considerable investments of time and money have greatly expanded possibilities for new research in history, demography, sociology, economics, and other disciplines. This special issue describes the content and design of 23 important historical databases. Authors were given the freedom to discuss a range of practical and technical decisions from evaluating archival sources to crowdsourcing data entry. The most common issue is nominative record linkage, but we find different choices between semi-automatic and fully automatic linkage techniques and various approaches for connecting diverse sources. Some databases describe special problems, like linking Chinese names, handwritten text recognition or the construction of a release in IDS-format. Other databases offer detailed descriptions of sources or discuss prospects for including new datasets.

Vertical dynamics of high-pressure air cushion bearing module: Stability and auto-oscillation

Unstable static equilibrium and vertical auto-oscillations are problems encountered in the application of a high-pressure air cushion module (ACM) for the indoor transportation of heavy loads. The results of two base methods are compared: linear stability analysis based on the linearized equations of the perturbed motion coupled to airflow fluctuations and numerical evaluation of the nonlinear dynamic response of the system. The main distinguishing feature of the analysis is that it comprehensively examines air compressibility in the cushion plenum and in the inlet and outlet flow zones. Accordingly, the study and its findings are valid for high-pressure and low-flow applications of air cushion transportation. A narrow stability region in the parameter domain is identified when the cushion pressure approximates the supply pressure. The peculiarities of the vertical dynamics of the system near stable and unstable static equilibrium positions are described, and influence of viscous damping is considered. The study results contribute to the generalized representation of the stability and vertical dynamics of ACMs and to the theoretical database for ACM design.

A Database-Driven Excavation of a Waterlogged Neolithic Settlement: The Case of Küssnacht-Immensee Dorfplatz (Switzerland)

ABSTRACT A settlement excavation of a site with waterlogged conditions was conducted in Küssnacht-Immensee (Lake Zug, Canton Schwyz, Switzerland). The documentation abandoned the idea of drawings and verbal description. Instead, based on prior research on the deposition mechanisms of this type of settlements, clearly specified sediment features were documented in a semi-quantitative fashion in a database, allowing for generic 3D modelling of the deposits and efficient 2D GIS-based evaluation of the excavation results. We present the database design and some example results that characterise the depositional processes. Strain-free profile photographs were mounted in the same 3D virtual model. We discuss different procedures and their pros and cons.

Analisa dan Perancangan Sistem Informasi Sekolah Terintegrasi Media Sosial sebagai Media Promosi

In the era of the industrial revolution 5.0, many changes occurred in various fields one of the revolution is information system. The information system discussed this time refers to an agency's information system in schools. SMK PGRI 1 Bangkalan is one of the schools at the vocational secondary education level in Bangkalan Regency which does not yet have a website-based information system and has a total of no more than 50 students. A website-based information system can be a recommendation in overcoming these problems. This system can be used by the school to disseminate information about SMK which can be used as a promotional medium and will be integrated directly with social media. This study uses the waterfall model which is analogous to a waterfall. The waterfall model is used as a model reference in developing an information system. The results of this study are the design of a school information system that is integrated by social media account as a promotional medium in the form such as use case diagrams, flowcharts, database designs, and website interface designs.

Development of a Microcontroller-Based Contact Tracing System

Since the first case of Covid-19 detected in 2019, national governments pursued to implement lockdowns and contact tracing programs to minimize the spread of the disease. Most contact tracing procedures, no matter how varied from one country to another, commonly leaned towards digital methods that made use of modern technology. Such was not the case however in the Philippines as the masses are barely able to cope with the available contact tracing scheme that requires internet connectivity. Rated as one of the countries with the slowest and most expensive internet service, most of its citizens still resort to the traditional pen-and-paper approach when registering for contact tracing upon entry in establishments. Guided by prototyping methodology, the research ventured in the development of a microcontroller-based contact tracing system that allows the participation of establishment visitors even without internet access. The system called ConTACTS, which is short for contact tracing using automated collection and tracking system, is made up of a deployable unit and a central database. The deployable unit was designed to be able to accept mobile number registrations of establishment visitors and transmit timestamped data to the central database. The design of the central database was aimed at its successful integration with a website to enable contact tracer access. The developed deployable unit features the Arduino Nano as a central hub interfacing an LCD screen, a keypad, a buzzer, a USB adapter and a GSM module. WampServer was used to develop the central database. The system was tested in terms of the ability of the deployable unit to send a confirmation message to each establishment visitor and transmit timestamped data to the central database. The overall success rate of confirmation message sending was found to be 95.86%. The device is also immaculately able to send data to the central database in an average time of 3.15 seconds so long as the device has data access.

CENSUS OF ABANDONED BUILT HERITAGE ASSETS: THE IMPORTANCE OF DEFINING SHARED METHODOLOGIES AND ONTOLOGIES

Abstract. The paper shows the studies carried out within the framework of two research agreements for the census of abandoned enlisted assets owned by public bodies in the Provinces of Piacenza, Parma and Reggio Emilia, stipulated with the respective Heritage Departments. The purpose of this research is to increase the cognitive framework of cultural assets in a state of abandonment, and then to transfer the results to the dedicated WebGIS platform, with the aim of identifying the ones which are most in need of a conservation and reuse intervention, in order to return them back to their community. Afterwards, as a result of the cataloguing carried out, it was possible to make some critical considerations and statistical reworkings of the collected data. The data analysis, performed through the design of a GIS database, finds out a higher frequency of abandonment for some specific building types and with recurring locations. The research also highlights, once again, the importance of defining common ontologies, which are essential for statistical data processing and interoperability between different existing databases.

INFRA-ART: An Open Access Spectral Library of Art-related Materials as a Digital Support Tool for Cultural Heritage Science

Easily accessible characterization techniques such as X-ray fluorescence (XRF), Fourier Transform Infrared Spectroscopy (FTIR), or Raman spectroscopy, are at this moment the most commonly used analytical tools in heritage and conservation science. Materials identification in works of art is a fundamental step for understanding an object's history or an artist's technique. Comprehensive characterization and diagnosis of the various constituent materials in artworks can provide valuable information on the artist's working methods, as well as significant evidence for dating, provenance attribution, or forgery detection. The development of databases with high-quality data on the pure substances used as artists’ materials is of utmost importance for the identification and characterization of unknown samples. However, there are relatively few open access spectra libraries dedicated exclusively to the cultural heritage field. To address this need, within the frame of the postdoctoral project INFRA-ART, an open access spectral library of art-related materials has been developed. The database is an ongoing compilation of spectra that contains at this moment over 1,000 high-quality attenuated total reflection–FTIR, Raman, and XRF spectra associated with over 500 known reference materials. In this article, a summary of the database structure and design, functionality, and use is presented, in view of the dissemination of this new open access spectral library to the scientific community.

Deep Neural Networks-Based Direct-Current Operation Prediction and Circuit Migration Design

Recently, design methods based on gm/Id parameters have attracted attention in analog integrated circuit design and have been automated with computer assistance. However, the look-up tables (LUTs) in the gm/Id method have the problem of high hardware resource overhead. To address this issue, this paper proposes a multi-output deep neural network (DNN) structure for modeling the direct-current parameters of transistors and replacing LUTs for circuit design. The proposed DNN models’ performance is verified using mainstream design technologies such as TSMC 40 nm (T40), TSMC 65 nm (T65), TSMC 180 nm (T180), and SMIC 180 nm (S180). Compared with LUTs, the proposed DNN models are able to reduce at least 99.9% storage space occupation and 95.62% prediction time overhead with a mean absolute percentage error of less than 0.2%. In addition, we propose an automated circuit migration design method using DNN models in different technologies, combined with gm/Id parameters. The method generates circuit design databases in different technologies and obtains device design results according to performance requirements. The experimental results show that using DNN models can reduce the time overhead by more than 40% compared to using LUTs. The simulation results of circuit transplantation design show that the circuit performance of T40, T65, S180, and T180 meets the requirements, which verifies the proposed DNN-based automated circuit design method.

The roles of preparation, location, and palliative care involvement in parent-perceived child suffering at the end of life

PurposeParents' perceptions of their child's suffering affect their bereavement experience. Identifying factors that shape parental perceptions of suffering could help build effective supportive interventions for children and parents navigating EOL and grief. We aimed to compare parent-perceived child suffering between diagnostic groups and identify related factors. Design and methodsWe combined databases from 3 surveys of parents whose children who died following cancer, a complex chronic condition (CCC), or advanced heart disease. We built multivariable logistic regression models to identify relationships between parent-perceived child suffering and parent/child, illness experience, and care-related factors. ResultsAmong 277 parents, 41% rated their child's suffering as moderate or high. Fifty-seven percent of parents whose child died from cancer reported that their child suffered “a lot” or “a great deal” at EOL, compared to 33% whose child died from a CCC, and 17% whose child died from heart disease (P < 0.001). Preparation for EOL symptoms was associated with decreased parent-perceived child suffering in multivariable modeling, with parents who were prepared for EOL 68% less likely to rate their child's suffering as high compared to those who felt unprepared (AOR: 0.32, CI [0.13–0.77], P = 0.013). ConclusionsPreparing families for their child's EOL may help mitigate lingering perceptions of suffering. Operationalizing preparation is crucial to optimizing family support during EOL care. Implications to practicePreparation for symptoms, and access to resources, including medical/psychosocial interventions and staff, may help ease parental perception of EOL suffering. Clinicians should prioritize preparing families for what to expect during a child's dying process.

The Development of a Web Application for Tracking Medical Cannabis Products

This research aims to develop a web application for tracking medical cannabis product information, designed and developed according to the System Development Life Cycle (SDLC) process. The study was conducted in the province of Buriram, Thailand, and the sample group was selected through purposive sampling, consisting of 30 individuals from Play La Ploen Community Enterprise, representing cannabis cultivators and medical cannabis product processors. Data was collected through in-depth interviews to gather database design and system development requirements. The tools used for system development were PHP, HTML, CSS, JavaScript, Bootstrap, Visual Studio Code, and XAMPP, with MySQL used as the database management system. The effectiveness of the information system was evaluated using a 5-point Likert scale questionnaire developed based on the PIECES framework. The research findings indicate that the medical cannabis product tracking system is functional, as users are able to scan the QR code on the packaging to obtain comprehensive and complete information about the product.

Developing a Web-Based GIS for Tourist Attractions and Cultural Heritage in Oyo Town, Nigeria

This research focused on developing a web-based GIS for tourist attractions and cultural heritage in Oyo town, Oyo state, Nigeria. The study considered the present situation of tourism in the study area as it seems almost dead due to the lack of awareness programmes to push the state's tourism to the world market. Before tourism can be well-accepted by all and sundry, understanding the locations of the various tourist attractions need to be made known. The town lacks an up-to-date tourist guide map, including the non-availability of digital information for tourism. The study aimed at developing a web-based Geographic Information System (GIS) for tourist attractions and cultural heritage in Oyo town. The methodology involved database design and creation, satellite image georeferencing and onscreen digitizing in ArcGIS 10.8, spatial analysis, and publishing of a web map in ArcGIS online. Products generated included tourist maps, digital road network maps, and other thematic maps showing hotels, restaurants, markets, and police stations. The paper recommended that government should properly document all the tourist sites in Oyo town, develop a functional tourism database using GIS technology to better enhance the tourist experience, and that detailed information about tourism activities should be easily made available and accessible from the tourism database.