Design Of Database System Research Articles

Energy consumption estimation and profiling for queries in distributed database systems based on a bottom-up comprehensive energy model

Quantifying energy consumption of database operations is the foundation of building energy-efficient database systems. Existing approaches only focused on stand-alone database servers, while we are interested in modeling energy consumption of database operations in the distributed environments. In this study, we aim at providing an accurate energy consumption model for queries executed in distributed database systems, profiling energy consumption characteristics of both the individual queries and the system as a whole, to guide the design of green database systems and to reveal opportunities for energy-efficient computing. As the execution of a distributed query is a combination of a set of subqueries that decomposed from it, we start from building energy models for individual subqueries by extracting basic operations that can effectively reflect their energy consumption. Then we use a bottom-up measuring and modeling method as the basis to provide a comprehensive energy estimation model for the entire distributed query. To validate the accuracy of the model, we use queries with a variety complexity that generated from three standard benchmarks (TPC-H, SSB, and Sysbench) on real distributed databases. Extensive experimental results show that our solution can achieve a high average accuracy of 94.63% for distributed queries. More importantly, based on these results we further explored energy consumption patterns for distributed queries and presented several important implications. And finally, a significant role of distributed joins has been discovered in saving both idle and dynamic energy cost of the system. We hope that taking advantage of our observations can help readers who wish to substantially improve energy efficiency for distributed database systems.

Coral Database and Monitoring System Design for Ecological Sustainability

Coral Database and Monitoring System Design for Ecological Sustainability

Development of a smart home suitability indicator and indicative self-assessment platform for the disabled facilities grants (DFGs)

Purpose Delay in housing adaptation is a major problem, especially in assessing if homes are suitable for the occupants and in determining if the occupants are qualified for the Disabled Facilities Grant (DFG). This paper describes the development of two self-administered intelligent integrated assessment tools from the DFG Adapt-ABLE system: (1) The Home Suitability Assessment Platform, which is a preventive mechanism that allows assessment of the suitability of homes based on occupants’ mobility status and (2) an indicative assessment platform that determines if the applicants are qualified for the DFG to prevent lengthy delays.Design/methodology/approach The adopted method aligned with a development study approach: a grounded literature review, a severity measurement approach, two stakeholder engagement workshops, four brainstorming sessions and four focus group exercises. The system development relied on Entity–Relationship Diagram (ERD) technique for data structures and database systems design. It uses DFG context sensitivity with alignment with DFG guidance, interlinkages and interoperability between the assessment tools and other platforms of the integrated Adapt-ABLE system.Findings The assessment tools are client-level outcomes related to accessibility, usability and activity based on the assessment process. The home suitability platform shows the percentage of the suitability of a home with assessment results that suggest appropriate action plans based on individual mobility status. The indicative assessment combines the function of referral, allocation, assessment and test of resources into an integrated platform. This enables timely assessment, decision-making and case-escalation by Occupational Therapists based on needs criteria and the eligibility threshold.Originality/valueThese assessment tools are useful for understanding occupants’ perception of their physical housing environment in terms of accessibility, suitability and usability based on basic activities of daily living and their mobility status. The indicative self-assessment tool will substantially cut down the application journey. The developed tools have been recommended for use in the CSJ Disability Commission report and the UK government Guidance on DFGs for local authorities in England.

Restaurant management database system design and implement

At present, the growth rate of the information age, various industries have begun to integrate with the Internet, the catering industry is no exception. This article is based on the current information age of restaurant management problems, for the current existence of restaurant management efficiency and personnel management and other research. The current manual management will still appear many drawbacks, such as difficult statistics. This paper through demand analysis, draw ER diagram after analyzing the relationship model using Mysql to build a restaurant project database, with convenient query turnover, understand the functions of best-selling products, employee information and other functions. Test whether the function of the system is normal through several common daily needs, and check whether it can pass the system analysis through some daily actual data. The test shows that the restaurant management database not only solves the needs of the daily operation of the business, but also provides the ability to analyze data.

Regional Feature Product Development Management Using Data Management Using Networked Websites in Assisted Villages in Realizing the Tridharma of Politeknik Negeri Medan

This research aims to carry out database management according to market needs and predetermined entities/variables, to be used as data storage for profiles of assisted villages based on superior village products and to redesign a web-based information system that presents profiles of assisted villages based on superior products and village connectivity. the. The research method used in database design and information system design uses descriptive qualitative methods by conducting focus group discussions with P3M Polmed administrators and conducting in-depth interviews with six village heads/secretaries in designing the prototype. This research produces a design for a networked website-based information system with the addition of creating the location and knowing the distance between one village and another, which presents a profile of the target village based on superior products that can be accessed via a network of websites and produces a mandatory output in the form of a book with an ISBN.

Innovative aspects of designing and managing database systems for modern companies in the energy sector

The transition to digital channels and maximum digitalization of the business of modern companies in the energy sector dictate the need to improve and develop new approaches to design and database management. The study aims to identify innovative aspects in the design and management of database systems. To achieve these goals, key aspects of database design are emphasized through the argumentation of the data modeling process. Modern types of database models are identified and the need to normalize data and get rid of their redundancy is argued. The main components of the company database management system are structured. The structure of the decision support system processes is proposed. A sequence of operations with the database has been developed in the case of registration/purchase of goods using online platforms. The structure of information systems of modern companies is highlighted with an emphasis on the main functions of database management systems, taking into account the growth of digital technologies and channels of interaction with customers. The developed approaches can be applied in practice as the basis for the theory of design and management of data warehouses, taking into account innovative aspects of development.

On hierarchical clustering-based approach for RDDBS design

Distributed database system (DDBS) design is still an open challenge even after decades of research, especially in a dynamic network setting. Hence, to meet the demands of high-speed data gathering and for the management and preservation of huge systems, it is important to construct a distributed database for real-time data storage. Incidentally, some fragmentation schemes, such as horizontal, vertical, and hybrid, are widely used for DDBS design. At the same time, data allocation could not be done without first physically fragmenting the data because the fragmentation process is the foundation of the DDBS design. Extensive research have been conducted to develop effective solutions for DDBS design problems. But the great majority of them barely consider the RDDBS's initial design. Therefore, this work aims at proposing a clustering-based horizontal fragmentation and allocation technique to handle both the early and late stages of the DDBS design. To ensure that each operation flows into the next without any increase in complexity, fragmentation and allocation are done simultaneously. With this approach, the main goals are to minimize communication expenses, response time, and irrelevant data access. Most importantly, it has been observed that the proposed approach may effectively expand RDDBS performance by simultaneously fragmenting and assigning various relations. Through simulations and experiments on synthetic and real databases, we demonstrate the viability of our strategy and how it considerably lowers communication costs for typical access patterns at both the early and late stages of design.

Research on the design and implementation of computer experiment cloud platform under the application of big data technology

Abstract In this paper, the computer experiment cloud platform is built using big data technology, and various functions are implemented based on optimizing the platform parameters based on distributed estimation algorithms. The functional and non-functional requirements of the platform are determined, and the overall architecture design and system database design of the platform are carried out. The distributed estimation algorithm and the UDMA algorithm are used to identify the motor model, and the PID controller uses a particle swarm-based algorithm for parameter optimization. The platform system’s requirements are evaluated from environmental and performance perspectives to ensure that it meets the requirements proposed by the requirements analysis. The value of W(S i) is small, and the actual performance load of the platform remains. The performance of the platform function is good and can withstand a large amount of concurrency, and the average value of 90% response time is maintained at 5.8698s, showing an increasing trend.

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.

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

Medical Equipment And Medication Inventory Information System At West Citarip Puskesmas Is Based On A Website

An inventory information system offers data from many processes, including purchasing, storing, and reporting. As a result, it is essential to create an application for the Inventory Information System to transform the company's performance process from manual to automated, resulting in more thorough reports. Data collection, system design, system analysis, and database system design are used to create this application. It is creating PHP-based application programs. MYQSL is the database used, while VisualStudio Code is used for development scripts. It has been determined that the West Citarip Health Center's Drug and Medical Device Inventory Information System is ready to be designed and implemented.

Design and development of a disease-specific clinical database system to increase the availability of hospital data in China

PurposeIn order to meet restrictions and difficulties in the development of hospital medical informatization and clinical databases in China, in this study, a disease-specific clinical database system (DSCDS) was designed and built. It provides support for the full utilization of real world medical big data in clinical research and medical services for specific diseases.MethodsThe development of DSCDS involved (1) requirements analysis on precision medicine, medical big data, and clinical research; (2) design schematics and basic architecture; (3) standard datasets of specific diseases consisting of common data elements (CDEs); (4) collection and aggregation of specific disease data scattered in various medical business systems of the hospital; (5) governance and quality improvement of specific disease data; (6) data storage and computing; and (7) design of data application modules.ResultsA DSCDS for liver cirrhosis was created in the gastrointestinal department of a 3A grade hospital in China and had more than nine data application modules. Based on this DSCDS, a series of clinical studies are being carried out, such as retrospective or prospective cohorts, prognostic studies using multimodal data, and follow-up studies.ConclusionThe development of the DSCDS for liver cirrhosis in this paper provides experience and reference for the design and development of DSCDSs for other specific diseases in China; it can even expand to the development of DSCDSs in other countries if they have the demand for DSCDS and the same or better medical informatization foundation. DSCDS has more accurate, standard, comprehensive, multimodal and usable data of specific diseases than the general clinical database system and clinical data repository (CDR) and provides a credible data foundation for medical research, clinical decision-making and improving the medical service quality of specific diseases.

Research and design of CRT-based homomorphic ciphertext database system

The cloud’s storage and query of private information have the cryptographic scholar due to the proliferation of cloud computing. In the traditional query mode, the private information stored in the cloud is at risk of being leaked. In order to solve this problem, a cloud ciphertext database system based on homomorphic encryption is a valid workaround. This paper presents a new cloud ciphertext database system model, which is based on the existing ciphertext database mode research and homomorphic properties. This paper also implements a ciphertext database system based on a CRT-based additive homomorphic scheme according to the model. Through theoretical analysis, the model is CPA-level safe and correct. The experimental results show that users can correctly query and download the data in the ciphertext database on the untrusted cloud server through the model, and it has efficiency advantages.

Development and Application of MOOC System for English Intercultural Communication Courses Using Neural Network

Presently, many researchers are focusing on the English intercultural communication course. However, these courses face serious challenges, such as individual student variances in conventional English cross-cultural teaching, fostering students’ cross-cultural communication abilities, and enhancing teaching quality. These problems need to be solved; therefore, this paper aims to explore the development and application of the Massive open online courses (MOOCs) system in the English cross-cultural communication course based on neural networks. Firstly, the overall function modules of the MOOC system for the English intercultural communication courses are described, with emphasis on the student function module, teacher function module, administrator function module, and system database design of the MOOC system. Second, the MOOC system’s teaching technique in an English intercultural communication course is based on a genetic algorithm, and the MOOC system’s teaching quality index in an English intercultural communication course is chosen using principal component analysis. We conducted several tests to demonstrate that the MOOC system of the English intercultural communication course using the neural network suggested in this work is resilient and may successfully increase teaching quality. The experiment proves that the MOOC system of the English intercultural communication course based on the neural network developed in this paper has efficient results as compared to existing studies. In addition, it can effectively improve the teaching quality and can train students’ intercultural communication skills and their ability to adapt to intercultural communication.

Construction and Knowledge Mining of Traditional Chinese Medicine Ancient Books Bibliographic Abstracts Database Based on Genetic Algorithm and BP Neural Network

With the rapid development of modern science technology and Internet technology, the establishment of a unified and standardized bibliographic summary database to realize the exchange and resource sharing of ancient Chinese medicine bibliography, is the inevitable trend of ancient Chinese medicine bibliography digital service. Firstly, this paper formulates the bibliographic metadata specification of traditional Chinese medicine ancient books (TCMAB), extracts each cataloging file into an XML document in line with the bibliographic metadata specification of TCMAB. Secondly, this paper realizes the unified description of ancient book resources in the database system of TCMAB, uses the native XML database eXist to store and manage the XML documents of all traditional Chinese medicine ancient book resources, and integrates the multimedia data with XML data. Finally, genetic algorithm and BP neural network are used for knowledge mining and discovery, the overall model design of TCMAB bibliographic abstracts database system is proposed based on the construction process of knowledge map. The system platform adopts B/S mode, eXist database management system, PowerSSP streaming media and video server for audio video processing.

Laser cladding of Fe-based corrosion and wear-resistant alloy: Genetic design, microstructure, and properties

To meet the needs of laser cladding remanufacturing of key parts with both corrosion and wear resistance, the “material genetic” design method was used to deduce the composition of alloy powder with the microstructure of corrosion and wear-resistant key genetic phase from the target performance of materials. The research was conducted based on the typical phase theory of traditional Fe-based alloys such as martensitic and carbide wear-resistant microstructure and austenitic and Cr-rich passivated film corrosion-resistant microstructure. A material gene design database system based on the matching design of corrosion and wear-resistant phase key genes was successfully constructed by building an atheoretical prediction model and optimizing 10,935 sets of candidate Fe-based alloy compositions using computer algorithms and thermodynamic calculations. Finally, a new 50Cr12Ni3Mo2W6Co5BSiTi3CeO2 Fe-based alloy composition with both good wear resistance and high corrosion resistance was obtained by optimizing the design. The laser cladding formability of the designed alloy was verified and the correspondence between the key genetic microstructure and the corrosion and wear resistance was characterized with optimized process parameters. The results show that the laser cladding has good formability. The microstructure of the cladding consists of martensite and Cr23C6 carbides with the characteristics of wear-resistant key genes and austenite and Cr-rich passivation film with the characteristics of corrosion-resistant key genes. The new laser cladding of Fe-based alloy shows better corrosion and wears resistance than the 50Cr6Ni2Y alloy prepared by traditional composition design methods. We hope that this research can provide a new approach to the design of alloy compositions for laser cladding remanufacturing of Fe-based parts with both corrosion and wear resistance.

Perkembangan Riset Desain Sistem Informasi Menggunakan Pendekatan Terstruktur : Sistematic Literature Review

This article aims to analyze the dynamics of information systems design using a structured model, based on the year of publication, the scope of application of information systems, and the information system platform designed (website, desktop, mobile). The method adopted is a literature study using a Systematic Literature Review (SLR) approach. The supporting instrument used in the literature study was the Nvivo 12 Plus. The articles that are evaluated are limited to journals indexed by Garuda (garuda.ristekbrin.go.id) from 2010-2021. The results of the evaluation of structured model-based information system design are classified based on three characteristics of information systems, namely: website-based information systems; desktop; and mobile. The classification based on case studies of information system design consists of five characteristics of institutions, namely government institutions; educational institutions; health institutions; profit institutions; and non-profit organizations. Tools evaluated are limited to Data Flow Diagrams (DFD) and Entity Relationship Diagrams (ERD). Based on the results of the literature study, it can be seen that the design of information systems based on a structured approach using Data Flow Diagrams (DFD) has increased in 2018 and 2019. Meanwhile, database system design using a structured approach-based Entity Relationship Diagram (ERD) has increased in 2019. The most studied scope of application of information systems based on the characteristics of institutions is profit institutions, educational institutions, and government agencies.

Rancang Bangun Sistem Informasi Geografis Pemetaan lokasi dan spesifikasi Hotel di Kota Palopo Berbasis Website

Palopo as one of the cities in South Sulawesi Province that is developing, especially in the field of tourism as conveyed by Andi Enceng as the Tourism Cadre of Palopo City, then Palopo was also appointed as the host of national activities such as national seminars of universities and international conference ICONSS. This makes many tourists who visit not only want to enjoy the beauty of nature, culture and so on but also to attend national activities carried out in palopo city, so that facilities and infrastructure related to lodging is needed in palopo city such as one of them is a hotel. However, information about the location of the inn is still not widely known. The information they get is less accurate in terms of geography, of course the limitations of information will be an obstacle for people who want to travel, especially for those who live outside palopo city to find information on the location of a nearby hotel location. The purpose of this research is to create a design of geographic information system mapping location and specifications of hotels in palopo city basedwebsite design interface and database system, make the system in accordance with the design that has been created and implement the system that has been created and conduct tests on the system. In data collection, the authors used methods of literature studies, observations and interviews. Meanwhile, in the development of the author's system using research and development method refers to the waterfall model. The software used is sublime text as text editor, PHP as programming language, MySQL for database management and xampp as its server. Testing techniques used in this system is black box testing techniques, Based on the tests that have been done that the design of geographic information system mapping location and specifications of hotels in the city of Palopo based website is feasible and in accordance with the required functions. The expected results in this study design this website provides all the data related to hotels in palopo city and has been adjusted in advance so as to facilitate parties in operating the system.

Overall structure design of model management and data protection system based on STL

This paper realizes the development of STL model management and data protection system for 3D printing cloud platform. Firstly, the 3D printing cloud platform is briefly introduced, and the system requirements analysis, system technical architecture construction, system flow and system database design are completed. Then, based on ASP.NET, database and other technologies, combined with C# language, Web development is carried out. Finally, from the perspective of tourist users, registered users and background administrators, the functions of their respective modules are realized.

Design and Development of Database System for Turning and Milling Compound high-speed Machining

In order to realize the advantages of high-speed cutting machine and improve the efficiency of high-speed cutting, a turning and milling compound high-speed machining process database was studied. According to the data information of cutting lathes, workpiece materials, tools and high-speed machining parameters, the functional requirements, system roles and system data relationships of the database system were analyzed. Based on the above information, the functional module, basic database, user permission and system architecture were designed, and a compound high-speed machining database system which is suitable for lathes and milling machines was developed.