• 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 Bulletin of The Korean Astronomical Society
• /
• v.39 no.2
• /
• pp.90-90
• /
• 2014

The Immersion Grating Infrared Spectrometer (IGRINS) is the first astronomical spectrograph that uses a silicon immersion grating as its dispersive element. IGRINS fully covers the H and K band atmospheric transmission windows in a single exposure. It is a compact high-resolution cross-dispersion spectrometer whose resolving power R is 40,000. An individual volume phase holographic grating serves as a secondary dispersing element for each of the H and K spectrograph arms. On the 2.7m Harlan J. Smith telescope at the McDonald Observatory, the slit size is $1^{{\prime}{\prime}}{\times}15^{{\prime}{\prime}}$. IGRINS has a plate scale of 0.27" pixel-1 on a $2048{\times}2048$ pixel Teledyne Scientific & Imaging HAWAII-2RG detector with a SIDECAR ASIC cryogenic controller. The instrument includes four subsystems; a calibration unit, an input relay optics module, a slit-viewing camera, and nearly identical H and K spectrograph modules. The use of a silicon immersion grating and a compact white pupil design allows the spectrograph collimated beam size to be 25mm, which permits the entire cryogenic system to be contained in a moderately sized ($0.96m{\times}0.6m{\times}0.38m$) rectangular Dewar. The fabrication and assembly of the optical and mechanical components were completed in 2013. From January to July of this year, we completed the system optical alignment and carried out commissioning observations on three runs to improve the efficiency of the instrument software and hardware. We describe the major design characteristics of the instrument including the system requirements and the technical strategy to meet them. We also present the instrumental performance test results derived from the commissioning runs at the McDonald Observatory.

• Journal of Bio-Environment Control
• /
• v.23 no.4
• /
• pp.293-302
• /
• 2014

This study was carried out to develop rain shelter which can make an appropriate size and environment for Chinese cabbage rainproof cultivation. Fifty three farms with chinese cabbage rainproof cultivation system have been investigated to set up width and height of rain shelter. Mostly the width of 6m was desired for rain shelter and the height of 1.6m for their eaves, so these values were chosen as the dimensions for rain shelter. After an analysis of their structural safety and installation costs by the specifications of the rafter pipe, Ø$25.4{\times}1.5t$ and 90cm have been set as the size of rafter that such size costs the least. This size is stable with $27m{\cdot}s^{-1}$ of wind velocity and 17cm of snow depth. Therefore it is difficult to apply this dimension to area with higher climate load. In order to sort out such problem, the rain shelter has been designed to avoid damage on frame by opening plastic film to the ridge. Once greenhouse band is loosen by turning the manual switch at the both sides of rain shelter and open button of controller is pushed then switch motor rises up along the guide pipe and plastic film is opened to the ridge. Chinese cabbage can be damaged by insects if rain shelter is opened completely as revealed a field. To prevent this, farmers can install an insect-proof net. Further, the greenhouse can be damaged by typhoon while growing Chinese cabbage therefore the effect of an insect-proof net on structural safety has been analyzed. And then structural safety has been analyzed through using flow-structure interaction method at the wind condition of $40m{\cdot}s^{-1}$. And it assumed that wind applied perpendicular to side of the rain shelter which was covered by insect-proof net. The results indicated that plastic film was directly affected by wind therefore high pressure occurred on the surface. But wind load on insect-proof net was smaller than on plastic film and pressure distribution was also uniform. The results of structural analysis by applying pressure data extracted from flow analysis indicated that the maximum stress occurred at the end of pipe which is the ground part and the value has been 54.6MPa. The allowable stress of pipe in the standard of structural safety must be 215 MPa or more therefore structural safety of this rain shelter is satisfied.

• Proceedings of the Korean Society of Crop Science Conference
• /
• 2017.06a
• /
• pp.252-252
• /
• 2017

Nowadays water shortage is becoming one of the biggest problems in the Korea. Many different methods are developed for conservation of water. Soil water management has become the most indispensable factor for augmenting the crop productivity especially on soybean (Glycine max L.) because of their high susceptibility to both water stress and water logging at various growth stages. The farmers have been using irrigation techniques through manual control which farmers irrigate lands at regular intervals. Automatic irrigation systems are convenient, especially for those who need to travel. If automatic irrigation systems are installed and programmed properly, they can even save you money and help in water conservation. Automatic irrigation systems can be programmed to provide automatic irrigation to the plants which helps in saving money and water and to discharge more precise amounts of water in a targeted area, which promotes water conservation. The objective of this study was to determine the possible effect of automatic irrigation systems based on soil moisture on soybean growth. This experiment was conducted on an upland field with sandy loam soils in Department of Southern Area Crop, NICS, RDA. The study had three different irrigation methods; sprinkle irrigation (SI), surface drip irrigation (SDI) and fountain irrigation (FI). SI was installed at spacing of $7{\times}7m$ and $1.8m^3/hr$ as square for per irrigation plot, a lateral pipe of SDI was laid down to 1.2 m row spacing with $2.3L\;h^{-1}$ discharge rate, the distance between laterals was 20 cm spacing between drippers and FI was laid down in 3m interval as square for per irrigation plot. Soybean (Daewon) cultivar was sown in the June $20^{th}$, 2016, planted in 2 rows of apart in 1.2 m wide rows and distance between hills was 20 cm. All agronomic practices were done as the recommended cultivation. This automatic irrigation system had valves to turn irrigation on/off easily by automated controller, solenoids and moisture sensor which were set the reference level as available soil moisture levels of 30% at 10cm depth. The efficiency of applied irrigation was obtained by dividing the total water stored in the effective root zone to the applied irrigation water. Results showed that seasonal applied irrigation water amounts were $60.4ton\;10a^{-1}$ (SI), $47.3ton\;10a^{-1}$ (SDI) and $92.6 ton\;10a^{-1}$ (FI), respectively. The most significant advantage of SDI system was that water was supplied near the root zone of plants drip by drip. This system saved a large quantity of water by 27.5% and 95.6% compared to SI, FI system. The average soybean yield was significantly affected by different irrigation methods. The soybean yield by different irrigation methods were $309.7kg\;10a^{-1}$ from SDI $282.2kg\;10a^{-1}$ from SI, $289.4kg\;10a^{-1}$ from FI, and $206.3kg\;10a^{-1}$ from control, respectively. SDI resulted in increase of soybean yield by 50.1%, 7.0% 9.8% compared to non-irrigation (control), FI and SI, respectively. Therefore, the automatic irrigation system supplied water only when the soil moisture in the soil went below the reference. Due to the direct transfer of water to the roots water conservation took place and also helped to maintain the moisture to soil ratio at the root zone constant. Thus the system is efficient and compatible to changing environment. The automatic irrigation system provides with several benefits and can operate with less manpower. In conclusion, improving automatic irrigation system can contribute greatly to reducing production costs of crops and making the industry more competitive and sustainable.

• Korean Journal of Ecology and Environment
• /
• v.41 no.3
• /
• pp.402-411
• /
• 2008

Grazing effects of two freshwater shellfish, Unio douglasiae (UNIO) and Cipangoplaudina chinese malleata (CCM), on the hibernal diatom communities in eutrophic water was examined in a laboratory. Two animals having different feeding types used in the study were collected from Keum River (Boryeong, Korea), acclimatized in the artificial management system in a laboratory over at least one month, and starved in a laboratory for 2 days before the experiment. Experimental waters, which dominated by Synedra ulna-Scenedesmus sp. (ca. 80%), was collected from eutrophic lake, Lake Ilgam (Seoul) in Feb., 19, 2008 at AM 10:00, and used in the study after the filtration with 1 mm Nylon mesh. Feeding experiments were largely divided into three kinds of animal treatments; five densities of UNIO (U0, U1, U2, U3, U4) and CCM (C0, C1, C2, C3, C4), and four combined densities of two shellfish (M0, M1, M2, M3). U0 and C0 were control (no addition of UNIO or CCM), U1 or C1 (each animal density at 0.5 ind. $L^{-1}$), U2 or C2 (1.0 ind. $L^{-1}$), U3 or C3 (1.5 ind. $L^{-1}$), and U4 or C4 (2.0 ind. $L^{-1}$), respectively. Four combined treatments were consisted of M0 (no animals), M1 (U1+C3), M2 (U2+C2), and M3 (U4+C1), respectively. Under the presence of animal, the concentration of Chl-a and algal abundance were clearly decreased with the increase of UNIO density and the treated time, while in combined group a strong decrease of algal density showed with the increase of UNIO density. Total phytoplankton density shifted as the similar patterns to that of Chl-a concentration (r=0.6527, p<0.0001), however, there showed the differences following a species. There were strong decreases of dominant species Synedra ulna, Scenedesmus sp., Ankistrodesmus falcatus in UNIO treatment group, Diatoma vulgare in combined group, while Cryptomonas ovata in high density of CCM increased about 20% in algal density. Grazing rates (GRs) based on the concentration of Chl-a was depend on the kind of shellfish and treatment time; a strong feeding of CCM showed in the initial stage, and four hours later, UNIO and combined group with high UNIO density showed the high GRs. Interestingly, faeces production of shellfish was highest in combined group with high density of CCM, while their size over 60 ${\mu}m$ was much higher in production magnitude than that less 60 ${\mu}m$. Collectively, these results suggest that two domestic shellfish and its combined treatment have a strong potential as an effective biological controller of diatom bloom in cold eutrophic waters.

• The Journal of Korean Academy of Prosthodontics
• /
• v.43 no.4
• /
• pp.528-543
• /
• 2005

Statement of problem: Repeated delivery and removal of abutment cause some changes such as wear, scratch or defect of hexagonal structure. It may increase the value of rotational freedom(RF) between hexagonal structures. Purpose: The purpose of this study was to evaluate surface changes and rotational freedom between the external hexagon of the implant fixture and internal hexagon of abutment after repeated delivery and removal under SEM and toolmaker's microscope. Materials and methods: Implant systems used for this study were 3i and Avana. Seven pail's of implant fixture, abutment and abutment screws for each system were selected and all fixtures were perpendicularly mounted in liquid unsaturated polyesther with dental surveyor. Each one was embedded beneath the platform of fixture. Surfaces of hexagonal structure before repeated closing and opening of abutment were observed using SEM and rotational freedom was measured by using toolmaker's microscope. Each abutment was secured to the implant future by each abutment screw with recommended torque value using a digital torque controller and was repeatedly delivered and removed by 20 times respectively. After experiment, evaluation for the change of hexagonal structures and measurement of rotational freedom were performed. Result : The results were as follows; 1. Wear of contact area between implant fixture and abutment was considerable in both 3i and Avana system. Scratches and defects were frequently observed at the line-angle of hexagonal structures of implant fixture and abutment. 2. In the SEM view of the external hexagon of implant fixture, the point-angle areas at the corner edge of hexagon were severely worn out in both systems. It was more notable in the case of 3i systems than in that of Avana systems. 3. In the SEM view of the internal hexagon of abutment, Gingi-Hue abutment of 3i systems showed severe wear in micro-stop contacts that were machined into the corners to prevent rotation and cemented abutment of Avana systems showed wear in both surface area adjacent to the corner mating with external hexagon of implant fixture. 4 The mean values of rotational freedom between the external hexagon of the implant fixture and internal hexagon of abutment were 0.48$\pm$0.04$^{\circ}$ in pre-tested 3i systems and 1.18$\pm$0.25$^{\circ}$ after test, and 1.80$\pm$0.04$^{\circ}$ in pre-tested Avana systems and 2.61$\pm$0.16$^{\circ}$ after test. 5. Changes of rotational freedom after test shouted statistical)y a significant increase in both 3i and Avana systems(P<0.05, paired t-test). 6. Statistically, there was no significant difference between amount of increase in the rotational freedom of 3i systems and amount of increase in that of Avana ones(P>0.05, unpaired t-test). Conclusion: Conclusively, it was considered that repeated delivery and remove of abutment by 20 times would not have influence on screw joint stability. However, it caused statistically the significant change of rotational freedom in tested systems. Therefore, it is suggested that repeated delivery and remove of abutment should be minimal as possible as it could be and be done carefully Additionally, it is suggested that the means or treatment to prevent the wear of mating components should be devised.

• Journal of Korean Society of Forest Science
• /
• v.97 no.1
• /
• pp.61-70
• /
• 2008

This study was conducted to develop a mobile tower-yarder with tractor for agriculture and forestry that is the efficient yarder in steep terrains, thinning operation and small scale logging operation. It was designed and manufactured that the power source of tower-yarder is equiped three hydraulic pump connected to PTO of tractor, and three hydraulic pump is used to operate the four motor for drum, the cylinder for clutch of interlocker, the cylinder for tower expanding and the out-rigger cylinder. It was to adopt the running skyline system and the inter-lock function, and to equip the double capstan drum, the storage drum and the clutch for interlock in the development of tower-yarder. It was to develop the tower-yarder which the winch torque of double-capstan drum, the traction force of double-capstan drum, the number of rotation of double-capstan drum and the line speed is $191kg{\cdot}m$, 1,910 kgf, 220.5 rpm and 138.5 m/min, respectively. And it was known that the optimum flange diameter of the main and haulback storage drum is about 360 mm and about 460 mm in order to storage the main line length of 250m and the haulback line length of 450 m. The carriage was made to adopt the running skyline system and to equip the lock function in order to the convenience of chocking and the fall down preventing of tree. It was provided to develop the wire remote controller for the inter-lock function, the convenience of control and the efficiency of yarding. In development process, this tower-yarder was attached the 3-point linkage hitch equipment and the tire wheel for the traction and moving of tower-yarder. Also, it was equipped that the out-rigger and the guy line in order to raise the safety and efficiency of yarding of tower-yarder.

• Journal of Broadcast Engineering
• /
• v.16 no.2
• /
• pp.216-225
• /
• 2011

Following the proliferation of three-dimensional video contents and displays, many terrestrial broadcasting companies have been preparing for stereoscopic 3DTV service. In terrestrial stereoscopic broadcast, it is a difficult task to code and transmit two video sequences while sustaining as high quality as 2DTV broadcast due to the limited bandwidth defined by the existing digital TV standards such as ATSC. Thus, a terrestrial 3DTV broadcasting with a heterogeneous video codec system, where the left image and right images are based on MPEG-2 and H.264/AVC, respectively, is considered in order to achieve both high quality broadcasting service and compatibility for the existing 2DTV viewers. Without significant change in the current terrestrial broadcasting systems, we propose a joint rate control scheme for stereoscopic 3DTV service based on the heterogeneous dual codec systems. The proposed joint rate control scheme applies to the MPEG-2 encoder a quadratic rate-quantization model which is adopted in the H.264/AVC. Then the controller is designed for the sum of the left and right bitstreams to meet the bandwidth requirement of broadcasting standards while the sum of image distortions is minimized by adjusting quantization parameter obtained from the proposed optimization scheme. Besides, we consider a condition on maintaining quality difference between the left and right images around a desired level in the optimization in order to mitigate negative effects on human visual system. Experimental results demonstrate that the proposed bit rate control scheme outperforms the rate control method where each video coding standard uses its own bit rate control algorithm independently in terms of the increase in PSNR by 2.02%, the decrease in the average absolute quality difference by 77.6% and the reduction in the variance of the quality difference by 74.38%.

• Journal of Broadcast Engineering
• /
• v.22 no.2
• /
• pp.193-206
• /
• 2017

In this paper, we propose a rate control method based on the $R-{\lambda}$ model that supports a parallel encoding structure in GOP levels or IDR period levels for 4K UHD input video in real-time. For this, a slice-level bit allocation method is proposed for parallel encoding instead of sequential encoding. When a rate control algorithm is applied in the GOP level or IDR period level parallelism, the information of how many bits are consumed cannot be shared among the frames belonging to a same frame level except the lowest frame level of the hierarchical B structure. Therefore, it is impossible to manage the bit budget with the existing bit allocation method. In order to solve this problem, we improve the bit allocation procedure of the conventional ones that allocate target bits sequentially according to the encoding order. That is, the proposed bit allocation strategy is to assign the target bits in GOPs first, then to distribute the assigned target bits from the lowest depth level to the highest depth level of the HEVC hierarchical B structure within each GOP. In addition, we proposed a processing method that is used to improve subjective image qualities by allocating the bits according to the coding complexities of the frames. Experimental results show that the proposed bit allocation method works well for frame-level parallel HEVC software encoders and it is confirmed that the performance of our rate controller can be improved with a more elaborate bit allocation strategy by using the preprocessing results.

• The Korean Journal of Nuclear Medicine Technology
• /
• v.12 no.1
• /
• pp.91-98
• /
• 2008

Purpose: Radio-isotopes (RI) use has been steadily developing due to industrial and technical development in the modern medical society. Particularly, popularization of domestic cyclotrons dramatically enable hospitals to produce and use diagnostic radio-isotopes. Generally, only specific facilities such as hospitals, research institutes, nuclear power plants and universities can use radio-isotopes, they are also responsible for ventilation system. The strength of radioactivity in the air is strongly regulated and controlled by korea atomic energy law in Korea Institue of Nuclear Safety (KINS), so that air radioactivity exposure can lead to environmental pollution surrounding places. In this study, we'd like to find out the investigation and the present condition of the controlled ventilation system in domestic hospitals by an emission standard from KINS, and try to reach an agreement about how to use the ventilation system. Result: Definition of filters, features and structures of pre-filters, hepa-filters, charcol filters, filter exchange procedures and precautions are explained. RI deflation concentration and filter exchange cycle have been presented as a standard prescribed in the rules of KINS. The Radiation Control Management System (RCMS) introduced by Seoul National University Bundang Hospital linking to digital pressure gauge with computer controller in another medical facilities were described in details. Conclusions: The system of medical facilities using RI has been remarkably developing in 21 century. Especially, radiation safety control system has also been grown rapidly into the subdivision, specialization, advanced technology along with international technical improvement. However, As far as current RI ventilation system is concerned, it has nothing better than doing in the past. Preferentially, to reinforce this, more sophisticated system with strict periodic filter exchange and exhaust air control guidance should be introduced by applying brilliant domestic information technology for RCMS and digital gauge method. From personal point of view as a radiation safety manager, I have provide with present problems and improvements. Futhermore, more improved guidance should be conducted.