공간 데이터웨어하우스에서 효율적인 공간 데이터 적재를 위한 이기종 데이터 소스의 비중복 추출기법

이동욱,백성하,김경배,배해영,Lee, Dong-Wook,Baek, Sung-Ha,Kim, Gyoung-Bae,Bae, Hae-Young 한국공간정보학회 2009 한국공간정보시스템학회 논문지 Vol.11 No.2

공간 데이터웨어하우스는 공간 DBMS 또는 다양한 소스데이터로부터 시간에 따라 추출된 공간데이터를 ETL 과정을 통해 가공된 데이터를 관리하는 시스템이다. 적재 주기 마다 추출된 공간데이터는 비공간 데이터와 달리 같은 주제의 중복된 공간 정보가 유용하지 않으며, 공간 데이터의 특징으로 저장 공간의 낭비가 크다. 또한 이기종간의 시스템에서 소스 데이터를 추출할 경우 서로 다른 공간데이터 타입 및 스키마를 가지고 있어 이를 위한 공간데이터 추출 기법이 요구된다. 기존 기법에서는 기준이 되는 Geocoding DB를 이용하여 추출된 공간데이터에 대한 주소 매칭과정을 수행함으로써, 정형화된 데이터 셋을 적재한다. 하지만 이 기법은 추출 데이터를 매번 Geocoding DB와 비교 연산이 발생하며, 주제별로 공간 데이터를 통합 관리함에 따라 이 기종 공간 DBMS 사이에 중복된 데이터를 고려하지 않는 문제점이 있다. 본 논문에서는 공간 데이터웨어하우스 구축기 내에서 이 기종의 소스 시스템으로부터 추출된 갱신질의 통합을 이용한 효율적 추출 기법을 제안한다. 이는 이 기종의 공간 DBMS로부터 발생한 과거 적재 시점부터 현재까지 발생한 질의 중 삽입이나 삭제 등의 업데이트 관련 질의만을 추출하여 공간데이터의 불필요한 추출 연산 비용을 제거한다. 또한 소스 공간 데이터베이스 관리시스템의 업데이트 질의를 이용하여 추출된 공간 데이터를 주제별로 중복 제거 및 통합 한다. 제안 기법은 데이터 중복 저장에 의한 저장 공간의 낭비를 줄이고, 적재시점 별 통합된 데이터를 적재함으로써 빠른 공간데이터 분석을 지원할 수 있다. Spatial data warehouses are a system managing manufactured data through ETL step with extracted spatial data from spatial DBMS or various data sources. In load period, duplicated spatial data in the same subject are not useful in extracted spatial data dislike aspatial data and waste the storage space by the feature of spatial data. Also, in case of extracting source data on heterogeneous system, as those have different spatial type and schema, the spatial extract method is required for them. Processing a step matching address about extracted spatial data using a standard Geocoding DB, the exiting methods load formal data set. However, the methods cause the comparison operation of extracted data with Geocoding DB, and according to integrate spatial data by subject it has problems which do not consider duplicated data among heterogeneous spatial DBMS. This paper proposes efficient extracting method to integrate update query extracted from heterogeneous source systems in data warehouse constructer. The method eliminates unnecessary extracting operation cost to choose related update queries like insertion or deletion on queries generated from loading to current point. Also, we eliminate and integrate extracted spatial data using update query in source spatial DBMS. The proposed method can reduce wasting storage space caused by duplicate storage and support rapidly analyzing spatial data by loading integrated data per loading point.

수평원관속에 동심으로 놓여있는 얼음 봉의 융해현상에 관한 보험적 연구

이동욱,유상신,Lee, Dong-Wook,Yoo, Sang-Sin 대한설비공학회 1986 설비저널 Vol.15 No.2

The melting phenomena of horizontal cylindrical ice-bar immersed in water and air concentrically in the cylinder are experimentally investigated for the temperature range from $3.5^{\circ}C\;to\;2.5^{\circ}C$. The shapes of the melting ice-bar are recorded photographically by the shadowgraph method. The shadowgraphs of the melting ice-bar show that water adjacent to the bar flows upward for the temperature range from $3.5^{\circ}C\;to\;5.8^{\circ}C$ while above $5.8^|\circ}C$ the flow is downward direction. The local and average Nusselt numbers are obtoined with the recorded shadowgraphs and comparator. Melting shapes of the ice-bar in the air show the vortex motion in the bottom portion of the bar, whereas no vortex motion appears in the bottom portion when the bar is melted in the water.

Metal-citrate Process를 이용한 마이크로파 유전체용 (Pb_0.5Ca_0.5)(Fe_0.5Nb_0.5)O₃ 나노 분말의 저온 합성

이동욱,원종한,심광보,강승구,현부성,Lee, Dong-Wook,Won, Jong-Han,Shim, Kwang-Bo,Kang, Seung-Gu,Hyun, Boo-Sung 한국세라믹학회 2002 한국세라믹학회지 Vol.39 No.11

마이크로파 유전체용 $(Pb_{0.5}Ca_{0.5})(Fe_{0.5}Nb_{0.5})O_3$ (PCFN) 나노 분말을 metal-citrate 공정을 이용하여 합성하였다. 금속 이온들과 유기 조직의 결합으로 이루어진 고분자 전구체를 형성시키고 이를 열처리하여 화학양론적 조성과 균일한 크기 분포를 갖는 PCFN 분말을 성공적으로 합성하였다. 초기 비정질상 PCFN 분말은 약 $400{\circ}$에서부터 결정화가 시작되어 $700{\circ}$에서 완전한 결정화를 이루었고, $900{\circ}$ 이상에서는 PbO의 해리로 인한 pyrochlore상이 생성되었다. $700{\circ}$에서 열처리된 단일상의 perovskite PCFN 분말은 약 40 nm의 평균 크기와 균일한 형상으로 분포되어 있었다. Nano sized $(Pb_{0.5}Ca_{0.5})(Fe_{0.5}Nb_{0.5})O_3$ (PCFN) powders with the stoichiometric composition and the uniform size distribution were successfully synthesized by the metal-citrate process through the calcination of the polymeric precursor which consisted of the metal ions and the organic network. The crystallization of the initial amorphous powders began at $400{\circ}$ and completed at $700{\circ}$. The pyrochlore phase was detected caused by the dissociation of PbO above $900{\circ}$. Single phase perovskite PCFN powders with 40 nm size and uniform shape were obtained through the calcination at $700{\circ}$.

흰쥐 간 마이크로좀의 cytochrome P - 450 의존성 testosterone hydroxylase 의 활성도 측정

이동욱,박기현 ( Dong Wook Lee,Ki Hyun Park ) 생화학분자생물학회 1988 BMB Reports Vol.21 No.3

A rapid and one time determinable TLC method for the monohydroxytestosterones formed by microsomal cytochrome P-450(P-450) was established, and applying this method the activity of P-450-dependent testosterone hydroxylases was observed in liver microsomes of rats pretreated with phenobarbital(PB). The 14 testosterone metabolites were found on the TLC plate. The amounts of 6-monohydroxytestosterones (2α-, 2β-, 6α-, 6β-,7α-and 16α-OH-T) were determined. The formation of these metabolites showed a good linearity(r = 0.9687-0.9999) corresponding to the concentration of P-450 added up to about 1.0 nmol/min/reaction mixture, and an excellent reproducibility (C.V.= 1.8 ± 1.0%) when determined with 0.5 nmol P-450 in this assay system. The hydroxylation of testosterone to its 2β-OH-T by PB-inducible P-450 was increased (2 fold), while 2α- and 7α-OH-T was rather decreased to 48 and 32%, respectively, compared with those of uninduced one. The 6β-OH-T was predominantly formed by uninducible and PB-inducible P-450, especially PB-inducible P-450 hydroxylated stereospecifically onto the C2-position of testosterone (2α/2β =1: 3.8). However, the oxidation rates of testosterone to its 6α-, 6β- and 16α-OH-T, and the total amount of testosterone metabolites identified were not changed, significantly by the administration of PB.

대용량 데이터스트림 실시간 압축 저장을 위한 저장관리자 설계 및 구현

이동욱,백성하,김경배,배해영,Lee, Dong-Wook,Baek, Sung-Ha,Kim, Gyoung-Bae,Bae, Hae-Young 대한공간정보학회 2009 한국공간정보시스템학회 논문지 Vol.11 No.3

유비쿼터스 환경에서 발생하는 실시간 데이터스트림의 처리 및 관리에 대한 요구사항이 증가되고 있다. 특히 인터넷 보안, 공장 자동화 기기설비 관리 등에서 발생하는 데이터스트림은 대용량 데이터가 실시간으로 발생하는 특징을 가지고 있어 이를 처리하기 위한 특화된 DSMS의 저장관리자의 개발이 요구된다. Coral8과 같은 기존의 DSMS의 경우 일반적인 데이터스트림의 처리가 가능 하지만 초당 10만 건 이상의 대용량의 실시간 데이터스트림이 발생하는 특수한 상황의 경우 이에 대한 처리 성능이 부족하며, 이에 대한 저장이 불가능하다. 관련 분야에서 일반적으로 사용되는 오라클10g의 경우 저장, 관리 성능은 우수하지만 실시간 데이터스트림 처리에 대한 고려가 되어 있지 않다. 본 논문에서는 삼성전자, 하이닉스, HP 등에 반도체, LCD 제조공장의 생산 기계에서 발생하는 대용량 데이터스트림을 실시간 압축 저장이 가능한 DSMS 저장관리자를 설계 및 구현하였다. 본 문에서는 시스템의 구조 및 주요 컴포넌트에 대해 설명하며, 관련시스템과 비교 평가를 통해 제안 시스템의 우수성을 보인다. Requirement level regarding processing and managing real-time datastream in an ubiquitous environment is increased. Especially, due to the unbounded, high frequency and real-time characteristics of datastream, development of specialized stroge manager for DSMS is necessary to process such datastream. Existing DSMS, e.g. Coral8, can support datastream processing but it is not scalable and cannot perform well when handling large-volume real-time datastream, e.g. 100 thousand over per second. In the case of Oracle10g, which is generally used in related field, it supports storing and management processing. However, it does not support real-time datastream processing. In this paper, we propose specialized storage manager of DSMS for real-time compressed storing on semiconductor or LCD production facility of Samsung electronics, Hynix and HP. Hynix and HP. This paper describes the proposed system architecture and major components and show better performance of the proposed system compared with similar systems in the experiment section.

Assay of Cytochrome P-450-dependent Testosterone Hydroxylases in Liver Microsomes of Rats

이동욱,박기현,Lee, Dong-Wook,Park, Ki-Hyun 생화학분자생물학회 1988 한국생화학회지 Vol.21 No.3

흰쥐 간 마이크로좀의 cytochrome P-450(P-450)에 의해 생성된 testosterone의 monohydroxy 대사물을 동시에 쉽게 정량할 수 있는 TLC 방법을 정립하였다. 이 방법을 이용하여 phenobarbital(PB)로 유도된 흰쥐 간 마이크로좀의 P-450에 의한 testosterone의 대사를 관찰하였다. 생성된 14종의 대사물이 확인되었고 그중 6종의 monohydroxy 대사물($2{\alpha}-$, $2{\beta}-$, $6{\alpha}-$, $6{\beta}-$, $7{\alpha}-$ 그리고 $16{\alpha}$-monohydroxytestosterone)을 정량하였다. 설정한 반응조건에서 이들 대사물의 생성은 P-450의 농도(1nmol/0.5ml 반응액 이하)에 따라 양호한 직선 관계 (r=0.9687-0.9999)와 재현성(C.V=$1.8{\pm}1.0%$)을 나타내었다. 또한 PB로 유도된 P-450에 의한 $2{\beta}$-monohydroxytestosterone의 생성은 대조군에 비해 2배로 증가된 반면$2{\alpha}-$와 $7{\alpha}$-monohydroxytestosterone의 생성은 오히려 48, 32%로 각각 감소되었다. 그러나 확인된 대사물의 총함량은 서로 비슷하였다. A rapid and one time determinable TLC method for the monohydroxytestosterones formed by microsomal cytochrome P-450(P-450) was established, and applying this method the activity of P-450-dependent testosterone hydroxylases was observed in liver microsomes of rats pretreated with phenobarbital(PB). The 14 testosterone metabolites were found on the TLC plate. The amounts of 6-monohydroxytestosterones ($2{\alpha}-$, $2{\beta}-$, $6{\alpha}-$, $6{\beta}$, $-7{\alpha}$-and $16{\alpha}$-OH-T) were determined. The formation of these metabolites showed a good linearity(r = 0.9687-0.9999) corresponding to the concentration of P-450 added up to about 1.0 nmol/min/reaction mixture, and an excellent reproducibility (C.V.=$1.8{\pm}1.0%$) when determined with 0.5 nmol P-450 in this assay system. The hydroxylation of testosterone to its $2{\beta}$-OH-T by PB-inducible P-450 was increased (2 fold), while $2{\alpha}-$ and $7{\alpha}$-OH-T was rather decreased to 48 and 32%, respectively, compared with those of uninduced one. The $6{\beta}$-OH-T was predominantly formed by uninducible and PB-inducible P-450, especially PB-inducible P-450 hydroxylated stereospecifically onto the C2-position of testosterone $(2{\alpha}/2{\beta}=1:3.8)$. However, the oxidation rates of testosterone to its $6{\alpha}-$, $6{\beta}-$ and $16{\alpha}$-OH-T, and the total amount of testosterone metabolites identified were not changed significantly by the administration of PB.

흰쥐 신장의 NAD 의존성 α - glycerophosphate 탈수소 효소의 정제 및 성상

이동욱,이희성 ( Dong Wook Lee,Hee Sung Lee,Sung Hye Cho ) 생화학분자생물학회 1988 BMB Reports Vol.21 No.3

NAD-linked α-glycerophosphate dehydrogenase(EC 1.1.1.8) in rat kidney existed as four different isozymic forms with an isoelectric point at pH 6.9, 6.6, 6.4 and 6.2, respectively. The major isozymic form(PI 6.6) was purified using several chromatographic procedures involving an ion exchange and two affinity chromatography steps. The 1,078 fold purified enzyme was homogeneous, nucleotide free protein. The molecular weight of the major isozyme was 62,000 daltons, the optimal pH and temperature for its catalytic activity were 10.0 and 55℃, respectively. At the optimal temperature this enzyme was rapidly inactivated(t_(1/2) = 1.5 min). The major isozyme was activated by the addition of cations such as K^+, Na^+, Mg^(++) or Ca^(++), and was strongly inhibited by alkylating agents such as P-hydroxymercurybenzoate or iodoacetamide. Glycerophosphate oxidation reaction obeyed the Michaelis-Menton behavior with Km values of 3.22 and 0.31 mM for glycerophosphate and NAD, respectively. The data suggest that although the isozyme pattern of NAD-linked α-glycerophosphate dehydrogenase is quite different by tissue or species of the animal the physico-chemical properties of the major isozymic form are very similar each other except the affinity for substrate and coenzyme.

탄성표면파 PSK-MSK 변환 필터

이동욱,이재경,황금찬,Lee, Dong-Wook,Lee, Jae-Kyong,Whang, Keum-Chan 한국음향학회 1990 韓國音響學會誌 Vol.9 No.2

MSK waveforms are advantageous from the point of view of reduced interchannel interference. MSK waveform, however, is more difficult to generate than PSK due to its complex pulse shape. A SAW filter is ideally suited for generation of MSK waveform because it provides accurate control of the required impulse responese and linear phase at high frequncies. In this paper, an implementation of SAW based PSK-MSK convert filter, which can easily convert the high frequency PSK waveform to MSK, is studied. MSK 신호는 PSK 신호보다 좁은 주파수 대역을 차지하여 채널간 간섭을 줄을 수 있는 장점이 있지만, 고주파 대역에서는 신호를 만들기 어렵다. 본 논문에서는 탄성표면과 필터가 고주파 대역에서도 원하는 임펄스 응답과 선형 위상 특성을 얻기 용이하다는 장점을 이용하여 손쉽게 고주파 PSK 신호를 MSK 신호로 실시간 변환 처리하는 탄성표면과 PSK-MSK 변환 필터를 설계 제작하고 그특성을 고찰하였다.

소나무 꽃가루에서 분리한 Trehalase 의 정제 및 성상에 관한 연구

이동욱,이희성,조성희 ( Dong Wook Lee,Hi Sung Lee,Sung Hee Cho ) 생화학분자생물학회 1981 BMB Reports Vol.14 No.2

Trehalose, the alpha-1, 1 linked disaccharide of glucose, occurs widely in nature. This sugar has been isolated from bacteria, yeast, fungi and a number of invertebrates, where it functions as reserve carbohydrate. Trehalase(α,α-trehalose 1-D-glucohydrolase, EC 3. 2. 1. 28. ) responsible for the hydrolysis of trehalose was isolated from pine pollen(Pinus densiflora Siebold) and purified 81 times by DEAE-cellulose column and Sephadex G-200 column chromatography. The activity of trehalase was measured by method of Lapp and Mason. The enzyme activity in pine pollen was detected 80.46% in cytosolic fraction, 4.09% in mitochondria) fraction and 10.33% in nucleic fraction. The pH optimum for enzymatic activity was found to be 5.4 and optimal temperature was 60℃ and the Km value for trehalose was estimated to be about 2. 56 × 10^(-3)M. The product of reaction was identited as D-glucose by paper chromatographic method. The trehalase activity was activated as much as 14∼17% by 1 × 10^(-4)M∼1 × 10^(-3)M concentration of Na^+, and 27∼15% by 1 × 10^(-5)∼1 × 10^(-4)M of Mg^(++), and the other cations(K+, Ca++) were tested for their abillity to replace Mg^(++), but none was effective. The molecular weight of trehalase was estimated to be approximately 70,000 by Sephadex G-200 gel filtration.

Purification and Properties of the Major Isozymic Form of NAD-linked ${\alpha}$-Glycerophosphate Dehydrogenase from Rat Kidney

이동욱,이희성,조성희,Lee, Dong-Wook,Lee, Hee-Sung,Cho, Sung-Hye 생화학분자생물학회 1988 한국생화학회지 Vol.21 No.3

흰쥐 신장의 NAD 의존성 ${\alpha}$-glycerophosphate 탈수소 효소는 4종의 isozyme으로 존재하였고 그들의 등전점은 pH6.9, 6.6, 6.4 및 6.2였다. 이들중 등전점 6.6인 major isozyme을 blue dextran-Sepharose 4B, DEAE-cellulose, Sephadex G-100 chromatography를 통하여 1,078배 정제하였다. Major isozyme의 분자량은 62,000이고, 반응 최적온도와 pH는 각각 55도 및 10.0이었고, 최적온도에서 쉽게 불활성화 되었다. 이 효소는 일가 및 이가 양이온의 첨가에 의해 활성화 되었으며 p-HMB와 iodoacetamide에 의해 활성이 크게 억제되었고, glycerophosphate와 NAD에 대한 Km값은 각각 3.22 및 0.31 mM 이었다. 이들 결과로부터 이 효소의 isozyme pattern은 조직에 따라 다를지라도 major isozyme의 이화학적 성상은 서로 비슷함을 알 수 있었다. NAD-linked ${\alpha}$-glycerophosphate dehydrogenase(EC 1.1.1.8) in rat kidney existed as four different isozymic forms with an isoelectric point at pH 6.9, 6.6, 6.4 and 6.2, respectively. The major isozymic form(PI 6.6) was purified using several chromatographic procedures involving an ion exchange and two affinity chromatography steps. The 1,078 fold purified enzyme was homogeneous, nucleotide free protein. The molecular weight of the major isozyme was 62,000 daltons, the optimal pH and temperature for its catalytic activity were 10.0 and $55^{\circ}C$, respectively. At the optimal temperature this enzyme was rapidly inactivated$(t_{1/2}=1.5min)$. The major isozyme was activated by the addition of cations such as $K^+$, $Na^+$, $Mg^{++}$ or $Ca^{++}$, and was strongly inhibited by alkylating agents such as P-hydroxymercurybenzoate or iodoacetamide. Glycerophosphate oxidation reaction obeyed the Michaelis-Menton behavior with Km values of 3.22 and 0.31 mM for glycerophosphate and NAD, respectively. The data suggest that although the isozyme pattern of NAD-linked ${\alpha}$-glycerophosphate dehydrogenase is quite different by tissue or species of the animal the physico-chemical properties of the major isozymic form are very similar each other except the affinity for substrate and coenzyme.