• 제목/요약/키워드: ETL

검색결과 143건 처리시간 0.026초

OMOP CDM 기반 의료 데이터 ETL 툴 개발 (Development of A HealthcareData ETL Tool Based on OMOP CDM)

  • 한만욱;이푸름;이호웅
    • 한국정보처리학회:학술대회논문집
    • /
    • 한국정보처리학회 2023년도 추계학술발표대회
    • /
    • pp.1224-1225
    • /
    • 2023
  • 디지털 헬스케어 서비스 활성화에 따라 디지털 의료 데이터의 양은 매년 급속하게 증가하고 있으며, 의 데이터의 상호 교환과 연동을 위한 다양한 CDM(Common Data Model)이 개발되고 있다. 그러나, 의료 데이터 교류에 대한 요구가 증가하면서, 기존 레거시 시스템의 데이터를 CDM으로 변환하기 위한 추가적인 비용이 소요될 수 밖에 없다. 이에 본 연구에서는 OMOP CDM (Observational Medial Outcomes Partnership Common DataModel) 기반 의료 데이터 ETL (Extract, Transform, Load) 툴을 개발하였다. OMOP CDM ETL 툴은 기존의 레거시 데이터베이스 정보를 CDM으로 변환할 수 있는 효과적인 료인터페이스를 제공함으로써, 디지털 의료 데이터 공유와 관리 및 분석의 효율성을 증대할 수 있을 것이다.

Effective Interfacial Trap Passivation with Organic Dye Molecule to Enhance Efficiency and Light Soaking Stability in Polymer Solar Cells

  • Rasool, Shafket;Zhou, Haoran;Vu, Doan Van;Haris, Muhammad;Song, Chang Eun;Kim, Hwan Kyu;Shin, Won Suk
    • Current Photovoltaic Research
    • /
    • 제9권4호
    • /
    • pp.145-159
    • /
    • 2021
  • Light soaking (LS) stability in polymer solar cells (PSCs) has always been a challenge to achieve due to unstable photoactive layer-electrode interface. Especially, the electron transport layer (ETL) and photoactive layer interface limits the LS stability of PSCs. Herein, we have modified the most commonly used and robust zinc oxide (ZnO) ETL-interface using an organic dye molecule and a co-adsorbent. Power conversion efficiencies have been slightly improved but when these PSCs were subjected to long term LS stability chamber, equipped with heat and humidity (45℃ and 85% relative humidity), an outstanding stability in the case of ZnO/dye+co-adsorbent ETL containing devices have been achieved. The enhanced LS stability occurred due to the suppressed interfacial defects and robust contact between the ZnO and photoactive layer. Current density as well as fill factors have been retained after LS with the modified ETL as compared to un-modified ETL, owing to their higher charge collection efficiencies which originated from higher electron mobilities. Moreover, the existence of less traps (as observed from light intensity-open circuit voltage measurements and dark currents at -2V) are also found to be one of the reasons for enhanced LS stability in the current study. We conclude that the mitigation ETL-surface traps using an organic dye with a co-adsorbent is an effective and robust approach to enhance the LS stability in PSCs.

데이터 레이크 구축을 위한 Apache NiFi기반 ETL 프로세스 (Apache NiFi-based ETL Process for Building Data Lakes)

  • 이경민;이경희;조완섭
    • 한국빅데이터학회지
    • /
    • 제6권1호
    • /
    • pp.145-151
    • /
    • 2021
  • 최근 들어 인간의 모든 활동 영역에서 디지털 데이터가 생성되고 있고 데이터를 안전하게 저장하고 가공하여 유용한 서비스를 개발하려는 시도가 많아지고 있다. 데이터 레이크는 데이터의 출처나 데이터를 활용하는 분석 프레임워크에 독립된 데이터 저장소를 말한다. 본 논문에서는 스마트시티에서 생성되는 다양한 빅데이터를 데이터 레이크에 안전하게 저장하고 서비스에서 활용할 수 있게 ETL 하는 도구와 이를 효과적으로 사용하는데 필요한 웹기반 도구를 설계하고 구현한다. 원천 데이터를 품질검사하고 정제하여 데이터 레이크에 안전하게 저장한 다음 데이터 수명주기 정책에 따라 관리하는 일련의 과정(ETL)은 대부분 비용이 많이 드는 인프라와 개발 및 유지 관리에 상당한 노력이 필요한 기술이다. 구현기술을 통해 IT분야 전문지식이 없어도 가시적이고 효율적으로 ETL 작업 모니터링, 데이터 수명주기 관리 설정과 실행이 가능하다. 이와는 별개로 데이터 레이크에 신뢰할 수 있는 데이터를 저장하고 사용하려면 데이터 품질검사 리스트 가이드가 필요하다. 또한, 데이터 수명주기 관리 도구를 통해 데이터 마이그레이션 및 삭제 주기를 설정하고 예약하여 데이터 관리 비용을 줄일 수 있어야 한다.

고휘도 녹색 인광 OLED 제작에서 전자수송층 처리 (Treatments of Electron Transport Layer in the Fabrication of High Luminous Green Phosphoresent OLED)

  • 장지근;김원기;신상배;신현관
    • 반도체디스플레이기술학회지
    • /
    • 제7권3호
    • /
    • pp.5-9
    • /
    • 2008
  • New devices with structure of ITO/2TNATA/NPB/TCTA/CBP:7%Ir(ppy)$_3$/BCP/ETL/LiF/Al were proposed to develop high luminous green phosphorescent organic light emitting diodes and their electroluminescent properties were evaluated. The experimental devices were divided into two kinds according to the material ($Alq_3$ or SFC137) used as an electron transport layer (ETL). Luminous intensities of the devices using $Alq_3$ and SFC137 as electron transport layers were 27,500 cd/$m^2$ and 51,500 cd/$m^2$ at an applied voltage of 9V, respectively. The current efficiencies of both devices were similar as 12.6 cd/A under a luminance of 10,000 cd/$m^2$, while showed slower decay in the device with SFC137 as an ETL according to the further increase of luminance. Current density and luminance of the device with SFC137 as an electron transport layer were higher at the same voltage than those of the device with $Alq_3$ as an ETL.

  • PDF

빅데이터 분석을 위해 아파치 스파크를 이용한 원시 데이터 소스에서 데이터 추출 (Capturing Data from Untapped Sources using Apache Spark for Big Data Analytics)

  • ;구흥서
    • 전기학회논문지
    • /
    • 제65권7호
    • /
    • pp.1277-1282
    • /
    • 2016
  • The term "Big Data" has been defined to encapsulate a broad spectrum of data sources and data formats. It is often described to be unstructured data due to its properties of variety in data formats. Even though the traditional methods of structuring data in rows and columns have been reinvented into column families, key-value or completely replaced with JSON documents in document-based databases, the fact still remains that data have to be reshaped to conform to certain structure in order to persistently store the data on disc. ETL processes are key in restructuring data. However, ETL processes incur additional processing overhead and also require that data sources are maintained in predefined formats. Consequently, data in certain formats are completely ignored because designing ETL processes to cater for all possible data formats is almost impossible. Potentially, these unconsidered data sources can provide useful insights when incorporated into big data analytics. In this project, using big data solution, Apache Spark, we tapped into other sources of data stored in their raw formats such as various text files, compressed files etc and incorporated the data with persistently stored enterprise data in MongoDB for overall data analytics using MongoDB Aggregation Framework and MapReduce. This significantly differs from the traditional ETL systems in the sense that it is compactible regardless of the data formats at source.

원자층 증착법과 용액 공정법으로 성장한 전자 수송층 산화주석 박막의 페로브스카이트 태양전지 특성 (Characteristics of Tin Oxide Thin Film Grown by Atomic Layer Deposition and Spin Coating Process as Electron Transport Layer for Perovskite Solar Cells)

  • 김기현;정성진;양태열;임종철;장효식
    • 한국재료학회지
    • /
    • 제33권11호
    • /
    • pp.475-481
    • /
    • 2023
  • Recently, the electron transport layer (ETL) has become one of the key components for high-performance perovskite solar cell (PSC). This study is motivated by the nonreproducible performance of ETL made of spin coated SnO2 applied to a PSC. We made a comparative study between tin oxide deposited by atomic layer deposition (ALD) or spin coating to be used as an ETL in N-I-P PSC. 15 nm-thick Tin oxide thin films were deposited by ALD using tetrakisdimethylanmiotin (TDMASn) and using reactant ozone at 120 ℃. PSC using ALD SnO2 as ETL showed a maximum efficiency of 18.97 %, and PSC using spin coated SnO2 showed a maximum efficiency of 18.46 %. This is because the short circuit current (Jsc) of PSC using the ALD SnO2 layer was 0.75 mA/cm2 higher than that of the spin coated SnO2. This result can be attributed to the fact that the electron transfer distance from the perovskite is constant due to the thickness uniformity of ALD SnO2. Therefore ALD SnO2 is a candidate as a ETL for use in PSC vacuum deposition.

Enhanced efficiency of organic light-emitting diodes by doping the electrontransport layer

  • Lee, Hyun-Koo;Kwon, Do-Sung;Lee, Chang-Hee
    • 한국정보디스플레이학회:학술대회논문집
    • /
    • 한국정보디스플레이학회 2005년도 International Meeting on Information Displayvol.II
    • /
    • pp.1410-1412
    • /
    • 2005
  • We present that the electroluminescence (EL) efficiency can be improved by doping an electron transport layer (ETL) with organic materials which can make electron current increase. The electron transport layer of aluminum tris(8 -hydroxyquinoline) (Alq3) is doped with 2-(4-Biphenylyl)-5-(4-tertbutylphenyl)- 1,3,4-oxadiazole) (butyl-PBD) to enhance the electron mobility of the ETL. The higher quantum efficiency of device having ETL using Alq3 doped with butyl-PBD can be attributed to the improved electron and hole balance.

  • PDF

Characteristic Improvements of Organic Light Emitting Diodes By Using Co-Evaporated Cathodes

  • Kwak, Y.H.;Lee, Y.S.;Park, J.H.;Choi, Jong-Sun
    • 한국정보디스플레이학회:학술대회논문집
    • /
    • 한국정보디스플레이학회 2002년도 International Meeting on Information Display
    • /
    • pp.710-713
    • /
    • 2002
  • In order to improve the power efficiency of multi-layer organic light emitting diodes (OLEDs), electron injection into ETL(electron transport layer) from cathode at the interface between ETL and cathode was enhanced by interposing a proper electron injection layer at the interface. The HTL(hole transport layer) and ETL materials used were N, N'diphenyl- N, N' - bis(3-methylphenyl-1, 1'- biphenyl - 4, 4 'diamine (TPD) and tris (8-hydroxyquinoline) aluminum ($Alq_3$) respectively. Cathodes using co-evaporated Al-CsF, Al-KF, and Al-NaF composites are adopted to enhance the electrical and optical properties of OLEDs. OLEDs with alkaline metal-doped cathode show a luminance of as high as 35,000 cd/$m^2$, and external quantum efficiency about 1.35 %. In addition, they show higher power efficiency at all bias conditions and good reproducibility.

  • PDF

PBD를 Hole Blocking Layer로 이용한 적색발광의 EL 소자 제작에 관한 연구 (The study on Red device using PBD as a Hole Blocking Layer)

  • 강민웅;김종성
    • 한국전기전자재료학회:학술대회논문집
    • /
    • 한국전기전자재료학회 2002년도 추계학술대회 논문집 Vol.15
    • /
    • pp.499-501
    • /
    • 2002
  • 본 연구에서는 ETL층으로 널리 알려져 있는 PBD(2-(4-biphenyl)-5-(4-tert-butylphenyl) -1.3,4oxadiazole)를 HBL(Hole-blocking layer) 물질로 이용 하고 Nile red를 사용하여 적색 발광의 EL(electroluminescence) 소자를 제작 평가하였다. 일반적인 유기 EL 소자의 구조인 Anode/HTL(Hole Transport Layer)/ETL(Electron Transport Layer)/Cathode로 이루어져 있다. 여기에 HTL과 ETL사이에 HBL를 추가하여 EL 소자의 성능을 향상 시킬 수 있으면, 이러한 구조의 최종 소자를 제작 EML(emitting layer; Nile red)의 두께 및 임계전압을 달리 하여 소자 의 특성을 평가 연구 하였다.

  • PDF

Improved stability of organic light-emitting diodes with lithium-quinolate doped electron transport layer

  • Choi, Sung-Hoon;Kim, Sang-Dae;Han, Kyu-Il;Lee, Se-Hee;Park, Eun-Jung;Kum, Tae-Il;Jung, Young-Kwan;Lee, Seok-Jong;Lee, Nam-Yang
    • 한국정보디스플레이학회:학술대회논문집
    • /
    • 한국정보디스플레이학회 2009년도 9th International Meeting on Information Display
    • /
    • pp.771-774
    • /
    • 2009
  • The Improved stability of organic light emitting diodes (OLEDs) containing lithium-quinolate (Liq) as the ETL doping material is investigated. The lifetime could be improved by threefold using the Liq-doped ETL structure. The improvement was attributed to the Liq-doped ETL, which improved hole-electron balance and has a good electrical stability. Additionally, when the Liq doped device was combined with an Mg/Al cathode, the OLED produced a longer lifetime than other device.

  • PDF