• 경영과학
• /
• 제20권2호
• /
• pp.1-16
• /
• 2003

Previous research on data extraction and integration for data warehousing has concentrated mainly on the relational DBMS or partly on the object-oriented DBMS. Mostly, it describes issues related with the change data (deltas) capture and the incremental update by using the triggering technique of active database systems. But, little attention has been paid to data extraction approaches from other types of source systems like hierarchical DBMS, etc. and from source systems without triggering capability. This paper argues, from the practical point of view, that we need to consider not only the types of information sources and capabilities of ETT tools but also other factors of source systems such as operational characteristics (i.e., whether they support DBMS log, user log or no log, timestamp), and DBMS characteristics (i.e., whether they have the triggering capability or not, etc), in order to find out appropriate data extraction techniques that could be applied to different source systems. Having applied several different data extraction techniques (e.g., DBMS log, user log, triggering, timestamp-based extraction, file comparison) to S bank's source systems (e.g., IMS, DB2, ORACLE, and SAM file), we discovered that data extraction techniques available in a commercial ETT tool do not completely support data extraction from the DBMS log of IMS system. For such IMS systems, a new date extraction technique is proposed which first creates Index database and then updates the data warehouse using the Index database. We illustrates this technique using an example application.

• 한국항해항만학회지
• /
• 제35권1호
• /
• pp.1-7
• /
• 2011

본 논문에서는 현재 건설 중인 목포대교와 선박 사이의 충돌 위험도 평가에 필요한 선박 정보와 기상 정보 수집 장치(Data Acquisition System, DAS) 개발에 관하여 기술하였다. 본 연구에서는 DAS를 통항 선박과 기상 현황 데이터를 수집하기 위한 신호 수신 및 처리 유닛과, 데이터 전송과 분배를 위한 네트워킹 유닛, 데이터 관리를 위한 유닛 등으로 구성하였다. 목포항 여객터미널과 신안군 안좌도를 왕복하는 카페리 선상에서의 현장 실험을 통해, 충돌 위기 평가에 적합한 정보를 DAS가 제공할 수 있음을 알았다. 또한 5차 버터워스 디지털 필터를 이용하여 기상 데이터에 포함된 잡음성 데이터를 충분히 억제할 수 있었다.

• 한국멀티미디어학회논문지
• /
• 제14권8호
• /
• pp.1010-1019
• /
• 2011

This was a preliminary research for the goal of understanding between internal structure of Osteogenesis Imperfecta Murine (OIM) bone and its fragility. 54 hyperspectral bone data sets were captured by using JASCO 2000 Raman spectrometer at UMKC-CRISP (University of Missouri-Kansas City Center for Research on Interfacial Structure and Properties). Each data set consists of 1,091 data points from 9 OIM bones. The original captured hyperspectral data sets were noisy and base-lined ones. We removed the noise and corrected the base-lined data for the final efficient classification. High dimensional Raman hyperspectral data on OIM bones was reduced by Principal Components Analysis (PCA) and Linear Discriminant Analysis (LDA) and efficiently classified for the first time. We confirmed OIM bones could be classified such as strong, middle and weak one by using the coefficients of their PCA or LDA. Through experiment, we investigated the efficiency of classification on the reduced OIM bone data by the Bayesian classifier and K -Nearest Neighbor (K-NN) classifier. As the experimental result, the case of LDA reduction showed higher classification performance than that of PCA reduction in the two classifiers. K-NN classifier represented better classification rate, compared with Bayesian classifier. The classification performance of K-NN was about 92.6% in case of LDA.

• 대한조선학회논문집
• /
• 제55권3호
• /
• pp.243-251
• /
• 2018

In the shipyard, a lot of data is generated, stored, and managed during design, construction, and operation phases to build ships and offshore structures. However, it is difficult to handle such big data efficiently using existing data-handling technologies. As the big data technology is developed, the ship and offshore industries start to focus on the existing big data to find valuable information from it. In this paper, the material requirement estimation method of offshore structure piping materials using big data analysis is proposed. A big data platform for the data analysis in the shipyard is introduced and it is applied to the analysis of material requirement estimation to solve the problems in piping design by a designer. The regression model is developed from the big data of piping materials and verified using the existing data. This analysis can help a piping designer to estimate the exact amount of material requirement and schedule the purchase time.

• Current Research on Agriculture and Life Sciences
• /
• 제26권
• /
• pp.45-54
• /
• 2008

The purpose of this research is to develope street trees management program for more an effective street trees management. The principal point of this program is to relate spatial data and attribute data that is the main concept in GIS(Geographic Information System). To do this function, MapObjects which is ESRI's mapping and GIS components was used to process spatial data and Access which had been developed by MS was used to manipulate attribute data in this program. Visual Basic also was used to design and develop user interfaces and procedures, relate two sort of data, and lastly complete Application. Relational data model was adopted to design tables and their relation, Antenucci's GIS development model was selected to design and complete this program. The configuration of this application is composed of management data and reference data. The management data includes the location of street tree, a growth condition, a surrounding environment, the characters of tree, an equipments, a management records and etc. The reference data include general information about tree, blight and insects.

• 대한교통학회지
• /
• 제33권4호
• /
• pp.379-392
• /
• 2015

우리나라의 화물 통계는 다양한 기관에 의해 다양한 목적으로 구축되고 배포되고 있다. 그러나 각 기관별로 통계 수집 목적과 발표되는 통계의 형식 상이하여 자료의 활용성이 매우 제한적인 한계를 지니고 있다. 각 목적에 따라 수집된 원시자료는 특정 항목을 기준으로 집합화(aggregated)된다. 화물 통계에서 이 항목들은 대표적으로 품목, 수단, 출 도착지가 될 수 있다. 본 연구는 이러한 집합화의 과정을 다루고 있으며 다음의 세 가지 연구 목적을 가지고 있다. 우선, 기관별로 집계하고 발표하는 다양한 형태의 화물 물동량 자료를 총체적으로 살펴보고 이를 요약 하고자 한다. 둘째, 여러 기관에서 제시하는 물동량 자료를 수리적 형태로 표현하고자 한다. 셋째, 이 수리표현이 OR(Operations Research)기법을 적용한 네트워크모형에 어떻게 적용될 수 있는지를 타진하고자 한다. 국내 물동량 자료를 살펴본 결과 14개 기관이 각기 다른 목적으로 물동량 데이터를 제공하고 있었고, 물동량의 수리표현을 한 결과 4개의 집계수준이 도출되었다. 한편, 구축된 수리표현은 실제 자료와 연관하여 OR기법을 적용한 화물 네트워크 문제의 결정변수 및 입력 자료와 연관성이 있는 것으로 파악되었다. 비록 본 연구에서는 특정 정량적 연구 방법론을 적용하는 등 일반적인 연구논문의 형식을 따르지 않았다. 그 이유는 본 연구에서 다루는 자료의 종류가 국내 모든 화물 자료를 총 망라하고 있고, 그 자료로 공통적으로 이용할 수 있는 수식은 존재치 않기 때문이다. 본 연구의 의의는 국내 화물자료가 가진 한계와 적용방안을 총체적으로 살펴봄으로써 화물 네트워크 모형을 비롯한 화물 관련 연구의 발전을 위한 기초자료 확립을 위한 구체적인 방안을 찾는 방향을 제시했다는 것에서 찾을 수 있을 것이다. 본 연구가 제안하는 화물 데이터 구득의 한계는 최근 정부가 지향하는 정부 3.0의 필요성을 역설한다 할 수 있다.

• Journal of the Korean Data and Information Science Society
• /
• 제20권5호
• /
• pp.933-939
• /
• 2009

The bivariate data in clinical research fields often has two types of failure times, which are mark variable for the first failure time and the final failure time. This paper showed how to generate bootstrap data to get Bayesian estimation for the joint distribution of bivariate survival times. The observed data was generated by Frank's family and the fake date is simulated with the Gamma prior of survival time. The bootstrap data was obtained by combining the mimic data with the observed data and the simulated fake data from the observed data.

• Journal of Korean Society for Atmospheric Environment
• /
• 제23권E2호
• /
• pp.57-65
• /
• 2007

In Korea, there is a general lack of information available on air emissions from industry. The reasons for this include the lack of regulatory requirements for emission monitoring, limited information on specific industries, and difficulties in monitoring certain sources. This paper presents the first detailed air pollutant emission factors from composite wood product manufacturing in Korea. This study introduced emission factors for wood-based panels such as plywood, particle board (PB), and medium density fiberboard (MDF). The emission factors of particulate matters (PM) and hazardous air pollutants (HAPs) from MDF were higher than that from other wood products. The concentration of total volatile organic compounds (TVOCs) for hot press from wood-based panels was higher than drying or gluing processes. Emissions data from NPIP were compared to the data from the suggested emission factors in this study and the US EPA's. The data from our emission factors were closer to the observed results than the data using the US EPA's emission factor.

• 한국정보통신학회:학술대회논문집
• /
• 한국정보통신학회 2012년도 춘계학술대회
• /
• pp.535-538
• /
• 2012

최근 ITS(Intelligent Transportation System)와 관련된 연구들이 활발하게 진행되면서 정보화 사회에 알맞은 차세대 교통정보 체계를 구축하는데 일조하고 있다. 도로상의 차량 속도 및 교통 정보를 실시간으로 감지할 수 있는 시스템을 구축하여 운전자에게 정보를 제공함으로써 전체 교통 상황의 흐름에 좋은 영향을 끼칠 수 있다. 본 연구에서는 각기 다른 근원지로부터 제공되는 실시간 교통 정보를 가공하여 보다 신뢰적인 실시간 교통정보를 제공하는 알고리즘을 개발하고 이를 적용하는 플랫폼 구축에 관한 연구이다.

• ETRI Journal
• /
• 제30권2호
• /
• pp.268-274
• /
• 2008

This paper proposes an open-loop clock recovery circuit (CRC) using two high-Q dielectric resonator (DR) filters for 39.8 Gb/s and 42.8 Gb/s dual-mode operation. The DR filters are fabricated to obtain high Q-values of approximately 950 at the 40 GHz band and to suppress spurious resonant modes up to 45 GHz. The CRC is implemented in a compact module by integrating the DR filters with other circuits in the CRC. The peak-to-peak and RMS jitter values of the clock signals recovered from 39.8 Gb/s and 42.8 Gb/s pseudo-random binary sequence (PRBS) data with a word length of $2^{31}-1$ are less than 2.0 ps and 0.3 ps, respectively. The peak-to-peak amplitudes of the recovered clocks are quite stable and within the range of 2.5 V to 2.7 V, even when the input data signals vary from 150 mV to 500 mV. Error-free operation of the 40 Gb/s-class optical receiver with the dual-mode CRC is confirmed at both 39.8 Gb/s and 42.8 Gb/s data rates.