• Title/Summary/Keyword: Spatial database

Search Result 1,135, Processing Time 0.028 seconds

Database Development Guideline for the Effective Management of Underground Facilities in Seoul (GIS를 이용한 지하매설물의 효율적 관리방안 : 데이터베이스 설계 및 구축방안을 중심으로)

  • 강영옥;조태영
    • 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.

  • PDF

Parallel Spatial Join Method Using Efficient Spatial Relation Partition In Distributed Spatial Database Systems (분산 공간 DBMS에서의 효율적인 공간 릴레이션 분할 기법을 이용한 병렬 공간 죠인 기법)

  • Ko, Ju-Il;Lee, Hwan-Jae;Bae, Hae-Young
    • Journal of Korea Spatial Information System Society
    • /
    • v.4 no.1 s.7
    • /
    • pp.39-46
    • /
    • 2002
  • In distributed spatial database systems, users nay issue a query that joins two relations stored at different sites. The sheer volume and complexity of spatial data bring out expensive CPU and I/O costs during the spatial join processing. This paper shows a new spatial join method which joins two spatial relation in a parallel way. Firstly, the initial join operation is divided into two distinct ones by partitioning one of two participating relations based on the region. This two join operations are assigned to each sites and executed simultaneously. Finally, each intermediate result sets from the two join operations are merged to an ultimate result set. This method reduces the number of spatial objects participating in the spatial operations. It also reduces the scope and the number of scanning spatial indices. And it does not materialize the temporary results by implementing the join algebra operators using the iterator. The performance test shows that this join method can lead to efficient use in terms of buffer and disk by narrowing down the joining region and decreasing the number of spatial objects.

  • PDF

Construction and Evaluation of Bank Marketing Database using Geographic Information Systems (GIS를 이용한 은행마케팅 데이터베이스의 구축과 과제)

  • Jo, Myung-Hee;Bu, Ki-Dong;Kim, Kwang-Ju;Suh, Jun-Seok
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.1 no.1
    • /
    • pp.52-69
    • /
    • 1998
  • Using GIS, this study constructs and evaluates a bank marketing system. The study collects a marketing GIS database case from the Daegu Bank, which is one of the leading local banks in Korea. The database includes spatial data such as digital road map, internal and external attribute data which are combined for the construction of bank marketing database. Based on these data, the study developed an interface which enables searching and analysing functions of bank GIS marketing system. For the development of the interface, this study examined the basic concepts of area marketing and its development and utilized Map/Info as a basic GIS software package and Delphi as computer language. Finally, the study makes a comprehensive evaluation of various problems of spatial and attribute data which occurred in the process of constructing the bank marketing database.

Industrial Engineering Department, Kangnung National University (국가지리공간정보 유통망 구축에 관한 연구)

  • Sung, Ki-Seok;Choi, Jae-Hun;Lee, Sang-Moo
    • Journal of Korea Spatial Information System Society
    • /
    • v.2 no.1 s.3
    • /
    • pp.63-72
    • /
    • 2000
  • The architecture of the National Geo-spatial Information Clearinghouse Network (NGICN) is suggested in this paper. We described the function and relationship of six elements of the NGICN. The elements are clearinghouse network gateway, clearinghouse node, geo-spatial data server, communication network, protocols and standards, and clients. The NGICN suggested in this research will prevent the duplication and improve the value of the database, and persuade the institutes or enterprises in the private sector to participate in producing the geo-spatial database. Finally it will setup the business of producing, circulating and utilizing the geo-spatial information as a new bases of Info-Communication Industry.

  • PDF

An Efficient Buffer Management Technique Using Spatial and Temporal Locality (공간 시간 근접성을 이용한 효율적인 버퍼 관리 기법)

  • Min, Jun-Ki
    • The KIPS Transactions:PartD
    • /
    • v.16D no.2
    • /
    • pp.153-160
    • /
    • 2009
  • Efficient buffer management is closely related to system performance. Thus, much research has been performed on various buffer management techniques. However, many of the proposed techniques utilize the temporal locality of access patterns. In spatial database environments, there exists not only the temporal locality but also spatial locality, where the objects in the recently accessed regions will be accessed again in the near future. Thus, in this paper, we present a buffer management technique, called BEAT, which utilizes both the temporal locality and spatial locality in spatial database environments. The experimental results with real-life and synthetic data demonstrate the efficiency of BEAT.

In-Route Nearest Neighbor Query Processing Algorithm with Space-constraint in Spatial Network Databases (공간 네트워크 데이터베이스에서 공간 제약을 고려한 경로 내 최근접 질의처리 알고리즘)

  • Kim, Yong-Ki;Kim, Ah-Reum;Chang, Jae-Woo
    • Journal of Korea Spatial Information System Society
    • /
    • v.10 no.3
    • /
    • pp.19-30
    • /
    • 2008
  • Recently, the query processing algorithm in the field of spatial network database(SNDB) has been attracted by many Interests. But, there is little research on route-based queries. Since the moving objects move only in spatial networks, the efficient route-based query processing algorithms, like in-route nearest neighbor(IRNN), are essential for Location-based Service(LBS) and Telematics application. However, the existing IRNN query processing algorithm has a problem that it does not consider traffic jams in the road network. In this thesis, we propose an IRNN query processing algorithm which considers space restriction. Finally, we show that space-constrained IRNN query processing algorithm is efficient compared with the existing IRNN algorithm.

  • PDF

Implementation of Rule Management System for Validating Spatial Object Integrity (공간 객체 무결성 검증을 위한 규칙 관리 시스템의 구현)

  • Go, Goeng-Uk;Yu, Sang-Bong;Kim, Gi-Chang;Cha, Sang-Gyun
    • Journal of KIISE:Software and Applications
    • /
    • v.26 no.12
    • /
    • pp.1393-1403
    • /
    • 1999
  • 공간 데이타베이스 시스템을 통하여 공유되는 공간 데이타는 무결성이 적절하게 유지되지 않는 한 전체 응용 시스템의 행위를 예측할 수 없게 되므로 데이타의 무결성 확인 및 유지는 필수적이다. 특히 공공 GIS에 저장된 공간 데이타는 토지 이용도 평가, 도시 계획, 자원 관리, 시설물 관리, 안전 관리, 국방 등 국가 전체 및 지역의 중요한 정책 결정을 위한 다양한 응용 시스템들에 의해 이용되므로 적절한 공간 객체의 무결성 확인이 더욱 더 필요하다. 본 논문에서는 능동(active) DBMS의 능동 규칙(active rule) 기법을 이용하여 공간 객체의 무결성 확인을 지원하기 위한 규칙 관리 시스템을 제시한다. 능동 규칙을 이용한 공간 객체의 무결성 확인은 응용 프로그래머를 무결성 확인에 대한 부담으로부터 자유롭게 할 수 있다. 본 시스템은 특정 DBMS에 종속되지 않는 독립적인 외부 시스템으로 존재하며, 능동 규칙 관리기, 규칙 베이스, 그리고 활성규칙 생성기의 3 부분으로 구성된다. 사용자가 공간 데이타베이스 응용 프로그램을 통해 공간 객체를 조작하고자 할 때, 본 시스템은 데이타베이스 트랜잭션을 단위로 조작되는 모든 공간 객체의 무결성 확인을 위해 응용 프로그램에 삽입될 무결성 제약조건 규칙들을 효율적으로 관리하는 역할을 한다.Abstract It is necessary that the integrity of spatial data shared through the spatial database system is validated and appropriately maintained, otherwise the activity of whole application system is unpredictable. Specially, the integrity of spatial data stored in public GIS has to be validated, because those data are used by various applications which make a decision on an important policy of the region and/or whole nation such as evaluation of land use, city planning, resource management, facility management, risk management/safety supervision, national defense. In this paper, we propose rule management system to support validating the integrity of spatial object, using the technique of active rule technique from active DBMS. Validating data integrity using active rules allows database application programmer to be free from a burden on validation of the data integrity. This system is an independent, external system that is not subject to specific DBMS and consists of three parts, which are the active rule manager, the rule base, and the triggered rule generator. When an user tries to manipulate spatial objects through a spatial database application program, this system serves to efficiently manage integrity rules to be inserted into the application program to validate the integrity constraints of all the spatial objects manipulated by database transactions.

Development of a Two-Way Evacuation Route Database Based on Interviews Conducted with Historic Preservation Area Residents

  • Mishima, Nobuo;Miyamoto, Naomi;Taguchi, Yoko;Kitagawa, Keiko;Oh, Yong-Sun;Park, Sun Gyu
    • International Journal of Contents
    • /
    • v.9 no.2
    • /
    • pp.48-57
    • /
    • 2013
  • It has been determined that two-way evacuation routes that connect houses to evacuation sites should be developed to protect residents of historic preservation areas from future disasters. These routes are required because traditional buildings and other historic spatial elements are located close to each other. It is important to understand residents' perceptions of evacuation routes that connect their houses to temporary safe places to develop evacuation system strategies that include effective two-way evacuation routes. This paper describes a procedure used to construct a two-way evacuation route database designed to preserve two study areas that was based on an interview survey conducted with area residents. The resulting database contained residents' perceptions of evacuation routes. The database contains categorized spatial problems related to these routes that can be used for future research.

The Improvement of the Road Facility Database Creation Using a Mobile GIS (모바일 GIS를 활용한 도로시설물 DB구축의 효율성 향상)

  • Lee, Hyun-Jik;Kim, Hyun-Tae
    • 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.

  • PDF

Visual Query and Analysis Tool of the Moving Object Database System

  • Lee, J.H.;Lee, S.H.;Nam, K.W.;Park, J.H.
    • Proceedings of the KSRS Conference
    • /
    • 2003.11a
    • /
    • pp.455-457
    • /
    • 2003
  • Diverse researches are working moving objects. The most important activities in a moving object database system are query and analysis of spatio -temporal data providing decision-making and problem solving support. Traditional spatial database query language and tools are inappropriate of the real world entities. This paper presents a spatio-temporal query and analysis tool with visual environment. It provides effective, interactive and user-friendly as well as statistic analysis. The moving objects database system stores plentiful moving objects data and performs spatio-temporal and nonspatio-temporal queries.

  • PDF