Database Design Research Articles

Analysis on the Implementation Effect of Promoting Active Learning with Project-Based Learning

Background Given today's information deluge and the swift strides in artificial intelligence, foundational knowledge is readily accessible online. The willingness to take the initiative to learn is obviously more important. At present, project-based learning is widely promoted in the world, and China is no exception, and since 2016, Zhejiang, China, has promoted STEAM education as a promotion curriculum integration. An important starting point for transforming the way you learn. Although project-based learning is widely carried out, there is a lack of quantitative research on the effective organization and implementation of project-based learning and the corresponding learning effects.Educators build and provide learners with supportive learning resources and tailor guiding issues of project-based learning to provide a path to transition from traditional direct teaching to a project-based active learning approach that encourages students to be proactive and seek resources as needed. Objectives This study will use the database design curriculum as an example to implement project-based learning, build project-based learning elements, and record students' learning activity data in project-based learning activities, which has 45 students in a junior college in Zhejiang in 2023. Methods The study collected data from learning platforms that included various supportive learning resources, including the number of online discussions, the number of tasks completed, video watch time data, chapter learning repetition, the distribution and trend of chapter learning time, teacher surveys, and face-to-face discussions and offline unsupervised learning. Results and Conclusions This lab takes database project-based learning as an example and evaluates whether learners can gain real-world practical experience in new learning methods. The analysis of project-based learning outcomes shows that the project-based active learning method enhances students' awareness of the importance of database design, cultivates enthusiasm, and promotes active learning in learning, better cultivate students who can navigate beyond basic knowledge points to embrace multidimensional inventive learning. Experimental data shows that strong positive correlation between high-quality project-based learning and student enthusiasm.

From traditional teaching to flipped classroom: Impact on learning in engineering degrees

Computer engineering students should develop competences related to the contents of databases design and SQL queries. For this purpose, the recommendations on the convenience of changing the traditional teaching methodology to the flipped classroom are followed. In this article we present a quantitative study in which we compare the potential for the development of engineering students' competences in the design and use of databases of the flipped classroom methodology and the traditional teaching methodology. The results obtained in the evaluation of the subject in two different courses are compared. In the first course, traditional teaching methodology was used. In the second one, flipped classroom was used when its implementation had already been tried and tested. The results of the content blocks of database design and SQL queries are compared, according to the type of learning promoted. In this article we show evidence that the implementation of the flipped classroom teaching methodology provides different results depending on the learning promoted and on the specific contents in the subject of relational databases. The benefits of implementing the flipped classroom depend on the content and type of learning promoted. We have found evidence that they improve theoretical learning outcomes for database design and in the resolution of non-reproductive activities in the SQL queries block. No conclusive benefits are reported for students’ competency development for either of the two content blocks.

Design and Development of Database and its Effective Implementation

Design and Development of Database and its Effective Implementation

BridgeConnect: A Comprehensive Study of an Interactive Q&A Platform for Enhanced Citizen-Organization Communication

This paper presents BridgeConnect, an innovative Question-Answering (Q&A) application aimed at bridging the communication gap between large organizations and the common populace in India. The portal allows users to post reviews and problems about government services and organizations, contributing to public discourse and accountability. The paper covers planning, database design, backend and frontend development, integration and testing, deployment, maintenance, and ongoing enhancements. Through comprehensive user feedback and analytical evaluation, BridgeConnect demonstrates significant potential in enhancing transparency and interaction between citizens and organizations.

On the Use and Construction of Wi-Fi Fingerprint Databases for Large-Scale Multi-Building and Multi-Floor Indoor Localization: A Case Study of the UJIIndoorLoc Database.

Large-scale multi-building and multi-floor indoor localization has recently been the focus of intense research in indoor localization based on Wi-Fi fingerprinting. Although significant progress has been made in developing indoor localization algorithms, few studies are dedicated to the critical issues of using existing and constructing new Wi-Fi fingerprint databases, especially for large-scale multi-building and multi-floor indoor localization. In this paper, we first identify the challenges in using and constructing Wi-Fi fingerprint databases for large-scale multi-building and multi-floor indoor localization and then provide our recommendations for those challenges based on a case study of the UJIIndoorLoc database, which is the most popular publicly available Wi-Fi fingerprint multi-building and multi-floor database. Through the case study, we investigate its statistical characteristics with a focus on the three aspects of (1) the properties of detected wireless access points, (2) the number, distribution and quality of labels, and (3) the composition of the database records. We then identify potential issues and ways to address them using the UJIIndoorLoc database. Based on the results from the case study, we not only provide valuable insights on the use of existing databases but also give important directions for the design and construction of new databases for large-scale multi-building and multi-floor indoor localization in the future.

Analysis and Design of Responsive Web-Based Learning Media Equipped with Pomodoro Feature in the Course of Software Engineering

The development of information and communication technology has brought about changes in the field of education, one of which is the emergence of web-based learning. Based on preliminary observation data collected through questionnaires, students still expressed uncertainty about their understanding of software engineering (SE) materials. The current learning media for SE include PowerPoint (PPT), e-modules, and instructional videos, which students find less engaging and challenging to comprehend. Additionally, students face distractions like games and social media, leading to difficulty maintaining focus while studying. The objectives of this research are (1) to analyze user and system needs and (2) to design web-based responsive learning media for the software engineering course, equipped with a Pomodoro feature. The research method used is research and development (R&D) with the 4D Thiagarajan development model, consisting of four stages: define, design, develop, and disseminate. However, only the definition and design stages were carried out due to research limitations. The presentation of data analysis results involves (1) needs analysis, which includes frontend analysis, learner analysis, task analysis, concept analysis, and specifying instructional objectives; (2) system design, which includes context diagrams and data flow diagrams; (3) database design, which includes Entity Relationship Diagram (ERD) and database file structure; (4) initial design in the form of a prototype; (5) technology design for development and implementation; and (6) instructional media testing design

RANCANGAN APLIKASI SPK PENENTUAN WALI KELAS BERDASARKAN PRESTASI GURU DENGAN METODE AHP PADA SMK JAKARTA BARAT 1

A decision support system (DSS) is the definition of a procedural model of data processing and assisting management in making decisions. Computer-based decision support systems can improve decision-making ability to solve problems that appear structured or unstructured. The Analytical Hierarchy Process (AHP) method can be used to solve the DSS problem. This method is one of the most sought-after optimal solutions among several other decision support system method options. The research was conducted at SMKN 1 West Jakarta which aimed to assist the school in selecting homeroom teachers based on the effectiveness of teachers in the learning process to students. The creation of this application is done through data collection, system design, system analysis and database design. The creation of this application program is developed using PHP, the database is MySQL. In running this application, input or alternative information is needed, namely the names of teachers, and the assessment criteria are professional values, pedagogic values, personality values, and social values. The process requirements needed are alternative data entry process, teacher data entry process and also criteria data. The result is a teacher report that is expected to help the principal to determine homeroom based on teacher achievement scores.

Enhancing registration systems: Implementing database systems in digital boarding schools

Islamic boarding schools, known as pondok pesantren are specialized schools for Islamic education in Indonesia. With the community's increasing interest in religious education, some pesantren have begun to offer online learning opportunities. Pondok Pesantren Bayt Tamyiz is a Islamic boarding school that has started developing online pesantren education under the name Tamyiz Digittren. This program aims to enhance understanding and translation of the Qur'an using the Tamyiz method. The pondok pesantren requires significant changes in its administrative systems, including the registration process. Information system development is often challenging for the pesantren staffs and software developers. One of the fundamental difficulties lies in the user requirement process. Typically, pesantren need help to provide the information system they need. Such difficulties hinder the development process as developers must conduct numerous experiments. This research aims to design and implement a suitable database for the new student registration system with minimal information and limited time development. The research follows a database development method divided into three stages: Requirement Collection and Analysis, Conceptual Database Design, and Logical Database Design. Database development utilizes MySQL as the Database Management System (DBMS) and PHP as the programming language. This research results in a database design capable of storing and managing student data, payments, and other registration information. We expect the results of this database development to be effective in supporting the registration system and in the future development of information systems at Pondok Pesantren Bayt Tamyiz.

Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning

Self-tuning is a feature of autonomic databases that includes the problem of automatic schema design. It aims at providing an optimized schema that increases the overall database performance. While in relational databases automatic schema design focuses on the automated design of the physical schema, in NoSQL databases all levels of representation are considered: conceptual, logical, and physical. This is mainly because the latter are mostly schema-less and lack a standard schema design procedure as is the case for SQL databases. In this work, we carry out a systematic literature survey on automatic schema design in both SQL and NoSQL databases. We identify the levels of representation and the methods that are used for the schema design problem, and we present a novel taxonomy to classify and compare different schema design solutions. Our comprehensive analysis demonstrates that, despite substantial progress that has been made, schema design is still a developing field and considerable challenges need to be addressed, notably for NoSQL databases. We highlight the most important findings from the results of our analysis and identify areas for future research work.

Blockchain-Based Solution for Supply Chain Data Integrity

Data plays a crucial role in today's world, guiding business decisions across various computer- assisted activities. Maintaining the integrity of data is vital, as any tampering could have serious consequences for important business decisions. This concern is particularly significant in cloud computing settings, where data owners have limited control over key aspects like physical storage and access control. Blockchain technology has emerged as an intriguing solution to address data integrity concerns. With its inherent properties, blockchain offers promising avenues for ensuring data integrity. However, some challenges need to be overcome, such as low throughput, high latency, and stability issues, which currently limit the practical implementation of blockchain-based solutions. we focus on a case study from the European SUNFISH project, which aims to develop a secure cloud federation platform for the public sector. We examine the specific data integrity requirements in cloud computing environments and identify the research questions that need to be addressed to implement blockchain-based databases effectively. We start by outlining the open research questions and the inherent difficulties associated with addressing them. Then, we propose a preliminary design for a blockchain-based database tailored to cloud computing environments. This design aims to leverage the strengths of blockchain technology while addressing the challenges unique to cloud computing. By addressing these research questions and proposing practical solutions, we aim to pave the way for the adoption of blockchain-based databases in cloud computing environments. This has the potential to enhance data integrity and security, ultimately benefiting organizations operating in the cloud.

Mongolian Education Resource Platform Based on Springmvc+Hibernate+Spring Integration Framework

With the popularization of educational informatization and the advancement of computer technology and multimedia playback, the process of educational networking has reached new heights nationwide. The education networking in Inner Mongolia Autonomous Region is currently in a rapid development stage. In order to provide Mongolian-speaking students with the benefits of educational networking, it is imperative to design and implement a Mongolian language educational resource platform. The designed Mongolian Language Educational Resource Platform in this paper adopts a B/S architecture and utilizes the SpringMVC, Hibernate, and Spring frameworks for overall development. Firstly, the relevant technical knowledge used is introduced, including the B/S architecture, the main frameworks used, and CSS technology, among others. Then, the requirements specification and detailed design plan of the platform are elaborated, including the database design. Finally, the implementation process of the core functionalities of this Mongolian language educational resource platform is described, and unit testing methods are employed to test these core modules. The system in this paper achieves the basic functionalities of the Mongolian language educational resource platform, and the entire platform's functionalities have met the expected goals.

Database Security Mechanisms in MySQL

MySQL security is a concept that originates from database security and mainly comprises attacks that exploit database systems vulnerabilities. SQL injection, inference attack, passive attack, active attack, and other database side attacks are general security issues in many modern database systems. Those methods are used by hackers to retrieve, manipulate, misuse, make or delete information in organizations’ relational databases through application layer or backend layer. Different techniques to prevent MySQL against these attacks investigated and discussed in this article. Besides, different ways to secure or database were introduced. In this article, different ways to protect the data in relational databases including database backups, database and table locking, database encryption, user control, MySQL Enterprise Firewall, and use of views are discussed. Furthermore, each protection method explained with their usages and advantages. Database designers have to be aware of these methods to increase data protection on their designed information management systems. The goals of this research are to cover all security problems that occur in MySQL backend, declaring the security vulnerabilities and providing suggestions to improve MySQL security and preventing an attacker from attacking these systems.

SISTEM PELAPORAN PENCATATAN AKUNTANSI ATAS PENDAPATAN PAJAK KENDARAAN BERMOTOR DENGAN MENGGUNAKAN METODE CASH BASIS PADA LAYANAN SAMSAT KELILING

AbstractRegional Revenue Management Center for Kab. Cirebon 1 Sumber is the center of an organization or agency that is under the local government which has responsibility for receiving regional revenues through coordinating and collecting taxes, levies, tax sharing, balancing funds and others. This study aims to design, implement, analyze, and implement.The data collection methodology used in a study is observation. The system used in this application program is PHP (Hypertext Preprocessor) as the web, MySQL as the database design, using the Google Chrome browser and using a cash-based method (cash basis). In reporting daily receipts at the central office for regional revenue management in the Cirebon Regency, 1 source is still using the manual, namely using HVS paper, there is accumulation of files, data recording errors, and in making reports less efficient and effective. cirebon 1 source is illustrated by using a running flowchart accompanied by explanatory narration, then made computerized into a flowmap to be applied to the system so as to minimize the occurrence of human errors, file stacking, lost data, to be more efficient and effective. Keywords: Income, Motor Vehicle Tax, Cash Basis, Mobile Samsat

Mapping the Earth's igneous record: a geospatial database approach

Abstract The record of igneous activity (magmatism and volcanism) can significantly affect natural resource exploration and exploitation, including the search for hydrocarbons, critical minerals, natural hydrogen and geothermal energy sources, as well as using mafic igneous rocks as storage sites for CO 2 . These effects will vary depending on the nature and timing of the activity, the structural framework and the crustal architecture of the affected country-rock. To understand these effects and the interplay with other factors, we must first know the igneous record's distribution, timing, and petrology. In this paper, we describe a new geospatial database of the igneous rock record designed to provide a baseline digital resource that is application-agnostic and can be applied across the broadest range of research and resource exploration activities. We discuss the challenges we have faced and solved at each of the three main stages of geospatial mapping: database design, database population and database visualization. This includes the importance of a comprehensive audit trail so that users can differentiate between well and poorly-constrained interpretations, helping identify areas requiring additional work and data acquisition. The result is a geospatial database that will facilitate a better understanding of the Earth system and natural resource exploration.

Develop a Program Design and Coding Standard

The use of programming language is increasing in the real world in all domains. So it’s important to follow and maintain coding guidelines & standard and follow the best practice. This article gives an overview of naming & coding standard, use of it, comparison of the main features of different programming languages(C++, Java, Python), data management approaches for local, mobile and cloud solutions for ERP and EHR implementations, the structure of each proposed algorithm and use, Few examples for in-house development, ERP solutions, packaged software implementations, and mobile applications, few proposals, and recommendations for further research. Also explain how to create the corporate standards a sample database and application design and development.

Optimization of gamified Learning Education Model based on XR + 5G technology

The new intelligent technology represented by 5G and XR has become the core driving force of the fourth industrial revolution, and the integrated application of the two in the field of education is also promoting the continuous transformation of teaching to gamification. Based on XR + 5G fusion technology, this paper proposes the optimization design of a gamified education model. Firstly, the problem of how to improve the network performance through D2D communication in a full-load 5G network is studied, and a D2D communication resource allocation framework based on cross-layer optimization design is proposed. In D2D user access control, a D2D user access criterion based on the distance between the CU user and D2D user receiver is designed according to the QoS requirement, maximum transmit power limit, and user channel information. XR simulation platform was designed based on a 5G network with optimized communication resource allocation. UMa and InH simulation scenarios were set according to XR business model working scenarios, and Wrap Around algorithm was used to model two circles of interference for users, ensuring the reliability of results while improving simulation efficiency. Finally, the platform channel was modeled strictly according to the channel modeling method in technical document 38.901, and the channel was calibrated with the channel provided by 3GPP. Based on the simulation platform, gamified education design is optimized. Including class platform and class platform gamification design, system demand analysis, and database design. In the gamification design, a relatively novel classroom interaction mode is introduced to increase students’ enthusiasm in class. In the demand analysis of the system, the main problems in class are listed, based on which the business and functional requirements of the gamification platform are determined. Experiments show that in the IID scenario, the proposed XR + 5G fusion technology can achieve 1.09 times the training speed and obtain 0.83 % learning accuracy gain compared with the individual learning algorithm. In the Non-IID scenario, the training speed of the proposed fusion technique is 1.03 times that of the individual learning algorithm, and there is a learning accuracy gain of 2.27 %.

Internet of Medical Things Security Frameworks for Risk Assessment and Management: A Scoping Review.

The massive expansion of the Internet of medical things (IoMT) technology brings many opportunities for improving healthcare. At the same time, their use increases security risks, brings security and privacy concerns, and threatens the functioning of healthcare facilities or healthcare provision. This scoping review aims to identify progress in designing risk assessment and management frameworks for IoMT security. The frameworks found are divided into two groups according to whether frameworks address the technological design of risk management or assess technological measures to ensure the security of the IoMT environment. Furthermore, the article intends to find out whether frameworks also include an assessment of organisational measures related to IoMT security. This review was prepared using PRISMA ScR guidelines. Relevant studies were searched in the citation databases Web of Science and Scopus. The search was limited to articles published in English between 2018 and 17 September 2023. The initial search yielded 1341 articles, of which 44 (3.3%) were included in the scoping review. A qualitative content analysis focused on selected security perspectives and progress in the given area was carried out. Thirty-two articles describe the design of risk assessment and management frameworks. Twelve articles describe the design of frameworks for assessing the security of IoMT devices and possibly offer a comparison of different IoMT alternatives. A description of the included articles was prepared from the selected security perspectives. The review shows the need to create comprehensive or holistic frameworks for operational security and privacy risk management at all layers of the IoMT architecture. It includes the design of specific technological solutions and frameworks for continuously assessing the overall level of information security and privacy of the IoMT environment. Unfortunately, none of the found frameworks offer an assessment of organizational measures even though the importance of the organization measures was highlighted in articles. Another area of interest for researchers could be the design of a general risk management database for IoMT, which would include potential IoMT-related risks connected to a particular device.

Информационная среда для индустриального и научно-познавательного туризма с применением ГИС

The subject of the stated research is conditioned by the need to develop modern methods and technologies of information support of the tourism industry of the regional profile taking into account its specifics and features. Awareness and comfortable conditions of tourist service are the key factors of successful promotion and sustainable development of this sphere. In the near future, domestic tourism has great prospects, it concerns many territories of the country, and the Southern Urals is no exception. The article is a continuation of research work related to the collection and analysis of geodata, as well as the visualization of the information environment. This study shows how to graphically visualize information on the basis of the development of an interactive scheme project with the possibility of overlaying it on a scalable satellite map in the field of industrial, scientific-cognitive tourism and architectural tourism on the example of a separate layer "Country of Cities" for the objects located in the South Urals. In the research on the basis of the program utility "Grid cartogram of reference archaeological objects" the design concept of the interface functionality of utility "KROT-1.0" ("Cartogram of reference objects of tourism. Version 1.0") is developed and tested as an interactive cartogram on Internet platforms. Methodology wise, the research process consists of 2 stages: pre-project or data collection with the formation of a database catalog and design and research, with the implementation of results, consisting in the development of the design concept of the utility and its integration with a web resource developed on the platform of non-commercial CMS; analysis and comparison of the results obtained on different platforms, publication or placement of the developed interactive schemes on internal servers and Internet platforms with further prospects for the development of mobile applications for the provision of information environment in different spheres of regional tourism.

Intelligent Financial Risk Warning for Enterprises Through Knowledge Graph-Based Deep Learning

The financial risk warning methods for enterprises have always been a practical concern. In digital society, the computational intelligence has brought more spirit to this demand. This paper first introduces the current situation of the development of Knowledge graph technology, describes the deep learning fusion method based on Knowledge graph, and expresses the feasibility of this study. Then, according to the requirements of Knowledge graph, it completes the method fusion of core data training and extraction, and completes the adaptive deep learning design for the Beautiful SCOP database, and establishes a STDE-FG financial risk early warning model. Through empirical analysis, the shortcomings of this model were identified, and a comparison of optimized and optimized results was completed. Two aspects of phenomenon can be found from experimental results. For one thing, the accuracy of the unoptimized STDE-FG early warning model has been improved by 37.5–55.3% compared to traditional prediction models, but the prediction value during legal person changes has a greater error than traditional prediction values. For another, the optimized STDE-FG early warning model has also improved its accuracy in predicting new investments and equity changes, with improvements of 17–32% and 16–28%, respectively, with significant changes. This model will have a positive impact on improving enterprise risk management capabilities and reducing financial risk costs.

Pfizer COVID19 vaccine is not associated with acute cardiovascular events excluding myocarditis– a national self-controlled case series study

BackgroundDespite publications assuring no increased risk for acute cardiovascular events (excluding myocarditis) and sudden death following administration of COVID19 vaccines, these issues still stir much public ado. We assessed the risk for acute cardiovascular events that require hospitalization (excluding myocarditis) and for mortality in the short-term following administration of the second dose of the Pfizer COVID19 vaccine in Israel.MethodsUsing a self-controlled case series (SCCS) study design and national databases, all second-dose vaccinees, who had not been diagnosed with COVID19 and who had an acute cardiovascular event (acute myocardial infarction/acute stroke/acute thromboembolic event) that required hospitalization in the 60 days following vaccine administration between Jan 11th, 2021 and Oct 31st 2021, were included. A similar analysis was carried out for mortality. The first 30 days following vaccination were defined as risk period while the next 30 days were defined as control period. The probability for an event between these periods was compared using a conditional logistic regression model, accounting for sex, age group, background morbidity and seasonal risk.ResultsOut of 5,700,112 second dose vaccinees, 4,163 had an acute cardiovascular event in the 60 days following vaccine administration. Following exclusion of 106 due to technical considerations, 1,979 events occurred during the risk period and 2,078 during the control period: Odds ratio, OR = 0.95, 95% confidence interval, CI 0.90–1.01, p = 0.12. Adjusted OR was similar (OR = 0.88, 95%CI 0.72–1.08). Stratifying by age showed no increased risk in any age group. Mortality assessment indicated low number of events in both periods. These results were consistent in sensitivity analyses.ConclusionsThere was no increased risk for acute cardiovascular events (excluding myocarditis) in the risk period compared to the control period following administration of the second dose of Pfizer COVID19 vaccine. Mortality data raised no concerns either, but may have been biased.