• Title/Summary/Keyword: MySql

Search Result 183, Processing Time 0.018 seconds

Development of Water Risk Management Platform for Indonesia Area (인도네시아 물 재해 관리 플랫폼 개발과 적용성 평가)

  • Park, Dae Hee;Park, Joo Seok
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2019.05a
    • /
    • pp.381-381
    • /
    • 2019
  • 동남아시아의 급격한 도시인구 증가는 도시화로 파생되는 제반문제를 유발하고 있으며 특히 집중호우와 홍수배제 시설의 부족 및 유관시설의 정보관리체계 부재는 홍수 피해규모를 가중시키고 있다. 인도네시아의 경우 물 재해 관리기관 간의 정보공유체계 부재로, 홍수로 인한 문제해결에 대하여 효과적인 대응이 어려운 실정이다. 주요 물 관리 기관인 유역관리청(BBWS)의 경우 조기홍수경보시스템을 보유하고 있으나 단순 수문현황 모니터링에 국한되어 운영되고 있다. 이에 본 연구에서는 홍수피해를 최소화 할 수 있는 동남아시아 맞춤형 물 재해 관리 클라우드 플랫폼을 개발하여 비구조적 홍수 문제해결의 매개체로 활용하고자 한다. 기본적인 유역 수문현황 모니터링과 함께 댐, 보, 배수문 및 펌프장 등 홍수방어시설물의 운영현황 정보, 홍수상황분석, 홍수위험지도 등 종합적인 물 재해 정보를 제공하고 사전에 홍수위험 지역을 분석하여 유관기관과 공유할 수 있는 물 재해 관리 의사결정지원시스템을 개발하고자 한다. 기본적인 정보관리 체계화를 위하여 인도네시아의 다양한 물 재해 관련기관에서 보유하고 있는 자료들의 통합 클라우드 DB관리 시스템을 구축하였다. 연구대상지역은 인도네시아 수도인 자카르타의 Pesanggrahan유역과 인근 Batam섬 Baloi유역을 선정하였으며 대상 유역의 수문, 기상자료 및 GIS 정보수집은 공동연구기관인 인도네시아 공공사업부 수자원청(MPWH)과 주요 물 관리기관인 유역관리청(BBWS)의 협조를 통하여 진행하였다. 수집된 자료들은 관계형 데이터베이스 관리시스템인 MySQL을 사용하여 통합 물 재해 정보 데이터베이스를 구축하였으며 완성된 데이터베이스의 정보제공 및 공유시스템은 웹기반 인터페이스를 통해 관리되도록 설계하였다. 홍수유출 해석을 위한 분석 엔진은 K-water의 홍수분석 시스템인 FAS를 이용하였다. FAS의 홍수분석모형인 COSFIM과 수리모형인 Fldwav를 연계하는 데이터 분석 플랫폼을 완성하였으며 인도네시아 현지 조건에 부합하는 홍수분석 시스템으로 Customizing과정을 수행하였다. 또한 FAS의 PC기반 시뮬레이션 형식을 DB 연계형 웹서비스 방식으로 연동되도록 개량하였으며 추후 SaaS형 물 재해 분석시스템으로 전환할 수 있는 개발환경을 확보하였다. 개발된 물 재해 분석 플랫폼(WRMP)을 활용하여 인도네시아 공동연구기관과의 협의를 통해 물 재해 관리 시나리오를 수립하고 그 대안을 제시하였으며, 적용 시나리오별 홍수피해 저감 효과를 분석하였다. 또한 향후 방재시설물까지 연계하여 운영효과를 분석할 수 있도록 구조화하였다. 개발된 물 재해 관리 시스템은 개선된 정보처리 및 분석시스템을 활용하여 종합적인 물 재해정보를 제공하고, 사전에 홍수위험 지역을 분석하여 유관기관과 공유할 수 있는 물 재해 관리 의사결정 지원시스템으로써 유용하게 활용될 수 있을 것이다.

  • PDF

The Statistical Approach-based Intelligent Education Support System (통계적 접근법을 기초로 하는 지능형 교육 지원 시스템)

  • Chung, Jun-Hee
    • Journal of Intelligence and Information Systems
    • /
    • v.18 no.1
    • /
    • pp.109-123
    • /
    • 2012
  • Many kinds of the education systems are provided to students. Many kinds of the contents like School subjects, license, job training education and so on are provided through many kinds of the media like text, image, video and so on. Students will apply the knowledge they learnt and will use it when they learn other things. In the existing education system, there have been many situations that the education system isn't really helpful to the students because too hard contents are transferred to them or because too easy contents are transferred to them and they learn the contents they already know again. To solve this phenomenon, a method that transfers the most proper lecture contents to the students is suggested in the thesis. Because the difficulty is relative, the contents A can be easier than the contents B to a group of the students and the contents B can be easier than the contents A to another group of the students. Therefore, it is not easy to measure the difficulty of the lecture contents. A method considering this phenomenon to transfer the proper lecture contents is suggested in the thesis. The whole lecture contents are divided into many lecture modules. The students solve the pattern recognition questions, a kind of the prior test questions, before studying the lecture contents and the system selects and provides the most proper lecture module among many lecture modules to the students according to the score about the questions. When the system selects the lecture module and transfer it to the student, the students' answer and the difficulty of the lecture modules are considered. In the existing education system, 1 kind of the content is transferred to various students. If the same lecture contents is transferred to various students, the contents will not be transferred efficiently. The system selects the proper contents using the students' pattern recognition answers. The pattern recognition question is a kind of the prior test question that is developed on the basis of the lecture module and used to recognize whether the student knows the contents of the lecture module. Because the difficulty of the lecture module reflects the all scores of the students' answers, whenever a student submits the answer, the difficulty is changed. The suggested system measures the relative knowledge of the students using the answers and designates the difficulty. The improvement of the suggested method is only applied when the order of the lecture contents has nothing to do with the progress of the lecture. If the contents of the unit 1 should be studied before studying the contents of the unit 2, the suggested method is not applied. The suggested method is introduced on the basis of the subject "English grammar", subjects that the order is not important, in the thesis. If the suggested method is applied properly to the education environment, the students who don't know enough basic knowledge will learn the basic contents well and prepare the basis to learn the harder lecture contents. The students who already know the lecture contents will not study those again and save more time to learn more various lecture contents. Many improvement effects like these and so on will be provided to the education environment. If the suggested method that is introduced on the basis of the subject "English grammar" is applied to the various education systems like primary education, secondary education, job education and so on, more improvement effects will be provided. The direction to realize these things is suggested in the thesis. The suggested method is realized with the MySQL database and Java, JSP program. It will be very good if the suggested method is researched developmentally and become helpful to the development of the Korea education.

Application of MicroPACS Using the Open Source (Open Source를 이용한 MicroPACS의 구성과 활용)

  • You, Yeon-Wook;Kim, Yong-Keun;Kim, Yeong-Seok;Won, Woo-Jae;Kim, Tae-Sung;Kim, Seok-Ki
    • The Korean Journal of Nuclear Medicine Technology
    • /
    • v.13 no.1
    • /
    • pp.51-56
    • /
    • 2009
  • Purpose: Recently, most hospitals are introducing the PACS system and use of the system continues to expand. But small-scaled PACS called MicroPACS has already been in use through open source programs. The aim of this study is to prove utility of operating a MicroPACS, as a substitute back-up device for conventional storage media like CDs and DVDs, in addition to the full-PACS already in use. This study contains the way of setting up a MicroPACS with open source programs and assessment of its storage capability, stability, compatibility and performance of operations such as "retrieve", "query". Materials and Methods: 1. To start with, we searched open source software to correspond with the following standards to establish MicroPACS, (1) It must be available in Windows Operating System. (2) It must be free ware. (3) It must be compatible with PET/CT scanner. (4) It must be easy to use. (5) It must not be limited of storage capacity. (6) It must have DICOM supporting. 2. (1) To evaluate availability of data storage, we compared the time spent to back up data in the open source software with the optical discs (CDs and DVD-RAMs), and we also compared the time needed to retrieve data with the system and with optical discs respectively. (2) To estimate work efficiency, we measured the time spent to find data in CDs, DVD-RAMs and MicroPACS. 7 technologists participated in this study. 3. In order to evaluate stability of the software, we examined whether there is a data loss during the system is maintained for a year. Comparison object; How many errors occurred in randomly selected data of 500 CDs. Result: 1. We chose the Conquest DICOM Server among 11 open source software used MySQL as a database management system. 2. (1) Comparison of back up and retrieval time (min) showed the result of the following: DVD-RAM (5.13,2.26)/Conquest DICOM Server (1.49,1.19) by GE DSTE (p<0.001), CD (6.12,3.61)/Conquest (0.82,2.23) by GE DLS (p<0.001), CD (5.88,3.25)/Conquest (1.05,2.06) by SIEMENS. (2) The wasted time (sec) to find some data is as follows: CD ($156{\pm}46$), DVD-RAM ($115{\pm}21$) and Conquest DICOM Server ($13{\pm}6$). 3. There was no data loss (0%) for a year and it was stored 12741 PET/CT studies in 1.81 TB memory. In case of CDs, On the other hand, 14 errors among 500 CDs (2.8%) is generated. Conclusions: We found that MicroPACS could be set up with the open source software and its performance was excellent. The system built with open source proved more efficient and more robust than back-up process using CDs or DVD-RAMs. We believe that the operation of the MicroPACS would be effective data storage device as long as its operators develop and systematize it.

  • PDF