• The Journal of the Korea Contents Association
• /
• v.9 no.2
• /
• pp.106-114
• /
• 2009

In this study, we are analysing adverse drug events and proposing a technical structure of "adverse drug event surveillance system" using business intelligence technology, hoping that we can use the system commonly and actively. It is the recent trend to adopt both of electronic review and manual review process to surveil adverse drug events and this study construct CDW applying ETL in BI Technology. As the result of analysis, the data pool included 701 doctors who prescribed and 3059 patients(1528 male, 1531 female), of total 318,222 cases, 2,086cases(0.6%) were suspected as having adverse drug events. And the single type of T.bilirubin> 3mg/dL(ADE type-LabR0005) was the most common(548 among 2085 cases) within the framework of signals.

• The Journal of The Korea Institute of Intelligent Transport Systems
• /
• v.17 no.5
• /
• pp.48-54
• /
• 2018

With the 4th industry era, smart factories are emerging. In the era of multi-product small scale production, unmanned transportation vehicles are rapidly increasing in utilization of unmanned transportation vehicles that carry and arrange goods in the work space. The conventional unmanned vehicle detected its position by using the guided line method and the position based method for indoor location recognition and movement. This method has disadvantages of initial high cost and maintenance / maintenance. In this paper, to solve the disadvantages, the method of predicting the direct path of the unmanned vehicle through the Kalman filter is verified using the white LED marker of the warehouse and the position data and the image data of the white LED marker recognition image. Through this, the reliability of the linear movement which occupies the most part in the lattice structure is secured. It is also expected that the reliance on additional position sensors will also be reduced.

• Spatial Information Research
• /
• v.22 no.6
• /
• pp.23-32
• /
• 2014

Recently, Korea government make an effort to make jobs through public information disclosure and a public-private partnerships. In this regard, the MOLIT (Ministry of Land, Infrastructure and Transport) is pushing the V-World Business. The V-World is the public platform for the government to disclose spatial and adminstration information. However, the V-World is still not been able to fulfill the role of a public platform, private partnerships window, Warehouse jobs. So, the molit is promoting the V-World advanced project, creating a long-term plan. This study performed a user satisfaction survey and analysis, this result are used as a basis data of the efficient execution of the V-World advanced project and creating long-term planning. Also, we suggested V-World Service Improvement, Open API Service Improvement, future service direction. This study improve the current the V-World, will be utilized as basic data of improving utilization of the use.

• Journal of Cancer Prevention
• /
• v.23 no.4
• /
• pp.183-190
• /
• 2018

Background: As the number of big-cohort studies increases, validation becomes increasingly more important. We aimed to validate administrative database categorized as colorectal cancer (CRC) by the International Classification of Disease (ICD) 10th code. Methods: Big-cohort was collected from Clinical Data Warehouse using ICD 10th codes from May 1, 2003 to November 30, 2016 at Seoul National University Bundang Hospital. The patients in the study group had been diagnosed with cancer and were recorded in the ICD 10th code of CRC by the National Health Insurance Service. Subjects with codes of inflammatory bowel disease or tuberculosis colitis were selected for the control group. For the accuracy of registered CRC codes (C18-21), the chart, imaging results, and pathologic findings were examined by two reviewers. Sensitivity, specificity, positive predictive value (PPV), and negative predictive value (NPV) for CRC were calculated. Results: A total of 6,780 subjects with CRC and 1,899 control subjects were enrolled. Of these patients, 22 subjects did not have evidence of CRC by colonoscopy, computed tomography, magnetic resonance imaging, or positron emission tomography. The sensitivity and specificity of hospitalization data for identifying CRC were 100.00% and 98.86%, respectively. PPV and NPV were 99.68% and 100.00%, respectively. Conclusions: The big-cohort database using the ICD 10th code for CRC appears to be accurate.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.4
• /
• pp.2784-2790
• /
• 2015

The column-oriented database storage is a very advanced model for large-volume data transactions because of its superior I/O performance. Traditional data storages exploit row-oriented storage where the attributes of a record are placed contiguously in hard disk for fast write operations. However, for search-mostly data warehouse systems, column-oriented storage has become a more proper model because of its superior read performance. Recently, solid state drive using flash memory is largely recognized as the preferred storage media for high-speed data analysis systems. In this research, we propose a new transaction recovery scheme for a column-oriented database environment which is based on a flash media file system. We improved traditional shadow paging schemes by reusing old data pages which are supposed to be invalidated in the course of writing a new data page in the flash file system environment. In order to reuse these data pages, we exploit reused shadow list structure in our column-oriented shadow recovery(CoSR) scheme. CoSR scheme minimizes the additional storage overhead for keeping shadow pages and minimizes the I/O performance degradation caused by column data compression of traditional recovery schemes. Based on the results of the performance evaluation, we conclude that CoSR outperforms the traditional schemes by 17%.

• The KIPS Transactions:PartD
• /
• v.16D no.4
• /
• pp.463-474
• /
• 2009

To analyze multidimensional data conveniently and efficiently, OLAP (On-Line Analytical Processing) systems or e-business are widely using views in a horizontal form to represent measurement values over multiple dimensions. These views can be stored as materialized views derived from several sources in order to support accesses to the integrated data. The horizontal views can provide effective accesses to complex queries of OLAP or e-business. However, we have a problem of occurring maintenance of the horizontal views since data sources are distributed over remote sites. We need a method that propagates the changes of source tables to the corresponding horizontal views. In this paper, we address incremental maintenance of horizontal views that makes it possible to reflect the changes of source tables efficiently. We first propose an overall framework that processes queries over horizontal views transformed from source tables in a vertical form. Under the proposed framework, we propagate the change of vertical tables to the corresponding horizontal views. In order to execute this view maintenance process efficiently, we keep every change of vertical tables in a differential file and then modify the horizontal views with the differential file. Because the differential file is represented as a vertical form, its tuples should be converted to those in a horizontal form to apply them to the out-of-date horizontal view. With this mechanism, horizontal views can be efficiently refreshed with the changes in a differential file without accessing source tables. Experimental results show that the proposed method improves average performance by 1.2$\sim$5.0 times over the existing methods.

• Tuberculosis and Respiratory Diseases
• /
• v.86 no.3
• /
• pp.203-215
• /
• 2023

Background: Surgical resection is the standard treatment for early-stage lung cancer. Since postoperative lung function is related to mortality, predicted postoperative lung function is used to determine the treatment modality. The aim of this study was to evaluate the predictive performance of linear regression and machine learning models. Methods: We extracted data from the Clinical Data Warehouse and developed three sets: set I, the linear regression model; set II, machine learning models omitting the missing data: and set III, machine learning models imputing the missing data. Six machine learning models, the least absolute shrinkage and selection operator (LASSO), Ridge regression, ElasticNet, Random Forest, eXtreme gradient boosting (XGBoost), and the light gradient boosting machine (LightGBM) were implemented. The forced expiratory volume in 1 second measured 6 months after surgery was defined as the outcome. Five-fold cross-validation was performed for hyperparameter tuning of the machine learning models. The dataset was split into training and test datasets at a 70:30 ratio. Implementation was done after dataset splitting in set III. Predictive performance was evaluated by R² and mean squared error (MSE) in the three sets. Results: A total of 1,487 patients were included in sets I and III and 896 patients were included in set II. In set I, the R² value was 0.27 and in set II, LightGBM was the best model with the highest R² value of 0.5 and the lowest MSE of 154.95. In set III, LightGBM was the best model with the highest R² value of 0.56 and the lowest MSE of 174.07. Conclusion: The LightGBM model showed the best performance in predicting postoperative lung function.

• Journal of Biosystems Engineering
• /
• v.10 no.1
• /
• pp.69-75
• /
• 1985

For the purpose of estimating the operating cost for feed production, energy consumption, labor requirement, maintenance cost, and supplies and miscellaneous costs are analyzed and developed as mathematical models. Mathematical model for energy usage Consists of electrical energy, boiler fuel energy and vehicle fuel energy. The mathematil model for electrical energy usage for the swine and poultry feed mill and the complete pelleted feed mill are developed, based on the general model mill and the computer program for its design developed in Kansas State University (Park, 1982). Also, the boiler fuel energy consumption model and the vehicle fuel energy consumption model are developed by analyzing the boiler system and the vehicle operation in the warehouse. In order to develop a mathematical model for labor requirement, the data that Vosloh (1968, 1976) constructed for labor requirement in his model mill are used by assuming that his model mill is similar to this model, in terms of labor assignment standards. Maintenance and repair costs are obtained by assuming to be 5.5% of the total capital investment cost. Also, supplies and miscellaneous costs are estimated by using Vosloh's report and it is approximately 0.87 dollars per ton based on daily production.

• Journal of Digital Convergence
• /
• v.16 no.5
• /
• pp.55-63
• /
• 2018

Although there has been a great change in the Chinese logistics industry, there have been few studies on the research trends of logistics in China. Existing research has been conducted on subdivision topics such as transportation efficiency, warehouse location and port efficiency. In this study, the research trends of logistics in China from 2000 to 2017 were analyzed using SNA method. The data were collected from foreign journals and a total of 82 related papers were used for analysis. The first period (2000-2008) was derived from the top keywords such as "Globalization", "Hong Kong", "FDI" and "outsousing". The results of the second period (2009-2013) were derived from keywords such as "international trade" and "reverse logistics", and in the third period (2013-2017) "3PL", "warehousing", "railways" "supply chain", "economic", "port" and "Belt and Road" The analysis of China's logistics using SNA method shows that the research trend of China's logistics is evolving as China is changing rapidly under the globalization context.

• Journal of the Institute of Electronics Engineers of Korea CI
• /
• v.48 no.4
• /
• pp.61-67
• /
• 2011

In these days, RFID adoption in supply chain management system needs technically part of the performance improvement of RFID Anti-Collision technology. We contrived new scanning algorithm that improve RFID Anti Collision performance, also can be applied to existing RFID readers. In this paper, the proposed algorithm were applied to the actual logistics scene recognition performance much better than the existing practices are presented. For improve of RFID Anti Collision performance, our algorithm implemented in the middleware associated with RFID PDA readers, and actually mount the RFID inventory data from the experiment were accumulated. Through this experiment, the proposed algorithm was confirmed that helps to minimize unaware area of the existing RFID inventory system and significantly improves performance of RFID field solution.