• 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.

• 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.

• 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.