• 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을 효율적으로 정의하고 추가하는 방법 그리고 시스템 모델링을 효과적으로 구성하는 방법에 대한 연구를 통해 본 연구를 더욱 개선시킬 수 있을 것이다.

• Journal of the Society of Cosmetic Scientists of Korea
• /
• v.30 no.4 s.48
• /
• pp.571-582
• /
• 2004

Recently the well-being, which is regarded as the new cultural code, has brought a new change in the cosmetic industry. The application of the functional products is getting mere and lots of functional cosmetics are now diversifying from the skin-care into the make-up as well as the herbal products. So the future in the market of functional cosmetic products is prospected to be positive. Therefore, cosmetic companies need an approach bases on the concept of the well-being. So to speak, they need to understand the needs of customers accurately from the customers point of view. Also it is a crucial issue that how the unique characteristics of functional cosmetic products as well as the development of products base on the concept of well-being make in balance. In this study, we attempt to inspect the advanced domestic market of the functional products due to the well-being trend and try to propose an option of making an advance it through the customers survey (for example, their need and their satisfaction on the functional products, etc) on the functional cosmetic products. For this purpose, it has been surveyed on adult female customers aged 19 to 60 located in Seoul and Gyeonggi province. 379 questionnaires among 510 were used in the final analysis. Collected data was analyzed using the statistical package for the social science (SPSS) program that can give the information about the general characteristics of the subjects like the frequency and percentage. And we used Cronbach's u reliability test, $x^2\;(chi-square)$ frequency analysis, t-test, and one-wat ANOVA to investigate the customers need, their degree of the satisfaction on the functional products of their own, factors of their perception on the quality on them. We think that the results of our study can act not only as the fundamental data on the customers need, their usage pattern, and their degree of the satisfaction, but also as the important tips of planning the marketing strategies.

• Korean Journal of Soil Science and Fertilizer
• /
• v.45 no.5
• /
• pp.725-732
• /
• 2012

There is relatively high vulnerability of soil erosion in slope highland agriculture due to a reclamation of mountain as well as low surface covering during early summer with high rainfall intensity. Especially, in soybean cultivation, soil disturbance by conventional tillage and exposure of topsoil at the early stage of soybean have intensified soil loss. The aim of this study was to evaluate various surface covering methods for reducing soil loss in highland soybean cultivation. The experiment was conducted in 17% sloped lysimeter ($2.5m{\times}13.4m$) with 8 treatments. Amount of runoff water and eroded soil, and soybean growth were investigated. Surface covering through sod culture and plant residue showed 3.4~45.0 runoff water amount with $177{\sim}2,375m^3\;ha^{-1}$ compared with control ($5,274m^3\;ha^{-1}$). And the amount of eroded soil was also reduced by 95% in surface covering treatment with $0.02{\sim}1.94Mg\;ha^{-1}$ than control with $40.72Mg\;ha^{-1}$. Yields of soybean pod showed $0.3Mg\;ha^{-1}$ in rye sod culture, $1.3Mg\;ha^{-1}$ in Ligularia fischeri var. spiciformis Nakai, $0.7Mg\;ha^{-1}$ in Aster koraiensis Nakai, $0.2Mg\;ha^{-1}$ in red clover and $2.0Mg\;ha^{-1}$ in non-covering, on the other hand, covering with cut rye showed $3.8Mg\;ha^{-1}$. Conclusively, covering the soil surface with cut rye were beneficial for reduction of soil loss without decreasing soybean yield in highland sloped fields.

• Korean Journal of Plant Resources
• /
• v.33 no.1
• /
• pp.15-23
• /
• 2020

There is high vulnerability of soil loss in sloping and highland used for agricultural production due to the low surface covering in summer rainy season. This study evaluated the surface-covering rate of landscape crop in reducing soil loss in the highland. The experiment was conducted in a 55% sloped lysimeter with three treatments of planting density using Korean native chrysanthemum, and investigated the soil coverage rate, run-off water, and soil erosion. The three treatments according to the degree of soil covering are bare soil as the control treatment TC, coverage rate of 43-59% for treatment T1, and, coverage rate of 63-81% for treatment T1, and T2. During the cultivation period, the average reduction of run-off water was 71% for treatment T1 and 76% for treatment T2, which are better, compared with the control. The reduction in eroded soil was 84% in treatment T1 and 98% for treatment T2, which is also better than the control treatment. Therefore, it is possible to alleviate the soil loss in sloping lands by planting chrysanthemum, which is superior among the perennial plant species and considered as a crop with economic value.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.5 no.2
• /
• pp.1-15
• /
• 2002

Atmospheric aerosols interact with sunlight and affect the global radiation balance that can cause climate change through direct and indirect radiative forcing. Because of the spatial and temporal uncertainty of aerosols in atmosphere, aerosol characteristics are not considered through GCMs (General Circulation Model). Therefor it is important physical and optical characteristics should be evaluated to assess climate change and radiative effect by atmospheric aerosols. In this study GMS-5 satellite data and surface measurement data were analyzed using a radiative transfer model for the Yellow Sand event of April 7~8, 2000 in order to investigate the atmospheric radiative effects of Yellow Sand aerosols, MODTRAN3 simulation results enable to inform the relation between satellite channel albedo and aerosol optical thickness(AOT). From this relation AOT was retreived from GMS-5 visible channel. The variance observations of satellite images enable remote sensing of the Yellow Sand particles. Back trajectory analysis was performed to track the air mass from the Gobi desert passing through Korean peninsular with high AOT value measured by ground based measurement. The comparison GMS-5 AOT to ground measured RSR aerosol optical depth(AOD) show that for Yellow Sand aerosols, the albedo measured over ocean surfaces can be used to obtain the aerosol optical thickness using appropriate aerosol model within an error of about 10%. In addition, LIDAR network measurements and backward trajectory model showed characteristics and appearance of Yellow Sand during Yellow Sand events. These data will be good supporting for monitoring of Yellow Sand aerosols.

• Korean journal of applied entomology
• /
• v.56 no.3
• /
• pp.301-308
• /
• 2017

Locusts, Locusta migratoria (Orthoptera: Acrididae) are periodical unpredictable agricultural pests worldwide and cause serious damage to crop production; however, little consideration has been given to the management of this pest. Herein, we constructed a locust-pathogenic fungal library and confirmed that some fungi could be used as resources for locust management. First, the entomopathogenic fungi were collected from sampled soils using a Tenebrio molitor-based baiting system. For the locust assay, a locust colony was obtained from the National Institute of Agricultural Science and Technology. A total of 34 entomopathogenic fungal granules, which were produced by solid cultures, were placed in the plastic insect-rearing boxes (2 g/box) and nymphs of locust were contained in the box. In 3-7 days, mycosis was observed on the membranous cuticles of the head, abdomen, and legs of locusts. In particular, Metarhizium anisopliae, M. lepidiotae, and Clonostachys rogersoniana exhibited high virulence against the locust. Given that the 34 isolates could be used in field applications, their conidial production and stability (thermotolerance) were further characterized. In the thermotolerance assay, Paecilomyces and Purpureocillium isolates had higher thermotolerance than the other isolates. Most of the fungal isolates produced ca. >$1{\times}10^8conidia/g$ on millet grain medium. In a greenhouse trial, the granular application of M. anisopliae isolate on the soil surface resulted in 85.7% control efficacy. This work suggests that entomopathogenic fungi in a granular form can be effectively used to control the migratory locust.

• Management & Information Systems Review
• /
• v.37 no.1
• /
• pp.139-154
• /
• 2018

R programming is free and open source system associated with a rich and ever-growing set of libraries of functions developed and submitted by independent end-users. It is recognized as a popular tool for handling big data sets and analyzing them. Reflecting these characteristics, R has been gaining popularity from data analysts. However, the antecedents of R technology acceptance has not been studied yet. In this study we identify and investigates cognitive factors contributing to build user acceptance toward R in education environment. We extend the existing technology acceptance model by incorporating social norms and software capability. It was found that the factors of subjective norm, perceived usefulness, ease of use affect positively on the intention of acceptance R programming. In addition, perceived usefulness is related to subjective norms, perceived ease of use, and software capability. The main difference of this research from the previous ones is that the target system is not a stand-alone. In addition, the system is not static in the sense that the system is not a final version. Instead, R system is evolving and open source system. We applied the Technology Acceptance Model (TAM) to the target system which is a platform where diverse applications such as statistical, big data analyses, and visual rendering can be performed. The model presented in this work can be useful for both colleges that plan to invest in new statistical software and for companies that need to pursue future installations of new technologies. In addition, we identified a modified version of the TAM model which is extended by the constructs such as subjective norm and software capability to the original TAM model. However one of the weak aspects that might inhibit the reliability and validity of the model is that small number of sample size.

• Journal of Life Science
• /
• v.19 no.9
• /
• pp.1314-1320
• /
• 2009

Histone deacetylase inhibitor (HDACI) is a new promising candidate as an antineoplastic agent for the treatment of solid and hematologic malignancies. In order to evaluate cell death and to elucidate the related mechanism(s) in NSCLC cells after HDACI, sodium butyrate (SB), a representative HDACI, was used to treat H460 cells for 48 hrs. SB exposure resulted in a significant reduction of cell viability at concentrations below 7.5 mM, and about 50% of cell death occurred at 20 mM. The types of cell death induced by SB were both apoptosis and necrosis, evaluated by Annexin-V staining combined with propidium iodide. SB treatment significantly evoked G2/M cell cycle arrest and subsequently induced cell death with caspase-dependent manner. While ERK protein content was not altered after SB, phosphorylated forms of ERK were markedly reduced. Taken together, SB is significantly able to induce cell death in NSCLC cell line H460, and it is suggested that the reduction of ERK phosphorylation might be closely involved in the cancer cell death mechanism initiated by HDACI.

• Journal of Environmental Policy
• /
• v.11 no.4
• /
• pp.39-57
• /
• 2012

Analysis of the economic impact on Korean bioindustry companies was approached after Korea access to the Nagoya Protocol on Access to Genetic Resources and the Fair and Equitable Sharing of Benefits Arising from their Utilization to the Convention on Biological Diversity (hereinafter 'the Protocol') enters into force. Cost analysis of the economic impact is based on the size of bioindustry market, dependency ratio on genetic resources abroad, ABS (Access and Benefit Sharing) ratio for royalty ratio. Korean bioindustry companies would have had to pay extra ABS cost around 1.3-6.0 billion won for using genetic resources abroad, if the Protocol had entered into force in 2009. And this cost is estimated to be around 13.6 - 63.9 billion won in 2015. All ABS costs account only about less than 0.01% of total Korean bioindustry volume of target years. These show us that joining the Protocol will not significantly impact the bioindustry market in Korea. If the Protocol enters into force, genetic resources users have to pay PIC (Prior Informed Consent) and MAT (Mutually Agreed Terms) cost before accessing the genetic resources outside of their country, regardless of the accession status of the country. This ABS costs and terms on provided genetic resources will be determined by compliance between genetic resources users and providers. As a genetic resources provider, Korean bioindustry companies will have advantage over technology transfer agreements, royalties, licensing agreements, and taxes on profits from patents including traditional knowledge. Also, Korean bioindustry companies are expected to get various socio-economic benefits such as patent litigation and regulatory proceedings as a genetic resources provider. Considering the advantages and disadvantages of the Protocol that Korean bioindustry companies will face together, the socio-economic impact of the Nagoya Protocol on Korean bioindustry companies is negligible regardless of the accession status of Korea to the Nagoya Protocol.

• Journal of Aquaculture
• /
• v.17 no.1
• /
• pp.39-45
• /
• 2004

Three experiments were conducted to determine utilization of Song-Gang(equation omitted) stone as the dietary additive for growth and immune stimulant in juvenile olive flounder. In the feeding trial, four diets were formulated to contain 0, 0.5, 1.0 and 2.0% Song-Gang(equation omitted) stone per kg diet (SGS$_{0}$ , SGS$_{0.5}$, SGS$_{1.0}$ , SGS$_{2.0}$ ). Fish averaging 5.0$\pm$0.04 g (mean$\pm$SD) were fed one of four experimental diets in triplicate groups for 8 weeks. There were no significant differences in weight gain, feed efficiency, protein efficiency ratio, hematosomatic index, condition factor and survival among fish fed all the diets. In chanlenge test, fish were infected by intraperitoneal injection of 0.1 $m\ell$ bacterial suspension with Edwardsielia tarda per fish after the feeding trial. Fish fed SGS$_{0.5}$ diet have a significantly higher cumulative survival rate than did fish fed the other diets (P<0.05). In the anti-mold test, Asprrgiilus niger, Penicillium pinophiltfm, Chaeromium globosum were inoculated with Song-Gang(equation omitted) stone using ASTM G-21 method. The amount of Α. niger, Ρ. pinuphiium. C. globosum didn't increase in Song-Gang(equation omitted) stone for 4 weeks for the test period. Therefore, these results indicate that 0.5% Song-Gang(equation omitted) stone per kg diet could increase immune resistance in juvenile olive flounder and Song-Gang(equation omitted) stone could be used as the anti-mold additive in fish feed.