Database Structure Design Research Articles

Antipatterns in Database Design

The purpose of the study is to adapt the antipattern method to improve the effectiveness of teaching students in the fields of “Applied Informatics”, “Information Systems and Technologies”, “Software Engineering” to the principles and techniques of relational database design within the framework of relevant disciplines and practices. Training in database design is an important component of the formation of a specialist software developer. The totality of decisions taken in the design process should be based on generally accepted rules, principles and recommendations, as well as on the existing experience in creating and operating information systems, which is difficult to reproduce in the conditions of the university audience.Materials and methods. An approach focused on the concept of antipatterns – unsuccessful common design solutions will allow increasing the effectiveness of students’ training in database design. The antipattern concept has become widespread following the wide spread use of the concept of a pattern, that is, a common standard solution inscribed in the context of the problem being solved. Both the concept of a pattern and the concept of an antipattern were initially focused on object-oriented software, but later gained recognition in all areas of information technology. The paper proposes a scheme for describing the antipattern, includ ing the name, a brief description, possible causes of occurrence, a list of disadvantages of application in the construction of relational databases, a conceptual model in the form of an ER-diagram (entity-relationship diagram), an example of the appropriate database structure, ways to avoid antipatterns, as well as possible exceptions when using just such a design decision when creating a database may be justified.Research results. Based on educational, scientific and technical literature and periodicals, as well as on the basis of an analysis of the existing practice of designing information systems, a catalog of common antipatterns for designing relational databases has been compiled and described. Examples of antipatterns: “Jumble of names”, “Duplicate tables”, “False abstraction”, “Non-atomic attributes”, “Duplicate columns”, “Changing data in due course (temporaryfields)”, “Parallel connections”, ““Divine” table”, “Speculative metadata modification”, etc. At the same time, some of the patterns made it possible to illustrate the general principles of relational database design, for example, such as “No sophisticated programming is capable of correcting fatal architectural flaws”. It is shown that the existing unsuccessful solutions are often due to certain prerequisites, for example, the need to perform a hotfix that is, a “temporary” solution, or a premature attempt to improve system performance, or the desire to get some report with one request, avoiding unnecessary connections, etc. In addition to the technical aspects, the relevance of a correct and uniform naming system is shown, the absence of which makes it difficult to maintain and develop the system and leads to unnecessary costs. The proposed approach was tested when teaching students the disciplines “Databases”, “Database design”, “Architecture of information systems”. The students who completed the training improved their understanding of the principles and practices of database structure design. Conclusion. The use of the proposed catalog of antipatterns in the educational process of the university makes it possible to accelerate the training of young specialists in the techniques of designing the structure of relational databases, avoid common mistakes when creating information systems, and improve the overall design culture.

Pembuatan Websiteonline Penjualan Jam Tangan Menggunakan Framework PHP Codeigniter dan MySQL

This online shop is a business that sells watches. This online shop previously implemented a transaction system, namely that buyers came directly to the location and paid for the products they purchased and could not make transactions outside of the shop. In promotions, the shop only offers new goods to buyers who come to the shop. This means that product promotion and marketing is not optimal. Other obstacles often faced by watch sellers include inaccurate recording of incoming turnover, as well as the number of watches in stock in the shop not being properly recorded. Seeing the condition of the problem, creating a website http://jamtanganonline.my.id/ was deemed appropriate as a solution. The aim of creating this Online Watch website is to make it easier for buyers to shop online and make it easier for sellers to promote and manage the number of watches in stock. Application creation is carried out using the Waterfall method. In the design stage, the author designed the Navigation Structure, UML Design and Database Structure Design. At the program creation stage, use the Sublime Text text editor using the CodeIgniter Framework, the PHP programming language and the use of MySQL and PhpMyAdmin databases. This application has been tested using the Black Box Testing method, proving that this application meets needs and is suitable for use.

Perancangan Sistem Informasi Pemesanan Interior pada PT. Cipta Kreasi Buana Berbasis Web Menggunakan Metode Prototype

Various information technologies are utilized for work purposes, one of which is web-based applications. PT. Cipta Kreasi Buana is a company engaged in interior design and furniture since 2015. In its business processes, the company often encounters difficulties in managing the ordering process for interior products. The existing manual system results in recording errors, inefficient scheduling, and a lack of transparency for customers due to insufficient visibility regarding the status of their orders. Additionally, the company recognizes the importance of keeping up with technological trends and digitalization in business to remain competitive and tap into new digital markets online. To address these issues, the researcher designed a web-based interior sales information system using a prototype method. This approach encompasses stages such as user needs analysis, interface and database structure design, prototype development, testing, and iteration. The research outcome includes the design of a website to tackle existing problems. Consequently, the generated system operates effectively, improving efficiency and accuracy in the ordering process for interior products. This has a positive impact on customers and enhances the company's sales.

Research and implementation of order-oriented textile production scheduling system

ABSTRACT A production planning and scheduling system for small and medium-sized textile enterprises is designed according to the actual needs of textile enterprises in the process of informatization construction. The system considers orders as the primary focus and employs modular design ideas to design functional modules and standardized interfaces based on a three-tier architecture. Furthermore, it uses a database structure design and computer programming to ensure the efficiency and reliability of information services. The main functions of the system include prioritization, automatic production scheduling, order processing, and real-time monitoring of the machine. An analytical hierarchy process optimization method is proposed and applied to a textile enterprise. The running results reveal that this method can effectively reduce the order completion time, improve punctuality delivery rate, save 2–3 days of production planning and machine scheduling for the enterprise, improve the resource allocation ability and production management efficiency, and has guiding significance for small- and medium-sized textile enterprises to realize informatization.

Design and Implementation of Clinical LIS360 Laboratory Management System Based on AI Technology

In order to realize the automation, standardization, and informatization of clinical laboratory work, this research topic develops and accomplishes a set of laboratory information systems (LISs). According to the design methods of software engineering, we first understand user’s demand and the current work situation of clinical laboratory and establish the system case model using Unified Modeling Language (UML) modeling technique. During the system design period, we explain the key technology theories, network structure, system security policy and the connection scheme with hospital information system (HIS). During the system function design period, the system was designed with 6 modules, they are daily inspection work, inquire and statistics, quality control, data dictionary, system configuration, and other tools. Through establishing database model, we accomplish the system database structure design. After the system design, we perform system implementation and test, to show the interface of system implementation and test plan accordingly. The development and application of LIS360 laboratory information management system can greatly improve the management level of laboratory and promote the standardization, modernization, and science of laboratory management. This system has solved the traditional mode of sending test report sheet manually for many years in the laboratory and won valuable time for clinicians to know the patient's condition in time.

ANALISIS DAN PERANCANGAN SISTEM INFORMASI PADA APLIKASI LAZADA

Along with the development of information technology, human work, especially in obtaining information becomes easier. Not only in obtaining information but also in processing information into data that humans need. The convenience of internet provider tariff services along with the affordability of the hardware that supports it also contributes to supporting the delivery and acquisition of information through internet media. The design of a web- based sales system is a system that aims to promote, market, as well as support the purchasing power and competitiveness of the company in reaching its consumers online. With the website, it is hoped that the existing information can reach consumers with a wider coverage area because the internet is a promotional media that is easy and fast to access. The data used in the preparation of this final project include primary data and secondary data. The research method used is field study and literature study. Field studies include observations, interviews, and documentation. While the literature study is carried out by conducting research on the results of the literature related to the problem, the data obtained is then analyzed more deeply, including problem analysis, needs analysis, hardware, software, and cost analysis. System design includes data flow design, data dictionary, erd, normalization, table relations, database structure design and input output design.

Design of Higher Education System Based on Artificial Intelligence Technology

In order to solve the problems of low security and response efficiency and slow running speed of the current designed higher education system, a higher education system based on artificial intelligence technology is designed. Firstly, according to the characteristics of artificial intelligence technology, intelligent teaching system, agent technology, and data mining technology are introduced in detail. Then it analyzes the overall and detailed functional requirements of the system and adaptively generates knowledge content and teaching mode suitable for students’ ability and personality by using intelligent reasoning ability and the collection and analysis of students’ personality characteristics. Through data mining of intelligent teaching system, the decision tree about curriculum is obtained, and the students’ cognitive ability is calculated. Based on the theory of cognitive science, using the “double master” teaching mode, combined with agent technology and intelligent teaching system, the system function is divided into six modules. Through the design of database structure and data table, the design of higher education system based on artificial intelligence technology is realized. The experimental results show that the proposed method has high security and response efficiency, fast running speed, and good teaching effect.

База данных биологических показателей управления продуктивностью агроценозов бобовых культур

Experimental data gained through research requires systematization and interpretation of the effectiveness of applicable objects, methods and agricultural technologies. This data is of scientific and practical value for proper decision-making in agricultural practice. The purpose of the research is twofold: 1) to develop a structured database based on the results of long-term field experiments using various plant-microbial symbioses in legumes agrocenoses under soil and climatic conditions of the Crimea; 2) to generalize information to search for the possibility of biological control of plant productivity. The database has the minimum software requirements: Microsoft Office suite for Microsoft Windows operating systems (XP or higher OS) and software package for statistical analysis Statistica_10. Data collection, sorting and systematization, as well as matrix writing was carried out in Microsoft Excel; database structure development and design – using Microsoft Visual Basic for Application (VBA); data analysis and processing, as well as agrocenosis productivity modelling, were carried out with the help of Statistica (StatSoft) version 10. The database size is 8 MB. It has three structured VBA blocks: 1) biological activity of the soil, 2) physiological and biochemical status, productivity of plants and 3) matrices of indicators of biological activity of the soil and plant biology. Information on the structural and functional organization of the soil microbiocenosis, enzymatic activity and soil respiration, symbiotic efficiency, intensity and direction of microbiological and biochemical processes in the rhizosphere of legumes, as well as their physiological status, productivity and seed quality included sequentially. The Database is implemented on 23 electronic sheets in Microsoft Excel, integrates and interacts with the Statistica_10. The Database allows searching for interactive links in the system “microorganisms–plants–soil”, modelling the productivity of agrocenoses, identifying plant-microbial systems with the active interface when using polyfunctional microbial preparations in the technology of growing legumes under soil and climatic conditions of the Crimea. With the help of the database, we found that the use of polyfunctional microbial preparations causes different potential in the system “microorganisms–plants–soil”. Bacterization of plants with microbial preparations has 1.8 times factorial effect more on the physiology and productivity of legumes (76 %) compared to a factorial effect on the biological activity of the soil in the agrocenosis (42 %). The potential of the interaction of the cyanorhizobial consortium with legumes was revealed. It had a minimal total factor difference (29 %) between the physiological and biochemical state, productivity of legumes and indicators of biological activity of soil compared to ‘Rhizobofit’ (36 %), ‘Rhizobofit’, ‘Phosphoenterin’, ‘Biopolycid’ (33 %), ‘Rhizobofit’ and arbuscular mycorrhizal fungi (39 %).

The Database and Functional Structure Design of the Breeder Pigeon `s MIS for Optimization in Selecting and Matching Based on RFID Technology

In order to improve the production and breeding efficiency of pigeon breeding farms, and at the same time to ensure the quality of pigeons, pigeon breeding farms should be managed scientifically. In the process of breeding, breeder pigeon optimization has become an important part of pigeon breeding production, which directly affects the quantity and quality of offspring pigeons. At the same time, this is also a pigeon management of the most important information subsystem. This paper hopes to develop a set of modern information management system for the optimal breeding of breeder pigeons, and build the breeder pigeon breeding management information system by combining the special RFID tags for breeder pigeons, computer network and database technology, so as to realize the effective traceability and sharing of all aspects of data of breeder pigeons. It is expected to establish corresponding mobile terminal software to realize data access and query anytime and anywhere, which can make the information management method of pigeon breeding yard more scientific and standardized, so as to achieve better economic and social benefits. Its technical achievements can also be applied to poultry farms and other breeding enterprises.

Study on precise positioning and construction of improved varieties of forest seed base

In this paper, the cultivars of Pinus koraiensis and Japanese larch varieties in Liaoning Province were studied. Aiming to solve the problem of data update difficulty and lack of information management, the Kriging interpolation method and UAV (Unmanned Aerial Vehicles) and GPS technology positioning method were used for fine positioning of the improved varieties of forest seed base. Using linear comparison and distributed comparison method for accuracy assessment, 100 Pinus koraiensises were sampled by liner comparison method among which 10 were selected to be tested by distribution comparison method. With the help of the high density total station, the samples were measured and analyzed by the coordination. It showed the positioning accuracy was less than 1m, which met the need of the production of the forest seed base. On this basis, the tree seed production management information base database was established and the database structure design and structure design was made. Therefore, the managers in the forest natural reserve could use the database to plan and do the daily management, measure the area, the circumference, and the coordination of the forest natural reserve. In this way, the field work was lightened and it also provided support for the seed base management and production.

Perancangan Sistem Informasi Penjualan Pakaian Pada Cv Nonninth Inc Berbasis Online

Online sales techniques are the choice of most people today both in the city and in the region. The shift in the way transactions is triggered by the ever-growing digital communication and IT tools. On the other hand the sellers want to utilize the technology optimally, of course, to be reinforced by established sales database systems. Good sales information system is not enough to build a transaction-buying system, but it is necessary to handle stock stock subsystems and financial reports as well as the existence of company profile information as an attraction to prospective customers.
 In increasing the sales turnover and structuring of the CV Nonninth administration system requires a robust system to brand their products more well-known while strengthening their sales database system. Sales system design at CV Nonninth inc is built based on (1) piece analysis, (2) system design stage and (3) system implementation into online based application program. Pieces analysis is done by taking into account performance, information, economic, control, efficiency, and service qualitative factors in current and future conditions. System design is done through the Context Diagram, Flowmap, Data Flow Diagram, Table Normalization, ERD, database structure, input and output design and program menu structure. As for the system implementation process using online based programs are Adobe Dreamwaver and Mysql. It is expected that this system can help CV Nonninth improve corporate performance both turnover and administration system

Study On Vector Element Evaluation Method For Urban Underground Space Resources Based On GIS

Recently the raster unit method and modified variable grid element method have been widely applied to the GIS-based urban underground space resources comprehensive evaluation. The raster unit method needs to divide the area into units, whose size controls accuracy of the assessment. Because the unit boundary is fixed, there are usually data conflicts and lack of information in some units. Therefore, graphical representation of the evaluated results becomes not precise. The modified variable grid element method solves the contradiction between result accuracy and data redundancy, through splitting the area into smaller elements in key and sensitive regions. However, the new vector element method proposed by this article can obtain a clear boundary and accurate calculation result because it is based entirely on the actual unit edge of each factor. Nevertheless, its application is limited by its complex operation. A practical example for underground space resources fuzzy-comprehensive evaluation based on the vector element method is introduced in this paper, together with the key steps for assessment and GIS-Attribute database structure design, which could provide a reference for similar projects.

Design and Establishment of Database on the AtoN Properties for AtoN Simulator

This study investigated the design and establishment of AtoN(Aids to Navigation) in the AtoN Simulator. In recent years, IALA(International Association of Lighthouse Authorities) has raised the need of a system which could verify whether AtoN is appropriate for the design of AtoN and placement planning. An AtoN Simulator provides simulation circumstances, including the topographical and environmental characteristics of a primary harbor and the characteristics of a navigating ship and the maritime traffic. In the present study, we have developed an AtoN simulator system, including the integrated system design and the construction of an AtoN database. The AtoN Manager was developed as a virtual AtoN to manage the AtoN simulation. However, the data and materials are difficult to manage. Hence, an AtoN Manager and an AtoN simulation system have been needed for an effective managing of the AtoN properties database data. For the database structure design, we have analyzed the database design methodology. The AtoN properties have been analyzed for the effective data management. The AtoN properties designed in the present paper were classified into 19 categories. The status and properties database of AtoN were installed in 14 major ports, those were applied to the AtoN Manager. Designing the AtoN properties database was defined to reduce confusion of the use of English terms and abbreviations. The terms and acronyms have been defined in the AtoN properties and designed to the properties database structure for each AtoN. Before structuring the database for the AtoN Manager, the data of the AtoN properties for each harbor have been organized in accordance with the Excel system. The regulated data were converted into the AtoN properties database in use for the AtoN Manager. The database based on the AtoN properties table structure to each AtoN was designed. The AtoN simulator was implemented by the AtoN Manager applied to the AtoN properties database.

Multi-dimensional database design and implementation of dam safety monitoring system

To improve the effectiveness of dam safety monitoring database systems, the development process of a multi-dimensional conceptual data model was analyzed and a logic design was achieved in multi-dimensional database mode. The optimal data model was confirmed by identifying data objects, defining relations and reviewing entities. The conversion of relations among entities to external keys and entities and physical attributes to tables and fields was interpreted completely. On this basis, a multi-dimensional database that reflects the management and analysis of a dam safety monitoring system on monitoring data information has been established, for which factual tables and dimensional tables have been designed. Finally, based on service design and user interface design, the dam safety monitoring system has been developed with Delphi as the development tool. This development project shows that the multi-dimensional database can simplify the development process and minimize hidden dangers in the database structure design. It is superior to other dam safety monitoring system development models and can provide a new research direction for system developers.

A new Volcanic managEment Risk Database desIgn (VERDI): Application to El Hierro Island (Canary Islands)

One of the most important issues in modern volcanology is the assessment of volcanic risk, which will depend – among other factors – on both the quantity and quality of the available data and an optimum storage mechanism. This will require the design of purpose-built databases that take into account data format and availability and afford easy data storage and sharing, and will provide for a more complete risk assessment that combines different analyses but avoids any duplication of information. Data contained in any such database should facilitate spatial and temporal analysis that will (1) produce probabilistic hazard models for future vent opening, (2) simulate volcanic hazards and (3) assess their socio-economic impact. We describe the design of a new spatial database structure, VERDI (Volcanic managEment Risk Database desIgn), which allows different types of data, including geological, volcanological, meteorological, monitoring and socio-economic information, to be manipulated, organized and managed. The root of the question is to ensure that VERDI will serve as a tool for connecting different kinds of data sources, GIS platforms and modeling applications. We present an overview of the database design, its components and the attributes that play an important role in the database model. The potential of the VERDI structure and the possibilities it offers in regard to data organization are here shown through its application on El Hierro (Canary Islands). The VERDI database will provide scientists and decision makers with a useful tool that will assist to conduct volcanic risk assessment and management.

Geospatial Database Design for China – Kazakhstan Tourism Resource Information System

This paper discusses the design method to construct the geospatial database for the China - Kazakhstan tourism resources information system, especially focuses on the design of the relational database structure for transportation network analysis. By expressing the logical structure of graph theory as four relational database tables, i.e. junction table, edge table, junction-edge connectivity table, and turning table, this topological structure can effectively express urban roads and inter-city roads within a relatively larger area and build complicated road networks, and it also can be applied to the shortest path analysis on different spatial scales.

The Design of the Smart Card Attendance System Database

Smart card attendance system using Delphi database development technologies and RF card technology development. Function of each sub-module design includes user login module, attendance information management module , a database management module , a database designed to follow the general principles set forth , and then the database structure design concept .

Pembangunan Database Destinasi Pariwisata Indonesia dan Implementasinya pada Sistem Berbasis Web

Regarding to: (1) the increasing region’s need in developing tourism destinations; (2) the needs of tourists in selecting appropriate attractions according to specified criteria; (3) the need of travel businesses to offer sights of interest in accordance with the needs of potential tourists, (4) the need to deepen and continue our previous research titled "Development of Tourism Destination Media Potential and Utilizing Local Resources in the Era of Autonomy and Regional Expansion ", we need to develop a complete database of tourism destinations in Indonesia that can facilitate those needs. We build a web-based database that is capable of storing complete information about Indonesian tourism destinations in thorough, systematic, and structured way. It is also able to classify a variety of attractions based on attributes such as: location (the name of the island, province, district), type/ tourism products, how to achieve the object, cost, and a variety of informal information, such as the ins and outs of the attraction area incorporated by the local or tourist experiences. The research will focus on deepening and refinement of the model and database structure design and implementation with the collection, processing, and data entry of primary and secondary data which amounts to approximately 140 tourism destinations in Indonesia. The research is arranged in stages as follows: (1) designing models and the database structure, (2) making a web-based program, (3) installation and hosting ; (4) data collection, (5) data processing and data entry, (6) evaluation and improvement/ refinement. Once developed, the database can be used as a starting point in the development of Data Warehouse, Decision Support System, and Expert System for Indonesian tourism industry.

Spatial Database Structure Design of Regional Geology Annals of China

Spatial Database Structure Design of Regional Geology Annals of China

Design of Wireless Heat Automatic Reading Meter Monitoring System

As the whole world values the energy-saving very highly, a monitoring system, which can monitor the precise heat consumption data and schedule on demand in time, is urgently needed. This paper presents a master station monitoring system of wireless heat automatic reading meter system (named as WiHeat-AMRS). It is mainly used for residential district heat-supply system whose main function is measuring heat, charging for heat, and monitoring the running status of the whole heat system. The master station monitoring system, which was designed and implemented by the author own, consists of two parts: monitoring component and back-end database. The paper focuses on the design of both monitoring component and back-end database structure. The monitoring component collects the data of each heat meter via a wireless gateway, analyzes those data, store in the database, and achieves the automated management of heat system. Meanwhile, the master station monitoring system has been put into service by our cooperative, and has gotten great reviews.