• Proceedings of the Korea Water Resources Association Conference
• /
• 2018.05a
• /
• pp.375-375
• /
• 2018

세계 수자원 시장은 연평균 6.5%씩 증가하고 있으며, 2025년 기준 1,038조원까지 급성장할 것으로 전문가들은 예상하고 있으나, 기후변화의 가속화로 인해 가뭄 및 홍수피해가 증가하여 수자원 관리가 더욱 어려워져지고 있다. 급속도로 변화는 환경에 대비하기 위해 국내에서는 수자원 및 기후변화에 대한 다양한 연구가 진행되고 있으나, 해외사업 진출 시에는 수자원 기초자료 수집에 대한 어려움을 겪고 있다. 이를 해결하기 위해 글로벌 수문기상자료 제공과 함께 GIS정보, 댐 및 저수지 관련 자료, 인문사회 자료, 물관련 통계자료, 물관련 재해자료 등을 웹으로 제공하는 글로벌 수자원 정보 시스템(GWB, Global World Bank)을 개발하고자 한다. 본 연구에서는 시스템의 통합 DB를 구축하고 관리방안을 도출하기 위해 수집된 메타데이터 속성 및 데이터구조를 파악하고, 세부항목별 자료 포맷을 분석 후 GIS기반 관측소 정보와 자료를 매칭하여 최종적으로 시스템 컨텐츠별로 DB를 맵핑하였다. 강수량과 기상자료는 33개국의 관측소 6,531개소의 일/월/연단위 관측자료와 10,977격자의 격자분석자료를 구축하였다. 수문자료는 33개국의 수문관측소 2,242개의 월/연단위 유량관측자료와 10,977격자의 월/연단위 직접유출, 기저유출, 잠재증발산의 격자분석자료를 구축하였다. 그리고, 수집된 강우와 기상자료는 기계 오작동, 자료 전송 오류 등으로 인한 결측치 및 이상치에 대해 자료품질분석을 통해 오자료에 대한 보정을 진행하였다. 해당자료는 MySQL를 활용하여 DB를 구축하였으며, GIS정보는 GeoServer를 활용하여 운영서버에 구축된 정보를 최종적으로 사용자에게 Web Browser로 표출하였다. 해당 시스템은 추후 전지구 수자원관련 정보를 제공하여 해외사업지역의 댐이나 보 등의 구조물 설계, 수자원산업의 해외 진출시 데이터 수집의 한계점 및 시간단축을 해결할 수 있어 수자원 분야에 기여 할 수 있을 것으로 판단된다.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.6 no.4
• /
• pp.99-108
• /
• 2003

In early year 2003, the previous Urban Planning Law and National Land Use Management Law were abolished and integrated into the Law regarding National Land Planning and Land Use Management. Accordingly, previous Urban Planning Information System is reformed into National Land Use Information System. This paper intends to develop indexes supporting decision-making process and to construct theme map using digital map that can be utilized for the National Land Use Information System. As a base for the index development, necessary database(DB) was established by utilizing the socio-economic information of towns and villages in Busan and a layer of public facilities. Based on the DB, multivariate analyses were performed to examine and analyze the spatial structure of Busan. It was then expressed and constructed as a theme map. The facility theme map was also constructed based on a layer of public facilities and the shortest distance between towns and villages.

• Journal of the Computational Structural Engineering Institute of Korea
• /
• v.21 no.6
• /
• pp.563-569
• /
• 2008

In this paper, the missile database system for the multidisciplinary design and optimization framework has been designed and investigated. The requirements of the missiles database are analyzed and the database design concept has been defined first. The data flow among the analysis disciplines is investigated and the Entity-Relation diagram is constructed to develop the database table and to define the database schema. The developed database system is integrated into the missile design framework to perform the store, search and management of the design data during the design and analysis of the missile development, hence the efficiency and validity of the database designed in this study has been demonstrated.

• Proceedings of the Korea Inteligent Information System Society Conference
• /
• 1999.03a
• /
• pp.161-171
• /
• 1999

Query language has been widely used as a convenient tool to obtain information from a database. However, users demand more intelligent query processing systems that can understand the intent of an imprecise query and provide additional useful information as well as exact answers. This paper introduces a meta-database and presents a query processing mechanism that supports a variety of intelligent queries in a consistent and integrated way. The meta-database extracts data abstraction knowledge form an underlying database on the basis of a multilevel knowledge representation framework KAH. In cooperation with the underlying database, the meta-database supports four types of intelligent queries that provide approximately or conceptually equal answers as well as exact ones.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.36 no.2
• /
• pp.67-74
• /
• 2018

This study has proposed a methodology to detect suspicious facilities that occupy national and public land by using the cadastral and digital maps. First, we constructed a spatial database of national & public land based on the cadastral maps by linking its management ledger. Using the PNU (Parcel Number) code as a key field, the data managed by different institutions are integrated into a single spatial information DB (database) and then, the use or nonuse state of each parcel is confirmed on the cadastral map. Next, we explored the suspicious facilities that existed in the unused parcel by utilizing the digital topographical map. Then, the proposed methodology was applied for various regions and tested its feasibility. Through this study, it will be possible to improve the utilization of digital maps and to manage the national and public land efficiently and economically.

• The Korean Journal of Archival Studies
• /
• no.78
• /
• pp.153-195
• /
• 2023

RDBMS is a widely used database system worldwide, and the term dataset refers to the vast amount of data produced in administrative information systems using RDBMS. Unlike business systems that mainly produce administrative documents, administrative information systems generate records centered around the unique tasks of organizations. These records differ from traditional approval documents and metadata, making it challenging to seamlessly transfer them to standard record management systems. With the 2022 revision of the 'Public Records Act Enforcement Decree,' dataset was included in the types of records for which only management authority is transferred. The core aspect of this revision is the need to manage the lifecycle of records within administrative information systems. However, there has been little exploration into how to manage dataset within administrative information systems. As a result, this research aims to design a database for a record management module that needs to be integrated into administrative information systems to manage the lifecycle of records. By modifying and supplementing ISO 16175-1:2020, we are designing an "human resource management system" and identifying and evaluating personnel management dataset. Through this, we aim to provide a concrete example of record management within administrative information systems. It's worth noting that the prototype system designed in this research has limitations in terms of data volume compared to systems currently in use within organizations, and it has not yet been validated by record researchers and IT developers in the field. However, this endeavor has allowed us to understand the nature of dataset and how they should be managed within administrative information systems. It has also affirmed the need for a record management module's database within administrative information systems. In the future, once a complete record management module is developed and standards are established by the National Archives, it is expected to become a necessary module for organizations to manage dataset effectively.

• Journal of KIISE:Computing Practices and Letters
• /
• v.16 no.8
• /
• pp.825-836
• /
• 2010

The advancement of electronic records brought great changes of the records management system. One of the biggest changes is the transition from passive to automatic management system, which manages massive records more efficiently. The integrated Rule-Oriented Data System (iRODS) is a rule-oriented grid system S/W which provides an infrastructure for building massive archive through virtualization. It also allows to define rules for data distribution and back-up. Therefore, iRODS is an ideal tool to build an electronic record management system that manages electronic records automatically. In this paper we describe the issues related to design and implementation of the electronic record management system using iRODS. We also propose a system that serves automatic processing of distribution and back-up of records according to their types by defining iRODS rules. It also provides functions to store and retrieve metadata using iRODS Catalog (iCAT) Database.

• Spatial Information Research
• /
• v.15 no.3
• /
• pp.335-346
• /
• 2007

Road sign is one of the road attached facilities to provide conveniences to motor drivers. The setup of location information according to the related regulation and the inclusion of various attributes such as place names, route numbers, symbols, bearings, distances to the place of interest distinguish the road sign from other facilities. These features give advantages to the informationization of road sign. Presently there established about 130,000 road signs on each class of roads, and about 280 road management offices have controlled these road signs independently, but there are plethora of ineffectiveness such as the lack of consistency, recognition, connectivity, and location suitability etc. These are the major factor of confusions rather than providing conveniences, and arisen a lot of public grievances. Accordingly, in this research the road signs throughout the nation were databased and the web-GIS based road sign management system was established to ameliorate the problems reveled. Since the road sign management system we developed reflected the demands of the persons in charge and users, the management effectiveness might be enhanced and the public inconveniences will be reduced.

• The Journal of the Korea Contents Association
• /
• v.13 no.12
• /
• pp.974-985
• /
• 2013

This research aimed to propose policy alternatives on acquisition and retention of SME's R&D personnel through the analysis of the status and problems of SME's R&D personnel. As research methods, literature review, survey analysis, domestic and foreign R&D personnel support system and practices benchmarking, human capital corporate panel (HCCP) and integrated survey DB material analysis, and case investigation by interview were used. The occupational status and problems of SME R&D personnel concerned on the corporate size, HRM practices on satisfaction and HRD problems, talent personnel management and training system status, the core talent management system and R&D personnel management system, and its complaints were organized. As conclusion, we have proposed alternatives on acquisition and retention of R&D personnel focused on the talent management. Suggestions were such as supports on R&D personnel management system and its dissemination, systematic career development programs, and excellency promotion on SME's and R&D talent personnel.

• Proceedings of the Korean Institute Of Construction Engineering and Management
• /
• 2007.11a
• /
• pp.886-891
• /
• 2007

All sorts of technique for schedule progress management is being developed recently. These can change and develop the abstractive concept model to a detailed model that describes the visual 3D image about a schedule plan. but, this technique is troublesome, because this requires the handwork by means of connection between 3D-CAD and scheduling Program. In this study, the process of real-time schedule progress control system using the integrated database by 3D-CAD object information system and schedule module is presented. This study present the process of a schedule progress management using IDEF0 model, and the process of real-time schedule progress management using RFID system. Through this study, we want to realize the rapid generation of estimated schedule information and to simulate and analyze actual schedule information by real-time.