• Proceedings of the Korea Information Processing Society Conference
• /
• 2009.11a
• /
• pp.153-154
• /
• 2009

최근 기업은 저장된 데이터를 비즈니스 인텔리전스 기반으로 통합하고 분석한다. 이를 위해서 기업들은 ETL(Extraction, Transformation, Loading) 기술을 이용하여 다양한 소스로부터 데이터를 추출하여 변환한 후 데이터웨어하우스에 저장한다. 그러나 데이터웨어하우스/데이터 마트 기반 비즈니스 인텔리전스 프로젝트들은 기존의 사용하던 툴이 기능상의 한계를 드러내면서 시스템 통합, 마이그레이션, 동기화 등의 어려움이 있다. 특히, 서로 다른 ETL 툴을 사용하는 경우 메타데이터의 통합, 데이터 실시간 동기화 기술, 데이터 표준화, 데이터 매칭 등이 어려워 부분적으로만 지원되고 있는 실정이다. 본 논문에서는 다양한 데이터 통합 및 추출, 변환하여 데이터웨어하우스에 저장할 수 있는 XMDR-DAI를 제안한다.

• 전기산업
• /
• v.3 no.1
• /
• pp.68-75
• /
• 1992

• Current Photovoltaic Research
• /
• v.9 no.1
• /
• pp.1-5
• /
• 2021

The properties of the electron transport layer (ETL) have a great effect on perovskite solar cell performance. Depositing conformal SnO2 ETL on bottom textured silicon cells is essential to increase current density in terms of the silicon-perovskite tandem solar cells. In the recent study, the SnO2 electron transport layer deposited by the sputtering method showed an efficiency of 19.8%. Also, an electron transport layer with a sputtered TiO2 electron transport layer in a 4-terminal tandem solar cell has been reported. In this study, we synthesized SnOx ETL with a various sputtering power range of 30-60W by Radio-frequency (RF)-magnetron sputtering. The properties of SnOx thin film were characterized using ellipsometer, UV-vis spectrometer, and IV measurement. With a sputtering power of 50W, the solar cell showed the highest efficiency of 13.3%, because of the highest fill factor by the conductivity of SnOx film.

• The KIPS Transactions:PartD
• /
• v.10D no.3
• /
• pp.407-416
• /
• 2003

As the usage of database systems dramatically increases and the amount of data pouring into them is massive, the performance administration techniques for using database systems effectively are getting more important. Especially in data warehouses, the performance management is much more significant mainly because of large volume of data and complex queries. The objectives and characteristics of data warehouses are different from those of other operational systems so adequate techniques for performance monitoring and tuning are needed. In this paper we extend functionalities of the DBMax, a performance administration tool for Oracle database systems, to apply it to data warehouse systems. First we analyze requirements based on summary management and ETL functions they are supported for data warehouse performance improvement in Oracle 9i. Then, we design architecture for extending DBMax functionalities and implement it. In specifics, we support SQL tuning by providing details of schema objects for summary management and ETL processes and statistics information. Also we provide new function that advises useful materialized views on workload extracted from DBMax log files and analyze usage of existing materialized views.

• Applied Chemistry for Engineering
• /
• v.9 no.5
• /
• pp.710-714
• /
• 1998

Organic electroluminescence devices (ELD) with hetero-junction structure were fabricated utilizing poly(p-phenylne vinylene) (PPV) as emitting layer and electron transport layer (ETL). 2-(4-biphenyl)-5-(4-tert-butylphenyl)-1,3,4-oxadiazole (PBD) was used as an electron transport agent. Copolymers with stilbene type comonomers, such as poly(styrene-co-PVTS), poly(styrene-co-MeO-PVTS) and poly(styrene-co-MeO-ST) were synthesized to be used as a matrix polymer to disperse electron transport agent (PBD). Among the hetero-junction EL devices fabricated with the above materials, the device with poly(styrene-co-PVTS) as matrix polymer for ETL gave the highest luminance ($120.7cd/m^2$, 13 V). EL devices made with poly(styrene-co-MeO-PVTS) or poly(styrene-co-MeO-ST) matrix exhibited lower luminance than the one with polystyrene matrix and the single layer EL (ITO/PPV/Mg) device.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.22 no.3
• /
• pp.527-535
• /
• 2021

Traditional business intelligence (BI) systems have been used widely as tools for better decision-making on time. On the other hand, building a data warehouse (DW) for the efficient analysis of rapidly growing data is time-consuming and complex. In particular, the ETL (Extract, Transform, and Load) process required to build a data warehouse has become much more complex as the BI platform moves to a cloud environment. Various BI solutions based on the NoSQL database, such as MongoDB, have been proposed to overcome these ETL issues. Decision-makers want easy access to data without the help of IT departments or BI experts. Recently, self-service BI (SSBI) has emerged as a way to solve these BI issues. This paper proposes a self-service BI system with farming data using the MongoDB cloud as DW to support the selection of new crops by return-farmers. The proposed system includes functions to provide insights to decision-makers, including data visualization using MongoDB charts, reporting for advanced data search, and monitoring for real-time data analysis. Decision makers can access data directly in various ways and can analyze data in a self-service method using the functions of the proposed system.

• 제어로봇시스템학회:학술대회논문집
• /
• 2002.10a
• /
• pp.103.2-103
• /
• 2002

1. Introduction 2. Structure of BNN 3. Decision of weight value and threshold value 4. Principle of Extension in the ETL algorithm 5. Approximation problem of one circular region 6. Problem of synthetic image having four class 7. Conclusion

• Digital Contents
• /
• no.10 s.137
• /
• pp.162-163
• /
• 2004

지난해 기업용 솔루션 업계의 최대 이슈로 급부상했던 BI(비즈니스인텔리전스)가 올해는 DW(데이터웨어하우스)라는 오랜 둥지에서 벗어나 독자적인 애플리케이션 영역으로 빠르게 성장하고 있다. 반면 ETL(데이터 추출 변환 로딩)툴을 중심으로 하는 데이터 통합 솔루션의 영역은 BI를 벗어난 영역으로의 확장을 강조하고 있고 그 부분이 경쟁력을 결정하는 핵심 포인트가 되고 있다. 최근 데이터통합 전문업체로 위상을 강화하고 있는 한국어센셜소프트웨어를 들러봤다.

• NEWSLETTER 전기공업
• /
• no.92-1 s.44
• /
• pp.1-20
• /
• 1992

• The KIPS Transactions:PartD
• /
• v.14D no.6
• /
• pp.701-706
• /
• 2007

Datawebhouse consists of both web log analysis used for customer management and datawarehouse used for decision support. However, datawebhouse needs complex operations for management in order to transform and integrate data from heterogeneous data sources and distributed systems. We propose a metadata schema in order to enable data integration and data management which are essential in datawebhouse environments. We show that our proposed schema supports datawebhouse development and enables integrated asset management of business information. With ETL metadata for web log extract, we can improve the data processing time of web log.