• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2005.06a
• /
• pp.187-190
• /
• 2005

There have been many studies to improve the performance of a database system focused on modifying data structure, data partitioning, and materializing strategy. The main contribution of this study is to propose a new alternative towards improving database performance by designing single table schema or processing queries virtually in main memory space. Material Requirement Planning(MRP) part explosion process has shown almost 2 times shorter under DB schema we suggested, and even more than 10 times shorter when separating and filtering policy of DB archiving process are assumed. Several experimental results are shown to illustrate the excellence of our solution.

• Korean Institute of Interior Design Journal
• /
• v.16 no.2 s.61
• /
• pp.314-321
• /
• 2007

The statistical method of human sensibility ergonomics is widely used for analyzing interior design because it has standard processes and it can help to get quantifiable results. However applying this method demands repeated intense work and great time and effort is required. In this study, a tool applying Web and virtual reality techniques for statistical human sensibility ergonomic interior design analysis is proposed and the key parts of the tool including database and interface are implemented. The database contains the sensibility adjective table and the physical interior design factor table for analyzing the relationship between human sense and physical design factors. Interface of the tool is implemented using Web technologies, so testers can evaluate interior design samples via standard Web browsers. The 3D control which is an important component of the interface is also implemented. Employing the suggested tool can reduce effort and time for evaluating human sense in Interior design field.

• Journal of the Korean Home Economics Association
• /
• v.31 no.4
• /
• pp.201-208
• /
• 1993

The ascorbic acid contents of 101 food items were analyzed by HPLC to provide database to estimate dietary intakes of ascorbic acid of Korean. Foods with high contents of ascorbic acid were green vegetables, citrus fruits, strawberry, kiwi, and fruit juices. This analysis data of ascorbic acid contents in some food items showed significant deviations compared with other Food Composition Table. Ascorbic acid content in soups were lower than those of raw foods by about 57%. The ascorbic acid contents in blanched or seasoned after blanching vegetables and boiled or steamed meals turned out to be decreased by about 52.3% and 47.5%, respectively, but the degrees were varied with the kind of foods as well as cooking methods. The ascorbic acid intakes from 18 most frequently consumed meals in Korea were determined to be about 1/2 of Food Composition Table according to this analysis data. The results showed the importance of accurate food database in assessing nutrient intake levels of population.

• The Transactions of the Korean Institute of Electrical Engineers D
• /
• v.52 no.12
• /
• pp.671-678
• /
• 2003

This paper proposes an expert system to generate automatically the test table of test system which can highly enhance the quality and productivity of product by inspecting quickly and accurately the defect device on the electronic circuit board tested. The expert system identifies accurately the tested components and the circuit patterns by tracing automatically the connectivity of circuit from electronic circuit database. And it generates automatically the test table to detect accurately the missing components, the misplaced components, and the wrong components for analog components such as resistance, coil, condenser, diode, and transistor, based on the experience knowledge of veteran expert. It is implemented in C computer language for the purpose of the implementation of the inference engine using the dynamic memory allocation technique, the interface with the electronic circuit database and the hardware direct control. And, the validity of the builded expert system is proved by simulating for a typical electronic board model.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.12 no.4
• /
• pp.1693-1713
• /
• 2018

An important technique used by database administrators (DBAs) is to improve performance in decision-support workloads associated with a Star schema is multi-level partitioning. Queries will then benefit from performance improvements via partition elimination, due to constraints on queries expressed on the dimension tables. As the task of multi-level partitioning can be overwhelming for a DBA we are proposing a wizard that facilitates the task by calculating a partitioning scheme for a particular workload. The system resides completely on a client and interacts with the costing estimation subsystem of the query optimizer via an API over the network, thereby eliminating any need to make changes to the optimizer. In addition, since only cost estimates are needed the wizard overhead is very low. By using a greedy algorithm for search space enumeration over the query predicates in the workload the wizard is efficient with worst-case polynomial complexity. The technology proposed can be applied to any clustering or partitioning scheme in any database management system that provides an interface to the query optimizer. Applied to the Teradata database the technology provides recommendations that outperform a human expert's solution as measured by the total execution time of the workload. We also demonstrate the scalability of our approach when the fact table (and workload) size increases.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.9 no.2
• /
• pp.445-453
• /
• 2005

The design process of a relational database system consists of requirement analysis, conceptual design using ER diagram, logical design, and physical design. In logical design process, the conceptual schema is transformed to relational schema, and relational schema is normalized. This traditional design process is hard to applied in real database design process, since there is an ambiguity in conceptual design process. In this paper, we suggest a new design process, which provides more structural design steps by removing the conceptual design process. In new approach, we produce the data flow diagram by the structural methodology. From the attributes in the data store of data flow diagram, we construct relational table schema, and we normalize relational schema. Finally we produced table relationship diagram in order to figure out relationships between tables.

• Progress in Medical Physics
• /
• v.31 no.4
• /
• pp.172-178
• /
• 2020

Purpose: Radiation oncology information systems (ROIS) have evolved toward connecting and integrating information between radiation treatment procedures. ROIS can play an important role in utilizing modern radiotherapy techniques that have high complexity and require a large amount of information. Methods: Using Access^TM software, we have developed a relational database that is highly optimized for a radiotherapeutic workflow. Results: The prescription table was chosen as the core table to which the other tables were connected, and three types of forms-charts, worklists, and calendars- were suggested. A fast and reliable channel for delivering orders and remarks according to changes in the situation was also designed. Conclusions: We expect our ROIS design to inspire those who need to develop and manage an individual ROIS suitable for their radiation oncology departments at a low cost.

• International journal of advanced smart convergence
• /
• v.10 no.2
• /
• pp.187-193
• /
• 2021

Data conversion refers to the process of extracting the data existing in the existing system, that is, the past data accumulated by the old information system or other methods and transferring it to the improved table of the new system. The person in charge of data conversion refers to the entire process of converting to the final destination table according to the rules designed/planned in advance. In most cases, data conversion design should be consider when the old system replace or the data of another existing system is converted and applied to a newly constructed information system. The goal of data conversion is to understand the current database system of operating environment, understand the characteristics of the DBMS in use, maintain the optimal database structure, and make the new system perform at its best. Data conversion methods are largely divide into a method using a tool and a conversion method using a program preparation. In this paper, we examine the advantages and disadvantages of the data conversion method, and try to derive the problems of the existing data conversion method. Based on this, an improved data conversion method for the system upgrade project was proposed, and verified through a questionnaire of an IT expert to prove its effectiveness

• The Korean Journal of Food And Nutrition
• /
• v.26 no.4
• /
• pp.886-894
• /
• 2013

The National Standard Food Composition Table published by the Rural Development Administration (RDA) provides the foundations in research, nutrition monitoring, policy and dietary practices in Korea. This databases consists of several sets of data including food descriptions, nutrients, portion weights, and source of data. The National Standard Food Composition Table have been published since 1970 and, recently, new version (8th edition) of Food Composition Table which has quantitative and qualitative nutrient data is released in 2011. In addition, the User-friendly Food Composition Table is divided into adult, children, and elderly categories depending on the subjects because we need different nutrients according to various ages. The Tables of Food Functional Composition is firstly edited in 2009. RDA published the minerals and fatty acids composition table, tables of amino acid, fat-soluble vitamin composition table, and the cholesterol table. The resulting database will be widely used. The users of the databases are from diverse fields, includeing federal agencies, the food industry, health professionals, restaurants, software application developers, academia and research organizations, international organizations, and foreign governments ect. Therefore, consistent improvements of the database is important, so that people can better address such health challenges by providing reliable and accurate data.

• KIEAE Journal
• /
• v.16 no.3
• /
• pp.5-12
• /
• 2016

Purpose: In case of existing building, A lot of attempts are being made like changing thermal system or using high efficiency products to decrease energy load and increase energy efficiency. However, (1) Absence of systemed database of green-remodeling technology and products. (2) Absence of comparative analysis system and qualitative/quantitative evaluation method of energy performance and energy reduction cost. (3) Existing remodeling was very hard to access for non-experts. So, in this paper, the authors developed data base for green-remodeling(Impact Table A, Impact Table B) and optimum combination dedication tool for user convenience. Accordingly, purpose of this paper validate usefulness of Impact Table and optimum alternative dedication tool. Method: For validate the usefulness of Impact Table and optimum combination dedication tool, the authors selected five test model office buildings. Next, through research investigation, the authors diagnosed the present state of buildings. In base of diagnosis results, select technologies for remodeling by qualitative comparison (Impact Table A). Next, evaluate quantitative price and performance technologies that selected in Impact Table A (Impact Table B). Lastly, through final evaluation of Impact Taba A and Impact Table B, determine the direction of the green-remodeling. Result: Impact Table and optimum combination dedication tool can use relative indicator for green-remodeling, especially through ROI by detail field.