• Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
• /
• 2010.09a
• /
• pp.50-58
• /
• 2010

최근 무선 통신 기술의 발전과 모바일 단말기 사용의 보편화됨에 따라 GIS 서비스가 점차 모바일 환경으로 이동하는 추세이다. 그러나 기존의 모바일 GIS 응용 시스템들은 파일 시스템을 이용하거나 공간 데이타 처리 기능을 지원하지 않는 모바일 DBMS를 이용하고 있기 때문에 효율적인 GIS 응용 시스템을 개발하기 위해서는 OGC에서 제공하는 다양한 공간 데이타 타입 및 공간 연산자를 지원하는 공간 질의 처리 시스템이 필요한 형편이다. 따라서, 본 논문에서는 효율적인 공간 데이타 처리를 위해 기존 모바일 DBMS에 기반하여 공간 질의를 처리하는 시스템을 개발한다. 모바일 DBMS 기반의 공간 질의 처리 시스템은 효율적인 공간 질의 처리를 위해 공간 데이타 타입 및 공간 연산자를 제공하고, 공간 데이타 캐싱 기능, 인덱스 압축 기법을 지원하고, 그리고 공간 데이타 타입을 변환하여 모바일 DBMS에 저장하는 기능을 제공한다. 마지막으로, 본 논문에서는 모바일 DBMS 기반 공간 질의 처리 시스템을 부동산 정보 서비스에 적용해 봄으로써 효용성을 입증하였다.

• Spatial Information Research
• /
• v.14 no.4 s.39
• /
• pp.379-389
• /
• 2006

Map databases for CNS (Car Navigation System) can be accessed quickly and compressed efficiently due to that these are usually recorded as in a PSF (Physical Storage Format). However, it is difficult to create and manage data storage based on a file-system. To solve these problems, DBMS needs to be combined with spatial data management. Therefore, we developed an embedded DBMS with which to store data and conduct quick searches in CNS. Spatial data could be easily managed and accessed using the compression method, Multi-Link, spatial index, and spatial division. In the result, the proposed embedded DBMS searched quickly and stably supported data management. If synchronization is applied in DBMS, it is expected to utilize the advantages of an embedded DBMS.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.8 no.1
• /
• pp.63-74
• /
• 2005

The telematics device, which is a typical embedded system on the transportation or vehicle, requires the embedded spatial DBMS based on RTOS (Real Time Operating System) for processing the huge spatial data in real time. This spatial DBMS can be developed very easily by SQL3 functions of the ORDBMS such as UDT (user-defined type) and UDF (user-defined function). However, developing index suitable for the embedded spatial DBMS is very difficult. This is due to the fact that there is no built-in SQL3 functions to construct spatial indexes. In this study, we compare and analyze both Generalized Search Tree and Relational Indexing methods which are suggested as common ways of developing User-Defined Indexes nowadays. Two implementations of R-Tree based on each method were done and region query performance test results were evaluated for suggesting a suitable indexing method of an embedded spatial DBMS, especially for telematics devices.

• The Journal of the Korea Contents Association
• /
• v.8 no.1
• /
• pp.290-299
• /
• 2008

We propose the query optimization technique using query classification in hybrid spatial DBMS. In our approach, user queries should to be classified into three types: memory query, disk query, and hybrid query. Specialty, In the hybrid query processing, the query predicate is divided by comparison between materialized view creating conditions and user query conditions. Then, the deductions of the classified queries' cost formula are used for the query optimization. The optimization is mainly done by the selection algorithm of the smallest cost data access path. Our approach improves the performance of hybrid spatial DBMS than traditional disk-based DBMS by $20%{\sim}50%$.

• Journal of Korean Society for Geospatial Information Science
• /
• v.16 no.4
• /
• pp.41-48
• /
• 2008

Currently used 3D models, which are mostly focused on visualization of 3D objects and lack topological structure, have limitation in being used for 3D spatial analyses and applications. However, implementing a full topology for the indoor spatial objects is less practical due to the increase of complexity and computation time. This study suggests an alternative method to build a 3D indoor model with less complexity using a spatial DBMS. Storing spatial and nonspatial information of indoor spaces in DB tables enables faster queries, computation and analyses. Also it is possible to display them in 2D or 3D using the queried information. This study suggests a 2D-3D hybrid data model, which combines the 2D topology constructed from CAD floor plans and stored in a spatial DBMS and the 3D visualization functionality. This study showed the process to build the proposed model in a spatial DBMS and use spatial functions and queries to visualize in 2D and 3D. And, then, as an example application, it illustrated the process to build an indoor evacuation simulator.

• Journal of Korean Society for Geospatial Information Science
• /
• v.17 no.4
• /
• pp.31-38
• /
• 2009

Most 3D models found in the literature focus on theoretical topology for exterior 3D volumes. Although there are a few indoor models such as CityGML or IFC, implementing a full topology for the indoor spaces is either less practical due to the complexity or not even necessary in some application domains. Moreover, current spatial DBMSs do not support functionalities explicitly for 3D topological relations. In this study, an alternative method to build a 3D indoor model with less complexity ernativespatial DBMS is suggested. Focusnation the fact that semantic attributes can be storedion the floor surface, we suggestivemulti-layered 3D model for indoor spaces. We show the process to build the proposed model in the PostGIS, a spatial DBMS. And, then, as an example application, we illustrate the process to build and run a campus building information system.

• Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
• /
• 2009.04a
• /
• pp.257-258
• /
• 2009

캠퍼스의 공간은 대학을 이루는 주요한 물적 자원 이며, 제한된 공간을 효율적으로 활용하기 위해서 공간사용현황을 파악하는 것은 중요하다. 다른 공간정보시스템은 공간데이터와 속성데이터의 불일치로 인한 문제점이 발생할 수 있는 여지가 있다. 이를 근본적으로 해결하기 위해서 본 연구에서는 공간 DBMS를 활용해서 캠퍼스 공간정보 시스템을 제안한다.

• Journal of Korea Spatial Information System Society
• /
• v.8 no.3
• /
• pp.1-14
• /
• 2006

Recently, to efficiently support the real-time requirements of LBS and Telematics services, interest in the spatial main memory DBMS is rising. In the spatial main memory DBMS, because all spatial data can be lost when the system failure happens, the recovery system is very important for the stability of the database. Especially, disk I/O in executing the log and the checkpoint becomes the bottleneck of letting down the total system performance. Therefore, it is urgently necessary to research about the recovery system to reduce disk I/O in the spatial main memory DBMS. In this paper, we study an efficient recovery system for the spatial main memory DBMS. First, the pre-commit log method is used for the decrement of disk I/O and the improvement of transaction concurrency. In addition, we propose the fuzzy-shadow checkpoint method for the recovery system of the spatial main memory DBMS. This method can solve the problem of duplicated disk I/O on the same page of the existing fuzzy-pingpong checkpoint method for the improvement of the whole system performance. Finally, we also report the experimental results confirming the benefit of the proposed recovery system.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2009.04a
• /
• pp.274-277
• /
• 2009

지리정보시스템(GIS: Geographic Information System)에서는 1 차원이 아닌 2 차원 공간상의 공간 데이터 처리를 위한 많은 연구가 수행되어 왔으며 DBMS 에서 이러한 2 차원 공간 데이터의 처리를 위하여 많은 기술들이 연구 개발되어 왔다. 최근 GIS 응용에서는 2 차원이 아닌 3 차원 공간데이터 처리에 대한 요구사항이 급증하고 있다. 이에 본 연구에서는 기존 2 차원 공간 DBMS에서 3 차원 공간데이터 처리를 위하여 확장 개발해야 할 요소에 대하여 살펴보고자 한다.

• Journal of Korea Spatial Information System Society
• /
• v.11 no.3
• /
• pp.50-54
• /
• 2009

Recently, many researches have been conducted to develop 3D Indoor/Outdoor Spatial Data Models. The 3D data created based on these data models have complex data structures. In order to manage these data efficiently, it is better to use a DBMS. There have been many researches to maintain the 3D data in Geo-DBMS, such that Oosterom (2002) and Arens (2005) developed a method to store 3D Building model, geometric and topological data of coverage in DBMSa. In this study, we propose a method to store the CityGML data into the RDBMS, Oracle Spatial 11g.