• Journal of Environmental Health Sciences
• /
• v.43 no.4
• /
• pp.298-306
• /
• 2017

Objectives: Since 1998, the Korea National Health and Nutrition Examination Survey (KNHANES) has been conducted in order to investigate the health and nutritional status of Koreans. The food intake data of individuals in the KNHANES has also been utilized as source dataset for risk assessment of chemicals via food. To improve the reliability of intake estimation and prevent missing data for less-responded foods, the structure of integrated long-standing datasets is significant. However, it is difficult to merge multi-year survey datasets due to ineffective cleaning processes for handling extensive numbers of codes for each food item along with changes in dietary habits over time. Therefore, this study aims at 1) cleaning the process of abnormal data 2) generation of integrated long-standing raw data, and 3) contributing to the production of consistent dietary exposure factors. Methods: Codebooks, the guideline book, and raw intake data from KNHANES V and VI were used for analysis. The violation of the primary key constraint and the $1^{st}-3rd$ normal form in relational database theory were tested for the codebook and the structure of the raw data, respectively. Afterwards, the cleaning process was executed for the raw data by using these integrated codes. Results: Duplication of key records and abnormality in table structures were observed. However, after adjusting according to the suggested method above, the codes were corrected and integrated codes were newly created. Finally, we were able to clean the raw data provided by respondents to the KNHANES survey. Conclusion: The results of this study will contribute to the integration of the multi-year datasets and help improve the data production system by clarifying, testing, and verifying the primary key, integrity of the code, and primitive data structure according to the database normalization theory in the national health data.

• 한국공간정보시스템학회:학술대회논문집
• /
• 2004.12a
• /
• pp.69-74
• /
• 2004

Selectivity estimation for spatial query is very important process in finding the most efficient execution plan. Many works have been performed to estimate accurately selectivity. Although they deal with some problems such as false-count, multi-count, they require a large amount of memory to retain accurate selectivity, so they can not get good results in little memory environments such as mobile-based small database. In order to solve this problem, we propose a new technique called MW histogram which is able to compress summary data and get reasonable results. It also has a flexible structure to react dynamic update. The experimental results showed that the MW histogram has lower relative error than MinSkew histogram and gets a good selectivity in little memory.

• Journal of Communications and Networks
• /
• v.16 no.4
• /
• pp.430-435
• /
• 2014

The performance of a distributed database system depends particularly on the site-allocation of the fragments. Queries access different fragments among the sites, and an originating site exists for each query. A data allocation algorithm should distribute the fragments to minimize the transfer and settlement costs of executing the query plans. The primary cost for a data allocation algorithm is the cost of the data transmission across the network. The data allocation problem in a distributed database is NP-complete, and scalable evolutionary algorithms were developed to minimize the execution costs of the query plans. In this paper, quadratic assignment problem heuristics were designed and implemented for the data allocation problem. The proposed algorithms find near-optimal solutions for the data allocation problem. In addition to the fast ant colony, robust tabu search, and genetic algorithm solutions to this problem, we propose a fast and scalable hybrid genetic multi-start tabu search algorithm that outperforms the other well-known heuristics in terms of execution time and solution quality.

• Journal of Navigation and Port Research
• /
• v.35 no.9
• /
• pp.735-740
• /
• 2011

It is necessary to develop the one stop system in order to protect our marine environment rapidly from oil spill accident. The purpose of this study is to develop real time database for oil spill prediction modeling and implement real time prediction modelling with ESI and server-client GIS based user interface. The existing oil spill prediction model cannot provide one stop information system for public and government who should protect sea from oil spill accident. The development of multi user based information system permits integrated handling of real time meteorological data from external ftp. A server-client GIS based model is integrated on the basis of real time database and ESI map to provide the result of the oil spill prediction model. End users can access through the client interface and request analysis such as oil spill prediction and GIS functions on the network as their own purpose.

• Review of KIISC
• /
• v.5 no.3
• /
• pp.38-48
• /
• 1995

다단계 보안 데이타베이스 관리체계(Multi-Level Secure Database Management System: MLS/DBMS)에서 모든 거래와 데이타는 각각 유일한 보안성을 가지고 있다 MLS/DBMS 상에서 동시수행중인 거래들은 공유 데이타를 접근하는 과정에서 충돌가능성을 항시 지니고 있다. 이러한 충돌을 해결하는 과정에서 만약 낮은 보안등급을 가지는 거래가 지연되는 현상이 발생하였을 경우, 높은 보안등급의 정보가 낮은 보안등급의 거래로 유출되어 결과적으로 보안정책을 위반하게된다 이러한 종류의 통신경로를 비밀경로라고 한다. 비밀경보 문제를 해결하기 위한 몇몇 종류의 거래관리 기법들이 제시되었다. 이들 기법들은 비록 비밀경로 문제를 해결하였지만, 불행하게도 이들은 보안의 또 다른 측면인 무결성에 대한 고려를 간과하고 있다. 본 논문에서 제안하는 고수준 보안 거래 관리기는 동시에 수행중인 거래들을 스케줄링하는 과정에서 정보의 기밀성 유지를 무결성의 손실없이 이루고 있다. 기밀성을 위하여 고수준 보안 거래관리기는 비완료된 데이타의 은닉에 방법적 기반을 두고 있다. 또한, 무결성을 얻기 위하여 데이타의 적절성을 판단하는 과정에서 데이타의 신뢰성을 최신성과 함께 고려하고 있다.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.31 no.5
• /
• pp.25-36
• /
• 2003

Aircraft design pursues integrated design efforts by considering all design elements together. In the integrated design environment, it is crucial for the design data to be consistent, free of errorm, and most recent. Database design process consists of the analysis of the data which shall be stored and managed, the construction of the E-R Diagram, and the mapping of the database table. As a DBMS (DataBase Management System), Oracle 8i is employed to design and construct the database. The database design methodology is devised to apply for the several MDO(Multidisciplinary Design Optimization) techniques like MDF(MultiDisplinary Feasible), IDF(Individual Discipline Feasible), and CO(Collaborative Optimization). The defined process is demonstrated through a couple of design examples, including a simple numerical example and a UCAV(Unmanned Combat Aerial Vehicle) design optimization.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.20 no.1
• /
• pp.47-57
• /
• 2002

The intention of this study is to construct the spatial database and to extract attribute data which are able to complete the omitted data in the topographical map or completion map of construction using the image data of various form such as artificial satellite images, aerial photographs, terrestrial photographs and so on. This study used the single frame images only for the raw image data, supposing the case of rigorous photogrammetric method is not available or rapid acquisition of information is need. The extracted spatial and attribute data from the images are used for modifying and updating the database, and for providing visual effect useful for guide and management of the facilities. This study intended to develop the technique able to apply in the case where comparative high accuracy is not required or rapid modification is necessary, and to verify the possibility of editing and updating the digital map using the photographs or video images remained as old data. Many of previous research on the management system for university facility has been accomplished focusing on the design and construction of database itself. Otherwise, this study aimed for the construction of guide and management system based on compiling the digital map of present state using multi-imagery, and the more applicability was intended too.

• Journal of the Society of Naval Architects of Korea
• /
• v.43 no.4 s.148
• /
• pp.512-520
• /
• 2006

The effects of flexibilities of supporting structures on shaft alignment are growing as ship sizes are Increasing mainly for container carrier and LNG carrier. But, most of classification societies not only do not suggest any quantitative guidelines about the flexibilities but also do not have shaft alignment design program considering the flexibility of supporting structures. A newly developed program, which is based on innovative shaft alignment technologies including nonlinear elastic multi-support bearing concept and hull deflection database approach, has S basic modules : 1)fully automated finite element generation module, 2) hull deflection database and it's mapping module on bearings, 3) squeezing and oil film pressure calculation module, 4) optimization module and 5) gap & sag calculation module. First module can generate finite element model including shafts, bearings, bearing seats, hull and engine housing without any misalignment of nodes. Hull deflection database module has built-in absolute deflection data for various ship types, sizes and loading conditions and imposes the transformed relative deflection data on shafting system. The squeezing of lining material and oil film pressures, which are relatively solved by Hertz contact theory and built-in hydrodynamic engine, can be calculated and visualized by pressure calculation module. One of the most representative capabilities is an optimization module based on both DOE and Hooke-Jeeves algorithm.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2010.04a
• /
• pp.411-413
• /
• 2010

The purpose of this research is to study use method of mobile system for effective field management for urban facilities. GIS database could be standardized commonly useful for the site management of city facilities through standard list, standard items and standard specification appropriate for the mobile system, and this is effective to manage the city facilities on the site in real time.

• Journal of the Korean housing association
• /
• v.16 no.4
• /
• pp.121-129
• /
• 2005

The major goal of this study is drawing design plan factors considering residents' life cycle and life style when remodeling design is needed. By drawing such design factors, the study will propose an alternative remodeling design plan. Such design method was defined as Multi-Dimensional module design method. And constructing data-system based on Multi-Dimensional module was secondary goal in this study. The details are as follows: Based on analysis of Residents' demand for remodeling and features of emotion-design applied to remodeling, the system which is suitable for application in remodeling design method was conducted. Based on the type of construction materials, the level value was set up according to emotion-factor application. Also, by conducting coding operation according to the distinction of construction materials, this study seeks the unit drawing method of information for constructing emotion-information system.