• 한국정밀공학회:학술대회논문집
• /
• 한국정밀공학회 2005년도 춘계학술대회 논문집
• /
• 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.

• 한국실내디자인학회논문집
• /
• 제16권2호
• /
• 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.

• 대한가정학회지
• /
• 제31권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.

• 대한전기학회논문지:시스템및제어부문D
• /
• 제52권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)
• /
• 제12권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.

• 한국정보통신학회논문지
• /
• 제9권2호
• /
• pp.445-453
• /
• 2005

관계형 데이터베이스의 설계 과정은 요구사항 분석, ER 모델을 이용한 개념적 설계, 논리적 설계, 그리고 물리적 설계 과정으로 구성된다. 논리적 설계과정은 ER 다이어그램으로 구성된 개념적 스키마를 관계형 스키마로 전환하여 정규화시키는 과정으로 이루어진다. 이런 기존의 설계 과정에서 요구사항의 분석 후 개념적 스키마를 도출하는 개념적 설계 과정이 명확치 않음으로 인해서, 실제 데이터베이스 설계현장에서 적용하기 어려운 점이 있다. 본 논문에서는 작업과정이 모호한 개념적 설계를 제거함으로 보다 체계적으로 데이터베이스 스키마를 설계할 수 있는 방법을 제안한다. 구조적 설계 방법을 이용하여 자료 흐름도를 작성하고, 자료흐름도의 자료저장소에 파악된 애트리뷰트를 이용하여 관계합성으로 관계형 스키마를 도출한다. 관계형 스키마를 정규화하고, 정규화된 테이블로부터 데이터의 의미를 파악하여 테이블 관계도를 작성함으로써 최종 논리적 스키마를 결정한다.

• 한국의학물리학회지:의학물리
• /
• 제31권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
• /
• 제10권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

• 한국식품영양학회지
• /
• 제26권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
• /
• 제16권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.