인라이닝을 이용한 XML 스키마의 관계형 스키마 변환 기법

정지문,조정길 남서울대학교 공학연구센터 2003 공학연구 Vol.4 No.-

데이터 중심의 XML 문서를 관계형 데이터베이스에 저장하고 관리할 경우에 XML 스키마로부터 관계형 스키마를 추출하는 것이 보다 시급한 일이다. 또한 생성된 테이블에 XML 문서를 분할하여 저장할 경우에 많은 널 값을 초래하거나 조인 비용의 증가를 가져오기 때문에 이에 대한 해결책이 필요하다. 이 논문에서 제안한 관계형 스키마 생성의 구체적인 연구 내용은 다음과 같다. XML 스키마로부터 관계형 스키마를 생성하는 Schema Hybrid Inlining 기법을 제안하였다. 제안된 기법은 XML 스키마 그래프를 바탕으로 관계형 스키마를 생성하게 되는데, 기존의 Inlining 방식을 확장하여 출현 지시자와 진입 차수에서의 테이블 생성 방법을 휴리스틱하게 매뉴얼 처리를 하며, 유도 관계에서 최종 노드인 조상 노드는 새로운 테이블을 생성한다. When any data-centric XML documents are stored and managed in RDBMS, schema extracting from XML Schema is an imminent problem. Furthermore, when they are stored in partitioned way on created table, there will be produced lots of null values and/or be increased cost for join, so we need a solution to solve these problem. This thesis proposes a Schema Hybrid Inlining technique to generate relational schema. The suggested technique creates a relational schema based on the XML Schema graph. Also, the technique expands the legacy Inlining method to manual and heuristical processes table generation method of appearance indicator and in-degree, and an ancestor node, terminal node, createds a new table on derived relation in this technique.

隔板을 가진 傾斜 4角密閉空間內의 自然對流 流動特性

鄭仁基,金重燁,洪性吉 嶺南大學校 工業技術硏究所 1987 연구보고 Vol.15 No.2

Two-dimensional natural convection in a partially divided inclined square enclosure is investigated experimentally. Two opposite walls of the enclosure are adiabatic while the other two isothermal walls are maintained at different temperatures, and a partition is situated perpendicularly at the mid-height of one adiabatic wall. The flow visualization experiments are carried out with water, Pr=4.95, for two Rayleigh numbers, Ra=1.968x10?? and 3.936x10??. The inclination of enclosure is varied from -30°to 90°, and the length of a partition is varied from L=0 to L=11/13W. The length of a partition and the inclination of an enclosure are to significantly effect on the flow patterns within the enclosure. The transition to the primary circulating flow is occured at the inclination of 30°∼40°, and the strongest wall-boundary flow and the wide core-stagnation region are presented at the inclination of 50°∼60°regardless the partition length. An oscillatory motion of natural convection is also found to occur in certain lengths of a partition at θ=0°, such as an enclosure heated from below with a horizontal partition.

주편 연속주조시 Thermal Soft Reduction 적용에 의한 중심 편석 개선

정영진,김지준,김선구,강충길 대한금속재료학회 2003 대한금속·재료학회지 Vol.41 No.11

Centerline macrosegregation is one of the most significant problems in continuous casting on stainless steel slabs. Numerical model have been developed in order to decrease centerline macrosegregation during continuous casting of STS 420J2 stainless steel slab. Extra cooling zone and extra cooling water quantity are determined by iterative coupled analysis of heat transfer and segregation. Segregation ratio is decreased by the intensive cooling at the extra cooling zone above the solid fraction of the slab center 0.7, so called thermal soft reduction (TSR). The experimental results show good agreements with numerical results.

시스틴 결석 : 증례 보고 A Case Report

이길용,노준,정충식 조선대학교 부설 의학연구소 2002 The Medical Journal of Chosun University Vol.27 No.2

Cystine calculi is the consequence of cystinuria, an autosomal recessive defect of the transepithelial of cystine and dibasic acids in the kidney and intestine. The hardness and frequent reccurrence of cystine stones present a special challenge to the urologist. we report a case of 15-year-old man who had a cystine calculi, which was successfully treated with percutaneous lithotripsy (PCNL), extracorporeal shock wave lithotripsy (ESWL) &edical therapy include high fluid intake, alkalinization and chelating agent.

폐전선 피복재 건류탄을 이용한 제강분진처리를 위한 기초연구

황용길,이상화,이성룡,정석수,최재신,조충형 東亞大學校 1995 東亞論叢 Vol.32 No.-

Distilled carbon from waste electric wire coated by vinyl is used to recover valuable metal such zinc, lead and iron in dust. Pemeability and compressive tests are who done to present basic data on extraction of zinc in dust. Experimental results obtained from sintering property of steelmaking dust, distilled carbon from waste electric wire coated by vinyl and waste pulp sludge mixture briquet at various sintering temperature are as followings; Permeability is increased as increasing distilled carbon and pulp amount at higher temperature than room temperature condition. Compressive strength at room temperature is increased as increasing distilled carbon and decreasing waste pulp amount, but decreased as increasing temperature and waste pulp amount. Weight Loss reaction experiment is increased a increasing distilled carbon and waste pulp amount. ZnO and Fe₃O₄ are obtained from sample containing ZnO, Fe₂O₃ and ZnO at 800℃. Permeability test at 500℃ and 800℃ did not well, because of 13.3% CaO in distilled carbon. Sample because semmi melted state at 1000℃. Distilled carbon obtained from waste electric wire showed effect of reduction and flux material.

진동시험에 의한 참외의 진동특성

김만수,정현모,김기석,박정길 충남대학교 농업과학연구소 2005 농업과학연구 Vol.32 No.1

During a long journey of agricultural products from the production area to markets, the quality of agricultural products was always affected by some degree of vibration. The vibration input during the transportation may cause serious agricultural product injury, and this damage is particularly severe whenever the vegetable inside package is free to bounce, and is vibrated at its resonant frequency. The objectives of this study were to determine the resonant frequency of the oriental melon and to investigate the relationships between resonant frequency and physical properties of the oriental melon such as mass, volume and major and minor axes. In this study vibration testing device was constructed to determine the vibration response of the oriental melon in frequency ranges of 5 to 150 Hz. The computer program for controlling the vibration shaker and the function generator and measuring the vibration characteristics of the oriental melon was developed. The ranges of resonant frequency and peak acceleration at resonance of the oriental melon were 51 to 73 Hz and 1.24 to 1.92 G-rms, respectively. The resonant frequency and the peak acceleration decreased with the increase of the sample mass, volume, major and minor axes of the oriental melon. Multiple regression models for resonant frequency and peak acceleration of the oriental melon as a function of mass, major axis and minor axis of the sample were developed and analyzed.

갑상샘암 수술환자의 심리 및 신체적 불편감에 미치는 정보교육 프로그램 효과

이양희,정영,박연주,최길순,정지연 朝鮮大學校 附設 醫學硏究所 2008 The Medical Journal of Chosun University Vol.33 No.2

본 연구는 정보교육 프로그램이 갑상샘암 수술 환자의 심리 및 신체적 불편감 감소에 미치는 효과를 검정하기 위해 실시된 비동등성 대조군 전,후 시차 설계의 유사 실험연구이다. 자료수집 기간은 2006년 6월 17일 부터 9월 19일 까지 3개월간 이었으며, 연구 대상자는 일개 종합병원에 갑상샘암 수술을 받기위해 입원한 환자 가운데 6월 17일 부터 8월 3일 까지 입원환자 29명을 대조군으로 하였고, 8월 5일 부터 9월 19일 까지 입원환자 30명을 실험군으로 하였다. 연구도구는 심리적 불편감을 측정하기 위해 Derogatis 등(14)이 개발한 ‘자기보고식 다차원 증상목록(Multidimensional Symptom Inven- tory)검사를 사용하였고, 신체적 불편감 측정은 McCorkle & Young(16)이 개발한 도구를 사용하였다. 본 연구의 결과는 다음과 같다; 1) 정보교육 프로그램을 받은 실험군은 정보교육 프로그램을 받지 않은 대조군에 비해 심리적 불편감 정도의 차이는 통계적으로 유의한 차이를 보이지 않았다(p= .135). 다만 ‘근심 걱정’요인에서 유의한 불편감 감소효과를 보였다(p= 0.49) . 2) 정보교육 프로그램을 받은 실험군과 정보교육 프로그램을 받지 않은 대조군은 두군 모두 신체적 불편감 정도가 사후 유의한 수준으로 증가함을 보였다(p= 0.90). 결론적으로 본 연구를 위해 만들어진 정보교육 프로그램은 갑상샘암 수술 환자의 신체적 불편감 감소에는 효과적이지 못하였으나 심리적 불편감의 근심걱정 요인을 감소시키는데는 효과가 있음을 알게 되었다. Objectives: This study was designed as a non-equivalent control group pre and post-test quasi-experimental study to examine the effects of education program using information on the psychological and physical discomfort of patients undergoing operation for cancerous thyroid glands. Methods: The study covered for three months from June 17, 2006 to September 19, 2006. The subjects of this study were selected from those patients who were admitted in one of the general hospitals in order to receive the operation for cancerous thyroid glands. They include 29 control group patients who were hospitalized during the period of Jun 17th to August 3rd 2006, and 31 experimental group patients who were hospitalized during the period of August 5th to September 19th, 2006, respectively. The instruments utilized for conducting this study includes the Multidimensional Self-Report Symptom Inventory test originally developed by Derogatis & et al. (1983) for measuring psychological discomfort. And for measuring physical discomfort, the tools developed by McCorkle & Young (1978) was utilized. Results: 1) Hypothesis 1 “The level of psychological discomfort of the experimental group who completed the information education program would be decreased comparing with that of the control group who didn't complete the program” was partly supported (Worry & Anxiety factor: p= .049). 2) Hypothesis 2 “The level of physical discomfort of the experimental group who completed the information education program would be reduced comparing with that of the control group who didn't complete the program” was not supported (p= -.90). Conclusion: The information program provided for this study was proved to be not effective for decrease physical discomfort of the patients undergoing operations for cancerous thyroid glands but proved to be effective for decrease the anxiety factor of psychological discomfort.

동일한 시료에 대한 국내 기관간의 STR 분석결과 비교 : STR 유전자좌 분석법의 표준화 설정을 위하여

박종태,신경진,양윤석,우광만,이숭덕,이승환,이정빈,정연보,조승희,한길로,한면수,홍승범 大韓法醫學會 2001 대한법의학회지 Vol.25 No.1

This paper described a collaborative exercise intended to see what kinds of short tandem repeat (STR) loci are used in different DNA typing laboratories in Korea and to compare their results for the demonstration whether uniformity of DNA profiling results from different laboratory could be achieved in Korea Laboratories were asked to test five tissue DNAs using methods routinely used in each laboratory and to report the results to the coordinating laboratory. The exercise demonstrated that each laboratory was using different STR loci for the typing with different STR numbers,2 VNTRS,36 STRs and amelogenin in total, and the direct comparison of the results from all the laboratory for the 18 loci could not be done as only one laboratory submitted typing results. Among 21 loci for which several laboratories submitted typing results, results for 14 loci were the same and results for the other 7 loci were different depending on the participating laboratory. D1S80, F13A01, D16S539, D21S11, D18S51, D3S1744 were the loci with different typing results. Even in the cases where commercial kits were used, the results were not the same depending on the machines used, that is the capillary electrophoresis or the gel based electrophoresis. The reason for the different results, points about the standardization of the methods arid the profiling data were described.

Comparison of the Damaged Area Caused by an Agricultural Dam-Break Flood Wave Using HEC-RAS and UAV Surveying

Jung, Chung-Gil,Kim, Seong-Joon 'Scientific Research Publishing, Inc.' 2017 Agricultural sciences Vol.8 No.10

HSPF 및 SWAT 모델을 이용한 볏짚피복 시나리오 적용에 따른 비점오염물질 저감효과 모델링

정충길(Jung, Chung Gil),안소라(Ahn, So Ra),양희정(Yang, Hee Jeong),김성준(Kim, Seong Joon) 대한토목학회 2012 대한토목학회 학술대회 Vol.2012 No.10