• Title/Summary/Keyword: DB Management Tool

Search Result 81, Processing Time 0.022 seconds

A Study on the Improvement of Land Suitability Assessment Results Using GIS Database (디지털 지리정보DB를 활용한 토지적성평가 결과의 향상을 위한 실행방법 연구)

  • Kim, Hang-Jib
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.8 no.1
    • /
    • pp.1-12
    • /
    • 2005
  • Land suitability assessment is the procedure that assesses development, agriculture or conservation suitability of land according to such criteria as soil, location and usability. But there are many problems to execute land assessment by law. Problems include inadequate basic data, lack of linkage with the spatial planning system, and inefficiency in operation. The purpose of this study is to improve methods of land suitability assessment as a sustainable land use management tool using case study. In this study, land suitability assessment will be executed through GIS. On the basis of the results of this case study, practical and institutional problems are described, and technical solutions are suggested.

  • PDF

Development of National Scale Environmental & Geographical Information System for Supporting Exposure Assessment (노출평가를 위한 전국규모의 환경지리지형정보 시스템 개발)

  • Kim, Jong-Ho;Kim, Mi-Sug;Kwak, Byeong-Kyu;Yoo, Hong-Suk;Shin, Chi-Bum;Yi, Jong-Heop
    • Journal of Korean Society of Environmental Engineers
    • /
    • v.28 no.10
    • /
    • pp.1082-1089
    • /
    • 2006
  • This study describes a methodology to develop a environmental and geographical information system for managing a national scale which is supports the environmental fate modeling. This system was developed via the integration of environmental and geographical information database(DB) and the DB usage software. For the sound environmental management, the DB were constructed by extracting the geometrical figures-such as points, polylines, and/or polygons-based on the geographical information previously developed in Korea. Then it was connected with the environmental information. Based on the Visual Basic Complier, the software can be a useful tool for visualizing the DB, for searching the environmental & geographical information, and supporting the environmental fate modeling.

The Building for Standard Specification DB of Urban Transit System Infrastructure used by Computer Design Tool (전산지원도구를 이용한 도시철도시설 표준사양 DB 구축 연구)

  • Lee, Woo-Dong;Park, Kee-Jun;Chung, Jong-Duk
    • Proceedings of the KSR Conference
    • /
    • 2006.11b
    • /
    • pp.791-795
    • /
    • 2006
  • Urban transit is one of the most effective ways for efficient operation and construction of an urban transit by composition system which is liked originally such as rolling-stock, power, signal and infrastructure. Urban rail transit system is running in domestic, imports major equipments from advanced countries and setup for maintenance. But it takes long time because it does each organizations and lines. Also, signal, power and track system apply different standard by each construction organizations it causes an increasing construction of cost accordingly it desperately needs a systematic countermeasure. Therefore standard specification of urban transit have been establishing and operatingfor efficient operation of urban transit and base technology security that is populace ride to become a base of state economy. After track, power and signal system will be announced. Standard specification become more, the importance of administrationof standards is emphasized more. Specification administrator’s the importance which use a computing support tool recently in railroad part in embossed and is predicted to be more such forward. Therefore we propose the effective method of management with track, power signal system by constructed data-base system.

  • PDF

RAUT: An end-to-end tool for automated parsing and uploading river cross-sectional survey in AutoCAD format to river information system for supporting HEC-RAS operation (하천정비기본계획 CAD 형식 단면 측량자료 자동 추출 및 하천공간 데이터베이스 업로딩과 HEC-RAS 지원을 위한 RAUT 툴 개발)

  • Kim, Kyungdong;Kim, Dongsu;You, Hojun
    • 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.

Concept Design for Inhouse Database Construction (사내(社內) 데이터베이스 구축(構築)을 위한 개념설계(槪念設計))

  • Lee, Chang-Han
    • Journal of Information Management
    • /
    • v.23 no.2
    • /
    • pp.40-56
    • /
    • 1992
  • The inhouse database can be used as an effective tool for managing inhouse/corporaterelated informations, which efficiently support business activities as they are shared by all the inhouse members. The inhouse database construction processes can be classified into a concept design, various kinds of DB format designs, abstracting/indexing, and DB operation/maintenance. This article presents a method of systematizing the concept design elements such as information flow support system, usable resources, and so on.

  • PDF

DB Performance Management Tool MAXGAUGE: Design and Implementation of its Web Version (DB성능관리 툴 MAXGAUGE: 웹 버전 설계 및 구현)

  • 김동균;구홍민;박락빈;이상원
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2004.04b
    • /
    • pp.229-231
    • /
    • 2004
  • 대량의 정보를 빠르게 처리하기 위해 DBMS의 성능관리는 필수적이고 이를 뒷받침하기 위해 많은 툴들이 있다. 이들 제품 중의 하나인 국산 Maxgauge는 오라클 데이터베이스의 성능 현황이 어떤지 조회하고, 설정된 임계 값을 초과하는지 강시하고, 성능 문제 발생시에 원인을 추적하는 기능을 제공한다. 하지만 이는 설치의 번거로움과 국한된 환경에서만 서비스를 받을 수 있다는 한계가 있기 때문에 우리는 웹을 통해서도 시간과 장소에 구애받지 않고 성능을 관리할 수 있게끔 클라이언트/서버 버전을 웹 버전으로 설계 침 구현하였다. 1)서론 2) MAXGAUGE 소개 3) Web버전 설계 및 구현 4) 결론 및 향후구현방향 5) 참고문헌

  • PDF

Design and Implementation of SIP Traffic Management Tool (SIP(Session Initiation Protocol) 트래픽 관리 도구의 설계와 구현)

  • 강경철;류연승
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2002.04a
    • /
    • pp.289-291
    • /
    • 2002
  • 본 논문에서는 SIP(Session Initiation Protocol)을 사용하는 VoIP(Voice over IP) 네트워크에서 SIP 트래픽을 감시, 분석하는 관리 도구인 SIPMan 을 설계하고 구현하는 연구를 소개한다. 구현하는 SIPMan 은 실시간으로 SIP 패킷을 캡처하여 call 에 대한 다양한 정보를 분석하여 DB 에 저장할 수도 있다. VoIP 망 관리자는 SIPM무의 web GUI를 사용하여 call detail record, SIP 트래픽 정보 등을 모니터링말 수 있다.

  • PDF

On an Efficient Development of the Test & Evaluation Plan through the insured Traceability of the Safety Requirements (안전 요구사항의 추적성 구현을 통한 시험/평가 계획서의 효율적 개발)

  • Yoon, Jae-Han;Lee, Jae-Chon
    • Journal of the Korea Safety Management & Science
    • /
    • v.9 no.6
    • /
    • pp.89-96
    • /
    • 2007
  • It is well known that the test and evaluation plan (TEP) is very crucial in the successful development of safety-critical systems. As such, this paper discusses an approach to the development of the TEP for a system that should meet safety requirements in the systems development process. It is studied how to incorporate the result of preliminary hazard analysis (PHA) in generating the safety requirements. It is also discussed how to deal with them when the system requirements (i.e., functions, performance, constraints, components, etc) and the safety requirements are integrated into one model. While doing so, we have constructed the required traceability among them, which is necessary and very useful when the safety requirements need to be corrected or be changed. The use of the traceability makes it possible to easily check out whether and how the safety requirements are properly incorporated in the system design process. Furthermore, without the verified traceability, the system cannot be changed or upgraded later. In order to implement the model on a computer-aided tool, we have constructed a database (DB) schema. As a result, the implemented model/DB allows to automatically generate TEP which can be used to measure the performance and safety level of the developed system.

Improvement of Administration Information Dataset Transfer Tools 'SIARD_KR' (행정정보 데이터세트 이관도구 SIARD_KR의 개선방안)

  • Byeon, Woo-Yeong;Yim, Jin-Hee
    • Journal of the Korean Society for information Management
    • /
    • v.39 no.1
    • /
    • pp.195-217
    • /
    • 2022
  • SIARD_KR is an administrative information dataset preservation tool. It is a partially modified version of SIARD, technology used for long-term preservation of relational databases developed by the Swiss Federal Archives, to suit Korea's situation better. Previous studies have focused on how SIARD is able to effectively extract all data contained in the relational database without loss. However, not all data contained in the database is meaningful information, that is, an administrative information dataset. This paper began, therefore, with the awareness of the problem of whether SIARD_KR reflects the characteristics of the administrative information dataset. SIARD_KR is not only a tool for extracting data stored in the DB. We want to see if it is capable of identifying and extracting only meaningful information, and maintaining meaningful information, even if it is separated from the original system. The purpose of this paper is to analyze the structure of SIARD_KR, identify expected problems, and suggest improvement measures for them.

Prediction of User Preferred Cosmetic Brand Based on Unified Fuzzy Rule Inference

  • Kim, Jin-Sung
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2005.11a
    • /
    • pp.271-275
    • /
    • 2005
  • In this research, we propose a Unified Fuzzy rule-based knowledge Inference Systems UFIS) to help the expert in cosmetic brand detection. Users' preferred cosmetic product detection is very important in the level of CRM. To this Purpose, many corporations trying to develop an efficient data mining tool. In this study, we develop a prototype fuzzy rule detection and inference system. The framework used in this development is mainly based on two different mechanisms such as fuzzy rule extraction and RDB (Relational DB)-based fuzzy rule inference. First, fuzzy clustering and fuzzy rule extraction deal with the presence of the knowledge in data base and its value is presented with a value between $0\∼1$. Second, RDB and SQL(Structured Query Language)-based fuzzy rule inference mechanism provide more flexibility in knowledge management than conventional non-fuzzy value-based KMS(Knowledge Management Systems)

  • PDF