관계형 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.

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.

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

김진호,이상범,박광래,홍승길,이초롱,김민기,김용기,이상민,변영웅,고병구,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),오원석(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.

습식 공정법에 의한 초발수 $TiO_2$ 박막 제조

김진호,정현호,황종희,임태영,최덕균,정덕수,김세훈,Kim, Jin-Ho,Jung, Hyun-Ho,Hwang, Jong-Hee,Lim, Tae-Young,Choi, Duk-Gun,Cheong, Deock-Soo,Kim, Sae-Hoon 한국결정성장학회 2009 韓國結晶成長學會誌 Vol.19 No.5

초발수 $TiO_2$ 박막을 습식 공정법에 의해 유리 기판 위에 성공적으로 제조하였다. Micro-nano 복합구조의 거친 표면을 갖는 박막을 제조하기 위하여 layer-by-layer(LBL) deposition 법과 liquid phase deposition(LPD) 법이 이용되었다. 초발수 박막은 LBL 법에 의해 texture 구조를 갖는(PAH/PAA) 박막을 제조 한 후 그 위에 LPD 법에 의해 $TiO_2$ 나노 입자를 적층시키고 그 표면을 fluoroalkyltrimethoxysilane(FAS)를 사용하여 발수 처리를 하여 제조하였다. $(PAH/PAA)_{10}$ 박막의 표면에 45분 동안 $TiO_2$를 적층한 박막은 RMS roughness가 65.6 nm로 거친 표면을 보여주었고 발수 처리 이후에 접촉각 $155^{\circ}$ 정도의 초발수 특성과 함께 파장 650 nm 이상에서는 80% 이상의 투과율을 보여주었다. 서로 다른 조건에서 제조된 박막의 표면 구조,광학적 특성, 접촉각을 FE-SEM, AFM, UV-Vis, contact angel meter를 이용하여 측정하였다. Superhydrophobic $TiO_2$ thin films were successfully fabricated on a glass substrate by wet process. Layer-by-layer (LBL) deposition and liquid phase deposition (LPD) methods were used to fabricate the thin films of micro-nano complex structure with a high roughness. To fabricate superhydrophobic $TiO_2$ thin films, the (PAH/PAA) thin films were assembled on a glass substrate by LBL method and then $TiO_2$ nanoparticles were deposited on the surface of (PAH/PAA) thin film by LPD method, Subsequently, hydrophobic treatment using fluoroalkyltrimethoxysilane (FAS) was carried out on the surface of prepared $TiO_2$ thin films. The $TiO_2$ thin film fabricated with 45 minutes immersion time on $(PAH/PAA)_{10}$ showed the RMS roughness of 65.6nm, water contact angel of $155^{\circ}$ and high transmittance of above 80% (>650nm in wavelength) after the hydrophobic treatment. The Surface morphologies, optical properties and contact angel of prepared thin films with different experimental conditions were measured by field emission scanning electron microscope (FE-SEM), atomic force microscope (AFM), UV-Vis spectrophotometer and contact angle meter.

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

김진호,박성은,김영민,김청숙,강성찬,정우성,심보람,엄기혁,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.

전이금속 이온과 Macrocyclic Ligand 사이의 반응에 관한 속도론적 연구 질소원자와 산소원자를 포함하는 거대고리 리간드를 중심으로

김진호,조문환,현동호,박휴범,김시중,이인종,Kim Jin-Ho,Cho Moon-Hwan,Hyeoun Dong-Ho,Park Hyu-Bum,Kim Si-Joong,Lee Ihn-Chong 대한화학회 1990 대한화학회지 Vol.34 No.5

새로이 합성된 거대고리 리간드 1,15,18-triaza-3,4;12,13-dibenzo-5,8,11-trioxa cycloeicosane (NdienOdienH$_4$)와 이미 합성된 거대고리 리간드 1,12,15-triaza-3,4;9,10-dibenzo-5,8-dioxa cycloheptadecane (NdienOenH$_4$)와 1,15-diaza-3,4;12,13-dibenzo-5,8,11-trioxa cycloheptadecane (NenOdienH$_4$)를 25$^{\circ}C$ 수용액에서 전위차계를 이용하여 양성자 첨가반응의 평형상수를 구하였다. 또한 위의 세 가지 리간드 각각과 Co(Ⅱ), Ni(Ⅱ), Cu(Ⅱ)의 금속이온과의 착물을 합성하여 25$^{\circ}C$수용액에서 안정도 상수를 전위차법으로 구하였다. 그리고 위의 착물 수용액에 에틸렌 디아민용액을 가해 착물의 리간드 치환반응 속도상수를 분광광도법으로 측정하였다. 그리고 활성화에너지와 활성화파라메타(${\{Delta}H^{\neq}$, ${\{Delta}S^{\neq}$)를 구하여 이 반응계의 타당한 메카니즘을 제안하였다. The protonation constants for the macrocyclic ligands 1,15,18-triaza-3,4;12,13-dibenzo-5,8,11-trioxa cycloeicosane (NdienOdienH$_4$), 1,12,15-triaza-3,4;9,10-dibenzo-5,8-dioxa cycloheptadecane (NdienOenH$_4$), and 1,15-diaza-3,4;12,13-dibenzo-5,8,11-trioxa cycloheptadecane (NenOdienH4) have been determined by the potentiometry in aqueous solutions (25$^{\circ}C$, I = 0.1, KNO$_3$). The stability constants for complexes formed in the aqueous solution (25$^{\circ}C$, I = 0.1, KNO$_3$) between the above ligands and the metal ions (Co(Ⅱ), Ni(Ⅱ), and Cu(Ⅱ)) have been measured by potentiometry. The rate of the ligand substitution reaction was measured spectrophotometrically by the addition of aqueous solutions of ethylenediamine to the solution of the complex. From the study of the temperature effect on the rate constant (k$_{obs}$), activation parameters (E$_a$,${\{Delta}H^{\neq}$, and ${\{Delta}S^{\neq}$) have been determined. The possible mechanism for the substitution reaction is proposed.

국산 데이터베이스관리체제(DBMS) 총집합

김진호,Kim, Jin-Ho 한국데이터베이스진흥원 1993 디지털콘텐츠 Vol.10 No.-

데이터베이스관리시스템(DBMS)의 도입 및 평가를 위한 지침

김진호,Kim, Jin-Ho 한국데이터베이스진흥원 1993 디지털콘텐츠 Vol.7 No.-