• Journal of Korea Water Resources Association
• /
• v.54 no.12
• /
• pp.1339-1348
• /
• 2021

In accordance with the River Law, the basic river maintenance plan is established every 5-10 years with a considerable national budget for domestic rivers, and various river surveys such as the river section required for HEC-RAS simulation for flood level calculation are being conducted. However, river survey data are provided only in the form of a pdf report to the River Management Geographic Information System (RIMGIS), and the original data are distributedly owned by designers who performed the river maintenance plan in CAD format. It is a situation that the usability for other purposes is considerably lowered. In addition, when using surveyed CAD-type cross-sectional data for HEC-RAS, tools such as 'Dream' are used, but the reality is that time and cost are almost as close as manual work. In this study, RAUT (River Information Auto Upload Tool), a tool that can solve these problems, was developed. First, the RAUT tool attempted to automate the complicated steps of manually inputting CAD survey data and simulating the input data of the HEC-RAS one-dimensional model used in establishing the basic river plan in practice. Second, it is possible to directly read CAD survey data, which is river spatial information, and automatically upload it to the river spatial information DB based on the standard data model (ArcRiver), enabling the management of river survey data in the river maintenance plan at the national level. In other words, if RIMGIS uses a tool such as RAUT, it will be able to systematically manage national river survey data such as river section. The developed RAUT reads the river spatial information CAD data of the river maintenance master plan targeting the Jeju-do agar basin, builds it into a mySQL-based spatial DB, and automatically generates topographic data for HEC-RAS one-dimensional simulation from the built DB. A pilot process was implemented.

• Korean Journal of Remote Sensing
• /
• v.26 no.5
• /
• pp.561-570
• /
• 2010

The purpose of this study is to develop an Android smartphone app providing analysis capabilities of remote sensing images, by using mobile browsing open sources of gvSIG, open source remote sensing software of OTB and open source DBMS of PostgreSQL. In this app, five kinds of remote sensing algorithms for filtering, segmentation, or classification are implemented, and the processed results are also stored and managed in image database to retrieve. Smartphone users can easily use their functions through graphical user interfaces of app which are internally linked to application server for image analysis processing and external DBMS. As well, a practical tiling method for smartphone environments is implemented to reduce delay time between user's requests and its processing server responses. Till now, most apps for remotely sensed image data sets are mainly concerned to image visualization, distinguished from this approach providing analysis capabilities. As the smartphone apps with remote sensing analysis functions for general users and experts are widely utilizing, remote sensing images are regarded as information resources being capable of producing actual mobile contents, not potential resources. It is expected that this study could trigger off the technological progresses and other unique attempts to develop the variety of smartphone apps for remote sensing images.

• Spatial Information Research
• /
• v.6 no.2
• /
• pp.133-152
• /
• 1998

This article considers the experimental foundations of geographical phenomena for the distribution of lodging houses and the development of lodging Information Systems in Shin-Chon Area. This system allows the rural students to find their lodging houses conveniently. We examine the geographical reality of lodging houses in Shin-chon area and explores the lodging information system, reflecting how students select the lodging houses. Criteria for selection of lodging houses are travel time to school, interior facilities, rent fee, members, owners of lodging houses, which are collected by field swvey. The lodging information system is built in integration of Visual Basic with spatial data which are created in Mapinfo and Arcview through MapObject, component GIS software. This system provide query tools to efficiently investigate data as well as interactive map display. Also it displays the characteristics of a selected lodging houses using the identify tool on the map.

• Journal of Bio-Environment Control
• /
• v.28 no.1
• /
• pp.16-27
• /
• 2019

Using virtual reality technology, users can learn and experience many interactions in virtual space like the actual physical space. This study was conducted to develop air flow simulator that allows farmers and consultants to consult air flow through VR devices by creating a greenhouse or pigpen model. It can help educate farmers about the importance of ventilation effects for agricultural facilities. We proposed CFD visualization system by building a virtual reality environment and constructing database of CFD and structure of agricultural facilities. After consultants can set up situations according to environmental conditions, the users experience the visualized air flow of agricultural facility according to the ventilation effects. Also it can provide a quantified environmental distribution in the agricultural facility. Currently, the CFD data in agricultural facilities are established during winter and summer. In order to experience various environmental conditions in the developed system, The experts need to run CFD data under various environmental conditions and register them in the system requirements.

• Journal of the Korea Society of Computer and Information
• /
• v.27 no.8
• /
• pp.77-84
• /
• 2022

In this paper, we propose a system for monitoring air pollutants such as fine dust using an unmanned aerial vehicle capable of autonomous navigation. The existing air quality management system used a method of collecting information through a fixed sensor box or through a measurement sensor of a drone using a control device. This has disadvantages in that additional procedures for data collection and transmission must be performed in a limited space and for monitoring. In this paper, to overcome this problem, a GPS module for location information and a PMS7003 module for fine dust measurement are embedded in an unmanned aerial vehicle capable of autonomous navigation through flight information designation, and the collected information is stored in the SD module, and after the flight is completed, press the transmit button. It configures a system of one-stop structure that is stored in a remote database through a smartphone app connected via Bluetooth. In addition, an HTML5-based web monitoring page for real-time monitoring is configured and provided to interested users. The results of this study can be utilized in an environmental monitoring system through an unmanned aerial vehicle, and in the future, various pollutants measuring sensors such as sulfur dioxide and carbon dioxide will be added to develop it into a total environmental control system.

• Journal of Environmental Impact Assessment
• /
• v.31 no.4
• /
• pp.214-225
• /
• 2022

This study emphasized the soil of environmental impact assessment to devise measures to minimize the negative impact of project implementation on the environment. As a series of efforts for impact assessment procedures, a national inventory-based database was established for urban development projects, and three machine learning model performance evaluation as well as soil pollutant concentration distribution mapping were conducted. Here, nine soil pollutants were mapped to the metropolitan area of South Korea using the Random Forest model, which showed the best performance. The results of this study found that concentrations of Zn, F, and Cd were relatively concerned in Seoul, where urbanization is the most active. In addition, in the case of Hg and Cr6+, concentrations were detected below the standard, which was derived from a lack of pollutants such as industrial and industrial complexes that affect contents of heavy metals. A significant correlation between land cover and pollutants was inferred through the spatial distribution mapping of soil pollutants. Through this, it is expected that efficient soil management measures for minimizing soil pollution and planning decisions regarding the location of the project site can be established.

• Journal of KIISE:Computing Practices and Letters
• /
• v.16 no.11
• /
• pp.1031-1040
• /
• 2010

Hash join is one of the core algorithms in databases management systems. If a hash join cannot complete in one-pass because the available memory is insufficient (i.e., hash table overflow), however, it may incur a few sequential writes and excessive random reads. With harddisk as the tempoary storage for hash joins, the I/O time would be dominated by slow random reads in its probing phase. Meanwhile, flash memory based SSDs (flash SSDs) are becoming popular, and we will witness in the foreseeable future that flash SSDs replace harddisks in enterprise databases. In contrast to harddisk, flash SSD without any mechanical component has fast latency in random reads, and thus it can boost hash join performance. In this paper, we investigate several important and practical issues when flash SSD is used as tempoary storage for hash join. First, we reveal the va patterns of hash join in detail and explain why flash SSD can outperform harddisk by more than an order of magnitude. Second, we present and analyze the impact of cluster size (i.e., va unit in hash join) on performance. Finally, we emperically demonstrate that, while a commerical query optimizer is error-prone in predicting the execution time with harddisk as temporary storage, it can precisely estimate the execution time with flash SSD. In summary, we show that, when used as temporary storage for hash join, flash SSD will provide more reliable cost estimation as well as fast performance.

• The KIPS Transactions:PartD
• /
• v.18D no.1
• /
• pp.1-8
• /
• 2011

The cache structure, which is designed for assuring fast accesses to frequently accessed data, resides on the various levels of computer system hierarchies. Many studies on this cache structure have been conducted and thus many page-replacement algorithms have been proposed. Most of page-replacement algorithms are designed on the basis of heuristic methods by using their own criteria such as how recently pages are accessed and how often they are accessed. This data-retrieval process in computer systems is analogous to human memory retrieval process since the retrieval process of human memory depends on frequency and recency of the retrieval events as well. A recent study regarding human memory cognition revealed that the possibility of the retrieval success and the retrieval latency have a strong correlation with the frequency and recency of the previous retrieval events. In this paper, we propose a novel page-replacement algorithm by utilizing the knowledge from the recent research regarding human memory cognition. Through a set of experiments, we demonstrated that our new method presents better hit-ratio than the LRFU algorithm which has been known as the best performing page-replacement algorithm for DBMS caches.

• Journal of KIISE:Databases
• /
• v.30 no.2
• /
• pp.176-183
• /
• 2003

Various techniques including histograms, sampling and parametric techniques have been proposed to estimate query result sizes for the query optimization. Histogram-based techniques are the most widely used form for the selectivity estimation in relational database systems. However, in the spatio-temporal databases for the moving objects, the continual changes of the data distribution suffer the direct utilization of the state of the art histogram techniques. Specifically for the future queries, we need another methodology that considers the updated information and keeps the accuracy of the result. In this paper we propose a novel approach based upon the duality and the marginal distribution to construct a histogram with very little time since the spatio-temporal histogram requires the data distribution defined by query predicates. We use data synopsis method in the dual space to construct spatio-temporal histograms. Our method is robust to changing data distributions during a certain period of time while the objects keep the linear movements. An additional feature of our approach supports the dynamic update incrementally and maintains the accuracy of the estimated result.

• Journal of the Institute of Convergence Signal Processing
• /
• v.4 no.1
• /
• pp.1-8
• /
• 2003

Various methods have been studying to maintain and apply the multimedia inform abruptly increasing over all social fields, in recent years. For retrieval of still images, we is implemented content-based image retrieval system in this paper that make possible to retrieve similar objects from image database after segmenting query object from background if user request query. Query image is processed median filtering to remove noise first and then object edge is detected it by canny edge detection. And query object is segmented from background by using convex hull. Similarity value can be obtained by means of histogram intersection with database image after securing color histogram from segmented image. Also segmented image is processed gray convert and wavelet transform to extract spacial gray distribution and texture feature. After that, Similarity value can be obtained by means of banded autocorrelogram and energy. Final similar image can be retrieved by adding upper similarity values that it make possible to not only robust in background but also better correct object retrieval by using object segmentation method.