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

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

韓國産 나비의 吸蜜植物에 關한 硏究

申裕恒,李光源 慶熙大學校 1988 論文集 Vol.17 No.-

This research covered the survey on the nectar plants attracted by a total of 79 species of butterflies inhabited in South Korea including Mt. Soˇlak, Mt. Myoˇngii, Mt. Choˇnma, Kangchon, Kwangnuˇng, Namhansansoˇng, Is. Hong, Is. Ulluˇng, etc. for 6 years from 1983 through 1988. The results obtained were as follows: 1. A total of 48 classes of 105 species of nectar plants on which 79 species(41%) of butterflies fed among 193 species inhabited in South Korea were observed. 2. Of the nectar plants in which butterflies fed, the plants of Compositae were rated the highest at 14% of the nectar plants. The second were the plants of Rosaceae(13%), the third were the plants of Cruciferae(11%). 3. In examining the preferences of the butterflies to the colors of nectar plants, it was found that white color was preferred by 43% of the butterflies in the highest rate, followed by blue color os 20% of the butterflies, yellow color by 10.5% of the butterflies and the red color by 8% of the butterflies at the lowest rate. 4. Staphylea bumalda and Rubus idaeus var. microphyllus were the shrubs on which the butterflies most frequently coming to feed. And Erigeron annuus and Cirsium japonicum var. ussuriense were the weeds on which the butterflies were most frequently coming to feed. 5. Pieris rapae showed the widest range of diversity to nectar plants by feeding on 18 species nectar plants. The second was Mellicta athalia which fed on 17 species of nectar plants. The the third was Artephaneura alcinous which fed on 16 species of nectar plants.

입원한 입시 스트레스 증후군 환자의임상양상에 관한 정신의학적 연구

신광철,진태원,이영식,이재우,이재광,이길홍 중앙대부설한국의과학연구소 1991 한국의과학 Vol.23 No.3

동하중 측정 신호처리의 개발에 관한 연구

신영균,이영준,박찬원,신형재,안광희 江原大學校 産業技術硏究所 1998 産業技術硏究 Vol.18 No.-

A high speed and stable A/D conversion data process is required to weigh a mass on moving conveyer weighing platter. The paper presents a new method to obtain stable and fast automatic weighing A/D conversion data process. Dynamic weighting system which is constructed with dual load cell is realized by the stable A/D conversion data preocess algorithm using DSP. The proposed memthod is applied to the real design, and that experimental results showed good performances of the weighing stability.

丹田呼吸의 生理學的 考察Ⅰ

申光均,金銑元 제주대학교 1982 논문집 Vol.14 No.-

本 硏究는 丹田呼吸 前後의 주먹의 충격적인 힘의 變化를 濟州大學 體育敎育科 3學年 學生中 任意抽出한 實驗群 5 名과 統制群 5名 對家으로 1981年 3月부터 1982年 2月까지 5次에 걸쳐 測定하였는 데 그 結果는 다음과 같다. 1. 1次 測定은 丹田呼吸 實施以前에 2次 測定은 丹田呼吸 實施 3 個月 後에 行하였는데 實驗群이나 統制群 사이에 별 差異가 없었다. 2. 丹田呼吸 實施 6 個月 後에 行한 3次 測定부터 현저한 差異가 있어 實驗郡이 統制群보다 平均 10kg의 增加를 보였고, 1次 測定 때보다 統制群이 5kg增加한데 비하여 實驗郡은 14kg 增加되었다. 3. 4次 測定은 實驗群이 統制群보다 12kg, 5次는 11kg 이상의 增加를 보였고 實驗群中에서도 個人差가 심하여 一次 測定때 보다 40kg 이상의 주먹힘이 增加된 경우도 있었다. This study was conducted to measure the changes of impulsive force of first occurring in consequence of Dan-Jeon Breathing. For this study ten students who were selected at random among junior collegians majoring in phyiscal education of Jeju National University were divided into two group, 5 for the experimental group and 5 for the controlled group. The results obtained were as follow. The first measurement was carried out before practicing Dan-Jeon Breathing and the second was after three months' practicing, but there were no conspicuous difference between both of them. At the fourth and fifth measurement as well as at the third that was taken six months after the beginning, the experimental group showed the improvement of 11 to 12 kg impulsive force of fist more than that of controlled group. And there also appeared so remarkable individual differences in the experimental group that the force of some student has improved more than 40kg comparing with the result of the first measurement.

급성 심근경색 초기에 도플러 심초음파를 이용한 좌심실 이완기 기능의 평가

신원용,김주성,김철현,이광희,최태명,현민수,김성구,권영주 순천향의학연구소;Soonchunhyang Medical Research Institute 2000 Journal of Soonchunhyang Medical Science Vol.6 No.1

Background : Congestive heart failure after acute myocardial infarction relate to left ventricular systolic sysfunction. Also, left ventricular diastolic function contribute to heart failure. The aims of this study were, firstly to characterize left ventricular diastolic function by transmitral flow velocity, and secondly to study the significance of Doppler measurements in relation to the development of heart failure in the early phase of myocardial infarction. Method : Pulsed Doppler echocardiography of transmitral flow was assessed in 34 patients with acute myocardial infarction. According to the Doppler transmitral flwo velocity profile, the study patients were assigned to the three groups: normal filling pattern (DT > 140ms, IVRT < 100ms), relaxation abnormality (DT > 140ms, IVRT ≥ 100ms), pseudonormal or restrictive pattern (DT ≤ 140ms). Also, on the basis of the presence of heart failure during first week of hospitalization, the patients were divided into two groups: patients with no sign of heart failure (Killip class Ⅰ) and heart failure (Killip class Ⅱ-Ⅳ). Results : Of the 34 patients studied, 10(29%) were normal filling pattern, 17(50%) abnormal relaxation and 7(21%) were restrictive patterns. The left ventricular ejection fraction(EF, 40 ±6%) of restrictive pattern was significantly lower than that of normal filling pattern of abnormal relaxation(p < 0.01). And, the IVRT, DT, E/A and left ventricular EF were reduced in patients with heart failure(14 patients) compared to no sign of heart failure(20 patients)(p<0.05). Of the patients with heart failure, IVRT and left ventricular EF were reduced in patients with DT≤140 ms compared to DT> 140ms(p=0.001). Conclusion : Left ventricular diastolic dysfunction is present early after onset of symptoms of acute myocardial infarction. Assessment of left ventricular diastolic function complements measurements of systolic function in the evaluation of cardiac function. DT, IVRT, E/A and left ventricular EF are useful predictors for development of congestive heart failure following acute myocardial infarction.

Pulmonary Aspergilloma : 1 수술 치험례 A Case

신원창,손광현,홍성란 인제대학교 1985 仁濟醫學 Vol.6 No.4

심한 객혈을 동반한 우측 상엽부의 mycetoma 병조를 절제한 후 임상 경과 완쾌되었다. 병리조직학적 검사상 Aspergilloma의 균사 및 아포로 구성된 fungus ball이 증명되었다. Pulmonary aspergilloma with massive hemoptysis is an occasionally fatal condition. A 43 year old house wife has had a severe recurrent hemoptysis for about 3 months. She received various medical treatment including anti-tuberculous measures without improvement. Roentgenographic findings were multicystic and soft patchy appearance at the posterior segment of the right upper lobe by A-P and lateral tomogram and also in computed tomogram. Pre-operatively fungus in the sputum culture was identified at the laboratory. Choice of surgical excision of the involved lobe was decided. Specimen showed beautiful fungus ball in the cavity and bronchiectasis of the communicated bronchi. Pathologic examination showed beautiful aspergillus fumigatus involving the lung parenchyma. Post-operatively hemoptysis was disappeared and 6th months follow up showed good recovery, For the reasons of the complex clinical pictures of the patient, authers report the case with a literature reviews.

장을 이용한 요로전환술 후 요석형성 위험인자의 변화

신관희,한광희,정원일,이형래,이상철,김원재 충북대학교 의학연구소 2002 忠北醫大學術誌 Vol.12 No.2

연구목적: 장을 이용한 요로전환술을 받은 환자들에게는 여러 가지 대사적 장애에 따른 합병증이 발생하게 되는데 그 중 하나인 요석형성의 위험인자에 대해 대사적 검사를 실시하였다. 대상 및 방법: 장을 이요한 요로전환술을 시행 받은 후 적어도 6개월간 추적관찰이 가능했던 30명(회장 도관술 24명, Mainz pouch 4명, 방광 확대술 2명)을 환자군으로 하였고 요석의 과거력이 없는 건강한 38명을 대조군으로 선정하였다. 요로감염이나 항생제를 투여하는 경우에는 대상에서 제외하였고 식이 제한을 하지 않은 상태에서 24시간 소변을 외래에서 모았다. 소변량, 나트륨, 인, 요산, 크레아티닌, 칼슘, 마그네슘, 수산, 구연산 등의 요검사 항목을 조사하여 환자군과 대조군의 측정치 및 크레아티닌으로 보정한 측정값을 각 성별에 따라 비교하였다. 결과: 혈중 칼슘, 인, 요산, 나트륨, 칼륨, 크레아티닌, 혈액요소질소 (BUN) 등 대부분의 혈중 검사 항목들은 환자군과 대조군 사이에 차이가 없었으나 혈중 단백질 수치만이 차이를 보였다. 23명의 남성 환자에게서 수산의 요 배설량이 대조군에 비해 현저히 높았으며 반대로 구연산과 요산은 대조군에 비해 낮았다 (p=0.006, p=0.001, and p=0.005, respectively). 또한, 남성 환자의 칼슘의 요 배설량은 대조군보다 오히려 적게 나타나 환자군의 칼슘/수산 비가 현저히 감소하였다 (p<0.001). 요중 칼슘, 나트륨, 인 및 요산은 크레아티닌의 농도와 관련성을 보였으며, 오직 수산만이 크레아티닌 보정 후에도 남성 환자군과 대조군 사이에 유의한 차이를 보였다. 한편, 7명의 여성 환자들에게서 대조군에 비해 마그네슘의 배설이 감소한 것 이외에 유의한 차이는 나타나지 않았다 (p=0.04). 결론: 본 연구의 결과로 볼 때 요로전환술을 받은 환자에게 요중 칼슘, 마그네슘, 구연산 등이 요석형성에 영향을 끼치는 인자로 작용하지만, 요중 수산 배설의 증가와 이에 따른 칼슘/수산 비율의 감소가 보다 더 주된 위험 요인이라 할 수 있다. Purpose: The present study was performed to assess the risk factors for urolithiasis in patients receiving urinary intestinal diversion due to certain underlying etiology. Materials and Methods: This study included 30 patients who had undergone various forms of urinary intestinal diversion (24 of ileal conduits, 4 of Mainz continent diversions, and 2 of augmentation cystoplasties) with post-operative duration of at least 6 months and 38 age-matched normal controls. Urine samples (24-hour) were randomly collected on an outpatient basis without any dietary restriction when the patients were free of urinary tract infection or antibiotics. Investigation of urinary analytes comprised urine volume, sodium, phosphorus, uric acid, creatinine, calcium, magnesium, oxalate, and citrate. Data were compared in original values and adjusted values by creatinine in each sex. Results: Almost serum analytes such as calcium, phosphorus, uric acid, sodium, potassium, creatinine, and BUN were not significantly different between patients and controls except protein. In 23 male patients, mean urinary excretion of oxalate was significantly greater than control group and conversely in that of citrate and uric acid (p=0.006, p=0.001 and p=0.005, respectively). Unexpectedly, urinary excretion of calcium in male patients was lower than in control (p=0.002) resulting in significant decrease in the ratio of calcium to oxalate (p<0.001). Among the urinary analytes, excretions of calcium, sodium, phosphorus, and uric acid were significantly correlated with that of creatinine. Oxalate was only different analyte when adjusted by creatinine between male patients and controls. In 7 female patients, decreased excretion of magnesium was observed when compared to control (p=0.04). Conclusions: Our study indicated that urinary intestinal diversion cause increased excretion of urinary oxalate leading to decreased calcium to oxalate ratio, as major metabolic alteration for urolithiasis, although urinary calcium, magnesium, or citrate may take a role.

Tetoron-Hemp 混紡사의 糊付에 關한 硏究

申光浩,鄭元圭,李光培,金碩根 嶺南大學校 工業技術硏究所 1975 연구보고 Vol.3 No.1

The purpose of this study is to investigate the characteristics of Tetoron-Hemp blended yarn sized by cornstarch and P.V.A. size The results are summarized as follows; 1) By using cornstarch size together with P.V.A. size, tensile strength and resistance to abrasion are increased. 2) When sample yarn is sized at the high temperature the effect of penetration is excellent. 3) By adding sodium sulphate, penetrating ability of size to sample yarn is increased. 4) The desizing activity is generally excellent in every sample yarns.

심근침범을 동반한 Becker형 근이영양증 환자에서 확인한 Dystrophin 유전자 Exon결실

김광일,오병희,이무용,채인호,신수,박성섭,김효수,손대원,이명묵,박영배,최윤식,이영우 대한순환기학회 1998 Korean Circulation Journal Vol.28 No.5