관계형 OLAP 데이터 웨어하우징 환경에서 조인과 집계함수를 포함하는 질의의 효율적인 처리

김진호,김윤호,김상욱,Kim, Jin-Ho,Kim, Yun-Ho,Kim, Sang-Wook 대한전자공학회 2002 電子工學會論文誌-CI (Computer and Information) Vol.39 No.5

대용량의 데이터가 저장되는 데이터 웨어하우징 환경에서 조인이나 집계 함수와 같은 고비용의 연산의 효율적인 처리는 매우 중요하다. 본 논문에서는 집계 함수(aggregate function)와 조인(join)이 모두 포함된 질의를 처리하는 새로운 기법을 제안한다. 제안하는 기법은 먼저 차원 테이블(dimension table)을 미리 그루핑한 후, 비트맵 조인 인덱스(bitmap join index)를 이용하여 조인을 처리하는 방식을 사용한다. 이 결과, 사실 테이블(fact table)만을 접근하여 집계 함수를 처리함으로써 기존 기법이 가지는 성능 저하의 문제점을 해결할 수 있다. 기존 기법과 제안하는 기법에 대한 비용 모델(cost model)을 정립하고, TPC-H 벤치마크를 기반으로 하는 다양한 시뮬레이션을 수행함으로써 제안된 기법의 우수성을 규명한다. Efficient processing of expensive queries that include joins and/or aggregate functions is crucial in data warehousing environment since there reside enormous volume of data. In this paper, we propose a new method for processing of queries that have both of joins and aggregate functions. The proposed method first performs grouping of the dimension table and then processes join by using the bitmap join index. This makes only the fact table accessed for processing aggregate functions, and thus resolves the serious performance degradation of the existing method. For showing the superiority of the proposed method, we suggest the cost models for the proposed and existing ones, and perform extensive simulations based on the TPC-H benchmark.

단치소요산가감방(丹梔逍遙散加減方)이 streptozotocin으로 유발된 고혈당 생쥐에 미치는 영향

김진호,김경수,김정상,Kim, Jin-Ho,Kim, Kyung-Soo,Kim, Jeong-Sang 대한한의학방제학회 2005 大韓韓醫學方劑學會誌 Vol.13 No.2

This study has been carried out to understand the effect of Danchisoyosangagambang (DC) on the hyperglycemic mice induced with streptozotocin(STZ). Experimental groups were made diabetic mice by intraperitoneal injection of STZ(60 mg/kg of body weight) tw ice by 24 h interval and then 120 mg/kg STZ was injected again 3 days after the earlier treatment. Control group was administered mice with 0.9 % saline(2 mL/kg), and experim ental groups were administered DC extract(DCA group, 10 mg/kg/day; DCB group, 30 mg/kg/day) after hyperglycemic induction for 6 weeks. The body weight of experimental groups was lower than control. The blood glucose concentration increased continuously, rea ching to 298.9 mg/dL after 6 weeks, however, experimental groups of the DCA and DCB groups significantly(p<0.0l) decreased in the 4, 5, and 6 weeks groups. Blood glucose tolerance test was not significant between control and experimental groups. We examined the blood transaminase activities to know the effect of herbal medicine on liver function. The GOT activities were lower in group DCB than in control. The GPT activities were lower in group DCA and DCB than in control. The content of triglyceride was significantly increased in group DCA compared to control. The SOD and catalase activities were higher in the group DCA compared to control. The results of immunohistochemical study, a few of insulin positive cells observed in the control and experimental group. These results suggest that administration of DC extract to the hyperglycemic mice decreased the blood glucose level.

농업인의 유기농업 기술개발 만족도 조사

김진호,이상범,박광래,홍승길,이초롱,김민기,김용기,이상민,변영웅,고병구,Kim, Jin-Ho,Lee, Sang-Beom,Park, Kwang-Lai,Hong, Seung-Gil,Lee, Cho-Rong,Kim, Min-Gi,Kim, Yong-Ki,Lee, Sang-Min,Byeon, Young-Woong,Ko, Byong-Gu 한국유기농업학회 2018 韓國有機農業學會誌 Vol.26 No.2

This study was conducted to investigate farmers' satisfaction in organic farming technologies developed by the Rural Development Administration (RDA). The survey targeted farmers who were eco-friendly or interested in eco-friendly agriculture. 70% of the target farmers were doing eco-friendly farming, and the satisfaction rate of the technology developed by the RDA was 3.85 points. The satisfaction of the farmers who participated in demonstration and demonstration of the farming field of the developed technology was 4.00 and the satisfaction level of organic farming instruction manual was 3.95. In addition, 38.4% of the surveyed areas were found to be pest control areas, and the impacts on the satisfaction of the organic cultivation related technology utilization and the satisfaction of the organic cultivation guide were analyzed. As a result, the RDA needs to develop and supply customized technology for aged small farmers.

자란만 패류양식해역의 물리환경 설명을 위한 평균체류시간 산정

김진호,박성은,김영민,김청숙,강성찬,정우성,심보람,엄기혁,Kim, Jin Ho,Park, Sung-Eun,Kim, Youngmin,Kim, Chung Sook,Kang, Sungchan,Jung, Woo-Sung,Sim, Bo-Ram,Eom, Ki-Hyuk 한국환경과학회 2020 한국환경과학회지 Vol.29 No.3

Residence time is defined as the time taken for a material in a system to leave the system. The residence time characteristics in shellfish aquaculture determine the dispersion of excretion from aquaculture farms, along with the supply of food by seawater exchange. In this study, we estimated the spatial distribution of average residence time in the shellfish farming area using a particle tracking model. As a result, a relatively short average residence time of about 20 days or less was calculated in most areas, but an average residence time of more than 40 days was calculated in the inner areas. Relatively long average residence times were calculated along the west coast compared to the east coast, with the longest average residence time of more than 50 days in the northwestern areas. It can be inferred that the disturbance of the benthic ecosystem caused by shellfish farms is likely to be large because of the relatively weak dispersion of excrement from shellfish farms located on the west coast, especially in the northwest region. This distribution of average residence time is important for understanding the potential effects of seawater exchange on the environmental sustainability of shellfish farms, along with the seawater circulation characteristics of Jaran Bay.

양궁 선수의 마음챙김 능력 향상을 위한 심리훈련 프로그램 적용

김진호(Kim, Jin-Ho),오원석(Oh, Won-Seok) 한국사회체육학회 2017 한국사회체육학회지 Vol.0 No.67

The purpose of this study is to investigate the effects of mindfulness training with psychological techniques in a professional archery team in South Korea. First of all, it is conducted to find the changes in mindfulness through the KIMS during the mindfulness training, and to analyze the changes in both mindfulness and psychological technique factors. After ten times of meditation (1h-1h30m/1d), ACT and MAC based on the mindfulness training program, there were significant positive influences of psychological factors such as techniques, acceptance, concentration behavior and attention behavior on an intervention group compared to a control group, resulting in KIMS. Although there were no significant differences in confidence and teamwork in the intervention group after the psychological techniques, there were positive effects on willpower, goal setting , concentration, anxiety control and imagery statistically in the intervention group. In conclusion, mindfulness training has positive effects on the mindfulness in Korean archers. This training also has a positive influence on psychological technique factors such as attention, imagery, concentration and anxiety control. According to previous literatures, it is proved that there were positive effects on the psychological technique factors with the changes in mindfulness. Therefore, it is required to develop tools which can measure the mindfulness and to apply the correlation of mindfulness and psychological techniques to the field.

친환경.저에너지 빌딩을 위한 친환경 설계 방법 고찰

김진호,김동훈,Kim, Jin-Ho,Kim, Dong-Hun 한국건설관리학회 2014 건설관리 : 한국건설관리학회 학회지 Vol.15 No.5

디지털 프린팅용 세라믹 잉크의 유약표면 인쇄적성 및 특성평가

김진호,황광택,조우석,한규성,Kim, Jin-Ho,Hwang, Kwang-Taek,Cho, Woo-Seok,Han, Kyu-Sung 한국결정성장학회 2017 한국결정성장학회지 Vol.27 No.5

$1000^{\circ}C$ 이상의 고온에서도 안정적인 발색 특성을 보이는 세라믹 잉크를 활용한 디지털 프린팅 기술은 우수한 내구성을 가지는 제품을 다양한 디자인을 적용하여 생산할 수 있는 친환경 공정이라는 장점으로 인해 최근 관심이 높아지고 있다. 특히 건축용 세라믹 타일 산업에서 잉크젯 프린팅 기술 도입을 통한 디지털 공정으로의 전환은 점점 가속화되고 있으며, 이와 관련된 프린팅 시스템 및 고온발색 세라믹 잉크에 관한 연구가 활발히 진행되고 있다. 본 연구에서는 세라믹 타일의 표면 유약층에서 고온발색 세라믹 잉크의 인쇄적성을 분석하였다. 디지털 4원색인 Cyan, Magenta, Yellow, Black 색상의 고온발색 세라믹 잉크가 프린팅된 세라믹 타일의 표면 및 단면의 미세구조를 분석함으로써 세라믹 잉크의 종류에 따른 인쇄특성에 대해 비교하였다. 또한 고온 열처리 공정이 필수적으로 요구되는 세라믹 소재의 특성상 잉크젯 프린팅 후 세라믹 잉크 패턴의 열처리 공정에 따른 거동변화에 관하여 고찰하였으며, 세라믹 타일 유약층에서 세라믹 잉크의 인쇄적성은 미세구조 및 고온 소성 과정에 큰 영향을 받고 있음을 확인하였다. Digital ink-jet printing technology using ceramic ink, which is thermally stable at high temperature above $1000^{\circ}C$, has an advantage of eco-friendly process applicable to manufacturing products with an excellent durability and various designs. Recently, replacement from conventional manufacturing process to digital process using ink-jet printing technique has been significantly accelerated in ceramic tile industry. In this study, we investigated ink-jet printability of ceramic ink on ceramic tile. Cyan, magenta, yellow, black ceramic inks, which are digital primary color of ink-jet printing, were printed on glazed surface of ceramic tiles, and their printabilities were comparatively analyzed. High temperature sintering process is generally required for manufacturing ceramic products, thus effect of sintering process on printed pattern of ceramic ink was also investigated by analyzing ink penetration depth and ink dot area.

Microstructure and Electrical Properties of Pb[(Mg,Mn)Nb]O3-Pb(Zr,Ti)O3 Piezoelectric Ceramics

김진호,Jong-Hwa Kim,Seung-Woo Baik 한국전기전자재료학회 2005 Transactions on Electrical and Electronic Material Vol.6 No.5

Phase evolution, microstructure and the electrical properties such as kP and Qm of Pb(Mg1/3Nb2/3)O3[PMN]-Pb(Mn1/3Nb2/3)O3[PM΄N]-PbZrO3[PZ]-PbTiO3[PT] quaternary system were investigated within the compositional ranges 0≤y≤0.125, y+z=0.125, and 0.39≤x≤0.54 of the formula Pb0.97Sr0.03[(Mg1/3Nb2/3)y (Mn1/3Nb2/3)z (ZrxTi1-x)1-(y+z)]O3. In the case of increasing Mn/(Mg+Mn) ratio for a fixed Zr/Ti ratio of 47.5/52.5, phase relation remained unchanged but the grain size drastically decreased, and the electrical properties changed as following: both kP and Qm reached the peak values at Mn/(Mg+Mn)@0.317 and gradually decreased; e33Tshowed a monotonic decrease; P-E hysteresis loop gradually changed to asymmetrical one, and Ei increased in correspondence. With increasing Zr/Ti ratio for a fixed Mn/(Mg+Mn) ratio of 0.317, on the contrary, the cell parameter (a2c)1/3 gradually increased, and tetragonal-rhombohedral morphotropic phase boundary appeared in the range of 51/49≤Zr/Ti≤54/46. In the meantime, the grain size substantially increased, and the electrical properties changed as following: kP and e33T reached peak values at Zr/Ti=51/49 and 48/52, respectively, and then gradually decreased; change of Qm was adverse to kP; both EC and Ei considerably decreased while PS moderately increased. For the system 0.125(PMN+PM΄N)-0.875PZT studied, the composition Mn/(Mg+Mn)=0.317 and Zr/Ti=51/49 revealed some promising electrical properties for piezoelectric transformer application such as kP=0.58, Qm@1000, and eT33=970, as well as dense and fine-grained microstructure.

울릉분지와 동해 해산의 기원과 발달과정에 대한 해양지구물리학적 연구

김진호,박수철,강무희,김경오,한현철,Kim Jinho,Park Soo-chul,Kang Moo-hee,Kim Kyong-O,Han Hyun-chul 대한자원환경지질학회 2005 자원환경지질 Vol.38 No.6

동해는 일본분지, 야마토 분지, 울릉분지 등 큰 3개의 해양분지와 크고 작은 고지대(topographic hihgs) 등으로 구성되어 있고, 주변해(marginal sea) 또는 후배호 분지 (back-arc basin)로 분류되며 태평양판, 필리핀판 등이 주변해 위치하고 있다. 동해의 남서쪽에 위치한 울릉분지는 평균수심 약 1500 미터, 최대수심 약 2500 미터를 보이며, 2000 미터 등 심선을 따라 동해의 일본 분지와 연결되어 있다. 분지 내에서 해저면 경사는 대체적으로 서쪽이 크게 나타나며, 남쪽과 동쪽의 경사는 이에 비하여 상대적으로 작게 나타난다. 지진계(OBS) 자료와 탄성파 자료 등에 의해 밝혀진 울릉분지의 지각 두께는 북쪽으로 그리고, 한국 연안 쪽으로 갈수록 두꺼워지는 경향을 보이며, 퇴적물의 두께는 울릉분지 남서쪽으로 갈수록 점차 두꺼워져 최대 약 12km에 이른다 울릉분지의 지각은 열개된 대륙지각(rifted continental crust), 신장된 대륙지각, 해저확장 초기단계에 형성된 해양지각 등 다양하게 제시되고 있으나 현재까지 구체적 증거는 없다. 수심 및 중력자료에 의하면, 울릉분지의 축은 북서-남동 방향으로 발달하고 있다. 또한, 후리에어-이상의 분포도 수심 자료와 유사하게 북서-남동 방향의 축을 중심으로 대칭성을 보이고 있으며, 퇴적물의 두께 분포 역시 북서쪽에서 남동 방향으로 진행하면서 일반적으로 두꺼워지는 양상을 보이고 있다. 울릉분지가 상대적으로 절은 연령에 해당하는 지각임에도 불구하고, 전체적으로는 후리에어-이상 값이 $-40\~50mGal$ 정도의 낮은 특징을 보이는데 이것은 울릉분지를 구성하는 지각과 퇴적물의 밀도가 일본분지와 야마토 분지를 구성하는 물질에 비하여 상대적으로 낮다는 것을 의미한다.나타났고, 이에 대한 적극적인 대안으로 의사와 간호사를 위한 교육프로그램 개발과 교육이 절실히 필요한데 일시적이고 일회적인 교육보다는 지속적이고 장기적이고 자동적으로 운영되는 체계가 필요하다.후 32.4$\pm$4.4, 32.1$\pm$4.5, 술 후 1일에 33.4$\pm$5.0, 31.7$\pm$5.1였다(repeated measures ANOVA, p < 0.05). 술 후 출혈량(mL)은 RAP군과 대조군에서 술 후 6시간에 357.2$\pm$ 177.1, 411.7 $\pm$ 279.5, 술 후 24시간에 599.4$\pm$145.6, 678.8 $\pm$256.4였다(t-test, p < 0.05). 동종 수혈은 RAP군에서 34명 중 7명에서(20.6$\%$), 대조군에서는 46명중 16명에서(34.8$\%$) 시행되어, RAP군에서 유의하게 빈도가 낮았다(Chi-square test, p < 0.05). 결론: 역행성 자가 충전법은 심폐바이패스의 충전에 의한 혈액희석을 최소화함으로서, 개심술 후 출혈과 동종수혈을 또한 줄이는 데 효과적인 방법이 될 수 있다고 생각된다.타내지 않았다.성 교사, 가정 전공 교사가 그렇지 않은 교사보다 해석적, 해방적 행동목표를 더 중요하게 인식하고 있었다. 특히 가정교육 철학을 배운 경험이 있는 교사가 그렇지 않은 교사보다 해방적 행동체계 목표를 중요시하는 것으로 나타났다. 이 연구 결과는, 실천 비판적인 가정 교과의 본질을 구현하기 위해서는 주생활 영역의 교육과정에 기술적, 해석적, 해방적 행동에 대한 목표들을 고루 포함하여야 하며 특히 The East Sea, a marginal sea or back-arc basin, consists of Japan Basin, Yamato Basin, and Ulleung Basin and is surrounded by the Pacific Plate and Philippine Sea Plate. Ulleung Basin locates in the southwestern part of the East Sea and shows the depth of 1,500 m in average and 2,500 m in maximum, connecting to the Japan Basin along 2,000 m contour. The slope of the seafloor is greater in the western side of the basin than in the southern and the eastern side. The crustal thickness of the Ulleung Basin from the OBS tends to get thicker toward the north and the west side and the sediment thickness of the Ulleung Basin is getting thicker toward the southeast side and reaches up to 12 km. The crustal type of the Ulleung Basin was variously suggested as like as a rifted continental crust, an extended continental crust, and an incipient oceanic trust. The origin of the crustal formation and the Ulleung Basin, however, is still controversial. Based on the bathymetry and gravtiy anomaly data for this study, the axis of the Ulleung Basin shows that the basin develops along the axis trending NW-SE direction and reveals a general symmetry of the bathymetry. And also the free-air gravity anomalies show a very similar pattern to the bathymetry of the basin. The sediment thickness is relatively thicker in the southeastern side of the basin than in the northwestern side. Although the crustal age of the Ulleung Basin is supposed to be younger than them of the Japan Basin and the Yamato Basin, the free-air gravity anomalies of the Ulleung Basin ranging -40 to 50 mGals are lower than the other basins, which suggests that the densities of crust and sediment of the Ulleng Basin are lower than the Japan Basin and the Yamato Basin.

SrAl₂O₄: Eu²⁺, Dy³⁺ 축광안료의 고온안정성에 관한 연구

김진호,이승용,김태호,한규성,황광택,조우석,Kim, Jin-Ho,Lee, Seung-Yong,Kim, Tae-Ho,Han, Kyu-Sung,Hwang, Kwang-Taek,Cho, Woo-Seok 한국세라믹학회 2014 한국세라믹학회지 Vol.51 No.6

Oxide phosphorescent phosphor has an wide application in ceramic art and decoration due to its chemical and mechanical properties. Here, phosphorescent properties of strontium aluminate phosphor ($SrAl_2O_4:Eu^{2+}$, $Dy^{3+}$) emitting yellowish-green light was investigated with thermal treatment at $1250^{\circ}C$ under air and reducing atmosphere. The characterizations of thermally treated samples were analyzed using X-ray fluorescence (XRF), X-ray diffraction (XRD), scanning electron microscopy (SEM), energy-dispersive X-ray spectroscopy (EDX), fluorescence spectrometer. $SrAl_2O_4:Eu^{2+}$, $Dy^{3+}$ still showed a good phosphorescent properties after annealing process in reducing atmosphere, while phosphorescence of $SrAl_2O_4:Eu^{2+}$, $Dy^{3+}$ annealed in air seriously degraded, due to oxidation of $Eu^{2+}$ to $Eu^{3+}$ ions. It was also observed that $SrAl_2O_4:Eu^{2+}$, $Dy^{3+}$ annealed in reducing atmosphere emitted yellowish-green light during 3 h after being exposed to sunlight.