• International conference on construction engineering and project management
• /
• 2009.05a
• /
• pp.1094-1099
• /
• 2009

Workforce information is important in production planning because production planning requires matching a production unit's capacity to loads of assignments. However, tracking and managing workforce information such as skills and accident history is not an easy job. This paper describes a prototype database system for a workforce database system that employs RFID technology. This system tracks daily workforce production capacity on sites. A pilot project is described to explore the benefits and possibility of using radio-frequency identification (RFID) to track and manage workforce information, and is followed by the results of a survey to identify benefits. In addition to the survey identifying the benefits of the database system, the paper also presents a list of challenges through a series of interviews.

• Korean Management Science Review
• /
• v.9 no.1
• /
• pp.53-65
• /
• 1992

Decision Support System(DSS) is an advanced information system concept prevailing since 1980s. It supports managers' decision making activities by providing not only information but decision alternatives. It essentially consists of the components of database, modelbase and dialogue systems. With the development of its databases, POSCO needs a number of modelbases in establishing DSSs in various areas such as production planning and investment. This research particularly focuses on establishment of a mid-and long-range investment DSS and investigates the necessity and the problems of an investment DSS and the decision criteria for investment priority. We (1) propose a modelbase which uses the concepts of Analytic Hierarchy Process(AHP) and Zero-Base Budgeting(ZBB), along with an appropriate scoring method, database and dialogue system to support the investment manager in evaluating investment proposals ; (2) implement the system using relational database management system ; and (3) discuss the results of implementing the investment DSS.

• Journal of Community Nutrition
• /
• v.7 no.2
• /
• pp.107-113
• /
• 2005

This study was conducted to develop a web expert system for nutrition counseling and menu management. This program manipulates a food, dish and menu and search database that has been developed. Clients can select a recommended general and therapeutic menu using this system. The web expert system can analyze nutrients in menus and compare nutrient contents of menus with Korean Recommended Dietary Allowances. It can access the food, dish and menu database. The expert menu database can insert, store and generate the synthetic information of age, sex, and therapeutic purpose of disease. With investigation and analysis of the client's needs, the menu planning program on the internet has been continuously developed. This system consists of the database that reaches to the food composition, the dishes and the menu. Clients can search food composition and conditional food based on nutrient name and amounts. This system is able to draw up the food with its order in dish. The menu planning can be organized and nutrients analysis can be compared with Korea Recommended Allowance. This system is able to read the nutrient composition of the each food, the dish and the menu. The results of analysis is presented quickly and accurately. Therefore it can be used by not only usual people but also dietitians and nutritionists who take charge of making a menu and experts in the field of food and nutrition. It is expected that the web expert system can be useful of nutrition education, nutrition counseling and expert menu management.

• International Journal of Automotive Technology
• /
• v.7 no.2
• /
• pp.217-226
• /
• 2006

To maintain competitiveness in the modern automotive market, it is important to carry out process planning concurrently with new car development processes. Process planners need to make decisions concurrently and collaboratively in order to reduce manufacturing preparation time for developing a new car. Automated generation of a simulation model by using the integrated process plan database can reduce time consumed for carrying out a simulation and allow a consistent model to be used throughout. In this research, we developed a web-based system for concurrent and collaborative process planning and flow analysis for an automotive general assembly using web, database, and simulation technology. A single integrated database is designed to automatically generate simulation models from process plans without having to rework the data. This system enables process planners to evaluate their decisions quickly, considering various factors, and easily share their opinions with others. By using this collaborative system, time and cost put into the assembly process planning can be reduced and the reliability of the process plan would be improved.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2004.11a
• /
• pp.311-318
• /
• 2004

The Land Use Suitability Assessment System was recently introduced by the $\ulcorner$Act on Planning and Utilization of the National Territory$\lrcorner$ to use, manage, and develop the national territory, which integrated the National Land Use and Management Act and the Urban Planning Act. It provides a guideline for classifying land use into 5 classes according to locational characteristics, usability, and developmental conditions of land in the vicinity. The database is constructed with LMIS cadastral data, posted land price data, and data of related agencies such as the Korea Forest Service, the Ministry of Environment, and the Korea Water Resources Corporation etc. After the database construction, individual parcels are analysed by steps and classified into 3 sub areas - conservation, agriculture, and development using GIS. In this paper we evaluate land use suitability for individual parcels by constructing the Land Use Suitability Assessment System for Jinju city. Therefore, we suggest that this system provides vital data in the urban management planning process.

• Proceedings of the KIEE Conference
• /
• 1998.07c
• /
• pp.1009-1011
• /
• 1998

This paper presents a design of network and database structure of the integrated system for power system operational planning and analysis that will be more economical and stable of power system operation. An alias of this system is Highly Integrated Total Energy System(HITES). The Client/server model of HITES is designed as a remote data management model. The input/output-type of application programs and Oracle server is standardized. The separated user-databases from main-database strengthen security of HITES. It is plan to do that tables and relationships are defined by database designs. The connection of application program and DBMS of HITES will be tested through database design and data construction.

• KIEAE Journal
• /
• v.9 no.6
• /
• pp.3-11
• /
• 2009

Building materials have a great impact on the health of a building's occupants. Thus, it is imperative that their health-related properties be taken into during the course of construction project. Unfortunately, no current database system exists that can provide information on the health performance of building materials at each stage of construction project management, from planning and design to building and maintenance. therefore, an inordinate amount of time and effort is required to choose the right health-friendly materials(DBHM). To solve this problem, this study aims at building a database management system for health-friendly building materials. It analyzes the health-related properties and performance of various materials, and proposes a database structure and operation algorithm. The system proposed in this study is expected to contribute to the objective evaluation of health-friendly building materials through the accumulation of relevant data.

• Journal of Korean Society of Rural Planning
• /
• v.19 no.4
• /
• pp.319-327
• /
• 2013

The objective of this research was to develop a relational database management system(RDBMS) to collect, manage and analyze data on agricultural non-point source(NPS) pollution. The system consists of the relational database for agricultural NPS data and data process modules. The data process modules were composed of four sub-modules for data input, management, analysis, and output. The data collected from the watershed of the upper Cheongmi stream and Geunsam-Ri were used in this study. The database was constructed using Apache Derby with meteorological, hydrological, water quality, and soil characteristics. Agricultural NPS-Data Management System(ANPS-DMS) was developed using Oracle Java. The system developed in this study can deal with a variety of agricultural NPS data and is expected to provide an appropriate data management tool for agricultural NPS studies.

• Water Engineering Research
• /
• v.5 no.4
• /
• pp.157-176
• /
• 2004

This research presents a prototype development and implementation of Decision Support System (DSS) for integrated river basin water management for the flood control. The DSS consists of Relational Database Management System, Hydrologic Data Monitoring System, Spatial Analysis Module, Spatial and Temporal Analysis for Rainfall Event Tool, Flood Forecasting Module, Real-Time Operation of Multi Reservoir System, and Dialog Module with Graphical User Interface and Graphic Display Systems. The developed DSS provides an automated process of alternative evaluation and selection within a flexible, fully integrated, interactive, centered relational database management system in a user-friendly computer environment. The river basin decision-maker for the flood control should expect that she or he could manage the flood events more effectively by fully grasping the hydrologic situation throughout the basin.

• Journal of Korean Society of Rural Planning
• /
• v.20 no.4
• /
• pp.277-284
• /
• 2014

Recently the use of smart phones and mobile devices is increasing rapidly, data search and retrieval in the mobile environments are generalized. There are only few mobile applications available in the area of agriculture while huge amount of new applications are developed and uploaded. The purpose of this study was to develop the android based mobile application for providing agricultural infrastructure and disaster information. The mobile application was designed through the database establishment and management system, server management system, and mobile application development. The database is composed of weather data, agricultural infrastructure data, and agricultural disaster data. By developing the mobile application which provides agricultural infrastructure information, it is expected to improve the accessibility to agricultural information and mitigate the agricultural disaster damages.