• KEPCO Journal on Electric Power and Energy
• /
• 제7권1호
• /
• pp.79-84
• /
• 2021

The fundamental element to be kept for big data analysis, artificial intelligence technologies and asset management system is a data quality, which could directly affect the entire system reliability. For this reason, the momentum of data cleaning works is recently increased and data cleaning methods have been investigating around the world. In the field of electric power, however, asset data cleaning methods have not been fully determined therefore, automatic cleaning algorithm of asset data for transmission cables has been studied in this paper. Cleaning algorithm is composed of missing data treatment and outlier data one. Rule-based and expert opinion based cleaning methods are converged and utilized for these dirty data.

• KEPCO Journal on Electric Power and Energy
• /
• 제7권1호
• /
• pp.73-77
• /
• 2021

As the big data analysis technologies has been developed worldwide, the importance of asset management for electric power facilities based data analysis is increasing. It is essential to secure quality of data that will determine the performance of the RISK evaluation algorithm for asset management. To improve reliability of asset management, asset data must be preprocessed. In particular, the process of cleaning dirty data is required, and it is also urgent to develop an algorithm to reduce time and improve accuracy for data treatment. In this paper, the result of the development of an automatic cleaning algorithm specialized in overhead transmission asset data is presented. A data cleaning algorithm was developed to enable data clean by analyzing quality and overall pattern of raw data.

• 품질경영학회지
• /
• 제30권2호
• /
• pp.72-85
• /
• 2002

Advances in computer and sensor technology have made it possible to obtain superlarge manufacturing process data in real time, letting us extract meaningful information from these superlarge data sets. We propose a systematic data analysis procedure which field engineers can apply easily to manufacture quality products. The procedure consists of data cleaning and data analysis stages. Data cleaning stage is to construct a database suitable for statistical analysis from the original superlarge manufacturing process data. In the data analysis stage, we suggest a graphical easy-to-implement approach to extract practical information from the cleaned database. This study will help manufacturing companies to achieve six sigma quality.

• 한국분무공학회지
• /
• 제12권4호
• /
• pp.185-190
• /
• 2007

There is a growing interest to develop a new cleaning technology to overcome the disadvantages of wet cleaning technologies such as environmental pollution and the cleaning difficulty of contaminants on integrated circuits. Laser cleaning is a potential technology to remove various pollutants on a wafer surface. However, there is no fundamental data about cleaning efficiencies and cleaning mechanisms of contaminants on a wafer surface using a laser cleaning technology. Therefore, the cleaning characteristics of a wafer surface using an excimer laser were investigated in this study. Fingerprint consisting of inorganic and organic materials was chosen as a representative of pollutants and the effectiveness of a laser irradiation on a wafer cleaning has been investigated qualitatively and quantitatively. The results have shown that cleaning degree is proportional to the laser irradiation time and repetition rate, and quantitative analysis conducted by an image processing method also have shown the same trend. Furthermore, the cleaning efficiency of a wafer contaminated by fingerprint strongly depended on a photothermal cleaning mechanism and the species were removed in order of hydrophilic and hydrophobic contaminants by laser irradiation.

• 한국표면공학회지
• /
• 제32권2호
• /
• pp.109-124
• /
• 1999

A study for replacing methylene chloride for an alternative cleaning agent which can be utilized for cleaning aluminium parts of hard disk drives was carried out at Suwon factory of Samsung Electro-mechanics Co. Ltd. As a result, quite a good cleaning agent was selected through data collection of alternative cleaning agents, their analysis of environment effects and safty factors and testing of their cleaning power. As compared with methylene chloride, the selected cleaning agent has better cleaning power. It is also more environmental-friendly, less toxic and more economical. And the operating cost reduction due to adoption of this alternative cleaning agent in Samsung Electro-mechanics Co. Ltd. was more than ￦l46,000,000 annually without any capital instrument in addition to improvement of environmental and safty conditions in the plant.

• 청정기술
• /
• 제14권2호
• /
• pp.103-109
• /
• 2008

본 연구에서는 솔더페이스트(solder paste)로 솔더링후 표면에 잔류하는 플럭스(flux)의 효과적인 세정성능 평가방법 개발을 목적으로 하였다. 솔더링시 플럭스의 퍼짐오차를 줄이기 위해 본 연구에서 고안한 금속치구를 이용하여 1,1,1-TCE 및 플럭스 제거용 몇 가지 대표 준수계 대체세정제에 대하여 세정시간에 따른 플럭스 제거율을 무게측정법으로 측정, 비교하였다. 세정시간 변화에 따른 각 세정제의 세정효율을 측정한 결과 측정값들의 상대표준편차(RSD)가 약 4%이하로 data의 신뢰성이 확인되었다. 따라서 솔더페이스트로 솔더링후 대체세정제의 잔류플럭스의 세정성능 평가시험에 본 연구에서 적용한 금속치구(metal test tool)를 이용한 평가방법이 유력한 방법으로 적용가능할 것으로 판단된다. 그리고 이 평가방법을 적용한 결과 현재 상용화 되어 있는 우수하다고 알려진 몇 가지 대표 준수계 대체세정제 중 ST100SX와 750H가 고활성 플럭스에 대한 세정력이 우수한 성능을 나타냈으나 기존의 1,1,1-TCE에 비해서는 현저히 떨어짐을 확인할 수 있었다.

• 한국환경보건학회지
• /
• 제43권4호
• /
• pp.298-306
• /
• 2017

Objectives: Since 1998, the Korea National Health and Nutrition Examination Survey (KNHANES) has been conducted in order to investigate the health and nutritional status of Koreans. The food intake data of individuals in the KNHANES has also been utilized as source dataset for risk assessment of chemicals via food. To improve the reliability of intake estimation and prevent missing data for less-responded foods, the structure of integrated long-standing datasets is significant. However, it is difficult to merge multi-year survey datasets due to ineffective cleaning processes for handling extensive numbers of codes for each food item along with changes in dietary habits over time. Therefore, this study aims at 1) cleaning the process of abnormal data 2) generation of integrated long-standing raw data, and 3) contributing to the production of consistent dietary exposure factors. Methods: Codebooks, the guideline book, and raw intake data from KNHANES V and VI were used for analysis. The violation of the primary key constraint and the $1^{st}-3rd$ normal form in relational database theory were tested for the codebook and the structure of the raw data, respectively. Afterwards, the cleaning process was executed for the raw data by using these integrated codes. Results: Duplication of key records and abnormality in table structures were observed. However, after adjusting according to the suggested method above, the codes were corrected and integrated codes were newly created. Finally, we were able to clean the raw data provided by respondents to the KNHANES survey. Conclusion: The results of this study will contribute to the integration of the multi-year datasets and help improve the data production system by clarifying, testing, and verifying the primary key, integrity of the code, and primitive data structure according to the database normalization theory in the national health data.

• Transactions on Electrical and Electronic Materials
• /
• 제14권5호
• /
• pp.254-257
• /
• 2013

In-situ optical emission spectroscopy (OES) is employed for PECVD chamber monitoring. OES is used as an addon sensor to monitoring and cleaning end point detection (EPD). On monitoring plasma chemistry using OES, the process gas and by-product gas are simultaneously monitored. Principal component analysis (PCA) enhances the capability of end point detection using OES data. Through chamber cleaning monitoring using OES, cleaning time is reduced by 53%, in general. Therefore, the gas usage of fluorine is also reduced, so satisfying Green Fab challenge in semiconductor manufacturing.

• 대한전기학회:학술대회논문집
• /
• 대한전기학회 2011년도 제42회 하계학술대회
• /
• pp.2015-2016
• /
• 2011

Detection of data cleaning bed of because method of communication uses AODV(Ad hoc On-demand Distance Vector) Zig-Bee communication though communication method is important being separated by several part structurally data monitor ring do it way to understand be. Although data that detect in transmitter will get into several kinds, data of each senses is detected by 4 - 20 mA conclusively and remainder data is consisted of temperature data. That is measured in transmitter in mast baud via conversion relation to do monitorring norm of data being decided to PC mistake of measured value so that can do control between enforcement compose. Speak that can manage equipment of cleaning bed by number of persons who write if detect data detection in wide cleaning bed through Zig-Bee communication and is easy because also administration of data consists of real time.

• 공기청정기술
• /
• 제30권3호
• /
• pp.18-23
• /
• 2017