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

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

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

단치소요산가감방(丹梔逍遙散加減方)이 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, J.H.,Seo, Y.H.,Lee, H.K. 한국전자통신연구원 2004 전자통신동향분석 Vol.19 No.4

네트워크 환경의 발전과 디지털 미디어 저작툴의 발전으로 이미지, 오디오, 비디오, 전자 문서 등의 멀티미디어 데이터는 시공간적 차이 없이 인터넷에서 빠르게 배포되고 있다. 품질의 손실 없이 무한 복제가 가능한 디지털 콘텐츠의 특성 및 저작권에 대한 의식의 부족 때문에 이들 데이터의 불법 복제 및 무단 배포가 일어나고 있다. 이와 동시에 디지털 콘텐츠의 저작권 정보를 보호하기 위한 워터마킹 기술도 연구개발이 활발하게 진행되고 있다. 또한 워터마킹 기술의 취약성을 밝히는 워터마크 공격 기술도 워터마킹 기술의 발전과 더불어 개발되고 있는 상황이다. 본 고에서는 다양한 워터마킹 기술들의 성능을 검증하기 위해 어떠한 워터마크 공격 기술과 워터마크 평가 기술이 있는지 동향을 파악하고 이러한 기술의 내용을 살펴본다. 또한 워터마크 공격 기술과 평가 기술에 관련된 최근의 국제 표준화 현황도 살펴본다.

생태계 모델을 이용한 마산만 퇴적물 준설이 수질에 미치는 영향 정량평가

김진호,김동명,Kim, Jin-Ho,Kim, Dong-Myung 해양환경안전학회 2016 해양환경안전학회지 Vol.22 No.5

퇴적물 준설은 수서생태계에서 오염물질을 영구적으로 제거하는 것으로 수서생태계 복원에 있어서 효율적인 방법으로 여겨진다. 본 연구에서는 수괴의 산소 요구율의 계산을 통해 마산만의 퇴적물 준설이 수질에 미치는 영향을 정량화하였다. 이를 위해 수질 및 저질 모델이 포함된 생태계 모델을 마산만에 적용시켰다. 모델 계산 결과, 육상 오염원이 감소할수록 수괴의 산소 요구율이 다소 증가한 반면에 만내측과 만외측의 준설에 의해서는 산소 요구율이 크게 증가하였다. 이러한 결과는 퇴적물 준설이 마산만 수질을 더욱 개선시킬 수 있음을 의미한다. 산소 요구율과 퇴적물 산소 요구량의 상관관계식을 통해 육상 부하량 10 % 감소에 의한 수질 개선효과에 상당하는 퇴적물 준설 면적이 만내측에서는 $1.68km^2$ 이며, 만외측에서는 $3.15km^2$ 임을 계산하였다. 이는 마산만 수질 개선을 위해서는 만내측의 퇴적물 준설이 효율적 방법임을 의미한다. Sediment dredging can permanently remove pollutants from an aquatic ecosystem, which is considered an effective approach to aquatic ecosystem restoration. In this study, we quantified the effects of sediment dredging on water quality in Masan Bay by calculation of oxygen demanding rate. We applied ecosystem model including water and sediment quality module in Masan Bay. The results showed that the increase of calculated oxygen demanding rate is significant due to sediment dredging of both inner part and outer part of Masan Bay. On the other hand, the increase is gradual due to decrease of anthropogenic load. It meant sediment dredging can improve water quality of Masan Bay more. Using correlation equation between oxygen demanding rate and sediment oxygen demand, we calculated that the area of sediment dredging which is equal to the effects of 10 % reduction of anthropogenic load. It is $1.68km^2$ in inner part and $3.15km^2$ in outer part of the Masan Bay. This Meant that to improve water quality of Masan Bay, sediment dredging in inner part is efficient method.

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

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

토끼의 바이러스성(性) 출혈증(出血症) 감염시(感染時) 신장(腎臟)의 광학(光學) 및 전자현미경적(電子顯微鏡的) 관찰(觀察)

김진호,정치영,박남용,Kim, Jin-ho,Chung, Chi-young,Park, Nam-yong 대한수의학회 1989 大韓獸醫學會誌 Vol.29 No.2

In order to observe the pathological changes of kidney in rabbits infected with the viral haemorrhagic disease, the kidney tissues from the 91 rabbits infected with the viral haemorrhagic disease were examined by light and electron microscopy. The results observed were as follows: 1. On light microscopic observation, the kidney lesions were identified as haemorrhagic glomerular necrosis(33.0%), membranous glomerulonephritis(20.9%), thrombotic glomerulopathy(19.8%), membranoproliferative glomerulonephritis(8.8%), mesangial proliferative glomerulonephritis(8.8%) ischemic acute tubular necrosis(7.7%), and acute serous glomerulitis(6.6%). 2. On electron microscopic observation, cytoplasmic degeneration of mesangial cells, and irregular thickening of basement membranes with electron dense granular materials were observed. In podocytes swelling of mitochondria, dilatation of endoplasmic reticulum and extensive fusion of foot processes were also observed. Nonenveloped round icosahedral picornaviral particles with a diameter of 28~33nm were detected in the cytoplasm of degenerative endothelial cells, polymorphonuclear leucoytes, and monocytes.

국내 데이터베이스기술 활성화를 위한 방안

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