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

• Microbiology and Biotechnology Letters
• /
• v.48 no.3
• /
• pp.344-357
• /
• 2020

Strain improvement and bioprocess development were undertaken to enhance hyaluronic acid(HA) production by Streptococcus zooepidemicus cells. Using a high-yielding mutant strain, statistical medium optimization was carried out in shake flask cultures, resulting in 52% increase in HA production (5.38 g/l) at the optimal medium composition relative to the parallel control cultures. For sufficient supply of dissolved oxygen (DO), which turned out to be crucial for enhanced production of HA, agitation system and speed were intensively investigated in 5 L bioreactor cultures. Increase in oxygen mass transfer coefficient (k_La) through increment of agitation speed (rpm) and 35% expansion of diameter of the newly-designed impellers showed significantly positive effects on HA production. By installing an expanded Rushton-turbine impeller for efficient break-down of sparged air, and an extended marine impeller above the Rushton-turbine impeller for efficient mixing of the air-born viscous fermentation broth, maximum amount of HA (9.79 g/l) was obtained at 450 rpm, 1.8 times higher level than that of the corresponding flask culture. Subsequently, the possibility of bioprocess scale-up to a 50 L bioreactor was investigated. Despite almost identical maximum HA production (9.11 vs 9.25 g/l), the average HA volumetric productivity (r_p) of the 50 L culture turned out only 74% compared to the corresponding 5 L culture during the exponential phase, possibly caused by shear damages imposed on the producing cells at the high stirring in the 50 L culture. The scale-up process could be successfully achieved if a scale-up criterion of constant oxygen mass transfer coefficient (k_La) is applied to the 50 L pilot-scale bioreactor system.

• Radiation Oncology Journal
• /
• v.21 no.1
• /
• pp.1-9
• /
• 2003

Purpose : The purpose of this study was to analyze the effect of a Linear accelerator based Photon Knife Radiosurgery System developed by the staff of Keimyung University Dongsan Medical Center for the treatment of cerebral arterlovenous malformation Material and Methods : Between December 1993 and October 2000, 30 patients with cerebral arteriovenous malformation (AVM) were treated with the Linac based Photon knife Radlosurgery System In the Department of Therapeutlc Radiology at Keimyung University Dongsan Medical Center. The median age was 34, ranging from 7 to 63 years, with a 2 : 1 male to female ratio. The locations of the AVM nidi were the frontal lobe (motor cortex), parletal lobe, and the thalamus, In that order. The diameters of the AVM nidi ranged 1.2 to 5.5 cm with a mean on 2.9 cm, and target volumes of between 0.5 and 20.5 cc, with a mean of 5.8 cc. The majority of patients received radiation doses of between 1,500 and 2,500 cGy, w14h a mean of 2,000 cGy, at 80% the isodose line. Twenty-five patients were treated with one isocenter, 4 with two, and 1 with four. The follow-up radiological evaluations were peformed with cranial computed tomogram (CT) or MRI between 6 month and one year interval, and if the AVM nidus had completely disappeared in the CT or MRI, we confirmed thls was a complete obliteration, with a cerebral or magnetic resonance angiogram (MRA). The median iollow-up period was 39 months with a range of 10 to 103 months. Results : Twenty patients were radloiogicaiiy followed up ior over 20 months, with complete obliteration observed in 14 (70%). According to the maximal diameter, all four of the small AVM (<2 cm) completely obliterated, 8 of the 10 patients with a medium AVW (2~3 cm) showed a complete obliteration, and two showed partial obliteration. Among the patients with a large AVM (>3 cm), only one showed complete obliteration, and S showed partial obliteration, but 3 oT these underwent further radiosurgery 3 years later. One who followed up for 20 months fellowing further radiosurgery eventually showed complete obliteration. Ten patients with seizure symptoms had no recurrent seizure due to radiosurgery and medication. One of the eleven patients who suffered intracranlal bleeding developed further bleeding at 9 and 51 months fellowing the radiosurgery although complete obliteration was eventually observed and the patient was managed in hospital then recovered. No patient suffered severe complications fellowing the radiosurgery. Conclusion : The radiosurgery with Linac-based Photon knife radiosurgery system, developed by the staff at our hospital, is a safe and effective treatment for AVM patients having diameters or volumes of less than 3 cm or 10 cm$^{3}$, respectively, located In Inoperable areas or who refused neurosurgery. We suggest that staged AVM radiosurgery may initially be considered, if the AVM target volume is above 10 cm$^{3}$

• Korean Journal of Materials Research
• /
• v.11 no.8
• /
• pp.629-635
• /
• 2001

To improve the ductility of $A1_3Hf$ intermetallics, which are the potential high temperature structural materials, the mechanical alloying behavior. the effect of Cu addition on the $Ll_2$ phase formation and the behavior of vacuum hot-pressed consolidation were investigated. During the mechanical alloying by SPEX mill, the $Ll_2 A1_3Hf$ intermetallics with the grain size of 7~8nm was formed after 6 hours of milling in Al-25at.%Hf system. The $Ll_2$ Phase of Al_3Hf$ intermetallics with the addition of 12.5at.%Cu, similar to that of the binary Al-25at.% Hf, was formed, but the milling time necessary for the formationof the $Ll_2$ phase was delayed form 6 hours to 10 hours. The lattice parameter of ternary $Ll_2(Al+Cu)_3Hf$ intermetallics decreased with the increase of Cu content. The onset temperature of $Ll_2$ to $D0_{23}$ phase in $Al_3Hf$ intermetallics was around 38$0^{\circ}C$, the temperature upon completion varied from 48$0^{\circ}C$ to 5$50^{\circ}C$ as the annealing time. The onset temperature of $Ll_2$ to $D0_{23}$ phase transformation in $(Al+ Cu)_3Hf$ intermetallics increased with the amount of Cu and the highest onset temperature of $700^{\circ}C$ was achieved by the Cu addition of 10at.%. The relative density increased from 89% to 90% with the Cu addition of 10at.% in $Al_3Hf$ intermetallics hot-pressed in vacuum under 750MPa at 40$0^{\circ}C$ for 3 hours. The relative density of 92.5% was achieved without the phase transformation and the grain growth as the consolidation temperature increased from 40$0^{\circ}C$ to 50$0^{\circ}C$ in $(Al+Cu)_3Hf$ intermetallics hot-pressed in vacuum under 750MPa for 3 hours.

• The Korean Journal of Malacology
• /
• v.17 no.1
• /
• pp.45-55
• /
• 2001

Gametogenes, reproductive cycle, first sexual maturity(biological minimum size), sex ratio and larval development of the marsh clam Corbicula japonica were investigated monthly by histological observations. Samples were collected in brackish water of Gokgang stream, Kyungsangbuk-Do, Korea, from August 1997 to July 1998. Sexuality of Corbicula japonica is dioecious and the species are an oviparous clam. The gonads are irregularly arranged from the sub-region of mid-intestinal gland in visceral cavity to reticular connective tissue of foot. The ovary is composed of a number of ovarian sac which are branched arborescent. Oogonia actively proliferate along the germinal epithelium of ovarian sac, in which young oocytes are growing. The testis is composed of a number of testicular tubules, and the epithelium of the tubule has function of germinal epithelium, along which spermatogonia actively proliferate. A great number of undifferentiated mesenchymal tissue and eosinophilic granular cells are abundantly distributed between developing oocytes and spermatocytes in the early developmental stages. With the further development of the ovary and testis these tissue and cells gradually disappear. Then the undifferentiated mesenchymal tissue and eosinophilic granular cells are considered to be related to the growing of the oocytes and spermatocytes. The spawning period is from July to September, and the main spawning occur between July and August when seawater temperatures reach above 22$^{\circ}C$. The reproductive cycle of this species can be divided into five successive stages; early active (February to April), late active (May to July), ripe (June to September), partially spawned (July to September), degenerative (September to October) and resting stage (October to February). Percentages of first sexual maturity of female and male clams ranging in length from 10 mm to 12 mm are over 50% and 100% for clams over 16.0 mm in shell length. Fertilized eggs or Corbicula japonica were 80-90 ${\mu}{\textrm}{m}$ in diameter. In the early embryonic development of C. japonica, the appearance of polar body, trochophore and D-shaped veliger were observed around 40 min., 27 hours and 4 days after spawning, respectively, at a water temperature of 26.5-28.$0^{\circ}C$. The size of larvae of early umbo stage was about 185-210 ${\mu}{\textrm}{m}$ in shell length, 160-180 ${\mu}{\textrm}{m}$ in shell height around 7 days after fertilization. The correlation of relative growth between the culture day (D) and shell length (SL) was expressed by the following simple formula from D-shaped veliger to metamorphosing stage; SL = 13.300D + 209.36($r^2$= 0.9078).

• Korean Journal of Ichthyology
• /
• v.17 no.3
• /
• pp.173-186
• /
• 2005

Genomic DNA was isolated from two geographic populations of largehead hairtail (Trichiurus lepturus) in Korea and the Atlantic Ocean. The eight arbitrarily selected primers were found to generate common, polymorphic, and specific fragments. The complexity of the banding patterns varied dramatically between primers from the two locations. The size of the DNA fragments also varied widely, from 150 bp (base pairs) to 3,000 bp. Here, 947 fragments were identified in the largehead hairtail population from Korea, and 642 in the largehead hairtail population from the Atlantic Ocean: 148 specific fragments (15.6%) in the Korean population, and 61 (9.5%) in the Atlantic population. In the Korean population, 638 common fragments with an average of 79.8 per primer were observed.; 429 common fragments, with an average of 53.6 per primer, were identified in the Atlantic population. The number of polymorphic fragments in the largehead hairtail population from Korea and the Atlantic Ocean was 76 and 27, respectively. Based on the average bandsharing values of all samples, the similarity matrix ranged from 0.784 to 0.922 in the Korean population, and from 0.833 to 0.990 in the Atlantic population. The bandsharing value of individuals within the Atlantic population was much higher than in the Korean population. The dendrogram obtained by the eight primers indicated two genetic clusters: cluster 1 (KOREAN 01~KOREAN 11), and cluster 2 (ATLANTIC 12~ATLANTIC 22). Individual KOREAN no. 10 from Korea was genetically most closely related to KOREAN no. 11 in the Korean population (genetic distance = 0.038). Ultimately, individual KOREAN no. 01 of the Korean population was most distantly related to ATLANTIC no. 16 of the Atlantic population (genetic distance = 0.708).

• The Journal of the Korean bone and joint tumor society
• /
• v.7 no.1
• /
• pp.20-27
• /
• 2001

Purpose : The giant cell tumor of tendon sheath is the second most common tumor of the hand, but recurred frequently although excision was performed. Authors analyzed and would report clinical findings and postoperative results of it. Materials and Methods : Between January 1991 and December 1998, 38 patients, 41 cases which the authors had performed excisional biopsy to the mass in the hand and diagnosed with the giant cell tumor of tendon sheath, was analyzed with age, sex, chief complaint, symptom duration, involved finger, involved tendon, frequently developed site in fingers, size, multiplicity, radiologic findings and recurrence. The mean duration of follow-up was 13.1 months (5~40 months). Results : Of 38 patients, twenty-nine were female. It is frequent in the fourth decade and mean age was 40.1 years old. The neurological compression symptom was found in 5 cases. The mean duration of symptom was 23.4 months. Flexor tendon was involved in 24 cases. The distal interphalangeal joint area in digit was involved most frequently in 20 cases. Index finger was the most common involved finger (14 cases), and long finger was the second most common (9 cases). All tumors were unilateral. The majority of patients had solitary lesion but one case had multiple lesion. In the radiologic findings, erosion or pressure indentation of bone was seen in 3 cases. All patients were operated by marginal excision. Recurrence rate was 5.1%. Conclusion : The risk factors in giant cell tumor of tendon sheath were female, forth decade, index finger, flexor tendon, and distal interphalangeal joint area. The recurrence was increased in marginal excision of recurred cases, in cases with multiple developed lesions or in multilobular lesion, so wide surgical excision is necessary to prevent recurrence.

• Journal of the Korean Society of Food Science and Nutrition
• /
• v.33 no.4
• /
• pp.723-729
• /
• 2004

To develop foods using dried persimmon, hot-water extracts of dried persimmons were added into strong wheat flour in the ratio of 10, 20, 30, and 40% and the quality characteristics of baked products were investigated. The proximate compositions of dried persimmons hot-water extracts were 70.37% of moisture, 1.72% of crude protein, 0.18% of crude lipids, 1.99% of crude ash and 4.37% of crude fiber, respectively. With increasing the addition of dried persimmons hot-water extracts, moisture content of the added breads was increased to 47.20% from 41.12% of non-added bread and water activity to 0.576 from 0.495. Water binding capacity of the added dried persimmons hot-water extracts rasied weight of the bread but decreased specific volume. In the hunter's color values the more dried persimmons hot-water extracts was added, the lower L vaules we, and the higher a and b values we. In the texture property, the addition of dried persimmons hot-water extracts increased hardness, gumminess and chewiness, while decreased adhesiveness and fracturability. Judging from texture, taste and overall acceptability of the product, recommended substitution level for hot-water extracts of dried persimmons in bread was 30% or less.

• Journal of Korean Society of Forest Science
• /
• v.24 no.1
• /
• pp.1-24
• /
• 1974

A national programme of erosion control for soil and water conservation needs to be based on factual information about rates and quantities of soil erosion and of water runoff. The best and simplest way of reducing sedimentation pollution is to prevent or control the erosion at its sources. Steeply sloping earth banks are liable to both surface erosion and land-slides and the key to the control of these form of erosion lies with drainages and dense vegetation establishment including surface mulching on the slopes. Micro-plots having $1.6m^2$ (1 metre in width and 1.6 metres in slope length, and 1:1.2 in gradient) of banking slopes on the coarse sand soil are used to establish the order of magnititude of the difference in controlling of soil erosion and water runoff, and in potentiality of execution in consideration of the values of landscapes, performed on the 2 repetetions of six-experiment plots consisted of five surface mulches including seedings and one bare slope as a control treatment. The main results obtained may be summarized as follows: 1. The significant difference is realized in the quantities of soil erosion between the measures of six treatments. 2. Excepting the differences between treatment III and VI, the significant difference is realized in the rate of surface runoff between each treatment measures. 3. Both measures of treatment II and IV are recognized as the most effective measures in controlling the soil erosion and water runoff and also in establishing the ground vegetation. (Treatment II is a measures of the coarse straw-mat mulchings on the micro-strip seedings, Treatment IV is a measures of the "SPRAY-ON method" on the micro-strip seedings). In consideration of the potentiality of execution as well as the value of landscapes, the measures of treatment II could be recommendable for establishing the vegetation cover on the denuded gentle slopes in hillsides while the measures of treatment IV could be suitable for accelerating the establishment of vegetation on steeply sloping earth banks and cuts.

• Journal of Korean Home Economics Education Association
• /
• v.16 no.3
• /
• pp.1-25
• /
• 2004

This study analyzes the external forms of the household textbooks and also the contents of them used at girls' middleㆍhigh schools during the period of Japanese ruling over Korea. To this end, 8 household textbooks published from 1928 to 1937 were analyzed. The results of the study are summarized as follows. 1. The household subject had become the one of the most important subjects to girl students as the practical uses were emphasized in educational area during the period. As a result. the classes of the household were the second in hours, following the class of Japanese (the national language) to girl students. 2. The contents of the household textbooks were intended to contain 'the modern' and 'the newest'. The students were also suggested to apply the contents of the textbooks to real home life. Many pictures, photos and illustrations were included in household textbooks to help students to understand the contents of the subject. 3. The purposes of the household class were the reformation of the living conditions and home economics. 4. The external characteristics of the household textbooks during the period were as follows. - Written in Japanese vertically and the size of the textbook was A5 (150/210) with pulp paper of good quality - The type style of the body of the textbooks was Ming-style type- The sequent order of the textbooks was the outer cover, the title page, pictorial, introduction, table of contents, the body, appendix and the back cover. 5. The household textbooks consisted of the first volume and the second volume. The first volume contained clothing and textiles, food and nutrition and housing. Taking care of the aged. nursing. child care, household economy and home management were included in the second volume. 6. The household textbooks were designed to make women the housewives.