• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.35 no.2
• /
• pp.81-90
• /
• 2017

This study aimed to construct an integrated database using the same spatio-temporal unit by employing various public-data types with different real-time information provision cycles and spatial units. Towards this end, three temporal interpolation methods (piecewise constant interpolation, linear interpolation, nonlinear interpolation) and a spatial matching method by district boundaries was proposed. The case study revealed that the linear interpolation is an excellent method, and the spatial matching method also showed good results. It is hoped that various prediction models and data analysis methods will be developed in the future using different types of data in the analysis database.

• 한국공간정보시스템학회:학술대회논문집
• /
• 2004.12a
• /
• pp.69-74
• /
• 2004

Selectivity estimation for spatial query is very important process in finding the most efficient execution plan. Many works have been performed to estimate accurately selectivity. Although they deal with some problems such as false-count, multi-count, they require a large amount of memory to retain accurate selectivity, so they can not get good results in little memory environments such as mobile-based small database. In order to solve this problem, we propose a new technique called MW histogram which is able to compress summary data and get reasonable results. It also has a flexible structure to react dynamic update. The experimental results showed that the MW histogram has lower relative error than MinSkew histogram and gets a good selectivity in little memory.

• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2003.09a
• /
• pp.459-462
• /
• 2003

Selectivity estimation of queries not only provides useful information to the query processing optimization but also may give users with a preview of processing results. In this paper, we investigate the problem of selectivity estimation in the context of a spatial dataset. Although several techniques have been proposed in the literature to estimate spatial query result sizes, most of those techniques still have some drawback in the case that a large amount of memory is required to retain accurate selectivity. To eliminate the drawback of estimation techniques in previous works, we propose a new method called MW Histogram. Our method is based on two techniques: (a) MinSkew partitioning algorithm that processes skewed spatial datasets efficiently (b) Wavelet transformation which compression effect is proven. We evaluate our method via real datasets. With the experimental result, we prove that the MW Histogram has the ability of providing estimates with low relative error and retaining the similar estimates even if memory space is small.

• Spatial Information Research
• /
• v.5 no.1
• /
• pp.115-131
• /
• 1997

Effective management of underground facilities which include water line, sewer line, electric line, telephone line, gas line etc., is very important for people's safety as well as administrative efficiency. The purpose of this study is four-fold: first, investigate management status of utility information of each utility companies, second, develope classification system of underground facilities and use this classification system for guidelines of database construction and for the exchange of database among utility companies, third, construct database using existing utility maps in pilot study area and identify accuracy of the existing maps and suggest strategy of database construction, fourth, suggest strategy of database maintenance and its organizational plan in connection with national plan.

• Journal of Korean Society for Geospatial Information Science
• /
• v.11 no.4 s.27
• /
• pp.53-60
• /
• 2003

GIS was introduced to spatial information of complex and various facility systematically and scientifically. And, recently, new trend has been spread by Mobile GIS owing to its fast development of information and communication technology. However, these Mobile GIS techniques were introduced in maintenances of various facilities. Due to its mismanagement, the use became insufficient in facilities causing database creation to require realism and mobility. Therefore, in this research to road facility of various facilities, it deduced improving the work process by using a Mobile GIS to analyze work process of the road facility database creation. And, through an experiment, by comparing and analyzing road facilities database creation process by existing method and improving method, could improvement of road facility database creation using a Mobile GIS.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.26 no.3
• /
• pp.12-36
• /
• 2023

Graph databases, which store different types of data and their relationships modeled as a graph, can be effective in managing and analyzing real estate spatial data linked by complex relationships. However, they are not widely used due to the limited spatial functionalities of graph databases. In this study, we propose a uniform grid-based real estate spatial data management approach using a graph database to respond to various real estate-related spatial questions. By analyzing the real estate community to identify relevant data and utilizing national point numbers as unit grids, we construct a graph schema that linking diverse real estate data, and create a test database. After building a test database, we tested basic topological relationships and spatial functions using the Jackpine benchmark, and further conducted query tests based on various scenarios to verify the appropriateness of the proposed method. The results show that the proposed method successfully executed 25 out of 29 spatial topological relationships and spatial functions, and achieved about 97% accuracy for the 25 functions and 15 scenarios. The significance of this study lies in proposing an efficient data integration method that can respond to real estate-related spatial questions, considering the limited spatial operation capabilities of graph databases. However, there are limitations such as the creation of incorrect spatial topological relationships due to the use of grid-based indexes and inefficiency of queries due to list comparisons, which need to be improved in follow-up studies.

• Journal of Korea Spatial Information System Society
• /
• v.11 no.2
• /
• pp.7-12
• /
• 2009

In this paper, we discuss the problem of continuous k.nearest neighbors (CKNN) monitoring over distributed streams wavelet synopses, which also considered sliding window structure under stream based kNN query. We developed traditional skylines techniques and propose a new method which called DR.skylines to process CKNN queries as a bandwidth.efficient approach. It tries to process CKNN queries on synopses for optimized sliding window time and space computation.

• Spatial Information Research
• /
• v.3 no.1
• /
• pp.55-63
• /
• 1995

The database design, which logically sets the base structure and orga¬nization of the database, is performed by considering the users requirement, the relations between various data, and the relations between data and application field.The road network data must be created to have geometrical topological structure, because various data elements are needed to recognize the state of each section and to relate between data element. In this study, we propose a method of creating the road network database for an integrated road management system.

• Proceedings of the KSRS Conference
• /
• 2003.11a
• /
• pp.135-137
• /
• 2003

The purpose of this preliminary study is the applied to geology using the Landsat TM satellite image of the Tanggung area of southern part of the Bandung, Indonesia to provide basic information for geological survey. For this, topography, geology and satellite image were constructed to spatial database. Digital elevation, slope, aspect, curvature, hill shade of topography were calculated from the topographic database and lithology was imported from the geological database. Lineament, lineament density, and NDVI were extracted the Landsat TM satellite image. The results showed the close relationship between geology and terrain and satellite image. Each sedimentary rock seldom corresponds with geology and analyses of topography but as a whole for sedimentary rocks coincide with them. Tuff and volcanic breccia in the volcanic rocks correspond with the result of terrain analyses. Talus deposits is well matched with the analyses of opography/satellite image.

• Journal of Korea Spatial Information System Society
• /
• v.6 no.1 s.11
• /
• pp.3-17
• /
• 2004

With the rapid growth of the Internet geographic information services through the WWW such as a location-based service and so on. Web GISs (Geographic Information Systems) have also come to be a cluster-based architecture like most other information systems. That is, in order to guarntee high quality of geographic information service without regard to the rapid growth of the number of users, web GISs need cluster-based architecture that will be cost-effective and have high availability and scalability. This paper proposes the design of the cluster-based web GIS with high availability and scalability. For this, each node within a cluster-based web GIS consists of main memory spatial databases which accomplish role of caching by using data declustering and the locality of spatial query. Not only simple region queries but also the proposed system processed spatial join queries effectively. Compare to the existing method. Parallel R-tree spatial join for a shared-Nothing architecture, the result of simulation experiments represents that the proposed spatial join method achieves improvement of performance respectively 23% and 30% as data quantity and nodes of cluster become large.