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

신성호(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.

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

윤수영,박원녕,정성필,김승호,이한식 대한응급의학회 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.

인장력을 받는 CT형강 고력볼트 접합부의 감소계수 U값에 관한 연구

윤성호,김진숙,김원식,신영록,김보영,최문식 대한건축학회 2003 대한건축학회 학술발표대회 논문집 - 계획계/구조계 Vol.23 No.2(구조계)

The purpose of this experimental study is to investigate the validity of code equation and table to calculate the reduction coefficient for effective net area in the limit state design code of steel structure and offer the basic research data for the effective net area of tee shape members in tension. The experimental tests were performed by loading the specimens through the flange with high strength bolt. Length of connection, number of bolt and the eccentricity are the parameters in test. According to result, the failure loads in test is less than predicted loads and it well showed when the predicted loads are based on reduction coefficient of the table in code. The lateral buckling of stem occurred in the members with big eccentricity and it reduce the failure loads. Therefore, we thought that an additional tests and research on the factors of effective net area is required.

기능성 소화불량증 환자에 대한 반하사심탕 엑기스제의 임상효과

윤상협,류봉하,류기원,김진성 WHO COLLABORATING CENTRE FOR TRADITIONAL MEDICINE 2003 東西醫學硏究所 論文集 Vol.2003 No.-

Objective : We evaluated the therapeutic effect of Banwhasasimtang dry extract powder on gastrointestinal symptoms and its side effects in patients with functional dyspepsia. Methods : Patients with functional dyspepsia, defined as discomfort in the epigastrium. A total 45 patients participated participated in this study. Dyspeptic symptoms ratio was obtained by patients, total point of symptom score / total 21 points x 100(%). On each of symptom after 4 weeks administration of Banwhasashim-tang was made by variation of symptom score: If symptoms score of posttreatment is lower than that of pretreatment, It is improved ; Otherwise aggravated, and if there is no change between them, unchangeable. When a full health condition of normal control is assumed 100%, relative health condition of dyspeptic patient could be calculated from 'full health condition- dyspeptic symptoms ratio. Therefore a whole satisfaction rate on symptom improvement was presented with variation of a relative health condition to dyspepsia between pretreatment and post. Results : Banwhasashimtang significantly unproved symptoms in patients. The significance was shown in both all seven items(p< 0.01, respectively) and 19.2% (p<0.01) of increase of a whole symptom improvement. There is no remarkable side-effect in all laboratory test, excepting 1 case abdominal pain another one case of recurred pain of chronic prostatitis. Conclusion : Banwhasashimtang extract provides symptomatic relief in functional dyspepsia and is no remarkable side-effect drug.

충북 남부지역 중소 제조기업의 경쟁력 제고를 위한 경영 및 애로기술 실태조사 연구

윤상원,구경완,정성진,백기영,김선훈,서용성,이근복 호서대학교 반도체제조장비국산화연구센터 2001 반도체장비학술심포지움 Vol.2001 No.-

본 연구에서는 충북 남부 3개군 지역(옥천 · 보은 · 영동)의 중소 제조기업의 경영실태 및 애로기술을 대상으로 실증조사 되었다.·지역의 특정상황의 전제하에 지방 중소기업들의 실질적인 문제점들을 발견하고, 그 개선 방안을 탐색함은 물론 산 · 학 · 연 컨소시엄 사업의 성공적인 수행을 위해 시도되었다.세부적으로는 중소 제조기업의 경영 및 애로기술 특성을 일반적 사항, 경영애로요인, 경영전략, 현장개선기법, 정보화, 제품 및 공정 기술상의 애로기술 현황파악의 6개 영역으로 조사되었다. 조사결과들은 추후 산 · 학 · 연 공동기술개발 사업에 있어 창의적, 틈새적 과제발굴 및 신제품 기술개발의 토대마련이 될 뿐 아니라, 지역경제 발전을 위한 산 · 학 관의 지원 전략 수립에 적극 활용 될 것으로 판단된다.

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

윤상원,서용성,홍순욱 永同工科大學校 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.

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

윤상화,강문원 용인대학교 국제스포츠과학연구원 체육과학연구소 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.