Database Design Research Articles

Development of Database System Principles and Applications Course based on Task-based Learning and Team-based Learning to Enhance Database Design Abilities of Second Year Students in Fujian University of Technology

Background and Aim: The undergraduate database system principles and applications course grapples with issues such as the gap between theory and practice, outdated content, and limited teaching methods. Addressing these challenges necessitates a comprehensive reform to enhance students' practical skills and adaptability to technological advancements. This study aimed to：1) study the background information focusing on course components of Database system principle and application course to enhance students’ database design ability, 2) develop a Database system principle and application course based on Task-based learning and Team-based learning to enhance students’ database design ability, and 3) determine the effectiveness of implementing the database system principle and application course based on Task-based learning and Team-based learning. Materials and Methods: The sample was second-year students majoring in Internet of Things engineering in the academic year 2023-2024 of Fujian University of Technology, the People’s Republic of China was 30 students from 1 classroom derived by cluster random sampling. The experimental design adopted in this study is a group Post-test-only design. The research instruments from each Phase of the study were as follows: Phase I: Interview forms for teachers and students on course-related questions. Phase II: 1) Database system principles and applications course based on Task-based learning and Team-based learning with a very high level of appropriateness. 2) Eight lesson plans based on Task-based learning and Team-based learning with a very high level of appropriateness. 3) An evaluation form of database design ability includes knowledge and skills. 4) a learning achievement test and 5) a student satisfaction questionnaire with a reliability of 0.897. The data were analyzed by using mean, standard deviation, and the one-sample t-test. Results: The results of the study were as follows: 1) The researchers reviewed the literature about the Database System Principles and Applications course and interviewed four teachers and 20 students for problems of the Database System Principles and Applications course, and the information gathered was used to develop the course. The database system principles and applications course in undergraduate education faces problems such as the disconnection between theory and practice, the lag in updating course content, and the single teaching method. These challenges emphasize the urgent need for comprehensive reform of the course content, teaching methods, and assessment system to enhance students' practical skills and their ability to adapt to the rapidly changing technological environment. 2) The Database System Principles and Applications Course based on Task-based Learning and Team-based Learning consisted of the principle, objective, content, instructional strategy, materials, and evaluation. 3) After implementing through Database system principles and applications course based on Task-based learning and Team-based learning, the students’ database design ability (Knowledge) was higher than the determined criterion of 70% at a significance level of .05 (M = 31.33, SD = 3.76, t = 4.825, p = .000) and the students’ database design ability (Skills) was higher than the determined criterion of 70% at a significance level of .05 (M = 45.12, SD = 2.89, t = 5.913, p = .000). 4) The students’ satisfaction was statistically higher than the determined criterion of 70% at a .05 level of statistical significance. Conclusion: To development of a task-based learning and team-based learning database system principles and applications course is significantly effective in enhancing students' database design ability.

Digitized fuel load survey in commercial and university office buildings for fire safety assessment

Fuel load significantly affects fire development in compartments, and its design value derives from the statistical results of numerous surveys. This work enhances the fuel load database by employing a digitized survey method to assess 27 university and commercial offices in Hong Kong and Mainland, China. The results revealed significant differences in fuel load densities: university offices averaged 382 MJ/m2 (SD: 297 MJ/m2) and commercial offices averaged 1804 MJ/m2 (SD: 1319 MJ/m2). Moreover, it proposed an online questionnaire method to overcome onsite access limitations. Furthermore, it identified higher fuel load densities in commercial offices due to higher paper-made content and greater occupancy density than university offices. The fuel load of university offices was lower than that in previous surveys and design codes, while commercial fuel load was higher. Notably, there is an increasing tendency of fuel load density and plastic combustible composition over the years. Additionally, it considers that Gompertz distribution better fits cumulative probabilities of fuel load density data with a small sample size. Overall, it provides a valuable database for future fire scenario design, fire codes edition, and fire safety assessment and discusses future collaboration with AI applications.

Promoting audit transparency in higher education through an internal academic quality audit application

This study aims to design and develop a web-based application for Internal Quality Audit at Universitas Ibnu Sina, replacing the conventional audit process which is currently in use. The previous manual audit process resulted in inefficiencies and increased the risk of errors. Key challenges identified include limitations in human resources, time, and funding, as well as the low effectiveness of the audit process. In order to address these issues, the proposed information system facilitates the distribution of online checklists and document uploads, thereby expediting the verification and reporting audit results. This research adopts the System Development Life Cycle (SDLC) approach in its development, utilizing methods that include use case diagrams, activity diagrams, sequence diagrams, and database design. These methods enhance interaction and workflow within the audit team. Testing results indicate that the system functions to the expected specifications. Furthermore, this study demonstrates that implementing a web-based system can accelerate reporting, improve the structure and documentation of audits, and support efforts to enhance academic quality at the university. Implementing this system is expected to increase efficiency and accuracy in the academic quality audit process at Universitas Ibnu Sina.

CovalentInDB 2.0: an updated comprehensive database for structure-based and ligand-based covalent inhibitor design and screening.

The rational design of targeted covalent inhibitors (TCIs) has emerged as a powerful strategy in drug discovery, known for its ability to achieve strong binding affinity and prolonged target engagement. However, the development of covalent drugs is often challenged by the need to optimize both covalent warhead and non-covalent interactions, alongside the limitations of existing compound libraries. To address these challenges, we present CovalentInDB 2.0, an updated online database designed to support covalent drug discovery. This updated version includes 8303 inhibitors and 368 targets, supplemented by 3445 newly added cocrystal structures, providing detailed analyses of non-covalent interactions. Furthermore, we have employed an AI-based model to profile the ligandability of 144 864 cysteines across the human proteome. CovalentInDB 2.0 also features the largest covalent virtual screening library with 2 030 192 commercially available compounds and a natural product library with 105 901 molecules, crucial for covalent drug screening and discovery. To enhance the utility of these compounds, we performed structural similarity analysis and drug-likeness predictions. Additionally, a new user data upload feature enables efficient data contribution and continuous updates. CovalentInDB 2.0 is freely accessible at http://cadd.zju.edu.cn/cidb/.

A Review of Existing Sources for the Design of an Archaeological Underwater Cultural Heritage Database of Puglia Region (Italy)

Abstract. Underwater cultural heritage (UCH) in Italy is under-documented despite its significance. Creating a comprehensive UCH database is essential but faces challenges, such as complex documentation processes, data interoperability, and international standard adherence. This paper examines data models, standards, and the use of webGIS and databases for underwater cultural heritage documentation in Italy and globally. International documents like the 1996 ICOMOS Charter and the 2001 UNESCO Convention emphasize in-situ preservation. However, documentation efforts remain scattered, lacking a unified database. GIS technologies are vital for managing and analyzing UCH data but are underutilized for public access and tourism. Projects like Andar per Mare and Archim3des in the Puglia region aim to promote underwater cultural heritage using webGIS platforms. However, existing sources like CartaPulia face limitations, including a lack of standardization, specialized fields for underwater cultural heritage characteristics, and language barriers. The proposed solution involves creating a new data model based on standards, resulting in a bilingual geodatabase. This geodatabase will support scientific and tourism-focused webGIS applications, enhancing accessibility and promoting Italy's underwater cultural heritage. A unified database will prevent duplication, facilitate discoveries, and promote Italy's cultural heritage.

Digital technology for the national sport development: Designing a database model to analyse elite sports data

Relational database models offer a pathway for the storage, standardization, and analysis of factors influencing national sports development. While existing research delves into the factors linked with sporting success, there remains an unexplored avenue for the design of databases that seamlessly integrate quantitative analyses of these factors. This study aims to design a relational database to store and analyse quantitative sport development data by employing information technology tools. The database design was carried out in three phases: (i) exploratory study for context analysis, identification, and delimitation of the data scope; (ii) data extraction from primary sources and cataloguing; (iii) database design to allow an integrated analysis of different dimensions and production of quantitative indicators. An entity-relationship diagram and an entity-relationship model were built to organize and store information relating to sports, organizations, people, investments, venues, facilities, materials, events, and sports results, enabling the sharing of data across tables and avoiding redundancies. This strategy demonstrated potential for future knowledge advancement by including the establishment of perpetual data updates through coding and web scraping. This, in turn, empowers the continuous evaluation and vigilance of organizational performance metrics and sports development policies, aligning seamlessly with the journal’s focus on cutting-edge methodologies in the realm of digital technology.

An automatic workflow for the quantitative evaluation of bit wear based on computer vision

As global oil exploration ventures into deeper and more complex territories, drilling bit wear and damage have emerged as significant constraints on drilling efficiency and safety. Despite the publication of official bit wear evaluation standards by the International Association of Drill Contractors (IADC), the current lack of quantitative and scientific evaluation techniques means that bit wear assessments rely heavily on engineers' experience. Consequently, forming a standardized database of drilling bit information to underpin the mechanisms of bit wear and facilitate optimal design remains challenging. Therefore, an efficient and quantitative evaluation of bit wear is crucial for optimizing bit performance and improving penetration efficiency.This paper introduces an automatic standard workflow for the quantitative evaluation of bit wear and the design of a comprehensive bit information database. Initially, a method for acquiring images of worn bits at the drilling site was developed. Subsequently, the wear classification and grading models based on computer vision were established to determine bit status. The wear classification model focuses on the positioning and classification of bit cutters, while the wear grading model quantifies the extent of bit wear. After that, the automatic evaluation method of the bit wear is realized. Additionally, bit wear evaluation software was designed, integrating all necessary functions to assess bit wear in accordance with IADC standards. Finally, a drilling bit database was created by integrating bit wear data, logging data, mud-logging data, and basic drilling bit data.This workflow represents a novel approach to collecting and analyzing drilling bit information at drilling sites. It holds potential to facilitate the creation of a large-scale information database for the entire lifecycle of drilling bits, marking the inception of intelligent analysis, design, and manufacture of drilling bits, thereby enhancing performance in challenging drilling conditions.

13-year colorectal cancer risk after lower-quality, higher-quality and no screening colonoscopy: a cohort study

ObjectiveA lower-quality colonoscopy has been shown to be less effective in reducing colorectal cancer (CRC) incidence than a higher-quality colonoscopy, but the comparison with no screening colonoscopy is lacking. We aimed to compare the 13-year risk of developing CRC between persons with I) a higher-quality screening colonoscopy, II) a lower-quality screening colonoscopy and III) without a screening colonoscopy. Study Design and SettingA healthcare database (∼20% of the German population) was used to emulate a target trial with three arms: Higher-quality screening colonoscopy (higherQualSC) vs. lower-quality screening colonoscopy (lowerQualSC) vs. no screening colonoscopy (noSC) at baseline. The quality of screening colonoscopy was categorized based on the polyp detection rate of the examining physician (cut-off: 21.8%). We included persons aged 55 to 69 years at average CRC risk and CRC screening naïve at baseline. We estimated adjusted cumulative CRC incidence over 13 years of follow-up. ResultsThe higherQualSC arm comprised 142,960 persons, the lowerQualSC arm 62,338 persons and the noSC arm 124,040 persons. The adjusted 13-year CRC risk was 1.77% in the higherQualSC arm, 2.09% in the lowerQualSC arm and 2.74% in the noSC arm. Compared to the noSC arm, the adjusted relative risk was 0.76 (95% CI: 0.70–0.84) in the lowerQualSC arm and 0.65 (95% CI: 0.60–0.69) in the higherQualSC arm. ConclusionOur study shows that a lower-quality screening colonoscopy is also effective in reducing CRC incidence compared to no screening colonoscopy. However, the effect is about one third less than that of a higher-quality screening colonoscopy.

Studying Contact Replays: Investigating Mechanisms, Management and Game Exposures (SCRIMMAGE) for brain health in the Australasian National Rugby League: a protocol for a database design

Concussions in contact sports are challenging for athletes, health professionals and sporting bodies to prevent, detect and manage. Design of interventions for primary prevention, early recognition of concussion and continuing...

Developing A Tourism Information Portal Using Web Technologies and Database Management

The quality and variety of the infrastructure at a place has a big impact on tourism. An essential component of the tourism sector, infrastructure has a unique influence on the growth of this rapidly developing sector. Many nations have realised how important infrastructure is to the travel and tourist sector, and as a result, their governments have partnered with the sector to provide infrastructure that is specifically needed for travel. The sites that draw tourists in the first place, where tourism is delivered, where businesses are located, and where tourists consume the product are all considered destinations. The design and implementation of a tourism information portal using web technologies and database administration is presented in this study. The portal's goal is to give travellers a thorough and intuitive way to get information about travel destinations, lodging options, and activities. Database design, web application development, and the integration of pertinent technologies like HTML, CSS, JavaScript, and PHP are all part of the development process. User testing and feedback are used to assess the portal's usability and functionality. The outcomes show how successful the portal is at delivering precise and current information, improving the traveler experience, and encouraging destination management. The study emphasises the use of web technologies and database management in tourism marketing and management, and it advances the development of tourism information systems.

How Well Can We Measure Chronic Pain Impact in Existing Longitudinal Cohort Studies? Lessons Learned

Multiple large longitudinal cohorts provide opportunities to address questions about predictors of pain and pain trajectories, even when not anticipated in the design of the historical databases. This focus article uses 2 empirical examples to illustrate the processes of assessing the measurement properties of data from large cohort studies to answer questions about pain. In both examples, data were screened to select candidate variables that captured the impact of chronic pain on self-care activities, productivity, and social activities. We describe a series of steps to select candidate items and evaluate their psychometric characteristics in relation to the measurement of pain impact proposed. In the UK Biobank, a general lack of internal consistency of variables selected prevented the identification of a satisfactory measurement model, with lessons for the measurement of chronic pain impact. In the English Longitudinal Study of Ageing, a measurement model for chronic pain impact was identified, albeit limited to capturing the impact of pain on self-care and productivity but lacking coverage related to social participation. In conjunction with its Supplementary Material, this focus article aims to encourage exploration of these valuable prospectively collected data to support researchers to make explicit the relationships between items in the databases and constructs of interest in pain research and to use empirical methods to estimate the possible biases in these variables. PerspectiveThis focus article outlines a theory-driven approach for fitting new measurement models to data from large cohort studies and evaluating their psychometric properties. This aims to help researchers develop an empirical understanding of the gains and limitations connected with the process of repurposing the data stored in these datasets.

Evaluating the quality of multiple-choice question pilot database: A global educator-created tool for concept-based pharmacology learning.

The Core Concepts of Pharmacology (CCP) initiative is developing educational resources to transform pharmacology education into a concept-based approach. This study evaluated the quality of global educator-created MCQs in generating items for the pharmacology concept inventory (PCI) instrument and developed as a resource for learning pharmacology fundamental concepts. A panel of 22 global pharmacology experts recruited from the CCP initiative research team participated in the MCQ pilot database design and evaluation. The quality analysis framework of the MCQs in the pilot database included four assessment tools: item writing guidelines (IWGs), Bloom's taxonomy, the CCP, and the MCQ design format. A two-phase evaluation process was involved, including inter-rater agreement on item quality, followed by resolving conflicts that occurred in quality assessment. The chi-square (χ2) test of independence and Cramer's V correlation tests were utilized to measure the relationship among quality assessment attributes. About 200 MCQs were gathered and 98% underwent expert evaluation. Nearly 80% addressed one or more CCP, with 52% designed using a context-dependent format. However, only 40% addressed higher levels of Bloom's cognitive domain and 10% adhered to all IWGs. A strong positive correlation was observed between the context-based item format and its effectiveness in assessing the higher cognitive domain, the main CCP and improved IWGs adherence. Context-based item construction can assess the higher cognitive skills and fundamental pharmacology concepts, showing potential for rigorous PCI development. The pilot database will store items to create the PCI, aiding the development of a concept-based pharmacology curriculum.

SQuADDS: A validated design database and simulation workflow for superconducting qubit design

We present an open-source database of superconducting quantum device designs that may be used as the starting point for customized devices. Each design can be generated programmatically using the open-source Qiskit Metal package, and simulated using finite-element electromagnetic solvers. We present a robust workflow for achieving high accuracy on design simulations. Many designs in the database are experimentally validated, showing excellent agreement between simulated and measured parameters. Our database includes a front-end interface that allows users to generate ``best-guess'' designs based on desired circuit parameters. This project lowers the barrier to entry for research groups seeking to make a new class of devices by providing them a well-characterized starting point from which to refine their designs.

Perancangan Database Sistem Informasi Dokter Praktik Mandiri (Si_Dori)

In the practice of independent doctors, patient registration is still done manually, so they have to come first because it takes longer, in addition, doctors cannot find out the disease experienced early and the follow-up actions that need to be taken. This study aims to make it easier for patients to register online, consult online, screen online, and have new features that make it easier for patients to access their conditions. The method used is the prototype method which is useful for designing and knowing the interaction between the system and the user, to be implemented by programmers. The results of this study are the design of an independent doctor's information system which includes a database design. The design of this independent doctor's information system can make it easier for patients to register online, consult online which can be given a prescription and redeemed at the nearest pharmacy, and more complete feature updates.

Penerapan Aplikasi Manajemen Laboratorium Dinas Lingkungan Hidup Kota Palembang

Waste samples that is managed properly will generate added value and provide benefits for environmental management. The purpose of this study is to design a web-based waste water sample data management information system so that it can make it easier for waste laboratory staff and the public as customers and admins to manage and access waste water sample data and transactions. The method used in data collection is the DevOps method and it is also not important as a researcher to interview officials from the Palembang city environmental service regarding the laboratory management application program.. In making the website, the author uses the PHP and MySQL programming languages with the DevOps development method, object-based software modeling using UML and designing the system interface to show system functions. Database design is made to show the relationship between entities and data contained in the system. Users who will use the waste laboratory management application information system are employees of the environmental service laboratory unit as admin and the public. The results of this study indicate that the website design that was built can make it easier for the admin to manage waste water sample data, it can be stored in a database and can be accessed at any time. Apart from that, for residents,, this system has the benefit of accelerating the process of collecting waste in their environment, this system has the benefit of speeding up the process of collecting waste water sample data.

DESIGN OF WEB-BASED ACADEMIC SERVICE SATISFACTION INFORMATION SYSTEM OF WEST SUMATERA SHIPPING POLYTECHNIC

The design of a web-based information system for academic service satisfaction at the West Sumatra Shipping Polytechnic aims to overcome the problems of the survey system which is still manual. This can slow down the process of information at the West Sumatra Shipping Polytechnic. The system design in this Final Project (TA) was built using a website platform and run online. The research method uses the System Development Life Cycle (SDLC) with the Waterfall model approach which consists of 5 stages, namely, a) Analysis b) Design c) Implementation d) Maintenance e) Planing. The programming language used is PHP, and the database application uses the MySql data processor as the database. The system design tool uses the unified Modeling Language (UML) method using 5 (five) diagrams according to design needs, namely Usecase Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagram and database design. This final project produces an effective and efficient Web-based design of an information system for academic service satisfaction at the West Sumatra Shipping Polytechnic that produces accurate and timely survey resultss

Design of real-time & historical database for photovoltaic power plant

Abstract The real-time & historical database of photovoltaic power plant monitoring system is used to store and manage the real-time and historical data, including power plant parameters, environmental data, and photovoltaic unit data and so on. Analyzing of this data is helpful for monitoring the status of the plant equipment, performing maintenance, and enhancing the operational efficiency of the power plant. The data models and database function of the database is designed. The data models include tags, data processing, and data storage models. Database function include the modules of the collection, storage, compression, and index query. The data collection module utilizes dynamic link libraries to access database data and configures parameters through a comprehensive data collection framework. The storage strategies involve in a combination of in-memory databases and disk-based historical databases, incorporating secondary caching technology and cloud server storage techniques. The data compression module is achieved through secondary compression methods. The index query module encompass time index files and the secondary index files to improve query speed and real-time system performance. The designed elements collectively establish an efficient monitoring system database.

Design of Master Data Management in the Bank Using Consolidation Approach and Jaro Wrinkler

The main objective of this project is to introduce master data management into the PT XYZ database system through analysis, design, and implementation. A database life cycle (DBLC) approach, consisting of database analysis, design, implementation, and testing, is used for the design phase. Based on the analysis carried out, it was found that two databases belonging to PT XYZ did not have a master data management process, and there was an incomplete master data management and implementation process at PT XYZ. This project ended with the successful of implementation the master data management process, thereby reducing the time required for PT XYZ business process applications. So that all PT XYZ business process applications can produce clean and valid data.

Sistem Informasi Bidang Sarana Disporasu Berbasis Website Menggunakan Framework Bootstrap

The North Sumatra Province Youth and Sports Service is one of the government agencies that oversees the fields of youth services, partnership services and sports services in North Sumatra. Previously, the process of collecting contract documents and procurement of goods was carried out by manually inputting all transactions using the Microsoft Excel program. Bootstrap is a framework used to build responsive and attractive websites and is built by applying database development methods via phpMyAdmin, building program websites via Visual Studio Code using HTML, CSS, PHP, and Xampp. The system creation stage consists of analysis, UML design, database design, and the implementation. So that the Web-Based Information System for Disporasu Facilities, which was built using the Bootstrap framework, can process data smoothly, quickly, with minimal errors, and the information needed about contract documents and sporting goods can be obtained easily.

Overview and limitations of database in global traditional medicines: A narrative review.

The study of traditional medicine has garnered significant interest, resulting in various research areas including chemical composition analysis, pharmacological research, clinical application, and quality control. The abundance of available data has made databases increasingly essential for researchers to manage the vast amount of information and explore new drugs. In this article we provide a comprehensive overview and summary of 182 databases that are relevant to traditional medicine research, including 73 databases for chemical component analysis, 70 for pharmacology research, and 39 for clinical application and quality control from published literature (2000-2023). The review categorizes the databases by functionality, offering detailed information on websites and capacities to facilitate easier access. Moreover, this article outlines the primary function of each database, supplemented by case studies to aid in database selection. A practical test was conducted on 68 frequently used databases using keywords and functionalities, resulting in the identification of highlighted databases. This review serves as a reference for traditional medicine researchers to choose appropriate databases and also provides insights and considerations for the function and content design of future databases.