• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.18 no.10
• /
• pp.117-124
• /
• 2017

A Smart Grid is a system that can efficiently use energy by exchanging real-time information in both directions between a consumer and a power supplier using ICT technology on an existing power network. DR(Demand response) is an arrangement in which electricity users can sell the electricity they save to the electricity market when the price of electricity is high or the power system is crisis. In this study, we developed a power meter data transmission device and power IT system that measure the demand information in real-time using a smart meter and transmit it to a cloud server. The power meter data transmission device developed in this study uses alight sensor connected to a Raspberry Pi 3 to measure the number of blinking lamps on the KEPCO meter per unit of power, in order to provide reliable data without any measurement errors with respect to the KEPCO power data. The power measurement data transmission device uses the standard communication protocol, OpenADR 2.0b. The measured data is transmitted to the power IT system, which consists of the VEN, VTN, and calculation program, via the LTE WiFi communication network and stored in its MySQL DB. The developed power measurement data transmission device issues a power supply instruction and performs a peak reduction DR when a power system crisis occurs. The developed power meter data transmission device has the advantage of allowing the user to adjust it every 1 minute, where as the existing smart metering time is fixed at once every 15 minutes.

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

• Korean Journal of Remote Sensing
• /
• v.33 no.5_2
• /
• pp.751-762
• /
• 2017

A crop information system can provide information regarding crop distribution, crop growth conditions, crop yield in various forms such as monitoring, forecasting, estimation or analysis. This paper presents the design and construction of a crop information system based on data collected in Korea, USA, and China. Therein, climate data including temperature, precipitation,solar radiation are used to evaluate the impact on crop growth, NDVI (Normalized Difference Vegetation Index) data is used in crop monitoring, and crop map data is utilized for the management of crop distribution. The system has achieved three prominent results: 1) Providing information with high frequency, 2) Automatically creating the report through the analysis of the data, 3) The users to easily approach the system and retrieve the information.

• Journal of Society of Preventive Korean Medicine
• /
• v.22 no.1
• /
• pp.91-105
• /
• 2018

Objectives : The purpose of this study was to introduce the case of using eCRF system in the Smoking Cessation Program project in Vietnam (2017). And aimed to derive the usefulness of the eCRF system and it potential for future global health business. Method : Introduce the smoking cessation program in vietnam (2017). Smoking Cessation was conducted in three provices of central vietnam Tamphu, Binhtu, Duytrinh) and eCRF was developed on the web environment by building AMP(Apache, PHP, MySQL). Dedicated application have also been developed for user. Result : Using the eCRF, the results of the program of the smoking cessation participants were recorded on the Database server. The implemented system focused on the role of a case recording platform that was simplified in function rather than an electronic version of the case report. It was useful for monitoring. Conclusions : The eCRF system was useful in global health business, and upgrading the system to reflect the feedback derived from the project could potentially be used in other projects. In addition, there are few cases where ICT is used in overseas health promotion projects using Oriental medicine, so further research is needed.

• BMB Reports
• /
• v.39 no.4
• /
• pp.441-447
• /
• 2006

Abuse of drugs can elicit compulsive drug seeking behaviors upon repeated administration, and ultimately leads to the phenomenon of addiction. We developed a procedure for the standardization of microarray gene expression data of rat brain in drug addiction and stored them in a single integrated database system, focusing on more effective data processing and interpretation. Another characteristic of the present database is that it has a systematic flexibility for statistical analysis and linking with other databases. Basically, we adopt an intelligent SQL querying system, as the foundation of our DB, in order to set up an interactive module which can automatically read the raw gene expression data in the standardized format. We maximize the usability of this DB, helping users study significant gene expression and identify biological function of the genes through integrated up-to-date gene information such as GO annotation and metabolic pathway. For collecting the latest information of selected gene from the database, we also set up the local BLAST search engine and non-redundant sequence database updated by NCBI server on a daily basis. We find that the present database is a useful query interface and data-mining tool, specifically for finding out the genes related to drug addiction. We apply this system to the identification and characterization of methamphetamine-induced genes' behavior in rat brain.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.8 no.4
• /
• pp.97-104
• /
• 2008

Recently the navigation service and LBS (Location based Services) using map supports much information services on mobile terminal. Also Internet Web sites support user much information. But, the user has the difficulty for acquiring the service and the various information based on map because of searching the many Internet sites. Accordingly, this paper supports a convergence information service model of various culture, education, tourism, sport and traffic for accessing synthesizing information based on map. And we design and implement this model using 공개 API. We present a convergence information service model of culture, tourism, sport and bus line information form tour destination and cultural place of Jeju province using the model. Additionally, we develop this service model using apache web server on Linux environment, PHP and JavaScript, MySQL database and Map 공개 API. As this service model supports a convenience action of culture and tourism for Jeju islanders and tourists.

• Korean Journal of Health Education and Promotion
• /
• v.20 no.3
• /
• pp.125-143
• /
• 2003

With the shift of cause of death from infection to chronic, the health expenditure has risen dramatically. To curb the increasing health expenditure, programs and campaigns to promote health were proposed and implemented. Most of them, however, were not successful in achieving satisfactory results. Customer Relationship Management has been gradually accepted as an innovative approach to health promotion. The objective of this research was to develop a Customer Relationship Management system for providing comprehensive health care services to the residents in the community. Detailed objectives were as follows： The first objective was the development of the CRM system for health promotion. The second objective was the satisfaction assessment for the health promotion program using the CRM system. The third was the proposal for the effective utilization of the CRM system. The development methodology of the CRM system was Rapid Warehouse Developing Method. As a CRM system equipment, a workstation with GIS of Windows 2000 was selected. SQL Server 2000 was used as a development tool and database. The subjects of study were diabetic mellitus patients, hypertension patients, and vaccin patients. The campaign channel of patients was an autocalling system. For the satisfaction assessment, a survey was performed. The main content of the survey was satisfaction level. The satisfaction level of the health promotion program using CRM system was 79.3%. In consideration of the above findings, we suggested ways of improving the Health Promotion Program by using CRM. The first was the efficient selection of the subjects of the Health Promotion Program. The second was the development for health promotion program using CRM system(life time health of individual etc).

• Journal of Advanced Marine Engineering and Technology
• /
• v.40 no.5
• /
• pp.418-428
• /
• 2016

In this study, a Vessel Shore Report Management System (VSRMS) is developed for the International Maritime Organization (IMO), Maritime Service Portfolio (MSP) Number 8, which comprises vessel shore reporting. Several documents have to be completed before the arrival/departure of a vessel at a port, as each national port has its own reporting format and data. The present vessel reporting system is inefficient, time-consuming, and involves excessive paperwork, which results in duplications and errors. To solve this problem, in this study, the vessel reporting formats and data contents of various national ports are investigated, as at present, the reporting documents required by the current IMO standard includes insufficient information which is requested by national ports. Initially, the vessel reporting information of various national ports are collected and analyzed. Subsequently, a database structure for managing vessel reporting data for ports worldwide is devised. To make the transfer of data and the exchange of information of vessel reports much more reliable, efficient, and paper-free, VSRMS, which is a software application for the simplification and facilitation of vessel report formalities, is developed. This application is developed using the latest Microsoft C#.Net Programming Language in the Microsoft Visual Studio framework 4.5. It provides a user interface and a backend MySQL server used for database management. SAP Crystal Reports 2013 is used for designing and generating vessel reports in the original report formats. The VSRMS can facilitate vessel reporting and improve data accuracy through the reduction of input data, efficient data exchange, and reduction of the cost of communication. Adoption of the VSRMS will allow the vessel shore reporting system to be automated, resulting in enhanced work efficiency for shipping companies. Based on this information system and architecture, the consensus of various international organizations, such as the IMO, the International Association of Marine Aids to Navigation and Lighthouse Authorities (IALA), the Federation of National Associations of Ship Brokers and Agents (FONASBA), and the Baltic and International Maritime Council (BIMCO), is required so that vessel reporting is standardized internationally.

• Spatial Information Research
• /
• v.18 no.4
• /
• pp.141-149
• /
• 2010

One of recent trends in Web-based GIS is the system development using FOSS (Free and Open Source Software). Open Source software is independent from the technologies of commercial software and can increase the reusability and extensibility of existing systems. In this study, we developed a Web-based GIS for interactive visualization of geographic information using Google Earth and spatial DBMS(database management system). Google Earth Plug-in and Google Earth API(application programming interface) were used to embed a geo-browser in the Web browser. In order to integrate the Google Earth with a spatial DBMS, we implemented a KML(Keyhole Markup Language) generator for transmitting server-side data according to user's query and converting the data to a variety of KML for geovisualization on the Web. Our prototype system was tested using time-series of LAI(leaf area index), forest map, and crop yield statistics. The demonstration included the geovisualization of raster and vector data in the form of an animated map and a 3-D choropleth map. We anticipate our KML generator and system framework will be extended to a more comprehensive geospatial analysis system on the Web.

• Journal of KIISE:Databases
• /
• v.29 no.6
• /
• pp.492-501
• /
• 2002

An asynchronous trigger processor (ATP) is a oftware system that processes triggers after update transactions to databases are complete. In an ATP, discrimination networks are used to check the trigger conditions efficiently. Discrimination networks store their internal states in memory nodes. TriggerMan is an ATP and uses Gator network as the .discrimination network. The changes in databases are delivered to TriggerMan in the form of tokens. Processing tokens against a Gator network updates the memory nodes of the network and checks the condition of a trigger for which the network is built. Parallel token processing is one of the methods that can improve the system performance. However, uncontrolled parallel processing breaks trigger processing semantic consistency. In this paper, we propose four trigger processing consistency levels that allow parallel token processing with minimal anomalies. For each consistency level, a parallel token processing technique is developed. The techniques are proven to be valid and are also applicable to materialized view maintenance.