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

• Journal of Biomedical Engineering Research
• /
• v.26 no.6
• /
• pp.399-406
• /
• 2005

In these days, HIS(Hospital Information System) raise the quality of medical services by effective management of medical records. As computing environment was developed, it is possible to search information quickly. But, standard medical data exchange is not completed between medical clinic and another organ so far. In case of patient transfer, past medical record was not efficiently transmitted. It be feasible treatment delay or medical accident. It is trouble that medical records is transferred by a person and communicate with each other. Extensible Markup Language (XML) is a simple, very flexible text format derived from SGML. Originally designed to meet the challenges of large-scale electronic publishing, XML is also playing an increasingly important role in the exchange of a wide variety of data on the Web and elsewhere. Form in system of company product, relative organs that handle bio-signal data is each other dissimilar and integration and to transmit to supplement bottleneck this research uses XML. In this study, it is discussed about sharing of medical data using XML web technology to standard medical record between hospital and relative organization The data structure model was designed to manage bio-signal data and patient record. We experimented about data transmission and all-in-one between different systems (one make use of MS-SQL database system and the other manage existent bio-signal data in itself form in file in this research). In order to search and refer medical record, the web-based system was implemented. The system that can be shared medical data was tested to estimate the merits of XML. Implemented XML schema confirms data transmission between different data system and integration result.

• Information Systems Review
• /
• v.7 no.2
• /
• pp.117-128
• /
• 2005

This study proposes an integrated monitoring system for data reliability improvement in a steel manufacturing industry. The data obtained from existing steel manufacturing process is not micro data which is gathered at the occurring point, but average value (macro data) which is gathered from the occurring point to ending point. This kind of macro data is not only difficult for a detailed analysis for an error causing factor, but it might cause a fatal influence as well on the quality of produced goods even if the error is within an error tolerance. And during the process of steel production, thousands of data is produced in a second, thus requiring database plan to manage abundant amount of data. Therefore, the following proposed system is capable of collecting as well as analyzing all the data generated from the process of product production. And the system was able to raise the efficiency of the database server by planning the database to handle large capacity data. Also, by applying web-based technology, inquiries and analysis of data with no limit on time and space was possible with PC connected to the intranet. Hence, the system was able to work on effective quality improvement of manufactured products, plus able to raise the reliability of the product. Also, accumulated data from long period of time was used for fundamental material for new controlling model, operation technology, and new product development.

• Wind and Structures
• /
• v.31 no.1
• /
• pp.21-29
• /
• 2020

The wind field measurement of severe winds such as hurricanes (or typhoons), thunderstorm downbursts and other gales is important issue in wind engineering community, both for the construction and health monitoring of the wind-sensitive structures. Although several wireless data transmission systems have been available for the wind field measurement, most of them are not specially designed for the wind data measurement in structural wind engineering. Therefore, the field collection is still dominant in the field of structural wind engineering at present, especially for the measurement of the long-term and high-frequency wind speed data. In this study, for remote wind field measurement, a novel wireless long-term and high-frequency wind data acquisition system with the functions such as remote control and data compression is developed. The system structure and the collector are firstly presented. Subsequently, main functions of the collector are introduced. Also novel functions of the system and the comparison with existing systems are presented. Furthermore, the performance of this system is evaluated. In addition to as the wireless transmission for wind data and hardware integration for the collector, the developed system possesses a few novel features, such as the modification of wind data collection parameters by the remote control, the remarkable data compression before the data wireless transmission and monitoring the data collection by the cell phone application. It can be expected that this system would have wide applications in wind, meteorological and other communities.

• KSCE Journal of Civil and Environmental Engineering Research
• /
• v.13 no.1
• /
• pp.141-149
• /
• 1993

The gravimetric geoid of the South Korea Region was computed on Geodetic Reference System 1980(GRS80) using a combination of satellite-derived potential coefficients and terrestrial gravaty data. $10^{\prime}{\times}10^{\prime}$ mean gravity anomalies were obtained from surface gravity data for the outer zones, $1^{\circ}{\times}1^{\circ}$ equal area mean anomalies were used for the inner zones, and point gravity anomalies were used for the innermost zones in the Stokes integration. The GRS80 potential coefficients were obtained from modification of GEM9 data and Integration was extended over a spherical cap of $30^{\circ}$ from the integration area. The results of a free-air geoid show that the systematic mean difference of approximately 2~3m in comparison of OSU89B model.

• Spatial Information Research
• /
• v.21 no.1
• /
• pp.15-22
• /
• 2013

Recently, there are various attempts to construct a u-City and a smart city. A Spatial information as the city-based infrastructure has been recognized as an essential element. In many cases GIS data being lack of compatibility due to the various format, it is difficult to provide public web services and link the data between government organizations. In this study, we developed a interconnection Server based on OGC standardization to support interoperability in a heterogeneous distributed environment. we hope the interconnection server that will be utilized as u-City platform and response platform for volcanic disaster through the test in the test-bed.

• Journal of the Korean Data and Information Science Society
• /
• v.25 no.4
• /
• pp.755-767
• /
• 2014

Recently, many firms have introduced information and communication technology (ICT) into supply chain. However, existing studies have not yet insisted definite conclusion with respect to ICT impact on supply chain. Thus, this study subdivides supply chain performance which previous researchers have studied comprehensively while suggesting perspective of the use of firm's ICT capabilities. We classify ICT capabilities into four types of group and then analyze the difference between groups regarding each factor of supply chain performance by ANOVA analysis and Tukey method. As a result of analysis, the group in which all ICT capabilities are high shows the highest level of integration and flexibility performance among supply chain performances. On the other hand, the group in which all ICT capabilities are low presents the lowest level of integration and flexibility performance. We also provide more precise and specific information with practitioners by analyzing the difference between groups with regard to detailed measurements on integration and flexibility variables.

• The Journal of The Korea Institute of Intelligent Transport Systems
• /
• v.9 no.1
• /
• pp.121-130
• /
• 2010

As the development of wireless environment and portable devices, navigation companies need more spatial information for Location Based Service and so they are investing heavily in this part. But my country have constructed lots of spatial dataset during the NGIS project, and then we can reduce costs by using constructed spatial dataset. The integration method of each building information between e-AIS and KLIS-rn is linked to designed mapping table by main building numbers and auxiliary cadastral number. e-AIS and KLIS-rn are integrated by the feature matching between CAD data and KLIS-rn. Due to the limitation of test data, more accuracy test will be required with various data sets.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.23 no.4
• /
• pp.208-216
• /
• 2020

Recently, issues regarding underground safety such as sink hole, ground subsidence and damage to old underground facilities have been increasing in urban areas, raising the need for more accurate management of underground facilities. Thus, this study derived a technique for comparing spatial data of underground facilities acquired from GPR exploration results acquired at the site with spatial data of integrated underground spatial maps. Using this underground space integrated map-linked service prototype program developed through this study, comparing the location information of the GPR exploration results and the underground space integrated map for the verification of site usability in some sections around Gangnam Station, the results demonstrated that the location of the map is 0.879m maximum, minimum of 0.101m and the average fudge factor was 0.625m. If accuracy of the GPR exploration results is guaranteed, it is judged that it can be used to improve the location accuracy of the underground space integration map.

• The Sea:JOURNAL OF THE KOREAN SOCIETY OF OCEANOGRAPHY
• /
• v.15 no.3
• /
• pp.124-132
• /
• 2010

In spite of the global importance of primary production of phytoplankton, some primary production data in Korean coastal waters still need to be better processed. The daily rates of water column primary production is generally estimated by integrating the primary production per unit volume over time and depth, but efforts for time integration algorithm have been conducted insufficiently. In this study a mathematical equation evaluating daily primary production integrated over time of a day is proposed and the effectiveness of the model is tested on Saemangeum Lake. The daily primary productions computed with the proposed equation were nearly the same with the results numerically integrated by substituting solar irradiance data. It was suggested that better estimation of primary production would be obtained by using monthly or weekly means of solar irradiance rather than more variable daily data. Because of the vertically heterogenous distribution of phytoplankton, it's hard to integrate the equation over depth to give the daily rates of primary production per unit area of water surface. However, the problem would be solved if, after the vertical distribution of phytoplankton was classified into several patterns and reduced to mathematical formula, every composite function of time integrated equation and chlorophyll distribution equation was integrated successfully.