• Title/Summary/Keyword: spatial information database

Search Result 942, Processing Time 0.025 seconds

Development of Database Management System for Agriculture Facilities Using Geographic Information System (GIS를 이용한 농업시설물 데이터베이스관리시스템 개발)

  • An, Won-Tae;Choi, Seok-Keun
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.22 no.4
    • /
    • pp.570-579
    • /
    • 2021
  • The environments in current farming and fishing communities have been exacerbated by the shortage of personnel caused by aging, the deficiency of equipment, and the decrease in produce prices. To help solve these issues, this study examined the history, such as inspections, failures, and repairs, by constructing a database for underground water wells, pumping stations, and irrigation, which are critical for management among agriculture production infrastructures. In particular, in the case of underground water wells, their optimal locations were determined using spatial information, such as a geological map of water resources, a water vein map, and underwater depth, because indiscreet installations and an absence of spatial information resulted in economic losses and environmental pollution. Therefore, this study could efficiently manage many facilities scattered in rural areas by developing a system. An analysis of the status of 14 underground water wells using spatial information showed that the location information at six points was specified incorrectly. On the other hand, a site investigation showed that the water vein map analysis at one point was inaccurate.

Dynamic Cell Leveling to Support Location Based Queries in R-trees (R-tree에서 위치 기반 질의를 지원하기 위한 동적 셀 레벨링)

  • Jung, Yun-Wook;Ku, Kyong-I;Kim, Yoo-Sung
    • Journal of Korea Spatial Information System Society
    • /
    • v.6 no.2 s.12
    • /
    • pp.23-37
    • /
    • 2004
  • Location Based Services(LBSs) in mobile environments become very popular recently. For efficient LBSs, spatial database management systems must need a spatial indexing scheme such as R-trees in order to manage the huge spatial database. However, it may need unnecessary disk accesses since it needs to access objects which are not actually concerned to user's location-based queries. In this paper, to support the location-based queries efficiently, we propose a CLR-tree(Cell Leveling R-tree) in which a dynamic cell is built up within the minimum bounding rectangle of R-trees' node. The cell level of nodes is compared with the query's cell level in location-based query processing and determines the minimum search space. Also, we propose the insertion, split, deletion, and search algorithms for CRL-trees. From the experimental results, we see that a CLR-tree is able to decrease $5{\sim}20%$ of disk accesses from those of R-trees. So, a CLR-tree can be used for fast accessing spatial objects to user's location-based queries in LBSs.

  • PDF

A Selectivity Estimation Scheme for Spatial Topological Predicate Using Multi-Dimensional Histogram (다차원 히스토그램을 이용한 공간 위상 술어의 선택도 추정 기법)

  • Kim, Hong-Yeon;Bae, Hae-Yeong
    • The Transactions of the Korea Information Processing Society
    • /
    • v.6 no.4
    • /
    • pp.841-850
    • /
    • 1999
  • Many commercial database systems maintain histograms to summarize the contents of relations, permit efficient estimation of query result sizes, and access plan costs. In spatial database systems, most query predicates consist of topological relationship between spatial objects, and ti is ver important to estimate the selectivity of those predicates for spatial query optimizer. In this paper, we propose a selectivity estimation scheme for spatial topological predicates based on the multi-dimensional histogram and the transformation scheme. Proposed scheme applies two partition strategies on transformed object space to generate spatial histogram, and estimates the selectivity of topological predicates based on the topological characteristic of transformed space. Proposed scheme provides a way for estimating the selectivity without too much memory space usage and additional I/Os in spatial query optimizer.

  • PDF

A Query Optimization Technique for Queries Including Attribute/Spatial Predicates in Spatial Database (공간 데이터베이스에서 속성/공간 조건이 혼합된 질의어의 최적화 기법)

  • 이정남;조완섭;이충세
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 1998.10b
    • /
    • pp.99-101
    • /
    • 1998
  • 대용량 공간 데이터를 포함하는 공간 데이터베이스에서 검색성능의 향상을 위해 공간 질의어가 최적화가 중요한 과제이다. 본 논문에서는 공간 데이터베이스에서 속성/공간 조건이 혼합된 질의에 적합한 질의 최적화 기법을 제시한다. 제안된 기법은 기존의 변환 규칙을 이용해서 대수 트리를 변환해 나가는 방법과는 달리 혼합된 질의어에 대한 질의 그래프로부터 동적 프로그래밍 기법으로 탐색 알고리즘을 실행함으로써 탐색 공간을 줄일 수 있고, 더욱 효율적으로 최소 비용의 실행 전략들 수립할 수 있다.

Study of a GIS Based Land Use/Cover Change Model in Laos

  • Wada, Y.;Rajan, K.S.;Shibasaki, R.
    • Proceedings of the KSRS Conference
    • /
    • 2003.11a
    • /
    • pp.266-268
    • /
    • 2003
  • This is based on the AGENT-LUC model framework. Luangprabang Province has the largest percentage of shifting cultivation area in Laos PDR. The model simulates the spatial and temporal patterns of the shifting cultivation in the study area, using a GIS database while the total area of shifting cultivation is controlled by supply and demand balance of food. The model simulation period is from 1990 to 1999, at a spatial resolution of 500m. The results are evaluated using statistical data and remote sensing images. Through the validation, it is concluded that the trends simulated agrees to that of statistical data and the spatial and temporal patterns are also replicated satisfactorily.

  • PDF

Position Information Storage System based on RDBMS

  • Jang, In-Sung;Cho, Dae-Soo;Park, Jong-Hyun
    • Proceedings of the KSRS Conference
    • /
    • 2003.11a
    • /
    • pp.897-899
    • /
    • 2003
  • Recently, owing to the rapid progress of Telecommunication technology, the increase of wireless internet’s subscriber and diffusion of wireless device, LBS (Location Based Services) which take advantage of user's location information and receive information in concerning with user’s location to be essential services. Location Based Services are related the moving objects which change their locations through time. Therefore, to provide location-based services efficiently, it is required that an efficient system which could acquire, store, and query the large number of locations. In this paper, we design management system to insert and search a huge number of Moving Object based on Legacy Relational Database.

  • PDF

Implementation of Annotation and Thesaurus for Remote Sensing

  • Chae, Gee-Ju;Yun, Young-Bo;Park, Jong-Hyun
    • Proceedings of the KSRS Conference
    • /
    • 2003.11a
    • /
    • pp.222-224
    • /
    • 2003
  • Many users want to add some their own information to data which was on the web and computer without actually needing to touch data. In remote sensing, the result data for image classification consist of image and text file in general. To overcome these inconvenience problems, we suggest the annotation method using XML language. We give the efficient annotation method which can be applied to web and viewing of image classification. We can apply the annotation for web and image classification with image and text file. The need for thesaurus construction is the lack of information for remote sensing and GIS on search engine like Empas, Naver and Google. In search engine, we can’t search the information for word which has many different names simultaneously. We select the remote sensing data from different sources and make the relation between many terms. For this process, we analyze the meaning for different terms which has similar meaning.

  • PDF

A Study on Model of Constructing the Cultural Database System. (GIS 기반의 문화데이터베이스구축 방안 연구)

  • 문병채;박현욱
    • Spatial Information Research
    • /
    • v.11 no.2
    • /
    • pp.185-201
    • /
    • 2003
  • The purpose of this study is to seek the methods of constructing a cultural information system based on GIS. It is impossible for regional culture to be formed apart from its surrounding space, so a study of culture should be based on realizing the features of its space. It is important to note that the elements composing a culture complicatedly interact with each other in their function and continuously change. Also they are interrelated in space and plentiful in their amount. Nevertheless, those studies practised so far in relation to culture and constructing cultural database are too limited in establishing cultural area or community life area required to recognize the regional identity So it is now essential that we should study the methods of cultural expression surpassing objective historical and cultural site maps instead of simple maps depicting historical remains or sites. From this viewpoint, this study tries to find various cultural phenomena in relation to their space through seeking the methods of constructing the cultural database model using XML. In addition, this study tries to construct a base for increasing the utilization of information in making the cultural contents.

  • PDF

Spatial Computation on Spark Using GPGPU (GPGPU를 활용한 스파크 기반 공간 연산)

  • Son, Chanseung;Kim, Daehee;Park, Neungsoo
    • KIPS Transactions on Computer and Communication Systems
    • /
    • v.5 no.8
    • /
    • pp.181-188
    • /
    • 2016
  • Recently, as the amount of spatial information increases, an interest in the study of spatial information processing has been increased. Spatial database systems extended from the traditional relational database systems are difficult to handle large data sets because of the scalability. SpatialHadoop extended from Hadoop system has a low performance, because spatial computations in SpationHadoop require a lot of write operations of intermediate results to the disk, resulting in the performance degradation. In this paper, Spatial Computation Spark(SC-Spark) is proposed, which is an in-memory based distributed processing framework. SC-Spark is extended from Spark in order to efficiently perform the spatial operation for large-scale data. In addition, SC-Spark based on the GPGPU is developed to improve the performance of the SC-Spark. SC-Spark uses the advantage of the Spark holding intermediate results in the memory. And GPGPU-based SC-Spark can perform spatial operations in parallel using a plurality of processing elements of an GPU. To verify the proposed work, experiments on a single AMD system were performed using SC-Spark and GPGPU-based SC-Spark for Point-in-Polygon and spatial join operation. The experimental results showed that the performance of SC-Spark and GPGPU-based SC-Spark were up-to 8 times faster than SpatialHadoop.

Real-time Geotechnical Information Database Development Using Location Based Service (LBS를 이용한 실시간 지반정보 DB 구축 시스템 개발)

  • Woo, Je-Yoon;Koo, Jee-Hee;Lee, Sang-Hoon
    • Journal of Korea Spatial Information System Society
    • /
    • v.5 no.2 s.10
    • /
    • pp.91-103
    • /
    • 2003
  • There are currently tremendous amount of geotechnical information saved, which has been qcquired for essential application of site selection, plan, design, constructin, repari in the builing work. However, due to the lack of the location data attribute, there has been a trouble in its analysis and GIS implementation. In this study, the geotechnical information aquisition program(PGeo) for real-time database in the field and geotechnical information reporting program(GeoReport) by Web-GIS for additional data input and its reporting function has been developed.

  • PDF