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

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

CM전문회사의 현장관리조직 운영실태 분석

신원상(Shin, Won-Sang),이강민(Lee, Kang-Min),손창백(Son, Chang-Baek) 대한건축학회 2014 大韓建築學會論文集 : 構造系 Vol.30 No.8

This study is aimed at offering basic data for enhancing the organizational structure and productivity of on-site construction management (CM) employees. To accomplish the objective, the organizational operation system and employee evaluation of domestic CM companies were analyzed by site scale to promote efficient operation. The findings are as follows. First, in terms of CM workforce, the employees handling architecture, electricity, and machines represented the highest proportion. As for qualification, top engineers were dispatched to both large-scale and small-scale CM sites more than any other employee. Second, the results on CM organizational productivity are as follows. The per capita sales increased as the service payment increased. In terms of scale, the site worth less than a billion won had per capita sales of 76 million won, about 5 times less than the site worth 5 billion won or more whose per capita sales were 371 million won. The monthly per capita sales also increased as the service payment increased. However, the difference was minimal, about a half of the difference in per capita sales. These findings would be useful for companies that have no systematic criteria for CM organization selection and evaluation.

用寒遠寒과 用熱遠熱에 대한 考察 : 六元正紀大論에서

채영진,신창환,임현택,여성원,한성규,이재원,정헌영,금경수 한국전통의학연구소 2003 한국전통의학지 Vol.13 No.1

Five elements motion and six kinds of natural factors influence not only human disease but also difference of medicine effect. Because the climate of summer is very hot, that is easy to increase the properties of hot medicines, a doctor must be careful to use it in summer. Also the climate of winter is very cold, that is easy to increase the properties of cold medicines, a doctor must be careful to use it in winter. But in the certain conditions to use diaphoretics or purgatives, in spite of that regulation a doctor can use them.

야뇨증 환아들의 심리사회적 특성에 대한 다기관 연구 : 행동 및 정서 문제를 중심으로

조수철,김재원,신민섭,황준원,한상원,박관현,이상돈,김경도,김건석,서홍진,이유식,정재용,김영균,문두건,남궁미경,한창희,조원열,김영식,배기수,이종국,정우영,신의진 大韓神經精神醫學會 2005 신경정신의학 Vol.44 No.6

Objectives : The aim of this study was to examine the behavioral and emotional problems associated with nocturnal enuresis in Korean children. Methods : Three hundred eighteen children with nocturnal enuresis, together with their parents, completed the Child Behavior Checklist (CBCL), Disruptive Behavior Disorder Scale according to DSM-IV (DBDS), Children's Depression Inventory (CDI), State-Trait Anxiety Inventory for Children (STAIC), and Piers-Harris Children's Self-Concept Scale (PHCSC). Ninety-three normal students were selected as the control group. Results : Compared to the normal control group, the mean scores with regard to the withdrawn, social problems, attention problems, delinquent behavior, aggressive behavior, externalizing problems and total problems profiles were significantly higher in the nocturnal enuresis group according to the CBCL results. The nocturnal enuresis group also scored significantly higher in the ADHD and ODD profiles of the DBDS. The nocturnal enuresis group was more depressed and anxious than the control group according to the results of the CDI and STAI. The mean score of the PHCSC was significantly lower in the nocturnal enuresis group when compared to the normal control group. Conclusion : The results of this study suggest that children with nocturnal enuresis in Korea have clinically relevant behavioral and emotional problems. The findings support the link between nocturnal enuresis and psychopathology in Korean children.

내동정맥루술후의 수지운동이 동정맥루의 혈류와 개존에 미치는 영향

신현석,조원현,이성문,우성구,김현철 大韓脈管外科學會 1995 大韓脈管外科學會誌 Vol.11 No.1

確率有限要素法을 利用한 Frame 構造物의 信賴性解析

신재철,정원석,한성호,김선훈 忠南大學校 産業技術硏究所 2002 산업기술연구논문집 Vol.17 No.1

In this paper reliability analysis using stochastic finite element method is formulated, and with its result reliability analysis is accomplished. A displacement and member force of frame structure is acquired in SFEMP(Stochastic Finite Element Method Program) using perturbation method, and then DMCSP(Direct Monte Carlo Simulation Program) is used to verify and compare previous results. With the previous two results, approximate reliability analyses of the MFOSM(Mean First Order Second Moment), AFOSM(Advanced First Order Second Moment), and MCS(Monte Carlo Simulation) including a relatively simple limit state function have accomplished and base of a safety estimate could be acquired. Finally, When the reliability analysis of a complicated structure using stochastic finite element method is accomplished, time is efficiently reduced, and the safety of a structure can be easily evaluated. Hence SFEMP may be considered an efficient tool for evaluating the structural safety and reliability of frame structure.

급성 림프구성 백혈병 환자에서 발생한 침습성 국균 심내막염 2예

신성철,백경란,정재홍,송봉근,김동희,전경만,채제욱,손준성,정숙인,오원섭,송재훈 대한감염학회 2003 감염과 화학요법 Vol.35 No.5

국균은 호흡기를 통해 유입되며 심한 면역기능저하 환자에서 기회감염을 일으키는 진균이며 주로 혈관을 따라 폐를 침범하고 심장과 골침범은 매우 드문 것으로 알려져 있다. 저자들은 급성 림프구성 백혈병 환자에서 발생한 침습성 국균 심내막염을 2예을 경험하였다. 19세 남자환자로 동종 조혈모세포이식 후 발생한 고열과 요통의 원인으로 감염성 심내막염 진단하에 수술결과 국균에 의한 감염으로 확증되어 수술적 절제술과 liposomal amphotericin B로 치료하였으나 국균 심내막염의 재발과 국균 척추염의 악화, 뇌 출혈로 사망하였다. 23세 남자환자로 관해요법 후 발생한 고열과 요통의 원인으로 국균 심내막염과 국균 척추염 진단하에 수술적 절제술과 amphotericin B로 치료하여 1년 2개월 동안 국균 심내막염의 재발은 없었으나 지속적인 백혈병의 재발과 국균 척추염의 악화, 침습성 폐 국균증으로 사망하였다. Although Aspergillus endocarditis has rarely been reported, it can cause fatal complications in hematologic malignancy patients and allogeneic stem cell transplant recipients. We experienced two cases of aspergillus endocarditis developed in acute lymphoblastic leukemia patients. Case; A 19-year-old patient developed Aspergillus endocarditis after allogenic hemopoietic stem cell transplantation. He was treated with surgical intervention and liposomal amphotericin B. He died of recurred Aspergillus endocarditis and cerebral hemorrhage probably related with aspergillosis of central nervous system. Case 2; A 23-year-old patient developed invasive Aspergillus endocarditis after induction chemotherapy. Aspergillus endocarditis was successfully treated by surgical intervention and amphotericin B. He died of refractory neutropenic fever and sepsis after the third relapse of leukemia and repetitive chemotherapy. He probably had invasive pulmonary aspergillosis without evidence of endocarditis recurrence. Because the mortality of Aspergillus endocarditis is very high, early diagnosis and surgical intervention are very important for better outcome.

대학신입생들의 구강상태 인식도와 상대구강진료필요도에 관한 상관관계 조사연구

원상연,신승철,김선영 단국대학교 치과대학 예방치과 1998 예방치과 세미나집 Vol.- No.12

The purpose of this study was to detemine toe correlation between the awareness and the status of their won oral diseases. A questionnaire survey form was desinged to determine the awareness of their won oral diseases and asked aoo of the university freshmen students to fill out the al of questionaries. They were then immediately examined for을 새 determine their status of dental hard tissures by using the WHO criteria. Also determined were the CPITN and the needs for orthodontic as well as prosthodontic treatments. The results were then statistically analyzed to determine the correlation coefficiencies between the awareness and the status of oral diseases by using SPSS statistical package. The results suggested the followings; 1. The correlation coefficiencies between the awareness and the status for number of teeth decayed, missed, and indicated for extractions were 0.18, 0.06 and 0.09 respectively. 2. The correlationg coefficiency between the awareness and the status in treated teeth(F component) and CPITN were 0.622 and 0.10 respectively. 3. The agreement between examiners and examiners on the needs for prosthodontic treatments was 87.31% and their sensitivity and specificity were 47.54% and 88.55% respectively. 4. The agreement between examiners and examinees on the needs for orthodontic treatment was 70.40% and their sensitivity and specificity were 77.27% and 69.71% respectively. Data indicate that a majority of respondents are lacking in the awareness of their own oral disease status. Therefore, it is concluded that a regular oral examination, a regular counselling on oral health status as well as specific oral health education for each individual warranted.

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

신관희,한광희,정원일,이형래,이상철,김원재 충북대학교 의학연구소 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.

固眞飮子가 galactosamine으로 유발한 흰쥐의 간중독에 미치는 영향

원철환,정승현,임성우,신길조,윤상협,이원철 동국대학교 한의학연구소 1997 東國韓醫學硏究所論文集 Vol.6 No.1

최근 간질환에 대한 진단과 기술의 비약적인 발전에도 불구하고 치료방법론에서는 그 해결이 모호한 상태에 있다. 실험적으로 간중독을 유발시킨 동물에 약물을 투여하여 그 약화를 입증하려는 노력이 진행되고 있다. 이에 저자는 固眞飮子가 간독성의 완화효과에 미치는 영향을 관찰하기 위하여 固眞飮子추출물을 투여한 흰쥐에 galactosamine으로 간독성을 유발하고 간조직내 glutathione과 과산화지질의 함량, 혈청중의 GOT, GPT, γ-GPT, ALT, LDH의 효소활성측정 및 혈청중의 bile acid함량을 측정하여 다음과 같은 유의한 결과를 얻었다. glutathione의 함량은 固眞飮子을 전처치한 실험군에서 유의성 있게 증가하여고, 과산화지질, 혈청중 GOT, GPT, γ-GPT, ALT, LDH, bile acid는 고진음자를 전처치한 실험군에서 유의성있게 감소하였다. The purpose of this study is to observe the protective effect of Kojinyumja on serum reaction and hepatic tissue in galactosamine treated rats. In this study, the experimental rats divided four group(Normal group, Control group, Sample A group, and Sample B group): Under the same condition, normal and contro1 group were administered water, sample A, B group were administered Kojinyumja for 8days. And then, Coth control group and Sample B group were injected to abdomen with galactosamine for 1day. The rates of glutathione, lipid peroxide, GOT, GPT, γ-GTP, ALP, LDH, and contents of bile acid level were measured. The results are as follows: The glutathione rate significantly increased in sample group, the others(lipid peroxide, G0T, GPT, γ-GTP, ALP, LDH, bile acid) significantly decreased in sample group.