• Journal of KIISE:Computing Practices and Letters
• /
• v.16 no.11
• /
• pp.1031-1040
• /
• 2010

Hash join is one of the core algorithms in databases management systems. If a hash join cannot complete in one-pass because the available memory is insufficient (i.e., hash table overflow), however, it may incur a few sequential writes and excessive random reads. With harddisk as the tempoary storage for hash joins, the I/O time would be dominated by slow random reads in its probing phase. Meanwhile, flash memory based SSDs (flash SSDs) are becoming popular, and we will witness in the foreseeable future that flash SSDs replace harddisks in enterprise databases. In contrast to harddisk, flash SSD without any mechanical component has fast latency in random reads, and thus it can boost hash join performance. In this paper, we investigate several important and practical issues when flash SSD is used as tempoary storage for hash join. First, we reveal the va patterns of hash join in detail and explain why flash SSD can outperform harddisk by more than an order of magnitude. Second, we present and analyze the impact of cluster size (i.e., va unit in hash join) on performance. Finally, we emperically demonstrate that, while a commerical query optimizer is error-prone in predicting the execution time with harddisk as temporary storage, it can precisely estimate the execution time with flash SSD. In summary, we show that, when used as temporary storage for hash join, flash SSD will provide more reliable cost estimation as well as fast performance.

• The Korean Journal of Applied Statistics
• /
• v.30 no.1
• /
• pp.41-55
• /
• 2017

This study predicts the average scores of top 150 PGA golf players on 132 PGA Tour tournaments (2013-2015) using data mining techniques and statistical analysis. This study also aims to predict the Top 10 and Top 25 best players in 4 different playoffs. Linear and nonlinear regression methods were used to predict average scores. Stepwise regression, all best subset, LASSO, ridge regression and principal component regression were used for the linear regression method. Tree, bagging, gradient boosting, neural network, random forests and KNN were used for nonlinear regression method. We found that the average score increases as fairway firmness or green height or average maximum wind speed increases. We also found that the average score decreases as the number of one-putts or scrambling variable or longest driving distance increases. All 11 different models have low prediction error when predicting the average scores of PGA Tournaments in 2015 which is not included in the training set. However, the performances of Bagging and Random Forest models are the best among all models and these two models have the highest prediction accuracy when predicting the Top 10 and Top 25 best players in 4 different playoffs.

• Applied Chemistry for Engineering
• /
• v.31 no.2
• /
• pp.147-152
• /
• 2020

In this study, we dedicated to optimize the process for a reactive diluent for epoxy resin of improved chemical resistance by using cardanol, a component of natural oil of cashew nut shell liquid (CNSL). The central composite design (CCD) model of response surface methodology (RSM) was used for the optimization. The quantitative factors for CCD-RSM were the cardanol/ECH mole ratio, reaction time, and reaction temperature. The yield, epoxy equivalent, and viscosity were selected as response values. Basic experiments were performed to design the reaction surface analysis. The ranges of quantitative factors were determined as 2~4, 4~8 h, and 100~140 ℃ for the cardanol/ECH reaction mole ratio, reaction time, and reaction temperature, respectively. From the result of CCD-RSM, the optimum conditions were determined as 3.33, 6.18 h, and 120 ℃ for the cardanol/ECH reaction mole ratio, reaction time, and reaction temperature, respectively. At these conditions, the yield, epoxy equivalence, and viscosity were estimated as 100%, 429.89 g/eq., and 41.65 cP, respectively. In addition, the experimental results show that the error rate was less than 0.3%, demonstrating the validity of optimization.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.13 no.8
• /
• pp.3417-3426
• /
• 2012

This study aims to determine how ownership structure (share-holding ratio of insiders, foreigners) affects agent costs (the portion of asset efficiency or non-operating expenses) through empirical analysis. However, as existing studies on correlations between ownership structure and agent costs adopted Pooled OLS Model, this study focused on additionally formulating Fixed Effect Model and Random Effect Model aimed to reflect the time of data formation and corporate effects as study models based on verification results on the suitability of Pooled-OLS Model before comparative analysis for the purpose of improvement of credibility and statistical validity of the results of empirical analysis based on the premise that the Pooled OLS Model is not reliable enough to verify massive panel data. The data has been accumulated over 10 years from 1998 to 2007 after the IMF crisis hit the nation, from a subject 331 companies except for financial institutions. As a result of the empirical analysis, verification of the suitability of model has determined that the Random Effect Model is appropriate in terms of asset efficiency among agent costs items. On the other hand, the Fixed Effect Model is appropriate in terms of non-operating costs. As a result of the empirical analysis according to the appropriate model, no hypothesis adopted in the Pooled OLS Model has been accepted. This suggests that developing an appropriate model is more important than other factors for the purpose of generating statistically significant empirical results by showing that different empirical results are produced according to the type of empirical analysis.

• Journal of agriculture & life science
• /
• v.45 no.4
• /
• pp.65-72
• /
• 2011

The objective of this research is to develop biomass allometric equation for Pinus densiflora in central region and Quercus variabilis. To develop the biomass allometric equation by species and tree component, data for Pinus densiflora in central region is collected to 30 plots (70 trees) and for Quercus variabilis is collected to 15 plots (32 trees). This study is used two independent values; (1) one based on diameter beast height, (2) the other, diameter beast height and height. And the equation forms were divided into exponential, logarithmic, and quadratic functions. The validation of biomass allometric equations were fitness index, standard error of estimate, and bias. From these methods, the most appropriate equations in estimating total tree biomass for each species are as follows: $W=aD^b$, $W=aD^bH^c$; fitness index were 0.937, 0.943 for Pinus densiflora in central region stands, and $W=a+bD+cD^2$, $W=aD^bH^c$; fitness index were 0.865, 0.874 for Quercus variabilis stands. in addition, the best performance of biomass allometric equation for Pinus densiflora in central region is $W=aD^b$, and Quercus variabilis is $W=a+bD+cD^2$. The results of this study could be useful to overcome the disadvantage of existing the biomass allometric equation and calculate reliable carbon stocks for Pinus densiflora in central region and Quercus variabilis in Korea.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.40 no.3
• /
• pp.207-215
• /
• 2022

This research has been focused on accessing precision and accuracy of UAV (Unmanned Aerial Vehicle)-derived 3-D surveying coordinates. To this end, a highly precise and accurate testing control network had been established by GNSS (Global Navigation Satellite Systems) campaign and its network adjustment. The coordinates of the ground control points and the check points were estimated within 1cm accuracy for 95% of the confidence level. FC330 camera mounted on DJI Phantom 4 repeatedly took aerial photos of an experimental area seven times, and then processed them by two widely used software packages. To evaluate the precision and accuracy of the aerial surveys, 3-D coordinates of the ten check points which automatically extracted by software were compared with GNSS solutions. For the 95% confidence level, the standard deviation of two software's result is within 1cm, 2cm, and 4cm for the north-south, east-west, and height direction, and RMSE (Root Mean Square Error) is within 9cm and 8cm for the horizontal, vertical component, respectively. The interest is that the standard deviation is much smaller than RMSE. The F-ratio test was performed to confirm the statistical difference between the two software processing results. For the standard deviation and RMSE of most positional components, exception of RMSE of the height, the null hypothesis of the one-tailed tests was rejected. It indicates that the result of UAV photogrammetry can be different statistically based on the processing software.

• Journal of Aerospace System Engineering
• /
• v.16 no.1
• /
• pp.97-103
• /
• 2022

An aircraft component can only be mounted on an aircraft if it has been certified to have a structural robustness under flight load conditions. Among the major components of the aircraft, a pylon is a structure that connects external equipment such as an engine, and external attachments with the main wing of an aircraft and transmits the loads acting on it to the main structure of the aircraft. In civil aircraft, when there is an incident of fire in the engine area, the pylon prevents the fire from spreading to the wings. This study presents the results of structural static tests performed to verify the structural robustness of a fuel pylon used to mount external fuel tank in an aircraft. In the main text, we present the test set-up diagram consisting of test fixture, hydraulic pressure unit, load control system, and data acquisition equipment used in the structure static test of the fuel pylon. In addition, we introduce the software that controls the load actuator, and provide a test profile for each test load condition. As a result of the structural static test, it was found that the load actuator was properly controlled within the allowable error range in each test, and the reliability of the numerical analysis was verified by comparing the numerical analysis results and the strain obtained from the structural test at the main positions of the test specimen. In conclusion, it was proved that the fuel pylon covered in this study has sufficient structural strength for the required load conditions through structural static tests.

• KSCE Journal of Civil and Environmental Engineering Research
• /
• v.30 no.5B
• /
• pp.459-469
• /
• 2010

This study is to develop a grid-based daily runoff model considering seasonal vegetation canopy condition. The model simulates the temporal and spatial variation of runoff components (surface, interflow, and baseflow), evapotranspiration (ET) and soil moisture contents of each grid element. The model is composed of three main modules of runoff, ET, and soil moisture. The total runoff was simulated by using soil water storage capacity of the day, and was allocated by introducing recession curves of each runoff component. The ET was calculated by Penman-Monteith method considering MODIS leaf area index (LAI). The daily soil moisture was routed by soil water balance equation. The model was evaluated for 930 $km^2$ Yongdam watershed. The model uses 1 km spatial data on landuse, soil, boundary, MODIS LAI. The daily weather data was built using IDW method (2000-2008). Model calibration was carried out to compare with the observed streamflow at the watershed outlet. The Nash-Sutcliffe model efficiency was 0.78~0.93. The watershed soil moisture was sensitive to precipitation and soil texture, consequently affected the streamflow, and the evapotranspiration responded to landuse type.

• International Journal of Computer Science & Network Security
• /
• v.23 no.10
• /
• pp.1-10
• /
• 2023

This paper proposes a method to extend Inter-Carrier Interference (ICI) canceling Orthogonal Frequency Division Multiplexing (OFDM) receivers for 5G mobile systems to spatial multiplexing 2×2 MIMO (Multiple Input Multiple Output) systems to support high-speed ground transportation services by linear motor cars traveling at 500 km/h. In Japan, linear-motor high-speed ground transportation service is scheduled to begin in 2027. To expand the coverage area of base stations, 5G mobile systems in high-speed moving trains will have multiple base station antennas transmitting the same downlink (DL) signal, forming an expanded cell size along the train rails. 5G terminals in a fast-moving train can cause the forward and backward antenna signals to be Doppler-shifted in opposite directions, so the receiver in the train may have trouble estimating the exact channel transfer function (CTF) for demodulation. A receiver in such high-speed train sees the transmission channel which is composed of multiple Doppler-shifted propagation paths. Then, a loss of sub-carrier orthogonality due to Doppler-spread channels causes ICI. The ICI Canceller is realized by the following three steps. First, using the Demodulation Reference Symbol (DMRS) pilot signals, it analyzes three parameters such as attenuation, relative delay, and Doppler-shift of each multi-path component. Secondly, based on the sets of three parameters, Channel Transfer Function (CTF) of sender sub-carrier number n to receiver sub-carrier number l is generated. In case of n≠l, the CTF corresponds to ICI factor. Thirdly, since ICI factor is obtained, by applying ICI reverse operation by Multi-Tap Equalizer, ICI canceling can be realized. ICI canceling performance has been simulated assuming severe channel condition such as 500 km/h, 8 path reverse Doppler Shift for QPSK, 16QAM, 64QAM and 256QAM modulations. In particular, 2×2MIMO QPSK and 16QAM modulation schemes, BER (Bit Error Rate) improvement was observed when the number of taps in the multi-tap equalizer was set to 31 or more taps, at a moving speed of 500 km/h and in an 8-pass reverse doppler shift environment.

• Journal of Advanced Navigation Technology
• /
• v.27 no.6
• /
• pp.835-840
• /
• 2023

RFID(Radio Frequency Identification) systems are attracting attention as a key component of Internet of Things technology due to the cost and energy efficiency of application services. In order to use RFID technology in the IoT application service field, it is necessary to be able to store and manage various information for a long period of time as well as simple recognition between the reader and tag of the RFID system. And in order to read and write information to tags, a performance improvement technology that is strong and reliable in poor wireless channels is needed. In particular, in the UHF(Ultra High Frequency) RFID system, since multiple tags communicate passively in a crowded environment, it is essential to improve the recognition rate and transmission speed of individual tags. In this paper, Middleton's Class A impulsive noise model was selected to analyze the performance of the RFID system in an impulsive noise environment, and FM0 encoding and Miller encoding were applied to the tag to analyze the error rate performance of the RFID system. As a result of analyzing the performance of the RFID system in Middleton's Class A impulsive noise channel, it was found that the larger the Gaussian noise to impulsive noise power ratio and the impulsive noise index, the more similar the characteristics to the Gaussian noise channel.