Database Design Method Research Articles

Efficient Off-Policy Q-Learning for Data-Based Discrete-Time LQR Problems

This paper introduces and analyzes an improved Q-learning algorithm for discrete-time linear time-invariant systems. The proposed method does not require any knowledge of the system dynamics, and it enjoys significant efficiency advantages over other data-based optimal control methods in the literature. This algorithm can be fully executed off-line, as it does not require to apply the current estimate of the optimal input to the system as in on-policy algorithms. It is shown that a persistently exciting input, defined from an easily tested matrix rank condition, guarantees the convergence of the algorithm. A data-based method is proposed to design the initial stabilizing feedback gain that the algorithm requires. Robustness of the algorithm in the presence of noisy measurements is analyzed. We compare the proposed algorithm in simulation to different direct and indirect data-based control design methods.

데이터 기반 UX 디자인 교육을 위한 사례기반학습(CBL) 프로그램 개발 및 적용

As people get used to using various types of data, more and more attempts are being made to use data as a material for creating design concepts in the design process. Because data can provide more objective insights, designers can design products in the right way through data. Recently, various studies have been conducted on data-based design. There are studies focused on the individual concepts of Data Driven, Informed, and Aware design, which can be said to be a classification of data-based design, but domestic studies conducted by classifying data-based design in practice are insufficient. Therefore, it is not easy for beginners who lack data-based design experience to use data-based design methods separately. This study aimed to learn the relationship between quantitative data and decision-making by having a mind set on how users who are not familiar with the design using data make decisions using data. Case-based learning was used to design educational programs that help beginners understand, and case papers and criteria that beginners can easily participate in to help them learn the processes and types of data-based design. The educational program conducted education for beginners in data-based design, and verified its usefulness through expert evaluation. The educational program developed in this study is expected to be used as a way for beginners to understand and find out how data-based design is implemented.

Artificial Intelligence in Engineering

Artificial intelligence (AI) has moved past its primitive stages and is now poised to revolutionize various fields, making it a disruptive technology. This technology is expected to completely transform traditional engineering in design, electrical, communication, and renewable energy approaches that have been human-centred. Despite being in its early stages, AI-powered engineering applications can work with vague design parameters and resolve intricate engineering problems that cannot be tackled using traditional design, electrical, communication, and renewable energy methods. This article aims to shed light on the current progress and future research trends in AI applications in engineering concepts, focusing on the ramp-up period of the last 5 years. Various methods such as machine learning, genetic algorithm, and fuzzy logic have been carefully evaluated from an engineering standpoint. AI-powered design studies have been reviewed and categorized for different design stages such as inspiration, idea and concept generation, evaluation, optimization, decision-making, and modeling. The review shows that there has been an increased interest in data-based design methods and explainable artificial intelligence in recent years. The use of AI methods in engineering applications has proven to be efficient, fast, accurate, and comprehensive, particularly with the use of deep learning methods and combinations that address situations where human capacity is inadequate. However, it is crucial to choose the appropriate AI method for an engineering problem to achieve successful results.

Review of artificial intelligence applications in engineering design perspective

Having passed the primitive phases and starting to revolutionize many different fields in some way, artificial intelligence is on its way to becoming a disruptive technology. It is also foreseen to totally change human-centred traditional engineering design approaches. Although still in the early phases, AI-powered engineering applications enable them to work with ambiguous design parameters and solve complex engineering problems, not otherwise possible with traditional design methods. This work attempts to shine a light on current progress and future research trends in AI applications in design/engineering design concepts, covering the last 15 years which is the ramp-up period for AI. Methods such as machine learning, genetic algorithm, and fuzzy logic have been carefully examined from an engineering design perspective. AI-powered design studies have been categorized and critically reviewed for various design stages such as inspiration, idea and concept generation, evaluation, optimization, decision-making, and modelling. As an overview result of this review, we can confidently say that the interest in data-based design methods and Explainable Artificial Intelligence (XAI) has increased in recent years. Furthermore, the use of AI methods in engineering design applications helps to obtain efficient, fast, accurate, and comprehensive results. Especially with deep learning methods and combinations, situations where human capacity is insufficient can be addressed efficiently. However, choosing the right AI method for a design problem under consideration is significantly important for such successful results. Hence, we have given an outline perspective on choosing the right AI method based on the literature outcomes for design problems.

A Resource Sharing System for Music Education Using the Entropy Technology

In order to improve the sharing level of music quality and educational resources within the background of emerging digital world, it is essential to design new methods. In this paper, we design a method for music quality education and a resource sharing system within the context of digital world which is established over the entropy technology. The designed structure includes the collection module of music quality education resources, the interactive compilation module of music education resources, the bottom data detection module, the cross bus control module, and the man-machine interface module under the background of digital technology. The information entropy feature extraction technology is adopted to schedule the bus in the process of sharing and transmitting music quality educational resources under the background of digital technology, and the transmission model of music quality education resources is designed. The modular design method of bottom database is adopted to realize the interactive and storage design of music quality education resources under the background of digital technology. Under the background of digital technology, the average mutual information entropy and feature distribution of association rules of music quality education resources are extracted. Furthermore, the method of fuzzy subspace information scheduling is combined with the entropy approach to share and schedule music quality educational resources, so as to comprehend the software development and, therefore, the design of music quality education and resource sharing system under the background of digital knowledge. The simulation outcomes confirm that under the background of digital technology, the music quality education and resource sharing system has good output stability and, therefore, strong human-computer interaction ability.

Systematic Literature Review Untuk Identifikasi Metodde Fragmentasi Pada Perancangan Sistem Database Terdistribusi

Large and complex databases that exist on a system can result in poor performance such as increasing access time and costs on a system. There are various ways to reduce the time and cost of data access and improve the performance of a database, one of them is by designing a Distributed Database. It is not known how many methods can be used to design a distributed database. This study aims to identify a distributed database design method using the Systematic Literature Review (SLR) method whose data were obtained from related journals from 2012–2022. This review is helpful for researchers as well as practitioners, for researchers this research will help them to see trends in the field of vertical fragmentation in distributed databases.

NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J

Modern developers of gaming mobile and Internet applications almost do not imagine themselves without the use of NoSQL databases, if they pursue the goal of creating scalable databases with high-performance and wide functionality. When designing a database for any NoSQL system, the developer needs a clear understanding of the logic of such databases and the capabilities of the tools offered by the corresponding DBMS. However, unfortunately, they do not have unified methods of logical design of such models, as in relational databases. Thus, there is a problem of developing effective methods for the logical design of such databases that would provide the necessary performance when implementing the business logic of the corresponding applications. The subject of the research is approaches to the logical design of NoSQL document and graph databases. The goal of the work is to propose unified logical modeling methods for MongoDB and Neo4j NoSQL systems based on an experimental study of their performance. The following tasks are solved in the work: analysis of current approaches to the logical design of document and graph databases\, the development of logical design methods for them; planning and experimental study of the performance of the proposed methods on the example of models developed with their help. The following methods are used: database design methods, database performance evaluation methods, development methods are based on MongoDB 5.0.5, Neo4j 4.4.3 DBMS, Visual Studio 2022 development environment. The following results are obtained: unified logical design methods for MongoDB and Neo4j NoSQL systems are proposed; on their basis, the corresponding logical models have been developed; experimental measurements of the number of resources required working with the developed models; recommendations on the proposed methods are formed. Conclusions: The proposed modeling methods for MongoDB have their own aspects of their effective use for different types of applications. The strengths and weaknesses of both methods were identified, but a mixed method based on a combination of modeling through normalization and denormalization was recommended. Even though Neo4j lost out to MongoDB in terms of consumed resources in most experiments, both DBMS's' demonstrate good productivity, taking into account the orientation to different tasks.

Smart Classroom College English Listening Teaching System Based on Virtual Environment Technology

This article mainly studies the design and realization of English listening teaching system based on virtual environment technology. This paper designs and builds a virtual experimental operating platform to assist students in experimental learning. At the same time, according to database design methods, steps and database specifications, the database is designed, functional modules are divided, and the main interface of system operation is introduced in detail. The system adopts B/S architecture, interacts with the server through the browser, and the computing and processing functions are mainly completed by the server. This system uses black box testing to test and verify system functions. Complete the performance test of the system by checking the monitoring points in the performance test cases. Experimental data shows that more than 70% of students believe that they can learn and read English independently in the Cypris Club virtual language learning community.

A reinforcement learning-based near-optimal hierarchical approach for motion control: Design and experiment

As a data-driven design method, model-free optimal control based on reinforcement learning provides an effective way to find optimal control strategies. The design of model-free optimal control is sensitive to system data because it relies on data rather than detailed dynamic models. A prerequisite for generating applicable data is that the system must be open-loop stable (with a stable equilibrium point), which restricts the data-based control design methods in actual control problems and leads to rare experimental studies or verification in the literature. To improve this situation and enrich its applications, we propose a pre-stabilized mechanism and apply it to the motion control of a mechanical system together with a reinforcement learning-based model-free optimal control method, which constitutes a so-called hierarchical control structure. We design two real-time control experiments on an underactuated system to verify its effectiveness. The control results show that the proposed hierarchical control is quite promising in controlling this mechanical system, even though it is open-loop unstable with unknown dynamics.

Comparing and assessing department-level instructional workloads: a study in data management

ABSTRACT Hiring academic staff into departments and supporting them remains the single costliest activity that most institutions of higher learning engage in and requires careful, long-term, data-driven planning. This study identifies widely available (but seldom actually used) variables needed for this process: available instructional workload units and student credits. While doing so, this study also walks through best practices in extracting such variables from administrative systems in repeatable, auditable ways using stock database design tools and methods. Finally, this study (literally) illustrates, in practice, how surfacing such variables in readily interpretable tables, pictures, and interactive dashboards can facilitate their application and use, by providing administrators with ways of presenting these data to peers and oversight boards in transparent, ideologically neutral, but yet actionable, formats. Although this study brings considerable quantitative data to bear, it is, at its core, a practical study in how academic administrators should be managing their data—the ‘new gold’.

SISTEM INFORMASI AKADEMIK SISWA PADA SMPN 1 KOTA SERANG

The development of internet technology rapidly, as one of information medium can certainly provide an ease in accessing information for an education institution. Before growing the internet technology, information process could not be worked properly, effectively, and efficiently. By the existence the Web-based information system of student academic monitoring at SMP 1 Kota Serang, it could provide convenience system for students or parents in monitoring students’ academic involved attendance information and student academic score. Monitoring is an activity that can be described as awareness about what would like to know, the highlevel monitoring is done in order to make the measurement of time that shows the movement or away from it. Monitoring will provide information on the status and tend to that measurement and evaluation are completed repeatedly from time to time, monitoring is generally carried out for specific purposes therefore the information provided by the school may be accepted well for students and parents. This web-based information system of student academic Monitoring at SMAP 1 Kota Serang was designed by using HTML, PHP, and MySQL as based of data. While in creating system design, the writer used the structured of database design method in diagram flow data (DFD). With applying student academic Monitoring, it can overcome the existing problems and ease in process of service that can be handled quickly and efficiently.

PERANCANGAN DESAIN BASIS DATA SISTEM INFORMASI GEOGRAFIS TANAH PENDUDUK DENGAN MENERAPKAN MODEL DATA RELASIONAL ( STUDI KASUS : DESA TUMBANG MANTUHE KABUPATEN GUNUNG MAS PROVINSI KALIMANTAN TENGAH )

Database design is a data design process that is used to support the operational activities and goals of organizations and agencies. The use of databases on the geographic information system of residents' lands makes it possible to store, change, and display all data quickly and easily. One of the factors that become a problem in database design is the point of view of seeing data that varies between designers, programmers, and end-users. Therefore we need a methodology in good database design by applying procedures, techniques, tools, and documentation. The method used in this study used the Research and Development (R&D) method, while the database design method used the Database Life Cycle (DBLC) method. The research variables were database design for the geographic information system of resident land with a relational data model. Research aspects include conceptual design, logical design, and physical design. The final result of this research is to produce 10 types of conceptual entities, produce a relationship diagram of the ten logical entities, and produce a physical design consisting of user_admin, user_pengguna, data_desa, data_kecamatan, data_kabupaten, jenis_tanah, data_penduduk, data_buku_c, data_mutasi, and data_sppt tables.

Research on Real Estate Information System of the Real Estate Market Based on Big Data Technology

This article analyzes and studies the importance of establishing a real estate information system in the real estate market. The research content of this article includes improving the efficiency of data utilization, formulating the important support of marketing strategy, and the inevitable trend of marketing system reform. The author studies the system technical route analysis, functional module design, logical hierarchical structure design, overall database design, data collection and storage method design, system key technology application, etc. The purpose of this article is to improve the applicability of information systems to regional development and to enhance the use value of big data technology itself.

Design, Validation, and Comparative Analysis of a Private Bus Location Tracking Information System

This paper addresses various aspects related to the design, development, and validation of a web-based information system that is intended to facilitate the management of a bus transportation service offered by a Jordanian university to its staff and students. Passengers can use this system to track bus trips to find out how far a desired bus is from a specific location. Also, they can know about arrivals and departures of buses managed using this system. Specifically, this work explores UI design, data structures, database design, system architecture, and development methods to realize the required features (e.g., user roles, bus setup, driver assignment, bus routes, bus schedules, and trip monitoring) in the proposed bus location tracking system. It also suggests using the free open-source API, rather than the proprietary Google Maps API, to develop the interactive maps. The system also records trip information and solicits passenger feedback to allow reviewing and analyzing that data to enhance the quality of service, reduce operation cost, and improve passenger satisfaction. The conducted comparative analysis results illustrate that the open-source API is accurate, fast, and responsive similar to the proprietary API. Furthermore, the user survey output confirms that the deployed system is easy to use, helpful, fast, responsive, and accurate.

APLIKASI PENJUALAN DAN PEMBELIAN PADA APOTEK ROSA DELIMA KENDARI BERBASIS PEMROGRAMAN DELPHI 7

The purpose of this study, to design a sales information system and drug purchasing at Rosa Delima Pharmacy which is useful in managing the sales, purchasing and reporting system quickly and accurately, which is now still doing the sales, purchasing and reporting system manually, in other words still doing data processing by recording regular notes. The impact that can be felt from this designed system is the ease in managing the business of selling goods, especially for the owner of Rosa Delima Pharmacy itself, the method used in designing this system is the DFD design method, the database design method uses ER and the programming language used is the programming language Delphi. The results of this study are an Application of Sales and Purchases at Rosa Delima Pharmacy Kendari

VRFT-based digital controller design using a generalized second-order reference model

Virtual Reference Feedback Tuning (VRFT) is a data-based controller tuning method wherein tuning is carried out directly from process input-output data without resorting to process identification. Although VRFT eliminates the need for a process model, the design methodology involves the use of a reference model and the selection of an appropriate reference model still remains an open problem. In this work, a generalized second-order reference model containing time delay and zero dynamics is derived. Furthermore, VRFT design equations using this reference model for two classes of linear controllers i.e. PID controller and a high-order controller with integrator, are developed. Simulation results are presented to illustrate the applications of the proposed design method and a comparison with existing data-based design methods and model-based design methods is made.

Sistem Basis Data Manajemen Akademik dengan Platform Web pada Sekolah Menengah Atas Muhammadiyah 4 Bandung

The purpose of this research is to design a database system that is implemented in a web-based academic management that can be used to support the information system and academic management at Muhammadiyah 4 High School Bandung. The proposed Method in system design includes 2 parts, such as system analysis and product design. Analytical methods include literature studies, interviews, and questionnaire. Meanwhile, the database design method used are three stages database design according to Connoly and Begg. The results achieved are web based academic and database management system at Muhammadiyah High School 4 Bandung. The conclusion obtained from this research is the system is able to provide information needs, faster, accurate, prevent duplication problem of data , to support decision making, to improve effective communication between the user, and to get the information easier.

Using Virtual Reality Technology to Visualize Management of College Assets in the Internet of Things Environment

This article studies the visual management of college assets under the changing environment of the Internet of Things, uses virtual reality technology to discuss the mechanism of its visualization, and studies the technical selection from the aspects of system architecture, database, and message middleware to provide reliable colleges and universities asset management, provide a complete authority distribution management mechanism, have a safe and reliable data storage mechanism and good scalability. And according to this goal, the overall architecture of the system is designed. Under this architecture, the main modules of the college asset management system divided into college asset information management, information release management, and other modules. To meet these functional modules, related diagrams are designed. The diagram creates a data table corresponding to it. The emphasis is on the systematic analysis of system performance and uses case modeling, static model, and dynamic model based on UML. The overall design of a three-tier logical structure including presentation layer, business logic layer, and data access layer, six functional modules including business process management, platform visualization management, application management, data storage, data processing, and data asset security control. Using the MySQL database and the database design method based on the E-R model, the definition of data entities was completed and the table structure design was carried out. It proved that the functions of the platform are in line with actual needs, and the performance can also meet the business requirements of the visualized management of college assets. It can manage data assets well and has high practical application value.

Design methods for the new database era: a systematic literature review

Over the last decade, a range of new database solutions and technologies have emerged, in line with the new types of applications and requirements that they facilitate. Consequently, various new methods for designing these new databases have evolved, in order to keep pace with progress in the field. In this paper, we systematically review these methods, with a view to better understanding their suitability for designing new database solutions. The study shows that while research in the field has expanded continuously, a range of factors still require further attention. The study identified important criteria in database design and analyzed existing studies accordingly. This analysis will assist in defining and recommending key areas for future research, guiding the evolution of design methods, their usability and adaptability in real-world scenarios. The study found that current database design methods do not address non-functional requirements; tend to refer to a preselected database; and are lacking in their evaluation.

Is There a Relationship Between Vocal Effort and VHI?

Vocal effort is often a symptom reported when a patient experiences a voice disorder. The aim of this investigation was to compare Voice Handicap Index (VHI) scores among patients with primary complaints of vocal effort (VE) versus vocal quality (VQ) and both vocal effort and quality (VQ+VE). A secondary aim was to compare Glottal Function Index (GFI), and glottic closure pattern between patients with the aforementioned primary presenting complaints and laryngeal pathology diagnosis. Prospective outcomes database design METHODS: Patients were identified with presenting complaints of VQ, VE, or VQ+VE who completed the VHI. Seven hundred and thirteen subjects who met criteria were categorized across three complaint groups and five laryngeal pathologies. Variables selected included age, gender, diagnosis, VHI, GFI, and 12-Item Short Form Health Survey. VHI and GFI scores were compared between the three presenting complaints. Relationships between the categorical variables and glottic closure were also assessed. Significant differences in total VHI were measured among all three presenting-complaint categories (P < 0.0001). Patients with VE only complaints had significantly greater VHI scores than those patients who report VQ only complaints. VHI scores were significantly higher for patients with combined complaints of VQ+VE as compared to VQ only or VE only. Significant differences in GFI were measured across all three complaints, and GFI was significantly higher in VE only as compared to VQ only (P < 0.001). Glottic closure pattern was not statistically significant in the variables examined. VHI scores were significantly different within pathology subgroups (P < 0.03). VE only complaints affect quality of life with and without concomitant VQ complaints. Patients with VE complaints perceive a higher level of glottic dysfunction. An underlying mechanism for increased VE could be altered glottic function, however, we were unable to suggest a correlation between glottic closure and GFI.