• Water Engineering Research
• /
• v.5 no.4
• /
• pp.157-176
• /
• 2004

This research presents a prototype development and implementation of Decision Support System (DSS) for integrated river basin water management for the flood control. The DSS consists of Relational Database Management System, Hydrologic Data Monitoring System, Spatial Analysis Module, Spatial and Temporal Analysis for Rainfall Event Tool, Flood Forecasting Module, Real-Time Operation of Multi Reservoir System, and Dialog Module with Graphical User Interface and Graphic Display Systems. The developed DSS provides an automated process of alternative evaluation and selection within a flexible, fully integrated, interactive, centered relational database management system in a user-friendly computer environment. The river basin decision-maker for the flood control should expect that she or he could manage the flood events more effectively by fully grasping the hydrologic situation throughout the basin.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.40 no.5
• /
• pp.429-437
• /
• 2022

Recently, the demand for a QA (Question Answering) system for human-machine communication has increased. Among the QA systems, a closed domain QA system that can handle spatial-related questions is called GeoQA. In this study, a new type of graph database, LPG (Labeled Property Graph) was used to overcome the limitations of the RDF (Resource Description Framework) based database, which was mainly used in the GeoQA field. In addition, GraphQL (Graph Query Language), an API-type query language, is introduced to address the fact that the LPG query language is not standardized and the GeoQA system may depend on specific products. In this study, database was built so that answers could be retrieved when spatial-related questions were entered. Each data was obtained from the national spatial information portal and local data open service. The spatial relationships between each spatial objects were calculated in advance and stored in edge form. The user's questions were first converted to GraphQL through FOL (First Order Logic) format and delivered to the database through the GraphQL server. The LPG used in the experiment is Neo4j, the graph database that currently has the highest market share, and some of the built-in functions and QGIS were used for spatial calculations. As a result of building the system, it was confirmed that the user's question could be transformed, processed through the Apollo GraphQL server, and an appropriate answer could be obtained from the database.

• Proceedings of the KSR Conference
• /
• 2003.05a
• /
• pp.326-330
• /
• 2003

The purpose of this study was to develop railroad geotechnical management system using Web GIS and the DB used in system included railroad informations and digital maps. Digital maps are primarily based on a topographical map(NGIS, 1:5000) and by adding digital maps(KRRI, 1:5000) and their spatial database system to NGI code layer, the management system was developed. The system was connected to geotechnical database already developed. The system was able to separate three parts which were layer choice, geotechnical information view and geotechnical analysis and it was possible to save geotechnical and spatial informations using ZEUS DB simultaneously. ZEUS/X was used for usefulness of GIS operation and by offering GUI, user interface for facility was achieved. Geotechnical and spatial informations in this system will provide basic data for plans, design and construction of railway lines in practical use.

• Journal of Korea Spatial Information System Society
• /
• v.8 no.1 s.16
• /
• pp.93-106
• /
• 2006

A Grid Database is a database management system to process effectively and use the distributed data in a grid computing environment. Spatial data is more important than other general data according to the local characteristics and requires a large storage. The grid database can be used as the optimal system for the management of the spatial data. However, contrary to the conventional distributed database systems, the Grid Database which guarantees the local autonomy has a possibility not to provide an effective system, or it is impossible to use a centralized management environment. In order to allow flexible responses to a dynamically changing environment, it is required to use effectively reorganized method. In this paper, hierarchical reorganization method is presented for dynamic reorganization in a grid database. When the reorganization is conducted, an organizer is created to collect the information of databases. In addition, the organizer which is constructed by the hierarchical structure supports information communication and reorganization, and then it allows the support of regional reorganization operation and effective balance control. The performance assessment of the proposed method shows that the processing capacity is increased after the reorganization.

• Spatial Information Research
• /
• v.9 no.2
• /
• pp.353-368
• /
• 2001

Recently central and local governments developed a huge spatial database and system using full-scale Geographic Information System (GIS). But Inconsistent spatial data through duplicated database management drops off in efficiency and confidence of administration. It is difficult to share data because of their unique system and data type. Under these circumstances Ministry of Construction and Transportation (MOCT) has been carrying out Land Management Information System (LMIS) to computerize land administration and policy affairs and to implement land database such as law, spatial, attribute data. A prerequisite mission of LMIS is to develop open system for solving the problem of duplicated data management and data sharing and for supporting various computer environments such as hardware, software, network etc. The purpose of LMIS is to reuse the existing investment resources and to expand the existing system resources. Therefore the purpose of this study is to investigate a method of LMIS operation under the existing circumstances and expansion of the system in the future. To do this, Supporting various DBMS, GIS server, Distributing Computing Platform(Unix, NT Server) is needed. Especially LMIS need to be developed as open system with interoperability to get independence of application from various GIS servers.

• The KIPS Transactions:PartD
• /
• v.10D no.4
• /
• pp.591-602
• /
• 2003

Delay and discontinuance phenomenon of service are cause by sudden increase of the network communication amount and the quantity consumed of resources when Internet users are driven excessively to a conventional single large database sewer. To solve these problems, spatial database cluster consisted of several single nodes on high-speed network to offer high-performance is risen. But, research about spatial join operation that can reduce the performance of whole system in case process at single node is not achieved. So, in this paper, we propose efficient parallel spatial join processing method in a spatial database cluster system that uses data partitions and replications method that considers the characteristics of space data. Since proposed method does not need the creation step and the assignment step of tasks, and does not occur additional message transmission between cluster nodes that appear in existent parallel spatial join method, it shows performance improvement of 23% than the conventional parallel R-tree spatial join for a shared-nothing architecture about expensive spatial join queries. Also, It can minimize the response time to user because it removes redundant refinement operation at each cluster node.

• Journal of Korean Society for Geospatial Information Science
• /
• v.7 no.2 s.14
• /
• pp.81-91
• /
• 1999

The study on the updating of the database of Geo-Spatial Information System that is necessary condition to GSIS operation have executed actively. In this study, digital orthophotos were produced by using the product of digital photogrammetry process and then multiscale digital orthophoto maps were generated tv the concept of image pyramids. The produced digital orthophoto has 2.092 meters accuracy compared to 1:5,000 topographic map. This digital orthophoto can be implemented in various Geo-Spatial Information System, providing valuable spatial reference for other objects in the database.

• 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.

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

The real-time traffic data is generated continuous and unbounded stream data type while intelligent transport system (ITS) needs to provide various and high quality services by combining with spatial information. Traditional database techniques in ITS has shortage for processing dynamic real-time stream data and static spatial data simultaneously. In this paper, we design and implement an advanced traffic monitoring system (ATMS) with the integration of existed data stream management system (DSMS) and spatial DBMS using IntraMap. Besides, the developed ATMS can deal with the stream data of DSMS, the trajectory data of relational DBMS, and the spatial data of SDBMS concurrently. The implemented ATMS supports historical and one time query, continuous query and combined query. Application programmer can develop various intelligent services such as moving trajectory tracking, k-nearest neighbor (KNN) query and dynamic intelligent navigation by using components of the ATMS.

• 한국공간정보시스템학회:학술대회논문집
• /
• 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.