• Title/Summary/Keyword: Triple

Search Result 2,698, Processing Time 0.046 seconds

The Clinical Outcomes of Off-Pump Coronary Artery Bypass Grafting in the Octogenarians (80세 이상 고령 환자에서 심폐바이패스 없이 시행한 관상동맥우회술의 중단기 성적)

  • Kim Do-Kyun;Lee Chang Young;Lee Kyo Joon;Joo Hyun Chul;Yoo Kyung-Jong
    • Journal of Chest Surgery
    • /
    • v.38 no.10 s.255
    • /
    • pp.680-684
    • /
    • 2005
  • Background: With the increasing age of the population, coronary artery bypass grafting in the elderly patients is becoming common. Off-pump coronary artery bypass grafting (OPCAB) has been proven to be less morbidity and to facilitate early recovery. The elderly patients may have benefits by avoiding the adverse effects of the cardiopulmonary bypass. The purpose of this study is to evaluate our results of OPCAB in elderly patients. Material and Method: A retrospective chart review was carried out for 12 patients aged over 80 years who underwent isolated OPCAB from January 2001 and March 2004. Data were collected risk factors for disease, extent of coronary disease, and in-hospital outcomes. Postoperative graft patiency was evaluated in 9 patients by multi-slice computed tomography. Result: Eleven patients had triple vessel disease or left main disease. Four patients were suffered from preoperative CVA, and 4 patients had chronic obstructive pulmonary disease. Two patients had myocardial infarction (MI), among them 1 patient was suffered from pulmonary edema after preoperative MI. There was no perioperative death, perioperative MI, and no ventricular arrhythmia. Also there was no perioperative stroke and renal failure. But there was one deep sternal infection who recovered by treating of muscle flap. Atrial fibrillation was newly developed in 1 patient, but was well controlled by medication. Mean intubation time was $15.9\pm4.4(8\~20hrs)$ hrs and mean ICU stay was $2.9\pm0.8(2\~4 days)$ days. Mean hospital day was $21.6\pm14.3(13\~56 days)$ days. Postoperative mean CK-MS was $11.3\pm14.1\;ng/mL$. Early postoperative graft patency rate was $100\%(24/24)$. Follow-up was completed in all patients. In this time, there was no patients with angina or death. Conclusion: The results of this study suggest that OPCAB reduces morbidity and favors hospital outcomes. Therefore, OPCAB is safe, reasonable and might be preferable operative strategy in elderly patients.

Middle and Long Term Results of 34 Cases of Emergency Coronary Artery Bypass Graft Surgery (응급 관상동맥 우회술 34예의 중장기 성적)

  • 손정환;김응중;지현근;신윤철;김건일;최광민;이원진;이원용
    • Journal of Chest Surgery
    • /
    • v.36 no.10
    • /
    • pp.741-747
    • /
    • 2003
  • Background: Coronary artery bypass graf t (CABG) has been settled as most safe surgery among the open heart surgeries. However, in patients with cardiogenic shock, the emergency CABG has higher mortality than elective CABG. We analyzed thirty four patients who underwent emergency CABG and report the middle and long-term results. Material and Method: From June 1994 to December 2001, 34 patients who underwent emergency CABG at Kang-dong Sacred Heart Hospital were include in this study. On the basis of hospital databases and Out Patient Department (OPD) follow up data, preoperative diagnosis, risk factor, coronary artery anatomy, operation technique, postoperative mortality, complication, recurrence of symptom, and mid and long term mortality were analyzed retrospectively. Result: Indications for emergency CABG were 29 cardiogenic shocks (85.3%), 4 intractable chest pains (11.8%), and 1 polymorphic ventricular tachycardia (2.9%). Preoperative angiographic diagnoses were triple vessel disease in 16 (47.1%) and left main disease in 8 (23.5%) patients. We used saphenous vein grafts in 81 and left internal thoracic artery grafts in 14 anastomosis. The mean number of grafts per patients was 2.8$\pm$0.8. The mean aortic cross clamp time was 91.9$\pm$34.6 minutes and the mean cardiopulmonary bypass time was 262.7$\pm$198.3 minutes. Early mortality was 50% and the most common cause of early mortality was low cardiac output in 7 (20.6%) patients. The mean follow-up period was 30.9$\pm$35.7 months. There were no recurrences of symptom and late mortality. Conclusion: In the case of emergency operation, aggressive and proper management with drugs and IABP should be done for preoperative hemodynamic stability and early surgical intervention is the most important factor for patient salvage.

The study of Tang Zong Hai's Medica-change thought (당종해(唐宗海)의 의역사상(醫易思想)에 관(關)한 연구(硏究))

  • Kim, Gi-Uk;Park, Hyeon-Guk
    • Journal of Korean Medical classics
    • /
    • v.12 no.2
    • /
    • pp.56-71
    • /
    • 1999
  • 1. In the recohnition of cosmos true form, It is compared to the Boundless(無極) the Great Absolute(太極),Yin and Yang(兩儀) throungh the fertilazation process of spermatozoon and ovum. 2. It is explained that principle of unchange through the Form and Action(體 用) relation of the outer appearances and Number (象數) with matching the number of nine and ten to HaDoo(河圖) and RakSye(洛書). 3. Eigth divinations(八卦) being compared to the human body, Care presevation of pregnancy(養胎) is explained that head forms firstly(Gun-I 1乾一), secondly lung(Tae-E 兌二), heart(E-Sam 離三), liver(Jin-Sa 震四), gall bladder(Son-Oo 巽五), kidney(Gam-Yuk 坎六), intestines and stomach(Gan-Chill 艮七), lastly flesh forms(Gon-Pal 坤八). 4. It is explained that process of physiological change of $\ll$Nei Ching The Natural Truth in Ancient Times$\gg$(內經 上古天眞論) by matching boy at the age of 8 to Gan-divination(艮卦), and girl at the age of 7 to Tae-divination(兌卦). 5. The theory of six sons from Gun-Gon(乾坤六子論) is explained by relation of Apriority Eight-divination(先天八卦) obedience and disobedience-left and right. 6. It is explained that form of the human-body and the relationship of the Heart - the Kidney through the Gam(坎) Li(離) - divination 7. The effort of interpretating time and space of the Twelve Horary signs is explanined by season, direction, Five elements(五行), rise and decline, the Three Sum(三合), the Six Sum (六合), the six crash(六衡)'s relation. 8. the process of change from apriority(先天) to postery(後天) in the book of Changes(周易) is explanined by comparing to the phenomenum of nature and the human body. 9. The Energy Satus(氣位) are different from the direction of Eight-divination(八卦) and the properties of the good or bad of herb-drugs are differnt from the place of production. 10. The rightness of realizating the Overlapping-divinations(重卦) are compared to the phenomenum of nature through the Divination Virture(卦德). 11. The dependence-relations of The Twelve Meridians(十二經脈) are explained by-matching January with liver meridian, February with gall bladder meridian, march with heart pericardium meridiam, April with small intestine meridkan, August with lung spleen meridian, jury with stomach meridian, August with lung meridian, September with large intestine meridian, October with urinary bladder meridianm November with kidney meridian. December with triple energizer meridian throng The Twelve Byuk-divination. 12. The process of menstration cycle is explained by The Month symbolizing-divination(月候卦). 13. Through The Trade(交易) prove the reason of feverish sympotoms to use feverish Drug, mill sympotoms to use mill drug of prescription and Heart-Kidneys Consensus(心賢相交) and through The Change(變易), prove the chill and feverish consensus of forechill after feverish, fore feverish after chill and through. The Non-Change(不易) explain the reason of chill sympotoms to use feverish drug, feverish sympotoms to use chill drug of prscription. 14. Ho-divination(互卦) applicate Jxa Sa(佐使) herb drug match of Kun Sin Jwa Sa() theory. 15. According to the Hyo-position(爻位) match the ages, body form and drug by matching Ehight-divination(八卦) to the human body form and function in medicine and the book of Changes(周易) application emphasize the human body Ehight-divination(人身八卦). 16. Throgh the Order-divination(序卦) explain the rightness of Divination Image(卦象) arrangement and all things take shape by cosmo-energy conseusus(宇宙氣交). 17. Throgh the Mixing-divination(難卦) supply the vacancy of medicine and the book of Changes(周易) relationship in the foreword explian the human energy movements, sleep, vomitting, the energy arrival(逮氣), heart pericardium(心包), lung membrane(肺膜) etc.... Like the above sentence medicine and the book of Changes(周易) theory of scholar Tang on the viewpoint of easten-the way Western appliance(東道西器) researching abyss of medicine impart to descendants, so I think that the achievement of medicine and the book of Changes(周易) study is very excellant and I expect that the study Korean Oriental Medicine(韓醫學) theory by means of medicine the book of Changes(周易) reference, will be accelarated.

  • PDF

Mushroom growth and cultivation environment at cultivation house of vinyl bag cultivation Shiitake mushroom on high-temperature period (고온기 표고 톱밥재배용 재배사 내의 환경 제어시스템과 버섯생육 온도)

  • Jhune, Chang-Sung;Kong, Won Sik;Park, Hye-Sung;Cho, Jae-Han;Lee, Kang-Hyo
    • Journal of Mushroom
    • /
    • v.12 no.4
    • /
    • pp.263-269
    • /
    • 2014
  • Although sawdust cultivation of shiitake (Lentinula edodes) is becoming more common, it is insufficiently competitive in spring and autumn, the best time to breed shiitake. Thus, it is urgently needed to develop a technique for all year round cultivation of shiitake using mushroom growing beds. In the present study, the temperature changes according to the location of shiitake cultivation facilities were investigated. We confirmed that a refrigerator, an air conditioner, triple membranes, shiitake cultivation beds, fog nozzles which were installed in the shiitake cultivation facilities play an important role in keeping the low temperature. Bag cultivation of shiitake was tested in temperature variation from $14^{\circ}C$ to $29^{\circ}C$ with a $3^{\circ}C$ interval to know its cultivating temperature range in hot summer season. In summary, the sawdust cultivation of shiitake is possible when the temperature difference between top and bottom is maintained below $1^{\circ}C$. And the temperature of the shiitake cultivation facilities should be maintained below $23^{\circ}C$ in the induction period for fruitbody formation.

Effects of Phosphate and Potash Fertilizers on the Yield and Nicotine Content of Tobacco Leaves (인산(燐酸) 및 가리비료(加里肥料)가 엽연초(葉煙草)의 수량(收量) 및 니코틴의 함량(含量)에 미치는 영향(影響))

  • Cho, S.J.;Kim, J.J.;Bae, H.W.
    • Korean Journal of Soil Science and Fertilizer
    • /
    • v.2 no.1
    • /
    • pp.31-38
    • /
    • 1969
  • This experiment was carried out to determine the effect of different levels of phosphate and potash firtilizers applied on yields and quality of leaf tobacco. It was done at all varying levels of phosphate and potassium fertilizers $S_0$ (non-fertilizer plot);N:P:K=0:0:0 (Kg/10a) $S_1$ (1/2 amount plot);N:P:K=10:7.5:10 (Kg/10a) $S_2$ (standard plot);N:P:K=10:15:20 (Kg/10a) $S_3$ (1.5 times plot);N:P:K=10:22.5:30(Kg/10a) $S_4$ (2.0times plot);N:P:K==10:30:40 (Kg/10a) Urea was applied as nitrogen, triple superphosphate as phosphate, potassium sulfate as potash source. The total amount of fertilizers was applied as basal dressing per one plant. This experiment was carried out by using randomized block design with 3 replication. The results obtained in terms of yields and quality are summarized as follows. 1. By increasing the amounts of phosphate and potassium fertilizers, growing status of the largest leaf length, the largest leaf width and stem size of tobacco increased in the order of $S_4>S_3>S_2>S_1>S_0$. 2. By increasing the amount of phosphate and potassium fertilizers, yield was increased in the order of $S_4>S_3>S_2>S_1>S_0$, This increase showed generally high significance among various levels of treatments. 3. The regressive equation was derived from the relationship between treatment levels and tobacco leaf yield. The most desirable treatment level for the maximum yield was estimated as the 2.87 times as much as the treatment level of phosphate and potasium fertilizers of standard plot. 4. By increased application of phosphate and potash fertilizers, the contents of $P_2O_5$ and $K_2O$ in the tobacco leaf became greater while the content of nicotine was decreased. Thus, a negative correlation between fertilizer application and nicotine content has been observed.

  • PDF

Validation of a Rapid Quantitative Method for the Residues of Nitrofuran Metabolites in Loach by Accelerated Solvent Extraction and HPLC Triple Quadrupole Mass Spectrometry

  • Ryu, Eun Chae;Han, Yun-jeong;Park, Seong-soo;Lim, Chul-joo;Choi, Sunok;Park, Se Chang
    • Journal of Food Hygiene and Safety
    • /
    • v.31 no.2
    • /
    • pp.85-93
    • /
    • 2016
  • A rapid method using HPLC-MS/MS has been developed for quantitative determination of the metabolites of nitrofurans, namely 3-amino-2-oxazolidone (AOZ), 5-morpholinomethyl-3-amino-2-oxazolidinone (AMOZ), 1-ammino-hydantoin (AHD) and semicarbazide (SEM) in loach. The extraction procedure was founded on simultaneous acidic hydrolysis and derivatization using 2-nitrobenzaldehyde (2-NBA) for 1 hour at $50^{\circ}C$, followed by purification with liquid-liquid extraction. Recovery was evaluated by spiking standards into blank samples at three levels (0.5, 1.0 and $2.0{\mu}g/kg$), and the mean recovery was 75.1-108.1%. Precision values expressed as the relative standard deviation (%RSD) were ${\leq}8.7%$ and ${\leq}8.5%$ for intra-day and inter-day precision, respectively. Linearity was studied in the range of $0.2-20{\mu}g/Kg$ for NBAOZ, $0.8-20{\mu}g/Kg$ for NBAMOZ, $0.2-20{\mu}g/Kg$ for NBAHD, and $0.1-20{\mu}g/Kg$ for NBSEM, and the obtained coefficient correlations (r) were ${\geq}0.99$ for all compounds. Limits of detection (LODs) for the derivatized nitrofuran metabolites were established at $0.06{\mu}g/Kg$ for NBAOZ, $0.24{\mu}g/Kg$ for NBAMOZ, $0.06{\mu}g/Kg$ for NBAHD, and $0.03{\mu}g/Kg$ for NBSEM. Limits of quantification (LOQs) were established at $0.2{\mu}g/Kg$ for NBAOZ, $0.8{\mu}g/Kg$ for NBAMOZ, $0.2{\mu}g/Kg$ for NBAHD, and $0.1{\mu}g/Kg$ for NBSEM. This simplified rapid method for reducing the derivatization and hydrolysis times can be applied to the determination of nitro-furan residues in loach.

Ethyl acetate fraction from Pteridium aquilinum ameliorates cognitive impairment in high-fat diet-induced diabetic mice (고지방 식이로 유도된 실험동물의 당뇨성 인지기능 장애에 대한 고사리 아세트산에틸 분획물의 개선효과)

  • Kwon, Bong Seok;Guo, Tian Jiao;Park, Seon Kyeong;Kim, Jong Min;Kang, Jin Yong;Park, Sang Hyun;Kang, Jeong Eun;Lee, Chang Jun;Lee, Uk;Heo, Ho Jin
    • Korean Journal of Food Science and Technology
    • /
    • v.49 no.6
    • /
    • pp.649-658
    • /
    • 2017
  • The potential of the ethyl acetate fraction from Pteridium aquilinum (EFPA) to improve the cognitive function in high-fat diet (HFD)-induced diabetic mice was investigated. EFPA-treatment resulted in a significant improvement in the spatial, learning, and memory abilities compared to the HFD group in behavioral tests, including the Y-maze, passive avoidance, and Morris water maze. The diabetic symptoms of the EFPA-treated groups, such as fasting glucose and glucose tolerance, were alleviated. The administration of EFPA reduced the acetylcholinesterase (AChE) activity and malondialdehyde (MDA) content in mice brains, but increased the acetylcholine (ACh) and superoxide dismutase (SOD) levels. Finally, kaempferol-3-o-glucoside, a major physiological component of EFPA, was identified by using high-performance liquid chromatography coupled with a hybrid triple quadrupole-linear ion trap mass spectrometer (QTRAP LC-MS/MS).

Effect of Glucose Control, SDSCA and Quality of Life of D-chiro-inositol(DCI) in patients with type 2 diabetes: A Path Analysis (제2형 당뇨병 환자의 D-chiro-inositol의 혈당강하 효과와 당뇨 자가관리 및 삶의 질: 경로분석)

  • Kang, Young Mi;Kim, Hyun Jin;Lee, Tae-Yong;Ku, Bon-Jeong
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.19 no.10
    • /
    • pp.243-253
    • /
    • 2018
  • This study aimed to investigate the effects of DCI on glucose control, quality of life(SF-36 Version 2.0, Korean) and SDSCA(Summary of Diabetes Self-Care Activities) in patients with type 2 diabetes mellitus. A randomized, double-blind, placebo-controlled study was performed on 46 patients with HbA1c 7.0% taking triple anti-diabetic drug regimen who visited the department of Endocrinology and Metabolism in Chungnam National University Hospital between March 2015 and May 2016. As a result, DCI treatment in the intervention group resulted in significantly reduced HbA1c levels $8.75{\pm}0.79%$(baseline), $8.36{\pm}1.03%$(after 12weeks), and $8.65{\pm}0.81%$(after 24weeks). However, patients in the control group did not show any significant change. Interestingly, both DCI treatment group and the control group significantly showed improvements in SDSCA. Participants in the intervention group showed a small yet significant improvement in their only fasting blood glucose test in SDSCA and revealed significant increase in the quantitative levels of quality of life, from $73.05{\pm}16.85$ to $82.74{\pm}10.68$. By using pathway analysis, improvement of SDSCA scores(${\beta}=-0.505$, t=-2.743) was the most influential factor to the fasting blood glucose. The quality of life of patients with type 2 diabetes mellitus was affected by changes of SDSCA scores(${\beta}=0.411$, t=2.024) and fasting c-peptide(${\beta}=-0.445$, t=-2.668) in DCI treatment group. In conclusion, treatment of DCI effectively improved glucose control in patients with type 2 DM(HbA1c level>7.0%) after 12 weeks of treatment, although it had no impact on glucose control after 24 weeks of treatment. Improved glucose control may encourage diabetic patients to conduct self-care activities and improve the quality of life. Based on the present study, we suggest that diabetes self-management, as well as consideration of comprehensive laboratory findings, may be important factor in regulating the quality of life in type 2 DM patients.

Effects of Sodium Sulfite and Extrusion on the Nutritional Value of Soybean Products for Nursery Pigs

  • Burnham, L.L.;Kim, I.H.;Kang, J.O.;Rhee, H.W.;Hancock, J.D.
    • Asian-Australasian Journal of Animal Sciences
    • /
    • v.13 no.11
    • /
    • pp.1584-1592
    • /
    • 2000
  • Three hundred nursery pigs were used in two growth assays (avg initial BW of 6.5 and 6.0 kg, respectively) to determine the effects of sodium sulfite ($Na_2SO_3$) as an extrusion aid for soy products used in diets for weanling pigs. In Exp. 1, treatments were arranged as $3{\times}2$ factorial with main effects of soy product [soybean meal (SBM), extruded SBM, and dry-extruded whole soybeans (DEWS)] and concentration of $Na_2SO_3$ (0 and 10 g/kg of soy product). The extruded SBM and DEWS treatments were processed in a dry extruder ($Insta-Pro^{(R)} $, Triple F Nutrition, Des Moines, IA) with barrel temperatures and throughputs of $169^{\circ}C$ and 578 kg/h, and $147^{\circ}C$ and 598 kg/h, respectively. All diets were formulated to 3.5 Mcal/kg DE, with 0.92% lysine for d 0 to 14, and 0.76% lysine for d 14 to 28. For d 0 to 14, there was a tendency for pigs fed diets with $Na_2SO_3$ to have greater ADG (p<0.08), and pigs fed SBM to have greater ADFI (p<0.02), thus pigs fed the extruded soy products has 15% greater gain/feed than those fed SBM (p<0.007). For d 14 to 28, there were no differences in ADG or gain/feed among pigs fed diets with SBM and those fed diets with the extruded soy products (p>0.15). However, pigs fed DEWS had greater ADG than pigs fed extruded SBM, and pigs fed $Na_2SO_3$ had greater ADG and ADFI compared to those not fed $Na_2SO_3$ (p<0.02 and 0.08, respectively). The positive response in ADG and gain/feed to the addition of $Na_2SO_3$ resulted with SBM and extruded SBM treatments, and not with DEWS (interaction effect, p<0.04). Overall (d 0 to 28), pigs fed DEWS had greater ADG (p<0.01) and gain/feed (p<0.08) than pigs fed extruded SBM. Also pigs fed diets with $Na_2SO_3$ had greater ADG, ADFI, and gain/feed compared to those fed diets without $Na_2SO_3$ (p<0.002, 0.04, and 0.04, respectively). Exp. 2 was designed as a $2{\times}3$ factorial with main effects of soy product (SBM and DEWS) and concentration of $Na_2SO_3$ (none, 7.5, and 15.0 g/kg of soy product). As in Exp. 1, all diets were formulated to 3.5 Mcal/kg DE, with 0.92% lysine for d 0 to 13, and 0.76% lysine for d 13 to 53. At a constant processing temperature (148 to $149^{\circ}C$, $Na_2SO_3$ increased throughput of the extruder (578, 595, and 602 kg/h for the 0, 7.5, and 15.0 g/kg additions, respectively). For d 0 to 13, treatment had no effect on ADG or ADFI, but gain/feed decreased for pigs fed SBM with increasing concentrations of $Na_2SO_3$, and increased for pigs fed DEWS with increasing concentrations of $Na_2SO_3$ (SBM vs DEWS sulfite quadratic interaction, p<0.03). For d 13 to 35, pigs fed DEWS had greater ADG (p<0.01) and gain/feed (p<0.001) than pigs fed SBM. Also, ADFI decreased and gain/feed increased with increasing concentrations of $Na_2SO_3$ (linear effects, p<0.04 and 0.01, respectively). Overall, pigs fed the diets with DEWS had greater ADG and gain/feed than pigs fed SBM (p<0.003 and 0.002, respectively), and $Na_2SO_3$ tended to decrease ADFI and increase gain/feed (linear effects, p<0.07 and 0.06, respectively). In conclusion, pigs fed DEWS had greater rate and efficiency of gain than pigs fed SBM. Also, adding $Na_2SO_3$ prior to extrusion increased yield and feed efficiency.

Automated-Database Tuning System With Knowledge-based Reasoning Engine (지식 기반 추론 엔진을 이용한 자동화된 데이터베이스 튜닝 시스템)

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

  • PDF