• Magazine of the Korean Society of Agricultural Engineers
• /
• v.40 no.3
• /
• pp.42-53
• /
• 1998

About 50 percent of irrigation and drainage facilities in our country are deteriorated as they were constructed over 40 years ago. Worsening the problems in function might be caused by these facilities' constant exposure to the elements. With these reason, efficient maintenance and management of irrigation and drainage facili- ties are required. A computerized system is tailored on the basis of the each characteristics'data of irrigation and drainage facilities. The unified management system to be introduced in this study is a package program consisting of three subprograms. Facility Management(FM) system, the first component, is a relational database system for image processing and registering the characteristics of irrigation and drainage facilities. The objective of this program is to manage the ledger of each facilities and to scan the characteristics of facilities. Telemeter(TM) system, the second component, monitors and processes the data from the sensors statistically. This system is preprogramed for the complete design of TC/TM system. Hydrological Data Management(HDM) system, the third component, executes the hydrological analysis using meteorological data. The unified management system can provide the latest information, such as image data, lists and items of facilities, and items of reforming and rebuilding etc., of the facilities to the manager. At the same time, this system can manage hydrological and meteorological data in realtime.

• The Transactions of the Korea Information Processing Society
• /
• v.5 no.6
• /
• pp.1404-1417
• /
• 1998

Currently, there exists two different methods for database retrieval in the internet. First is to use the search engine and the second is to use the plug-in or ActiveX technology, If a search engine, which makes use of indices built from keywords of simple text data in order to do a search, is used when accessing a database, first it is not possible to access more than one database at a time, second it is also not possible to support various conditional retrievals as in using query language, and third the set of data received might include many unwanted data, in other words, precision rate might be relatively low. Plug in or Active technology make use of Web browset to execute chents' query in order to do a database retrieval. Problems associated with this is that it is not possible to activate more than one DBMS simultaneously even if they are of the same data model. sefond it is not possible to execute a user query other than the ones thai arc previou sly defined by the client program In this paper, to resolve those aforementioned problems we design and implement database retrieval system using a virtual database, which makes it possible to provide direct query jntertacc through the conventional Web browser. We assume that the virtual database is designed and aggregated from more than one relational database using the same data model.

• Journal of Chest Surgery
• /
• v.35 no.3
• /
• pp.209-216
• /
• 2002

Background: Valvular heart disease is still the most common health problem in Korea. By the end of the year 1999, there has been 94,586 cases of open heart surgery since the first case in 1958. Among them, 36,247 cases were acquired heart diseases and 20,704 of those had valvular heart disease. But there was no database system and every surgeon and physician had great difficulties in analysing and utilizing those tremendous medical resources. Therefore, we developed a valve registry database program and utilize it for risk factor analysis and so on. Material and Method: Personal computer-based multiuser database program was created using Microsoft AccessTM. That consisted of relational database structure with fine-tuned compact field variables and server-client architecture. Simple graphic user interface showed easy-to-use accessability and comprehensibility. User-oriented modular structure enabled easier modification through native AccessTM functions. Infinite application of query function aided users to extract, summarize, analyse and report the study result promptly. Result: About three-thousand cases of valve replacement procedure were performed in our hospital from 1968 to 1999. Total number of prosthesis replaced was 3,700. The numbers of cases for mitral, aortic and tricuspid valve replacement were 1600, 584, 76, respectively. Among them, 700 patients received prosthesis in more than two positions. Bioprosthesis or mechanical prosthesis were used in 1,280 and 1,500 patients respectively Redo valve replacements were performed in 460 patients totally and 40 patients annually Conclusion: Database program for registry of valvular heart disease was successfully developed and used in personal computer-based multiuser environment. This revealed promising results and perspectives in database management and utilization system.

• The KIPS Transactions:PartD
• /
• v.11D no.4
• /
• pp.765-774
• /
• 2004

In order to integrate heterogeneous biological information sources, it is necessary to define the view that represents unified viewpoint for the multiple sources by hiding heterogeneity of the data. We present an XML-based view definition model and show Its operating principles in designing the middleware system to integrate biological information sources. This model supports the user-defined XML view to increase flexibility in constructing the integration system and execute integrated queries on higher level ion. Based on the view-definition model, we present a wrapping model for relational database systems and web resources as well as an application program.

• Progress in Medical Physics
• /
• v.14 no.1
• /
• pp.43-50
• /
• 2003

PACS mostly has been used in large scaled hospital due to expensive initial cost to set up the system. The network of PACS is independent of the others: network. The user's PC has to be connected physically to the network of PACS as well as the image viewer has to be installed. The web based mini-PACS can store, manage and search inexpensively a large quantity of radiologic image acquired in a hospital. The certificated user can search and diagnose the radiologic image using web browser anywhere Internet connected. The implemented Image viewer is a viewer to diagnose the radiologic image. Which support the DICOM standard and was implemented to use JAVA programming technology. The JAVA program language is cross-platform which makes easier upgrade the system than others. The image filter was added to the viewer so as to diagnose the radiologic image in detail. In order to access to the database, the user activates his web browser to specify the URL of the web based PACS. Thus, The invoked PERL script generates an HTML file, which displays a query form with two fields: Patient name and Patient ID. The user fills out the form and submits his request via the PERL script that enters the search into the relational database to determine the patient who is corresponding to the input criteria. The user selects a patient and obtains a display list of the patient's personal study and images.

• Journal of Food Hygiene and Safety
• /
• v.35 no.6
• /
• pp.607-617
• /
• 2020

Human bio-monitoring (HBM) data is a very important resource for tracking total exposure and concentrations of a parent chemical or its metabolites in human biomarkers. However, until now, it was difficult to execute the integration of different types of HBM data due to incompatibility problems caused by gaps in study design, chemical description and coding system between different sources in Korea. In this study, we presented a standardized code system and HBM knowledge model (KM) based on relational database modeling methodology. For this purpose, we used 11 raw datasets collected from the Ministry of Food and Drug Safety (MFDS) between 2006 and 2018. We then constructed the HBM database (DB) using a total of 205,491 concentration-related data points for 18,870 participants and 86 chemicals. In addition, we developed a summary report-type statistical analysis program to verify the inputted HBM datasets. This study will contribute to promoting the sustainable creation and versatile utilization of big-data for HBM results at the MFDS.

• Geophysics and Geophysical Exploration
• /
• v.3 no.1
• /
• pp.25-32
• /
• 2000

The geophysical data management system was developed to meet both the increasing demands of geophysical data in the practical application of civil engineering, underground water survey, and environmental problems and needs for digital archive and quality control of geophysical data. The system for a data manager is developed under Client/Server (C/S) environment. This manager system is characterized by a relational geophysical database system using MS SQL-server, standardization of geophysical data format, the development of C/S interface program for Windows environment, and the development of transfer program module for the searched data. The system developed for a general user under the internet environment is characterized by Web service (URL:http//geophy.kigam.re.kr) and the development of plug-in module to visualize geophysical image data.

• 제어로봇시스템학회:학술대회논문집
• /
• 2000.10a
• /
• pp.103-103
• /
• 2000

In this paper to cope with the reduction of products life-cycle as the variety of products along with the various demands of consumers, a virtual simulator is developed to make the changeover of manufacturing line efficient to embody a virtual simulation similar to a real manufacturing line. The developed virtual simulator can design a layout of a factory and make the time scheduling. Every factory has one simulator so that one product can be manufactured in the factories to use them as virtual factories. We suggest a scheme that heightens the agility to the diversity of manufacturing models by making the information of manufacturing lines and products models to be shared. The developed unit simulator can construct a proper virtual manufacturing line along with the required process of products using several kinds of operator and work cell. A user with the simulator can utilize an interface that makes one to manage the separate task process for each manu(acturing module, change operator components and work cells, and easily teach tasks of each task module. The developed simulator was made for users convenience by Microsoft Visual C++ 6.0 that can develop a program supplying graphic user interface environment and by OpenGL of the Silicon Graphics as a graphic library to embody 3D graphic environment. Also, we show that the simulator can be used efficiently for the agile manufacturing by the communication among the factories being linked by TCP/IP and a hybrid database system made by a hierarchical model and a relational model being developed to standardize the data information.

• Korean Medical Education Review
• /
• v.17 no.1
• /
• pp.33-38
• /
• 2015

During the education reform in 2009, the Catholic University of Korea College of Medicine (CUMC) adopted body systems as the basis for structuring basic medical education. After running the new program for 5 years, we need to evaluate the program by comparing it with nationwide standards. This study was designed to evaluate the coverage of our basic medical education program by comparing it with the assessment items of the medical licensing examination for physicians in the Republic of Korea. We built a relational database populated with 3,017 learning outcomes from all the courses on basic medical education. We tagged each learning outcome according to 2 criteria: 206 physician encounters and 9 outcome domains. A majority of the learning outcomes were in the domains of 'knowledge' and 'critical thinking'. In addition, we repeated the categorization process with 584 assessment items of the medical licensing examination in the Republic of Korea and compared them with the categorization results of the learning outcomes. Among the 206 physician encounters, we found that outcomes on family violence and sexual violence were missing in the learning outcomes of CUMC. Eighty-two physician encounters were associated with more than one outcome domain, and 96 physician encounters were covered in more than one course. Twenty-one physician encounters were repeated in 5 or more courses and 34 physician encounters had outcomes categorized into 3 or more domains. Thus, we showed that the 2-way categorization could be applied to the comparison and evaluation of two different education formats.