과학기술정보콘텐츠 통합관리시스템 구축을 위한 데이터 마이그레이션 모델 수립 및 적용 사례

신성호(Sung-Ho Shin),이민호(Min-Ho Lee),이원구(Won-Goo Lee),윤화묵(Hwa-Mook Yoon),성원경(Won-Kyung Sung),김광영(Kwang-Young Kim) 한국컴퓨터정보학회 2011 韓國컴퓨터情報學會論文誌 Vol.16 No.11

국내 데이터베이스 구축 시장은 작년 기준으로 3조 6,633억원 규모로 추정된다. 데이터베이스 산업의 지속적인 성장과 맞물려, 데이터 마이그레이션의 중요성도 날로 높아지고 있다. 고객 위치를 찾아주는 g-CRM이나 고객에게 상품을 추천하는 맞춤 설계 기능 등은 모두 고객 데이터베이스, 상품 데이터베이스, 지리정보 데이터베이스 등이 결합되어야 구현 가능한 서비스들이다. 스마트 비즈니스의 핵심 인프라도 통합되고 완전하며 신뢰할 수 있는 데이터베이스라고 할 수 있다. 이러한 데이터베이스의 중요성에도 불구하고, 데이터 마이그레이션 및 통합 과정의 효율적인 수행 방안이나 데이터 검증 방법에 대하여는 구체적인 연구가 부족한 실정이다. 본 연구에서는 다양한 타입으로 존재하는 과학기술분야 콘텐츠들을 대상으로 데이터 마이그레이션을 위한 모델을 설계하였고, 모델을 기반으로 실제 데이터 마이그레이션 작업을 수행한 결과를 제시하였다. 아울러 데이터 마이그레이션 결과에 대한 검증을 위해 데이터베이스의 완전성, 데이터값의 일관성, 관계의 일관성을 검증하였고, ANSI/ASQ Z1.4-2003에서 제시된 샘플링 검사 기법도 적용하였다. 결과적으로 모델 수립에 의한 체계적인 데이터 마이그레이션 수행은 데이터베이스 정합성 및 데이터값의 정확성에 영향을 미치고, 고품질의 데이터베이스를 유지하기 위한 필수 요소라 할 수 있다. The domestic market of database in Korea is estimated to be over 3.663 trillion won. The data migration is getting to be more important along with the continuous growth of the database industry. g-CRM and private recommending function are examples of the service that can be given through coupling among customer database, product database, geographic information database, and others. The core infrastructure is also the database which is integrated, perfect, and reliable. There are not enough researches on efficient way of data migration and integrating process and investigation of migrated data though trends of database in IT environment as above. In connection with this issue, we have made a model for data migration on scientific and technological contents and suggest the result of data migration process adapting that model. In addition, we verified migration's exhaustiveness, migration's consistency, and migration's coherence for investigation of migrated data and database. From the result, we conclude data migration based on proper model has a significant influence on the database consistency and the data values correctness and is essential to maintain high qualified database.

통풍형 방음벽 개발 및 적용에 관한 연구

윤제원(Je-Won Yoon),김영찬(Young-Chan Kim),김금모(Keum-Mo Kim),장강석(Kang-Seok Jang),구본성(Bon-Sung Ku),엄주용(Joo-Yong Eom) 한국소음진동공학회 2011 한국소음진동공학회 학술대회논문집 Vol.2011 No.10

The purpose of this study is to develop an air-passing soundproofing panel with more improved structure to reduce the CO2 emission and installation cost. To reduce the emission of CO2 ; it is suggested to choose low CO2 emission material relative to the aluminum and to reduce the materials by developing a specially designed air-passing soundproofing panel structure. First of all, we performed the flow analysis to predict the wind pressure according to the open angle of the air-passing soundproofing panel and the noise level analysis at the receiver point. To verify the simulation, a prototype of the soundproofing panel was made. The flow test in the wind tunnel and load test were performed. The economic evaluation for the installation of the air-passing soundproofing panel was performed and specifications of the installation was prepared. As the results of this research, it was verified that the wind load was reduced about 40% to that of the conventional one at 25m/s wind speed in the wind tunnel test. By applying the 4m span soundproofing wall with air-passing soundproofing panel and under the cost of 250 thousand won/m2 instead of the conventional 2m span panel, the installation cost will always be lowered than the conventional one in the combination of (60:40~50:50) conventional to air-passing soundproofing panel from the economic evaluation. The 20% reduction of CO2 was found by changing the 50% of aluminum soundproof panel to air-passing soundproofing panel.

난소 및 난소 종양 염전의 초음파 소견

오연희,이현경,이원재,이성우,박수성,윤혜원,임문환,심재철,김용탁,김성숙,김정란 동국대학교 경주대학 1993 東國論集 Vol.12 No.-

Acute torsion of the ovary and ovarian mass is a recognized surgical emergency, but rarely has the diagnosis been made preoperatively on the basis of imaging studies. The sonographic findings in 14 cases of surgically proven torsion of the ovary and ovarian mass are described. Mostly cystic ovarian mass, engorged vessel, dilated uterine tube, beak-like echo(torsion site), smooth mass wall thickening an free-fluid collection in cul-de-sac are described. More significant in terms of specificity were the demonstration in 6 cases(42.9%) of the smooth mass wall thickening and in 8 cases(57.1%) of a free fluid in the cul-de-sac. We report the sonographic findings of ovary and ovarian mass torsion that may suggest the preoperative diagnosis of this condition.

정신분열병에 대한 리스페리돈의 효과 및 안정성

이민수,김용구,김영훈,연병길,오병훈,윤도준,윤진상,이철,정희연,강병조,김광수,김동언,김명정,김상훈,김희철,나철,노승호,민경준,박기창,박두병,백기청,백인호,손봉기,손진욱,양병환,양창국,우행원,이정호,이종범,이홍식,임기영,전태연,정영조,정영철,정인과,정인원,지익성,채정호,한상익,한선호,한진희,서광윤 大韓神經精神醫學會 1998 신경정신의학 Vol.37 No.1

연구목적 : 본 시험의 목적은 임상시험 시작전에 연구자들을 대상으로 PANSS Workshop을 통하여 PANSS, ESRS에 대한 국내에서의 표준화 작업을 구축하고 새로운 정신병 치료제인 리스페리돈의 효과와 안정성을 재확인하여 리스페리돈 사용에 대한 적정화를 이루는데 있다. 연구방법 : 1996년 4월부터 1996년 9월까지 국내 39개 대학병원 정신과에 입원중인 혹은 증상이 악화되어 입원하는 정신분열병 환자 377명을 대상으로 다시설 개방 연구를 시행하였다. 1주일간의 약물 배설기간을 가진후, 리스페리돈을 8주간 투여하였고, 기준점, 1주, 2주, 4주, 그리고 8주후에 평가되었다. 용량은 제1일에는 리스페리돈 1mg씩 1일 2회, 제2일에는 2mg씩 1일 2회, 제3∼7일에는 3mg씩 1일 2회 투여하였다. 이후 환자의 임상상태에 따라 임의로 증량할 수 있으며, 최대 일일 16mg을 초과하지 않도록 하였다. 추체외로 증상을 조절하기 위한 투약을 허용하였다. 임상증상 및 부작용의 평가는 PANSS(Positive and Negative Syndrome Scale), CGI(Clinical Global Impression) 그리고 ESRS(Extrapyramidal Symptom Rating Scale)을 사용하였다. 연구결과 : 377명중 343명(91%)이 8주간의 연구를 완결하였다. 치료 종결시점인 8주후 PANSS 총점수가 20% 이상 호전된 경우를 약물 반응군으로 정의할때, 약물반응군은 81.3%였다. 리스페리돈에 반응하는 예측인자로는 발병연령, 이전의 입원 횟수, 유병기간이 관련 있었다. 리스페리돈은 1주후부터 PANSS양성, 음성, 및 일반정신병리 점수상에 유의한 호전을 보여 효과가 빨랐다. CGI의 경우도 기준점에 비해 1주후부터 유의한 감소를 나타내었다. ESRS의 경우, 파킨슨 평가점수는 기준점과 비교해 투여 1주, 2주, 4주후 유의하게 증가되었다가 8주후 기준점과 차이가 없었다. Dystonia 평가점수는 1주후만 유의한 증가를 보였으며, dyskinesia 평가점수는 유의한 차이가 없었다. 혈압, 맥박수의 생명징후 및 일반 혈액학 검사, 생화학적 검사, 심전도 검사에서 유의한 변화는 없었다. 결 론 : 이상의 다시설 개방 임상 연구를 통해 리스페리돈은 정신분열병 환자에서 양성증상뿐만 아니라 음성증상 및 전반적인 증상에도 효과적인 것으로 사료된다. 보다 명확한 평가를 위해서는 다른 항정신병약물과의 이중맹검 연구가 필요할 것으로 생각되며, 또한 장기적 치료에 대한 평가도 함께 이루어져야 하겠다. Objective : The purpose of this study was to investigate the efficacy and safety of risperidone in the treatment of Korean schizophrenic patients. Method : This multicenter open study included 377 schizophrenic patients drawn from 39 university hospitals. After a wash-out period of 1 week, the schizophrenic patients were treated with risperidone for 8 weeks and evaluated at 5 points ; at baseline, and 1, 2, 4 and 8 weeks of treatment. The dose was increased from 2mg/day(1mg twice daily) to 6mg/day(3mg twice daily) during the first week and adjusted to a maximum of 16mg/day over the next 7 weeks according to the patient's clinical response. Medication to control extrapyramidal symptoms was permitted. The psychiatric and neurological status of the patients was assessed by PANSS, CGI, and ESRS scales. Results : 343(91%) of 377 patients completed the 8-week trial period. Clinical improvement, as defined by a 20% or more reduction in total PANSS score at end point, was shown by 81.3% of patients. The predictors of response to risperidone were associated older age, shorter duration of illness, fewer previous hospitalization. Risperidone had rapid onset of action ; a significant decrease of the total PANSS and three PANSS factor(positive, negative, general), and CGI was already noticed at the end of first week. For the ESRS, parkinsonism rating scores were significantly increased until week 4 comparing with baseline. Dystonia rating scores were significantly increased until week 1, and dyskinesia rating scores were not significantly changed during the study. Laboratory parameters including vital sign, EKG, hematological, and biochemical values showed no significant changes during the trial. Conclusions : This study suggests that risperidone is generally safe and effective against both the positive and negative symptoms in our group of patients.

건선 병변부 및 병변주위부 피부의 Cytokines 유전자 발현

윤기성,김도원,정상립,김문규,김정철 경북대학교 병원 1997 경북대학교병원의학연구소논문집 Vol.1 No.1

It has been proposed that cytokines may be involved in mediating the characteristic pathological changes in psoriasis, including epidermal hyperplasia, compromised keratinocyte differentiation, and dermal and epidermal infiltration by polymorphonuclear leukocytes and mononuclear cells. The purpose of this study os to assess the pattern of cytokine gene expression in psoriatic skin lesion. To investigate the cytokine expression pattern, we examined the transcripts of cytokine genes using reverse transcription and polymerase chain reaction (RT-PCR) method with 13 cytokine-specific primers. The Results were as follow; 1. Only the TGF-β gene was expressed in the normal skin. 2. IL-1α, IL-1β, IL-8, and TGF-β were detected in both lesional and perilesional psoriatic skin. The lesions showed more prominent expression. 3. IL-10 and GM-CSF were weakly detectable in three lesional psoriatic skin respectively, and IL-2R in two lesional psoriatic skin. 4. IL-2,IL-4,IL-5,IL-6 TNF-α, IFN-γ were not detectable on both lesional and perilesional psoriatic skin. Therefore, distinct differences in the cytokines gene expression were noted between normal and psoriatic skin. The patterns of cytokines gene expression in perilesional skin were similiar to those of lesional psoriatic skin.

한국인의 급성 골수성 백혈병 및 골수 이형성 증후군과 HLA 연관성

윤정숙,김원일,한경자,김용구,임지향,민우성,김춘추 대한조혈모세포이식학회 2000 대한조혈모세포이식학회지 Vol.5 No.1

배경:주조직 적합항원 복합체(Major Histocompatibility Complex : MHC)는 쥐에서 처음 이식 항원으로 발견된 이래 이식 면역 분야에서 광범위하게 연구되어 왔으며, 면역 반응을 조절하는 주요 유전자로서 감염, 종양, 자가면역 질환 등의 발생에 관여한다. 사람에서 자가 면역 질환과 HLA 연관성이 증명되어 있으나, 백혈병에서 HLA 연관성에 관한 연구는 드물며 대상군 수가 유의한 결론을 얻기에 부족하다. 본 연구에서는 급성 골수성 백혈병(AML)과 골수 이형성 증후군(MDS) 환자를 대상으로 HLA class I, II 항원 및 2-유전자좌 일배체형 빈도를 구하고, 이를 정상 대조군과 비교하는 통계적 방법으로 AML 및 MDS군과 연관된 HLA 항원 및 일배체형이 있는지 살펴보고, AML군은 FAB 분류와 면역 표현형 분류에 따른 아군으로 분류하여 각 아군과 연관된 HLA 항원 및 일배체형을 관찰함으로써 AML 및 MDS군과 HLA의 연관성을 규명해 보고자 하였다. 방법:1991년 1월부터 1998년 7월까지 성모병원에 내원하여 NIH standard microlymphocytotoxicity를 이용한 혈청학적 방법으로 HLA class I, II 항원 형별 검사를 실시한 415례의 AML과 62례의 MDS 환자를 대상으로 하여 각 질환군과 FAB, 면역 표현형 아군에서 HLA 항원 빈도와 유전자 빈도를 구하고, 항원 빈도를 대조군과 비교하여 Haldane’s method에 따라 상대 위험도(RR)를 구한 뒤 chi-square 법으로 유의성을 검증하였다. AML, MDS 각 질환군과 아군에서 square root법을 이용하여 HLA A-B, C-B, B-DR 2-유전자좌 일배체형 빈도를 구하고, 이를 대조군과 비교하여 chi-square 법으로 유의성을 검증하였다. 결과:1) Cw8이 AML, MDS 질환군에서 RR이 0.10, 0.22로 매우 감소하여 이들 질환과 강한 연관성 정도를 나타냈다(p<0.001). 2) Blank 유전자 빈도의 증가가 AML, MDS 질환군의 각 HLA locus에서 관찰되었으며, 특히 이 분석 결과는 DR locus에서 현저하여, AML과 MDS군에서 DR-blank 빈도는 11.6%, 7.0%로 매우 증가하였다. 3)AML군과 A2-B61, Cw8-B61, B62-DR11 일배체형 연관성과, MDS군과 Cw3-B51, B62-DR14, B35-DR9 일배체형 연관성이 관찰되었다. 4)FAB 분류별 아군에서 AML-M3와 A33 항원 연관성과 AML-M1과 A2-B51 일배체형 연관성이 높은 통계적 유의성을 나타내었다(p<0.001). 5) AML 면역 표현형 아군에서 HLA-A29, B56 항원과 panmyeloid 면역 표현형인 CD33, CD15와의 연관성이 관찰되었고, A2-B48, Cw7-B44 일배체형과 myeloid 면역 표현형인 CD34, CD33, CD11c와의 연관성이 관찰되었다. 결론:AML과 MDS는 HLA와 연관성 있는 질환이며, AML과 MDS군의 발생 및 AML군에서 백혈병 세포의 분화 단계를 예측하기 위해 본 연구 자료가 유용할 것으로 생각된다. Background:The Major Histocompatibility Complex (MHC) has been widely studied in the field of transplantation immunology, since initially defined as transplantation antigen in mouse in 1936. Although associations have been demonstrated between many autoimmune diseases and HLA in human, the studies of HLA association with human leukemia are rare, and have too small sample size to get a significant result. We tried to invesgate the association of AML and MDS with HLA, and the association of FAB, immunological subgroup with HLA in AML group by using appropriate statistical methods. The purpose of this study is to elucidate the HLA role in the development of AML and MDS, and find any HLA antigens or haplotypes which can predict the development of AML or MDS. Methods: The subject of this study was 415 patients with AML and 62 patients with MDS who admitted in St. Mary's hospital between 1991. 1. and 1998. 7., and were typed for HLA class I, II antigens by using serological method of NIH standard microlymphocytotoxicity. We calculated the HLA antigen, gene and 2-locus haplotype frequencies in AML and MDS group and FAB, immunological subgroup, calculated relative risk by Haldane's method by comparing HLA antigen frequencies in disease group with those in normal control population. The Chi-Square method or Fisher's exact test was used to assess the significance of the differencies in the antigen and haplogtype distributions in the control vs disease population. Results: 1)The frequencies of Cw8 were severely decreased in AML and MDS population with relative risk of 0.10, 0.22, and revealed high statistical significance with p-values less than 0.001, suggesting strong Cw8 association with AML and MDS. This means Cw8 may be a gene which resists to the development of AML and MDS, or may be linked to other recessive gene, Cw8 may be a gene which encodes increased immune responses to exogenous antigens such as leukemia virus, or may be linked to other immune response gene, otherwise, Cw8 may be an antigen which has a key role in immune surveillance to the development of AML or MDS. 2) Blank gene frequencies were increased in AML and MDS group, and this phenomenon was prominent in DR locus, showing 11.6% and 7.0% of DR-blank gene frequencies in AML and MDS. This suggests increased HLA homozygosity or increased undetected antigens due to loss or modification of HLA alleles in AML and MDS. 3) The associations of A2-B61, Cw8-B61, B62-DR11 haplotypes with AML, and A30-B14, Cw3-B51, B62-DR14, B35-DR9 haplotypes with MDS were observed. 4) According to FAB classification in AML, highly significant HLA-A33 antigen association with AML-M3 and A2-B51 haplotype association with AML-M1 were observed. 5) According to immunological classification in AML, HLA-A29, B56 each antigen association with CD33, CD15, panmyeloid immunophenotypes and A2-B48, Cw7-B44 each haplotype association with CD34, CD33, CD11c, myeloid immunophenotypes were observed. Conclusion:AML and MDS is a disease associated with HLA, and this study will be valuable in predicting the development of AML and MDS, differentiation stages of leukemic cells in AML.

태권도 지도자의 지도유형과 스포츠 우리성과의 관계

윤상화,강문원 용인대학교 국제스포츠과학연구원 체육과학연구소 2008 體育科學硏究論叢 Vol.18 No.1

This study set out to analyze the general leadership type of Taekwondo instructors and to investigate the relations between their leadership type and sports weness. The population was the elementary(fourth graders or higher graders), middle, and high school students attending the Taekwondo gyms registered in Gyeonngi Province in 2007. The proportionate stratified sampling was applied, and total 449 were chosen, who were asked to fill out a questionnaire. The questionnaire consisted of the items regarding the characteristics of Taekwondo practice, criteria of leadership types, and sports weness. The statistics techniques used to analyze the data included reliability analysis, frequency analysis, independent samples t-test, one-way ANOVA, correlation analysis, and multiple regression analysis. The research design and data treatment results were reflected in the data interpretation and led to the following findings: First, the individual characteristics of the Taekwondo students were investigated. As a result, the autocratic leadership was most perceived by the high school students, who were followed by middle and elementary school students. Those who practiced Taekwondo more than one year and obtained the Class 1 or higher perceived the positive leadership most, which was followed by training instruction, social, democratic, and autocratic leadership. Meanwhile, those who practiced Taekwondo less than one year and obtained the Class(Dan) 1 or lower perceived the training instruction style most, which was followed by the positive, democratic, social, and autocratic style. That is, there were differences of the students' perception of the instructors' leadership according to their individual characteristics. Second, there were no significant differences in their sports weness according to the practice period and class but there were significant differences according to school. The students' individual characteristics led to the partial differences in sports weness. Third, the relations between the leadership type and sports weness were examined. As a result, there were significant differences among the democratic, social and positive style of the five subfactors of leadership type in terms of life, which implied the partial influences on sports weness. There were significant differences in all the subfactors in terms of practice, which was translated into the positive impacts on sports weness.

뇌파조절을 통한 학습능력 향상의 실증분석연구

윤상원,서용성,홍순욱 永同工科大學校 1996 硏究論叢 Vol.2 No.1

효율적인 STC수행의 기반 연구가 될 수 있는 학습방법론으로서, 뇌파조절이 가해지는 환경하에서 학습효율 향상의 변화정도를 정성적 및 정량적 실험을 실시하였다. 그 결과를 바탕으로 뇌파조절이 학생들의 학습능력에 어느정도 영향을 미치는가에 대해 통계적분석 방법으로 검증하여, 새로운 학습방번론을 모색하고자 한다. 실험분석결과 뇌파조절을 이용한 학습방법은 각 개인의 심리적, 육체적 상태를 개선해 줄 뿐만아니라, 학습효율도 증진시킬 수 있음을 보여 주었으며, 이는 실제 학교수업에 적용가능성이 클 것으로 사료된다. Under the circumstances of brain wave control, qualitative experiments (English word tests, IE subject tests, brain wave measurnments, music effect analysis) and Quantitative experiments (psychological , physical , scholastic evaluation) are executed to examine the level of learning improvements, which are the basic study for special topices course. On the base of the results, we verify the effectiveness of such an educational method for low level students using statistcal analysis and explore a new learning methodolgy. Through this study, we find that learning method using the effects of brain wave control not only makes better the physical and the psychological state of each student, but also advances the learning effectiveness, which is considered to apply a practical teaching extensively.

고강도콘크리트를 사용한 RC 내진골조의 履歷特性實驗

윤정배,이상원,배흥한 慶尙大學校生産技術硏究所 1998 生産技術硏究所論文集 Vol.14 No.-

The interior beam-column joint behaviors in RC frames using high-strength concrete are investigated. Test parameters are flexual strength ratio, joint shear stress and compresive strength. The results from different strength show relatively diffrent with respect to shear stress level in the critical range. For the higher strength case, the design parameters are needed more precise investigations.

고칼륨혈증에서 심전도의 진단적 의의

윤수영,박원녕,정성필,김승호,이한식 대한응급의학회 2000 대한응급의학회지 Vol.11 No.3

Background: Hyperkalemia is a common and potentially life-threatening metabolic disorder. The electrocardiogram(ECG) is known to be a relatively sensitive diagnostic tool for hyperkalemia. However many exceptions, in which patients showed normal ECG findings even though hyperkalemic, have been reported. The purpose of this study was to determine the extent of correlation between the ECG findings and hyperkalemia and to determine when the ECG has value for diagnosing hyperkalemia. Methods: Patients who had been diagnosed as having hyperkalemia at two university hospitals during three years were enrolled in this study. We reviewed the medical records of the patients and evaluated the following 6 ECG abnormalities: tall T waves, narrow T waves, QRS widening, atrioventricular block, loss of P waves, and sine waves. We defined tall T waves and narrow T waves as 20 percentiles of heights and widths of the T waves from the 100 patients with normokalemia. Results: During the study period, there were 100 hyperkalemic patients, and we analyzed 69 available electrocardiograms. Abnormal ECG findings were revealed in 67%of 69 patients. The higher the serum potassium level, the more abnormal ECG findings. The common ECG abnormalities were tall T waves and loss of P waves. The patients with normal ECGs even though hyperkalemic had relatively low potassium levels. And whether chronic renal disease was not correlated to the ECG abnormality. Conclusion: The electrocardiogram is a good diagnostic tool for hyperkalemia if it is used with accurate diagnostic criteria. Thus, hyperkalemia should be considered when the ECG shows tall T waves or loss of P waves.