오픈소스 DBMS 기반 공간정보 메타데이터 변환 및 질의처리기 설계 및 구현

Abstract

As diverse web-based geo-spatial services are developed, the values of technologies and standards related to this trend are also emphasized. Also, metadata is one of the crucial factors in geo-spatial services building and operation. Geo-spatial metadata is widely used in the spatial information technology and industry with the main advantages of compatibility, interoperability and management of consistent and systematic information. However, because those are composed of complicated elements and needs XML storage and management, individual organization which implement and operate practical application system is inclined to define and use its own metadata specifications. In this study, a prototype supporting mandatory components in OGC standard catalog service is designed and implemented, linked to PostgreSQL, open source DBMS. As the main features, XML metadata server was built with the helps of XML query functions in PostgreSQL. Metadata extraction program, that metadata elements are directly extracted from geo-based file formats was developed to easily utilize standard metadata such as ISO/TC 19115, TTAS.KO-10.0139 and TTAS.IS-19115, and those elements are processed into XML. Furthermore, geo-based images sets are applied to another metadata of ISO/TC 19115-2. As well, metadata transformation is needed due to inconsistent or non-corresponding definition among standard metadata; in this program, transformation modules are also implemented to interoperable uses between standard metadata. Given target applications with geo-spatial data sources and contents, this model can be applied, and it can be used for extension in other external web-based service systems or applications, because it supports international standard specifications. Also through this kind of development, extension for other formats and other metadata specifications is possible.