• Proceedings of the KSRS Conference
• /
• 2003.11a
• /
• pp.499-501
• /
• 2003

As semiconductor memory becomes cheaper, the memory capacity of computer system is increasing. Therefore computer system has sufficient memory for a plentiful spatial data. With emerging spatial application required high performance, this paper presents a GIS database system in main memory. Memory residence can provide both functionality and performance for a database management system. This paper describes design of DBMS for storing, querying, managing and analyzing for spatial and non-spatial data in main-memory. This memory resident GIS DBMS supports SQL for spatial query, spatial data model, spatial index and interface for GIS tool or applications.

• Spatial Information Research
• /
• v.20 no.1
• /
• pp.59-69
• /
• 2012

For the USN(Ubiquitous Sensor Network) environment which generally uses spatial sensor data as well as aspatial sensor data, a sensor database system to manage these sensor data is essential. In this reason, some sensor database systems such as TinyDB, Cougar are being developed by many researchers. However, since most of them do not support spatial data types and spatial operators to manage spatial sensor data, they have difficulty in processing spatial sensor data. Therefore, this paper developed a spatial sensor database system by extending TinyDB. Especially, the system supports spatial data types and spatial operators to TinyDB in order to manage spatial sensor data efficiently and provides the memory management function and the filtering function to reduce the system overload caused by sensor data streams. Lastly, we compared the processing time, accuracy, and memory usage of the spatial sensor database system with those of TinyDB and proved its superiority through the performance evaluation.

• Journal of Biosystems Engineering
• /
• v.27 no.2
• /
• pp.161-172
• /
• 2002

Database as a supporting system for decision-making is one of essential parts for realizing precision farming. Application models on constructing a database for precision farming, including collection of spatial and attribute data, were suggested using a GPS, DXF files, AutoCAD, a Java application program and PostgreSQL DBMS in this study. The constructed spatial database based on the schema design of spatial and attribute data table was evaluated as a supporting system for decision-making by a simulation of a virtual variable-rate chemical applicator. The applicator could extract the values of soil property at its consecutive location in the tested field in communication with the constructed database, and prescribe the corresponding variable-rate of chemicals. The results of the study suggested the possibility that the constructed database can function a supporting system for decision-making for precision farming.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.7 no.2
• /
• pp.87-96
• /
• 2004

When watershed spatial database is constructed from DEM, hydrological geographic characteristics of watershed can be easily extracted. And the characteristics can be assigned and managed as the attribute of spatial database. In this study the scheme of constructing framework spatial database which is basic information for managing watershed information is examined. We established framework spatial data and defined the relationship of the data. And framework spatial database of test site was constructed. In this study, HyGIS(Hydrological Geographic Information System) which is developed by domestic technology for making hydrological spatial data and developing water resources system is used. Hydrological geographic characteristics and spatial data is extracted by HyGIS. And the data from HyGIS is used for constructing framework spatial database of test site. Finally, this study suggests the strategy of constructing framework spatial database for developing watershed management system based on river network.

• Spatial Information Research
• /
• v.10 no.3
• /
• pp.421-438
• /
• 2002

Abstraction of geographic data within a spatial database context must deal with geometrical simplification, modification or maintenance of the integrity of features, spatial and aspatial data, topology within class, and relationships between classes. This research is to propose a method to abstract a spatial database into a high level database. This study refines operators to carry out the modifications required by the abstraction process in the spatial database. Then, a set of operator sequences (workflows) is suggested to specify operators required to abstract a given feature class and to arrange them in order. Finally, a prototype system is developed, based on rule management with a graphic user interface. When the abstraction process is implemented sequentially we demonstrate that a preferential ordering of operations improves efficiency and reduces loss and distortion in the information.

• Proceedings of the Korean Information Science Society Conference
• /
• 2001.04b
• /
• pp.22-24
• /
• 2001

A new GIS software Spatial Database Engine(SDE) has been developed to integrated with spatial database that combines conventional and spatially related data. As we known well in the traditional relation database system, the query evaluation techniques are a well-researched subject, many useful and efficient algorithms have been proposed, but in the spatial database system, it is a litter difference with the traditionally ones. Based on the Query Graph Model(QGM), we implemented our own query evaulation plan in the SDE, which can deal with the full functionality query statement SELECT-FROM-WHERE_GROUPBY-HAVING, and treat the spatial data and non-spatial data seamlessly. We proposed a novel multi way join algorithm base on nest loop that may be attractive.

• Spatial Information Research
• /
• v.1 no.1
• /
• pp.7-16
• /
• 1993

Current computer technologies developing. our requirements are changing from simple alpha-numeric processing to graphic and image. spatial data processing which are easy for user to understand and use. Geographic information system is a kind of spatial database system that can not only print out the data in the form of maps but also manipulate. store. retrieve. and analyze the geographic data. It is efficient system that can process the spatial data which has a geographical feature and its relative attribute data. Conventional relational database management systems are not suitable for spatial data processing, so we need to design the spatial database mana-gement system which is suitable for efficient spatial data processing. In this paper we design the extended storage management system that supports the spatial index technique that allows user to access fast and store and manage the enormous spatial data efficiently like geographic information system.

• Tunnel and Underground Space
• /
• v.11 no.1
• /
• pp.64-71
• /
• 2001

The purpose of this study is to develop rail rockfall and landslide information system to manage spatial database using GIS. For this, a spatial database containing information such as railroad, map, topographic analysis, meteorological data, and rockfall has been constructed for 2.5 km or 5 km buffer zone from the Kyungchun, Youngdong, Jungang, Taebak and Jungsun Rairoad where risk of landslide occurrence potential is high. For management of the spatial database, railroad rockfall and landslide information system has been developed. The information system consists of view, table, chart, layout and project environment. The functions provided in the system are data conversion, editing, labeling, zoom in and out, map making, graphic editing, text DB management, charting, on-line help as well as input, retrieve and output of spatial database. The system was developed using ArcView script language Avenue, and consisted of pull-down menus and icons for easy use. The spatial database and the information system can be used to rockfall and landslide management and analysis near the railroad as basic data and tool.

• Journal of Intelligence and Information Systems
• /
• v.9 no.3
• /
• pp.99-115
• /
• 2003

In this paper, we present a knowledge-based object-oriented spatial database system called KOBOS. A knowledge-based approach is introduced to the object-oriented spatial database system for data modeling and approximate query answering. For handling the structure of spatial objects and the approximate spatial operators, we propose three levels of object-oriented data model: (1) a spatial shape model; (2) a spatial object model; (3) an internal description model. We use spatial type abstraction hierarchies(STAHs) to provide the range of the approximate spatial operators. We then propose SOQL, a spatial object-oriented query language. SOQL provides an integrated mechanism for the graphical display of spatial objects and the retrieval of spatial and aspatial objects. To support an efficient hybrid query evaluation, we use the top-down spatial query processing method.

• The Bulletin of The Korean Astronomical Society
• /
• v.42 no.2
• /
• pp.88.3-89
• /
• 2017

We present our experiences with open-source NoSQL database systems in analyzing spatial and temporal astronomical data. We conduct experiments of using Redis in-memory NoSQL database system by modifying and exploiting its support of geohash for astronmical spatial data. Our experiment focuses on performance, cost, difficulty, and scalability of the database system. We also test OpenTSDB as a possible NoSQL database system to process astronomical time-series data. Our experiments include ingesting, indexing, and querying millions or billions of astronomical time-series measurements. We choose our KMTNet data and the public VVV (VISTA Variables in the Via Lactea) catalogs as test data. We discuss issues in using these NoSQL database systems in astronomy.