• Journal of the Korean Association of Geographic Information Studies
• /
• v.13 no.4
• /
• pp.1-11
• /
• 2010

This study proposed the method for the SWMM data generation connected with the spatial database and designed the data model in order to display flooding information such as the runoff sewer system, flooding areas and depth. A variety of data, including UIS, documents related to the disasters, and rainfall data are used to generate the attributes for flooding analysis areas. The spatial data is constructed by the ArcSDE and Oracle DB. The prototype system is also developed to display the runoff areas based on the GIS using the ArcGIS ArcObjects and spatial DB. The results will be applied to the flooding analysis based on the SWMM.

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

• Journal of the Korean Association of Geographic Information Studies
• /
• v.11 no.4
• /
• pp.161-171
• /
• 2008

Nowdays the need of modeling a real world using computers leads to increase the importance of GIS. Moreover, the wide spread of the Internet service has brought about Web GIS Development. Especially, the tuning of Web GIS system has a crucial role in improving the performance of high resolution image Web GIS system. Thus, this study provides a variety of ways to improve the performance of high resolution image Web GIS system. We have tuned IBM AIX operation system, Oracle, ArcSDE in the database level and Tomcat, ArcIMS in the application level. What is more, we propose ways of coding which can have a positive impact on performance. As a result, the proposed methods guarantee high resolution image Web GIS system to improve performance.

• The Transactions of the Korea Information Processing Society
• /
• v.5 no.9
• /
• pp.2281-2293
• /
• 1998

Spatial objects in the space II odd hale been changed bl eitber non-spiltial operations or spatial operations. For example, their states arc changed by the following operation: changing their owners, changing their owner's address, installing new constructions, changing precincts, splitting, and merging, The conventional geographic information system(GIS), however, did not also manage their histoncal information cecause it handles the snapshot image of spatial ohjects in the world. In this paper we therelore propose a spatiotemporal data model which is ahle to not un]y manage the historical information of spatial objects but also, support their historical intemlgation by extending a time dimension and a historical pointer for SDE(Spatial Database Engine) spatial data model. Finally, the proposed spatiotemporal data model using a layered time extension are going to contribute to manage the history of spatial objects in the world and retrieve them.

• Journal of Korea Spatial Information System Society
• /
• v.9 no.2
• /
• pp.1-11
• /
• 2007

Recently, with the development of collecting methods of spatial data, the spatial data is produced, circulated, and used in various fields of industry and research. To manage the mass spatial data efficiently, the researches on extension of the existing commercial DBMS, such as ESRI's ArcSDE or Oracle's Oracle Spatial, is making progress actively. However, the usage of the extension of the commercial DBMS Incurs an additional expense and causes an interoperability problem due to differences in spatial data types and spatial operators. Therefore, in this paper, we developed an OpenGIS Spatial Interface for Oracle, which supports a standard interface by fellowing the "Simple Features Specification for SQL" proposed by OGC(Open Geospatial Consortium). Since the OpenGIS Spatial Interface provides all spatial data types and spatial operators proposed in "Simple Features Specification for SQL", users can manage mass spatial data of Oracle efficiently by using the standard interface without additional expense. In addition, we proved that the OpenGIS Spatial Interface is superior to the Oracle Spatial in the response time through the performance evaluation.

• Spatial Information Research
• /
• v.9 no.2
• /
• pp.207-225
• /
• 2001

This study develops a GIS-based system which examines the adequacy of the Groundwater development project before the actual designing of the project. A system environment is constructed in order to efficiently and scientifically manage and analyze data related to Groundwater through a Server/Client environment. For this programs such as GIS S/W ArcVies3.2, RDBMS ORACLE, ArcSDE (Spatial Database Engine) are used. WHPA and AQTESOLV are employed as a underground water simulation program and Scripts, a language for ArcView, is used to develop graphic user interface (GUI). Using the system developed here, we can transfer simulation results obtained by WHPA regarding Groundwater levels in new development projects into GIS. We can also judge whether a Groundwater development project should be permitted through examining overlaps of th effects of the development and comparing with o pollutants. At the same time, the system has a feature of supporting Groundwater development and based designing through judging the proper amount of Groundwater in a new project. It is also possible to easily and quickly prepare charts and reports using the outputs of the system. Since a two-tiered system which shares DB using inter-and intranets is developed, all the departments in the ministry of agriculture and forest and the agriculture base corporation can share accurate, reliable and latest information related to Groundwater.

• Journal of the Korea Society of Computer and Information
• /
• v.12 no.4
• /
• pp.229-237
• /
• 2007

To solve of complex problems for access and management data stored in the very large spatial database system that need to constructed metadata for the physical and logical elements concerned with spatial and non-spatial data sets. Also, in the underground water management system which managed with spatial and non-spatial elements, need to spatial features metadata system based on feature-based. We, in this paper, proposed metadata model for the feature-based underground water management system using underground water meta-information inputted on the DXF formatted tile-based geological maps. Additional, we modeled metadata level of feature and data set and presented standard specification of underground water metadata.

• Journal of the Architectural Institute of Korea Structure & Construction
• /
• v.36 no.1
• /
• pp.163-172
• /
• 2020

This study is a case study for in-house developed Record Maintenance and Management (RMMS) which is a digital data storage/retrieval system in a GIS-enabled solution. RMMS is designed for reorganizing submitted architectural drawings associated with scanned drawings files & geodatabase, managing metadata/table and geometric features in ArcSDE/Enterprise geodatabase format. The birth of the RMMS was borne out of a necessity for a modernized approach in digital file basis to provide improved customer services for various architectural drawings and associated with geo-spatial and its attribute information. Through a case study for building permit & review practice implemented on an internet-based Electronic Architectural administration Information System (EAIS) at the local governments in Korea, this study is able to derive differences between GIS-enabled RMMS system implemented in the Richmond City and internet-based EAIS system implemented in the local government in Korea. In an effort to be the most effective, it presents meaningful ways of maximizing efficiency in record maintenance & management system derived from the case studies that looked into in ways of a method in RMMS' operation, implementation on GIS platform, mutual interface among various programs with various digital files and finally technical supports and system development /upgrade.