• The KIPS Transactions:PartD
• /
• v.11D no.1
• /
• pp.183-194
• /
• 2004

The existing management job of research expenses has been divided into three parts： budget planning, budget draw-up, and exact settlement of budget. However, it caused some problems. Under this current circumstance it is required to obtain research expenses steadily, to operate efficiently and to use them clearly to solve such problems. As a result of a study on data warehouse development process of existing system integration company (Inmon, IBM) to reflect current trend described above, data warehouse development process of Inmon uses systematic and gradual access as a classical development cycle method. It causes overlap and feedback to the previous step in the process of each step Is requested. And another problem that it is difficult to toil what function refers and corrects data because functions and data are separated during performing development process at data warehouse development process of IBM is caused. Integrated management data warehouse development process of research expenses in the enterprise environment which applies UML at planning and analysis step, design step and implement and test step is suggested in this paper. Information retrieval agent uses existing budget plan DB, budget draw-up DB and budget settlement DB to find out information that a user wants to know. Information retrieval agent collects and saves information at integration database and information integration agent extracts, transports, transforms and loads the data. Information integration agent reduces a user's efforts to access to a number of information sources and check each of them. It also screens out data that a user may not need. As a result, integrated management data warehouse development process of research expenses in the enterprise environment reflects a user's requirements as much as possible and provides various types of information to make a decision which is needed to establish the policy of research expense management. It helps an end user approach his/her desired analysis information quickly and get various data from the comprehensive viewpoint rather than the fragmentary viewpoint. Furthermore, as it integrated three systems into one, it is possible to share data, to integrate the system, to reduce operating expenses and to simplify supporting environment for the decision making.

• Proceedings of the Korean Information Science Society Conference
• /
• 2007.06a
• /
• pp.17-18
• /
• 2007

데이터베이스 튜닝은 일반적으로 데이터베이스 어플리케이션을 "좀 더 빠르게" 실행하게 하는 일련의 활동을 뜻한다[1]. 데이터베이스 관리자가 튜닝에 필요한 주먹구구식 룰(Rule of thumb)들을 모두 파악 하고 상황에 맞추어 적용하는 것은 비싼 비용과 오랜 시간을 요구한다. 그렇게 때문에 서로 다른 어플 리케이션들이 맞물려 있는 복잡한 서비스는 필수적으로 자동화된 데이터베이스 성능 관리와 튜닝을 필 요로 한다. 본 논문에서는 이를 해결하기 위하여 지식 도매인(Knowledge Domain)을 기초로 한 자동화 된 데이터베이스 튜닝 원칙(Tuning Principle)을 제시하는 시스템을 제안한다. 각각의 데이터베이스 튜닝 이론들은 지식 도매인의 지식으로 활용되며, 성능에 영향을 미치는 요소들을 개체(Object)와 콘셉트 (Concept)로 구성하고 추론 시스템을 통해 튜닝 원칙을 추론하여 쉽고 빠르게 현재 상황에 맞는 튜닝 방법론을 적용시킬 수 있다. 자동화된 데이터베이스 튜닝에 대해 여러 분야에 걸쳐 학문적인 연구가 이루어지고 있다. 그 예로써 Microsoft의 AutoAdmin Project[2], Oracle의 SQL 튜닝 아키텍처[3], COLT[4], DBA Companion[5], SQUASH[6] 등을 들 수 있다. 이러한 최적화 기법들을 각각의 기능적인 방법론에 따라 다시 분류하면 크게 Design Tuning, Logical Structure Tuning, Sentence Tuning, SQL Tuning, Server Tuning, System/Network Tuning으로 나누어 볼 수 있다. 이 중 SQL Tuning 등은 수치적으로 결정되어 이미 존재하는 정보를 이용하기 때문에 구조화된 모델로 표현하기 쉽고 사용자의 다양한 요구에 의해 변화하는 조건들을 수용하기 쉽기 때문에 이에 중점을 두고 성능 문제를 해결하는 데 초점을 맞추었다. 데이터베이스 시스템의 일련의 처리 과정에 따라 DBMS를 구성하는 개체들과 속성, 그리고 연관 관계들이 모델링된다. 데이터베이스 시스템은 Application / Query / DBMS Level의 3개 레벨에 따라 구조화되며, 본 논문에서는 개체, 속성, 연관 관계 및 데이터베이스 튜닝에 사용되는 Rule of thumb들을 분석하여 튜닝 원칙을 포함한 지식의 형태로 변환하였다. 튜닝 원칙은 데이터베이스 시스템에서 발생하는 문제를 해결할 수 있게 하는 일종의 황금률로써 지식 도매인의 바탕이 되는 사실(Fact)과 룰(Rule) 로써 표현된다. Fact는 모델링된 시스템을 지식 도매인의 하나의 지식 개체로 표현하는 방식이고, Rule 은 Fact에 기반을 두어 튜닝 원칙을 지식의 형태로 표현한 것이다. Rule은 다시 시스템 모델링을 통해 사전에 정의되는 Rule와 튜닝 원칙을 추론하기 위해 사용되는 Rule의 두 가지 타업으로 나뉘며, 대부분의 Rule은 입력되는 값에 따라 다른 솔루션을 취하게 하는 분기의 역할을 수행한다. 사용자는 제한적으로 자동 생성된 Fact와 Rule을 통해 튜닝 원칙을 추론하여 데이터베이스 시스템에 적용할 수 있으며, 요구나 필요에 따라 GUI를 통해 상황에 맞는 Fact와 Rule을 수동으로 추가할 수도 었다. 지식 도매인에서 튜닝 원칙을 추론하기 위해 JAVA 기반의 추론 엔진인 JESS가 사용된다. JESS는 스크립트 언어를 사용하는 전문가 시스템[7]으로 선언적 룰(Declarative Rule)을 이용하여 지식을 표현 하고 추론을 수행하는 추론 엔진의 한 종류이다. JESS의 지식 표현 방식은 튜닝 원칙을 쉽게 표현하고 수용할 수 있는 구조를 가지고 있으며 작은 크기와 빠른 추론 성능을 가지기 때문에 실시간으로 처리 되는 어플리케이션 튜닝에 적합하다. 지식 기반 모률의 가장 큰 역할은 주어진 데이터베이스 시스템의 모델을 통하여 필요한 새로운 지식을 생성하고 저장하는 것이다. 이를 위하여 Fact와 Rule은 지식 표현 의 기본 단위인 트리플(Triple)의 형태로 표현된다, 트리플은 Subject, Property, Object의 3가지 요소로 구성되며, 대부분의 Fact와 Rule들은 트리플의 기본 형태 또는 트리플의 조합으로 이루어진 C Condition과 Action의 두 부분의 결합으로 구성된다. 이와 같이 데이터베이스 시스템 모델의 개체들과 속성, 그리고 연관 관계들을 표현함으로써 지식들이 추론 엔진의 Fact와 Rule로 기능할 수 있다. 본 시스템에서는 이를 구현 및 실험하기 위하여 웹 기반 서버-클라이언트 시스템을 가정하였다. 서버는 Process Controller, Parser, Rule Database, JESS Reasoning Engine으로 구성 되 어 있으며, 클라이 언트는 Rule Manager Interface와 Result Viewer로 구성되어 었다. 실험을 통해 얻어지는 튜닝 원칙 적용 전후의 실행 시간 측정 등 데이터베이스 시스템 성능 척도를 비교함으로써 시스템의 효용을 판단하였으며, 실험 결과 적용 전에 비하여 튜닝 원칙을 적용한 경우 최대 1초 미만의 전처리에 따른 부하 시간 추가와 최소 약 1.5배에서 최대 약 3배까지의 처리 시간 개선을 확인하였다. 본 논문에서 제안하는 시스템은 튜닝 원칙을 자동으로 생성하고 지식 형태로 변형시킴으로써 새로운 튜닝 원칙을 파생하여 제공하고, 성능에 영향을 미치는 요소와 함께 직접 Fact과 Rule을 추가함으로써 커스터마이정된 튜닝을 수행할 수 있게 하는 장점을 가진다. 추후 쿼리 자체의 튜닝 및 인텍스 최적화 등의 프로세스 자동화와 Rule을 효율적으로 정의하고 추가하는 방법 그리고 시스템 모델링을 효과적으로 구성하는 방법에 대한 연구를 통해 본 연구를 더욱 개선시킬 수 있을 것이다.

• The Journal of Society for e-Business Studies
• /
• v.25 no.2
• /
• pp.15-27
• /
• 2020

This study starts with the idea that the process of creating a Gantt Chart for schedule planning is similar to Tetris game with only a straight line. In Tetris games, the X axis is M machines and the Y axis is time. It is assumed that all types of orders can be worked without separation in all machines, but if the types of orders are different, setup cost will be incurred without delay. In this study, the game described above was named Gantris and the game environment was implemented. The AI-scheduling table through in-depth reinforcement learning compares the real-time scheduling table with the human-made game schedule. In the comparative study, the learning environment was studied in single order list learning environment and random order list learning environment. The two systems to be compared in this study are four machines (Machine)-two types of system (4M2T) and ten machines-six types of system (10M6T). As a performance indicator of the generated schedule, a weighted sum of setup cost, makespan and idle time in processing 100 orders were scheduled. As a result of the comparative study, in 4M2T system, regardless of the learning environment, the learned system generated schedule plan with better performance index than the experimenter. In the case of 10M6T system, the AI system generated a schedule of better performance indicators than the experimenter in a single learning environment, but showed a bad performance index than the experimenter in random learning environment. However, in comparing the number of job changes, the learning system showed better results than those of the 4M2T and 10M6T, showing excellent scheduling performance.

• Progress in Medical Physics
• /
• v.12 no.1
• /
• pp.41-50
• /
• 2001

The quantification analysis of renal scintigraphy is strongly affected by the location, shape and size of region of interest(ROI). When ROIs are drawn manually, these ROIs are not reproducible due to the operators' subjective point of view, and may lead to inconsistent results even if the same data were analyzed. In this study, the effect of the ROI variation on the analysis of renal scintigraphy when the ROIs are drawn manually was investigated, and in order to obtain more consistent results, methods for automated ROI definition were developed and the results from the application of the developed methods were analyzed. Relative renal function, glomerular filtration rate and mean transit time were selected as clinical parameters for the analysis of the effect of ROI and the analysis tools were designed with the programming language of IDL5.2. To obtain renal scintigraphy, $^{99m}$Tc-DTPA was injected to the 11 adults of normal condition and to study the inter-operator variability, 9 researchers executed the analyses. The calculation of threshold using the gradient value of pixels and border tracing technique were used to define renal ROI and then the background ROI and aorta ROI were defined automatically considering anatomical information and pixel value. The automatic methods to define renal ROI were classified to 4 groups according to the exclusion of operator's subjectiveness. These automatic methods reduced the inter-operator variability remarkably in comparison with manual method and proved the effective tool to obtain reasonable and consistent results in analyzing the renal scintigraphy quantitatively.

• Progress in Medical Physics
• /
• v.21 no.2
• /
• pp.165-173
• /
• 2010

In this paper, we evaluated the performance of 3D CRT, IMRT and three kind of RA plannings to investigate the clinical effect of RA with liver cancer case. The patient undergoing liver cancer of small volume and somewhat constant motion were selected. We performed 3D CRT, IMRT and RA plannings such as 2RA, limited triple arcs (3RA) and 3MRA with Eclipse version 8.6.15. The same dose volume objectives were defined for only CTV, PTV and body except heart, liver and partial body in IMRT and RA plannings. The steepness of dose gradient around tumor was determined by the Normal Tissue Objective function with the same parameters in place of respective definitions of dose volume objectives for the normal organs. The approach between the defined dose constraints and the practical DVH of CTV, PTV and Body was the best in 3MRA and the worst in IMRT. The DVHs were almost the same among RAs. Plans were evaluated using Conformity Index (CI), Homogeneity Index (HI) and Quality of coverage (QoC) by RTOG after prescription with dose level surrounding 98% of PTV in the respective plans. As a result, 3MRA planning showed the better favorable indices than that of the others and achieved the lowest MUs. In this study, RA planning is a technique that is possible to obtain the faster and better dose distribution than 3D CRT or IMRT techniques. Our result suggest that 3MRA planning is able to reduce the MUs further, keeping a similar or better targer dose homogeneity, conformity and sparing normal tissue than 2RA or 3RA.

• Journal of radiological science and technology
• /
• v.35 no.4
• /
• pp.335-343
• /
• 2012

Intensity-modulated radiotherapy(IMRT) have the ability to provide better dose conformity and sparing of critical normal tissues than three-dimensional radiotherapy(3DCRT). Especially, with the benefit of health insurance in 2011, its use now increasingly in many modern radiotherapy departments. Also the use of linear accelerator with high-energy photon beams over 10 MV is increasing. As is well known, these linacs have the capacity to produce photonueutrons due to photonuclear reactions in materials with a large atomic number such as the target, flattening filters, collimators, and multi-leaf collimators(MLC). MLC-based IMRT treatments increase the monitor units and the probability of production of photoneutrons from photon-induced nuclear reactions. The purpose of this study is to quantitatively evaluate the dose of photoneutrons produced from 3DCRT and IMRT technique for Rando phantom in cervical cancer. We performed the treatment plans with 3DCRT and IMRT technique using Rando phantom for treatment of cervical cancer. An Rando phantom placed on the couch in the supine position was irradiated using 15 MV photon beams. Optically stimulated luminescence dosimeters(OSLD) were attached to 4 different locations (abdomen, chest, head and neck, eyes) and from center of field size and measured 5 times each of locations. Measured neutron dose from IMRT technique increased by 9.0, 8.6, 8.8, and 14 times than 3DCRT technique for abdomen, chest, head and neck, and eyes, respectively. When using IMRT with 15 MV photonbeams, the photoneutrons contributed a significant portion on out-of-field. It is difficult to prevent high energy photon beams to produce the phtoneutrons due to physical properties, if necessary, It is difficult to prevent high energy photon beams to produce the phtoneutrons due to physical properties, if necessary, it is need to provide the additional safe shielding on a linear accelerator and should therefore reduce the out-of-field dose.

• Korean journal of applied entomology
• /
• v.42 no.3
• /
• pp.173-184
• /
• 2003

Beetles belonging to the families Scolytidae, Platypodidae, Bostrichidae, and Lyctidae intercepted from imported timbers at Busan port were investigated from March 1 to November 30 in 2000. In addition, hosts imported country were examined. A total of 52 species of within 23 genera was intercepted from nineteen species of timbers or logs from fifteen countries. In Scolytidae, 35 species of 16 genera in three subfamilies were identified 12 species in Xyleborus, 6 species in Ips, 3 species in Trypodendron, 2 species in Arixyleborus, and 12 species of all different genera including Alinphagous. Scolytidae were intercepted from 16 species of timbers in 13 genera imported from 11 countries. The highest beetles were intercepted from Malaysian lauan. In Platypodidae, 9 species of one genus (Platypus) were intercepted from 6 species of timbers in 4 genera imported from 6 countries including Australia. The highest numbers were intercepted from Malysian lauan. In Bostrychidae, 5 species of 4 genera in two subfamilies were intercepted from 6 species of timbers in 4 genera imported from four countries. In Lyctidae, Trogoxylon sp., Minthea sp., and Minthea rugicollis were intercepted from 3 species of timbers in 2 genera imported from 3 countries.

• The KIPS Transactions:PartD
• /
• v.10D no.6
• /
• pp.885-896
• /
• 2003

The typws of service using location Information are being various and extending their domain as wireless internet tochnology is developing and its application par is widespread, so it is prospected that LBS(Location-Based Services) will be killer application in wireless internet services. This location information is basic and high value-added information, and this information services make prior GIS(Geographic Information System) to be useful to anybody. The acquisition of this location information from moving object is very important part in LBS. Also the interfacing of acquisition of moving object between MODB and telecommunication network is being very important function in LBS. After this, when LBS are familiar to everybody, we can predict that LBS system load is so heavy for the acquisition of so many subscribers and vehicles. That is to say, LBS platform performance is fallen off because of overhead increment of acquiring moving object between MODB and wireless telecommunication network. So, to make stable of LBS platform, in this MODB system, acquisition of moving object location par as reducing the number of acquisition of unneccessary moving object location. We study problems in acquiring a huge number of moving objects location and design some acquisition model using past moving patternof each object to reduce telecommunication overhead. And after implementation these models, we estimate performance of each model.

• Investigative Magnetic Resonance Imaging
• /
• v.13 no.1
• /
• pp.31-39
• /
• 2009

Purpose : This study proposes the keyhole method in order to improve the time resolution of the proton resonance frequency(PRF) MR temperature monitoring technique. The values of Root Mean Square (RMS) error of measured temperature value and Signal-to-Noise Ratio(SNR) obtained from the keyhole and full phase encoded temperature images were compared. Materials and Methods : The PRF method combined with GRE sequence was used to get MR temperature images using a clinical 1.5T MR scanner. It was conducted on the tissue-mimic 2% agarose gel phantom and swine's hock tissue. A MR compatible coaxial slot antenna driven by microwave power generator at 2.45GHz was used to heat the object in the magnetic bore for 5 minutes followed by a sequential acquisition of MR raw data during 10 minutes of cooling period. The acquired raw data were transferred to PC after then the keyhole images were reconstructed by taking the central part of K-space data with 128, 64, 32 and 16 phase encoding lines while the remaining peripheral parts were taken from the 1st reference raw data. The RMS errors were compared with the 256 full encoded self-reference temperature image while the SNR values were compared with the zero filling images. Results : As phase encoding number at the center part on the keyhole temperature images decreased to 128, 64, 32 and 16, the RMS errors of the measured temperature increased to 0.538, 0.712, 0.768 and 0.845$^{\circ}C$, meanwhile SNR values were maintained as the phase encoding number of keyhole part is reduced. Conclusion : This study shows that the keyhole technique is successfully applied to temperature monitoring procedure to increases the temporal resolution by standardizing the matrix size, thus maintained the SNR values. In future, it is expected to implement the MR real time thermal imaging using keyhole method which is able to reduce the scan time with minimal thermal variations.

• The Korean Journal of Air & Space Law and Policy
• /
• v.29 no.1
• /
• pp.3-32
• /
• 2014

Safety Management System is the aviation industry policy for while operating the aircraft, to ensure the safety crew, aircraft and passengers. For operating a safe aircraft, in order to establish the international technical standards, the International Civil Aviation Organization has established the Annex 19 of the Convention on International Civil Aviation. As a result, member country was supposed to be in accordance with the policy of the International Civil Aviation Organization, to accept the international standard of domestic air law. The South Korean government announced that it would promote active safety management strategy in primary aviation policy master plan of 2012. And, by integrating and state safety programmes(ssp) and safety management system(sms) for the safe management of Annex 19 is to enforce the policy on aviation safety standards. State safety programmes(ssp) is a system of activities for the aim of strengthening the safety and integrated management of the activities of government. State safety programmes(ssp) is important on the basis of the data of the risk information. Collecting aviation hazard information is necessary for efficient operation of the state safety programmes(ssp) Korean government must implement the strategy required to comply with aviation methods and standards of the International Civil Aviation Organization. Airlines, must strive to safety features for safety culture construction and improvement of safety management is realized. It is necessary to make regulations on the basis of the aviation practice, for aviation safety regulatory requirements, aviation safety should reflect the opinion of the aviation industry.