• Journal of Digital Convergence
• /
• v.13 no.2
• /
• pp.193-204
• /
• 2015

An array DBMS has been expected widely from scientists because it is convenient to store and analyze the data of array type. In this paper, we describe how to handle satellite remote-sensing images in the array DBMS. However, previous works in their visualization have two problems as follows. First, the images are visualized as a state of distorted by the curvature of the earth. Second, it is difficult to apply the results of visualization by pre-written queries to other analyses. Therefore, this paper proposes a three dimensional visualization method of satellite remote-sensing images, not traditional 2D visualization. Our research contents are as follows. First, we describe how to store, process, and analyze the satellite remote-sensing images in the array DBMS. Second, we propose a three-dimensional visualization method for their processed outputs. Lastly, our contributions can be summarized that we propose a method of handling satellite remote-sensing images in the array DBMS and their 3D visualization techniques. It is also expected that their use be available widely in many industrial areas.

• Journal of Biosystems Engineering
• /
• v.39 no.4
• /
• pp.267-273
• /
• 2014

Purpose: This study was conducted to develop a web-based business management system to ensure the efficient operation and transparent management of government-subsidized agricultural machinery rental businesses. Methods: An MS_SQL2000 database management system (DBMS) solution was utilized in the system for high system compatibility and integrated management. This system was targeted to be compatible with Internet Explorer 6.0 or later and to ensure security and seamless web operations. The system administrator is able to manage a fleet of agricultural machinery, including various inventory codes, release and return, fleet registry, and business performance. Users (farmers) may search the database of rental machinery and reserve them. Results: With respect to rental reservations, the system administrator can manage the fleet by setting the rental status to Approved, Released, or Returned. Through the web, the administrator can also create a database that includes machinery specifications, features, and rental rates. In addition, business performance data can be analyzed using a diverse array of tools to streamline the rental business. Without having to go to the rental office, users can save time and money by searching for and renting agricultural machinery through the information available on the website, including availability, specifications, and rental fees. After deploying the system, the time required to analyze monthly performance and create reports was dramatically reduced from 20 days per person to one day per person. Conclusions: Since 2014, AMRB has been installed and is operating in agricultural machinery rental businesses in 31 cities and counties in South Korea. This study recommends continued expansion and dissemination of AMRB for the systematic and efficient management of agricultural machinery rental businesses.

• Journal of Korea Spatial Information System Society
• /
• v.10 no.1
• /
• pp.1-14
• /
• 2008

Recently, because of the need to wide-area spatial data for spatlal analysis and military purpose, there are increasing demand for the efficient retrieval of mass spatial data in Geographic Information System(GIS) fields. Oracle Spatial and ESRI ArcSDE, that are GIS Software, are to manage mass spatial data stably and to support various services but they are inefficient to retrieve mass spatial data because of the complexity of their spatial data models and spatial operations. Therefore, in this paper, we developed a spatial middleware that can retrieve mass spatial data efficiently. The spatial middleware used Oracle which is a representative commercial DBMS as a repository for the stable management of spatial data and utilized OCCI(Oracle C++ Call Interface) for the efficient access of mass spatial data in Oracle. In addition, various spatial operating methods and the Array Fetch method were used in the spatial middleware to perform efficient spatial operations and retrieval of mass spatial data in Oracle, respectively. Finally, by comparing the spatial middleware with Oracle Spatial and ESRI ArcSDE through the performance evaluation, we proved its excellent retrieval and storage performance of mass spatial data.