• Title/Summary/Keyword: 공간 ETL

Search Result 4, Processing Time 0.019 seconds

Non-Duplication Loading Method for supporting Spatio-Temporal Analysis in Spatial Data Warehouse (공간 데이터웨어하우스에서 시공간 분석 지원을 위한 비중복 적재기법)

  • Jeon, Chi-Soo;Lee, Dong-Wook;You, Byeong-Seob;Lee, Soon-Jo;Bae, Hae-Young
    • Journal of Korea Spatial Information System Society
    • /
    • v.9 no.2
    • /
    • pp.81-91
    • /
    • 2007
  • In this paper, we have proposed the non-duplication loading method for supporting spatio-temporal analysis in spatial data warehouse. SDW(Spatial Data Warehouse) extracts spatial data from SDBMS that support various service of different machine. In proposed methods, it extracts updated parts of SDBMS that is participated to source in SDW. And it removes the duplicated data by spatial operation, then loads it by integrated forms. By this manner, it can support fast analysis operation for spatial data and reduce a waste of storage space. Proposed method loads spatial data by efficient form at application of analysis and prospect by time like spatial mining.

  • PDF

Non Duplicated Extract Method of Heterogeneous Data Sources for Efficient Spatial Data Load in Spatial Data Warehouse (공간 데이터웨어하우스에서 효율적인 공간 데이터 적재를 위한 이기종 데이터 소스의 비중복 추출기법)

  • Lee, Dong-Wook;Baek, Sung-Ha;Kim, Gyoung-Bae;Bae, Hae-Young
    • Journal of Korea Spatial Information System Society
    • /
    • v.11 no.2
    • /
    • pp.143-150
    • /
    • 2009
  • 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.

  • PDF

Energy Band Schemes in Organic Electroluminescent Devices Using Terbium Complexes Prepared by Vacuum Evaporation Method (진공 증착법에 의한 Terbium Comp1exes를 이용한 유기 전기 발광 소자의 에너지 밴드에 관한 연구)

  • 표상우;김옥병;이한성;최돈수;이승희
    • Proceedings of the Korean Institute of Electrical and Electronic Material Engineers Conference
    • /
    • 1999.05a
    • /
    • pp.582-588
    • /
    • 1999
  • 정보화 사회의 발전과 함께 멀티미디어에 대한 관심이 집중되고 있으며, 점유 공간이 작고 가벼우며 대면적이 가능한 정보 표시 디스플레이에 대한 기술은 고부가가치 산업으로 인식되어 지고 있다. 이러한 정보 표시 디스플레이들 중, 전기 발광 소자 (Electroluminescence Display : ELD), 액정 표시 디스플레이 (Liquid Crystal Display LCD), 플라즈마 디스플레이 (Plasma Display Panel) 등의 대한 연구가 세계적으로 매우 활발하게 진행되고 있다. 본 연구에서는 란탄 계열의 금속 착 화합물인 Tb(ACAC)$_3$(Phen)과 Tb(ACAC)$_3$(Phen-Cl)를 이용해 다비이스를 제작한후 광학적 및 전기적 특성을 조사하였다. 또한 luminous efficiency와 cyclic voltametric 방법을 이용해 에너지 밴드로 두 발광 물질인 Tb(ACAC)$_3$(Phen)과 Tb(ACAC)$_3$(Phen-Cl)을 비교.분석하였다. 본 연구의 디바이스 구조를 보면 anode/hole transporting layer (HTL)/emitting material layer (EML)/electron transporting layer (ETL)/cathode와 같고 ETL를 aluminum-tris- (8-hydroxyquinoline) (Alq$_3$)와 bis(10-hydroxybenzo(h)quinolinato)beryllium (Bebq$_2$)를 사용하였으며 HTL 로 N,N'-diphenyl-N,N'-bis(3-methylphenyl)-1,1'-biphenyl-4,4'-diamine (TPD)를 사용하였다.

  • PDF

A Study on BIM-based Facility Management System Architecture Development considering the heterogeneous solution data integration (BIM과 이기종 솔류션 데이터 통합을 고려한 시설물관리 시스템 아키텍처 개발에 관한 연구)

  • Kang, Tae Wook;Choi, Hyun Sang
    • Spatial Information Research
    • /
    • v.21 no.4
    • /
    • pp.25-34
    • /
    • 2013
  • The purpose of this study is to develop an efficient BIM-based FM(Facility Management) system architecture to integrate the heterogeneous solution data related to FM. The heterogeneous solution data can be an FM system, asset management system, or facility sensor database systems, as well as files created by a modeler. In this study, we define the consideration for the external heterogeneous data integration related to BIM-based FM and propose the methodology. To implement it, trends in related studies were reviewed and general use cases of BIM-based FM were derived to develop the architecture for the integration between BIM and the heterogeneous solution data. The component architecture was designed to implement the use cases, and the schema was developed for the prototype by using the proposed architecture.