• Journal of Information Management
• /
• v.37 no.3
• /
• pp.117-137
• /
• 2006

Science and technology association is producing huge amount of information through the academic activities related in industrial technology between the members and becoming major provider of industrial technology information. But the infrastructure in its individual institute of institution is very poor, which makes systematic management and service unavailable. So, KISTI developed the management and logistics system collecting and processing various technical information produced by institutes and managing as well as distributing through the web. We studied cases matched with requirements of institution and opted for the modeling, using web based application and information retrieval system. Finally, the members of the institution as well as unregistered users can access to the technical reports database easily and quickly. We are planning to extend the range of target institutes and make a progress the system to high functional level.

• Journal of KIISE:Software and Applications
• /
• v.26 no.12
• /
• pp.1393-1403
• /
• 1999

공간 데이타베이스 시스템을 통하여 공유되는 공간 데이타는 무결성이 적절하게 유지되지 않는 한 전체 응용 시스템의 행위를 예측할 수 없게 되므로 데이타의 무결성 확인 및 유지는 필수적이다. 특히 공공 GIS에 저장된 공간 데이타는 토지 이용도 평가, 도시 계획, 자원 관리, 시설물 관리, 안전 관리, 국방 등 국가 전체 및 지역의 중요한 정책 결정을 위한 다양한 응용 시스템들에 의해 이용되므로 적절한 공간 객체의 무결성 확인이 더욱 더 필요하다. 본 논문에서는 능동(active) DBMS의 능동 규칙(active rule) 기법을 이용하여 공간 객체의 무결성 확인을 지원하기 위한 규칙 관리 시스템을 제시한다. 능동 규칙을 이용한 공간 객체의 무결성 확인은 응용 프로그래머를 무결성 확인에 대한 부담으로부터 자유롭게 할 수 있다. 본 시스템은 특정 DBMS에 종속되지 않는 독립적인 외부 시스템으로 존재하며, 능동 규칙 관리기, 규칙 베이스, 그리고 활성규칙 생성기의 3 부분으로 구성된다. 사용자가 공간 데이타베이스 응용 프로그램을 통해 공간 객체를 조작하고자 할 때, 본 시스템은 데이타베이스 트랜잭션을 단위로 조작되는 모든 공간 객체의 무결성 확인을 위해 응용 프로그램에 삽입될 무결성 제약조건 규칙들을 효율적으로 관리하는 역할을 한다.Abstract It is necessary that the integrity of spatial data shared through the spatial database system is validated and appropriately maintained, otherwise the activity of whole application system is unpredictable. Specially, the integrity of spatial data stored in public GIS has to be validated, because those data are used by various applications which make a decision on an important policy of the region and/or whole nation such as evaluation of land use, city planning, resource management, facility management, risk management/safety supervision, national defense. In this paper, we propose rule management system to support validating the integrity of spatial object, using the technique of active rule technique from active DBMS. Validating data integrity using active rules allows database application programmer to be free from a burden on validation of the data integrity. This system is an independent, external system that is not subject to specific DBMS and consists of three parts, which are the active rule manager, the rule base, and the triggered rule generator. When an user tries to manipulate spatial objects through a spatial database application program, this system serves to efficiently manage integrity rules to be inserted into the application program to validate the integrity constraints of all the spatial objects manipulated by database transactions.

• Journal of the Korean Society of Environmental Restoration Technology
• /
• v.25 no.4
• /
• pp.49-65
• /
• 2022

Since trees in the city are green assets that create a healthy environment for the city, systematic management of trees improves urban ecosystem services. The sporadic urban tree information centered on the site is vast, and it is difficult to manage the data, so efforts to increase efficiency are needed. This paper summarizes tree data inventory based on data constructed by Seoul Green Trust activists and constructs and discloses online database maps using Tableau Software. In order to verify the utilization of the map, we divided into consumer and supplier aspects to collect various opinions and reflect feedback to implement tree database maps for each area and species of Seoul Forest. As a result, the utilization value of tree database in urban parks was presented. The technical significance of this study is to systematically record the process of constructing and implementing a dashboard directly using the Mapbox platform and Tableau Software in the field of landscaping for the first time in Korea. In addition, the implications and supplements of landscape information were derived by collecting user opinions on the results. This can be used as an exploratory basis in the process of developing online-based services such as web and apps by utilizing landscaping tree information in the future. Although the visualization database currently constructed has limitations that ordinary users cannot interact in both directions because it utilizes business intelligence tools in terms of service provision it has affirmed both the database construction and its usability in web public format. In the future it is essential to investigate the assets of the trees in the city park and to build a database as a public asset of the city. The survey participants positively recognized that information is intuitively presented based on the map and responded that it is necessary to provide information on the overall urban assets such as small parks and roadside trees by using open source maps in the future.

• Spatial Information Research
• /
• v.7 no.1
• /
• pp.147-153
• /
• 1999

Geological map and data are needed for land use planning, resources development, geological hazard prevention, environment protection and education, Since the nationwide geological database in Korea has not been constructed yet, there are many problems in using the geological map and data. There are many problems such a stratigraphy unestablishment, map conservation and edge matching in geological paper map. Therefore it is difficult to construct the geological map database, but the geological map database must be constructed as soon as possible as one of national thematic map. In this study, geological maps of pilot area such as Ansung geological map on a scale of 1:50,000, Busan on a scale of 1:250,000, Namchang on a scale of 1:25,000 and the whole Korean peninsula on a scale of 1:1,000,000 were designed and constructed to database using Geographic Information System(GIS). In addition the geological map management program was developed by GIS program. The digital geological maps were produced using the constructed geological database. The database could be of access through Internet World Wide Web(WWW) environment and be distributed in Compact Disk(CD).

• Journal of Environmental Science International
• /
• v.14 no.10
• /
• pp.929-935
• /
• 2005

The Monitoring System developed in this study was designed to help manage the recreational forests by gathering data on visitors' profiles and their opinions about recreational use and related facilities, This data could identify for changing situations in forest recreation demand as well as providing information on planning the management and use of the forest areas in advance. The standardized questionnaire had contained visitor profiles, activities, distribution of use by area, distribution us by time, duration of the visit, expenditure of visitors and information on visitor satisfaction and motivation. Also, the questionnaire had included the evaluations visitors' perception of facilities in order to identify the importance and performance of the various facilities, such as recreational and educational facilities, accomodations, directional signs as well as infrastructure. The monitoring system was developed in the object-oriented programming (OOP) environment. Microsoft Visual Basic 6,0 for the program language, Microsoft Access, and Excel program were used to develop the system. The monitoring system was composed of data input, database, and data analysis system, Once data were put into data input system, it automatically transferred to database, and it eventually produced the results of statistical analysis with one step procedure. This study was integrated with facilities and visitor monitoring system to identify the visitor impact at the recreational forests. In addition, this monitoring system would provide necessary and useful background information for management on recreational use of natural resources in a practical manner.

• Journal of the Korean Institute of Landscape Architecture
• /
• v.34 no.4 s.117
• /
• pp.84-95
• /
• 2006

This study begins by examining the reason for the lack of urban planning that takes the water cycle into consideration. While there are institutions that support environmentally friendly development or smooth water circulation, these designs are not reflected in planning nor in the real world. After reviewing foreign case studies, policy suggestions and possible policy implications for Korea are derived. In Korea, there is not a sufficient level of relevant laws or institutions systematically established to make it possible to deal with rainwater in a decentralized way. Instead, facility standards or guidelines are considered separately for the control of water and for preventing natural disasters. And even though an environmentally friendly approach is stipulated in relevant laws in terms of spatial planning, there are no planning systems or implementation tools to actualize this kind of approach. The factors that make decentralized rainwater management possible in urban planning are analyzed based on the case study of Germany. Germany requires developers to plan in order to achieve ecological urban development. In addition, as a detailed implementation tool to promote conservation of the water cycle, the law provides for various kinds of measures such as restrictions on the proportion of impervious surface area according to the use of the land, required compensation measures for environmental degradation following development, introduction of a fee for rainwater runoff and the establishment of ecological landscape planning. The actual reason these measures can be implemented however is the provision of planning guidelines and design criteria for rainwater utilization, absorption and containment, and the construction of a database for various environmental information.

• Journal of the Korea Safety Management & Science
• /
• v.19 no.4
• /
• pp.133-140
• /
• 2017

The Ministry of Science, ICT and Future Planning made law for Pre-Hazard Risk Analysis in December 31, 2014 to protect researchers from continuing accidents in laboratory. Conducted before an experiment, Pre-Hazard Risk Analysis finds hazards of the experiment and rules to manage the hazards.So the Pre-Hazard Risk Analysis can support laboratory safety system by prevent accidents in laboratory. Pre-Hazards Risk Analysis is newly created system so that executors need Guidelines to perform this analysis properly. This study is to develop guide tool for Pre-Hazard Risk Analysis by analyzing other risk assessment systems; PSM, Off-site Consequence Assessment, laboratory safety system. Also, this study suggested how to establish database for Pre-Hazard Risk Assessment by analyse KRAS.

• Korean Journal of Construction Engineering and Management
• /
• v.3 no.1 s.9
• /
• pp.83-90
• /
• 2002

Actual construction data are unsystematically handled and uselessly hoarded after completion of the project although actual construction data can be applied to the various works of the future projects. Many researches have been carried out by several engineers and scholars of construction firms and research institutes, but the level of the application is not plausible yet. The objective of this paper is to propose a web-based data model and application system for commercial buildings in order to enhance the usability of the actual construction data on line. The principal factors of commercial building project data and the user$^{\circ}{\phi}s$ requirements in various areas, such as planning, design, procurement and construction and so on are analyzed to implement the database structure of the proposed system. The application of resource Information focused on cost, manpower, equipment is included in the system, which is expected to enhances the usability of actual database application system compared with other researches proposed so far.

• Nutrition Research and Practice
• /
• v.2 no.2
• /
• pp.121-129
• /
• 2008

This study was conducted to develop the NutriSonic Web Expert System for Meal Management and Nutrition Counseling with Analysis of User's Nutritive Changes of selected days and food exchange information with easy data transition. This program manipulates a food, menu and meal and search database that has been developed. Also, the system provides a function to check the user's nutritive change of selected days. Users can select a recommended general and therapeutic menu using this system. NutriSonic can analyze nutrients and e-food exchange ("e" means the food exchange data base calculated by a computer program) in menus and meals. The expert can insert and store a meal database and generate the synthetic information of age, sex and therapeutic purpose of disease. With investigation and analysis of the user's needs, the meal planning program on the internet has been continuously developed. Users are able to follow up their nutritive changes with nutrient information and ratio of 3 major energy nutrients. Also, users can download another data format like Excel files (.xls) for analysis and verify their nutrient time-series analysis. The results of analysis are presented quickly and accurately. Therefore it can be used by not only usual people, but also by dietitians and nutritionists who take charge of making a menu and experts in the field of food and nutrition. It is expected that the NutriSonic Web Expert System can be useful for nutrition education, nutrition counseling and expert meal management.

• Korean Journal of Construction Engineering and Management
• /
• v.5 no.2 s.18
• /
• pp.153-161
• /
• 2004

The systematic material and labor management planning should be established on accomplished EVM data. The matrix method of integrated cost and schedule was used with common category concept according to the construction project control system. The construction project control system was suggested through analyzing process and data modeling based on integrated cost, schedule and material. Information of construction project can be developed the relationship between the field data and the integrated cost, schedule database. Process and data modelling is provide a standard data format which are related to the material, labor management based on integrated cost, schedule database.