• Journal of KIISE:Databases
• /
• v.29 no.3
• /
• pp.180-192
• /
• 2002

We investigate the effect of the data skew of join attributes on the performance of a pipelined multi-way hash join method, and propose two new harsh join methods in the shared-nothing multiprocessor environment. The first proposed method allocates buckets statically by round-robin fashion, and the second one allocates buckets dynamically via a frequency distribution. Using harsh-based joins, multiple joins can be pipelined to that the early results from a join, before the whole join is completed, are sent to the next join processing without staying in disks. Shared nothing multiprocessor architecture is known to be more scalable to support very large databases. However, this hardware structure is very sensitive to the data skew. Unless the pipelining execution of multiple hash joins includes some dynamic load balancing mechanism, the skew effect can severely deteriorate the system performance. In this parer, we derive an execution model of the pipeline segment and a cost model, and develop a simulator for the study. As shown by our simulation with a wide range of parameters, join selectivities and sizes of relations deteriorate the system performance as the degree of data skew is larger. But the proposed method using a large number of buckets and a tuning technique can offer substantial robustness against a wide range of skew conditions.

• Journal of the Korean Geotechnical Society
• /
• v.39 no.11
• /
• pp.7-22
• /
• 2023

In January 2022, a new legislation was enforced to enhance the safety of underground construction. Consequently, a comprehensive assessment of underground safety is now an integral part of the planning process, including an evaluation of its impact. Ensuring the stability of temporary retaining walls during underground excavation has become paramount, prompting a heightened focus on the assessment of underground safety. This study delves into the analysis of the Multi-axis Flat Continuous Soil Cement Wall retaining wall (MFS) construction method. This method facilitates the expansion of wall thickness in the ground and provides flexibility in selecting and spacing H-piles. Through laboratory model tests, we scrutinized the load-displacement behavior of the wall, varying the H-pile installation intervals using the MFS method. Additionally, a 3-dimensional numerical analysis was conducted to explore the influence of H-pile installation intervals and sizes on the load for different thicknesses of the MFS retaining wall. The displacement analysis yielded the calculation of the height of the arching effect acting on the wall. To further our understanding, a design method was introduced, quantitatively analyzing the results of axial force and shear force acting on the wall. This involved applying the maximum arching height, calculated by the MFS method, to the existing member force review method. The axial force and shear force, contingent on the H-pile installation interval and size applied to the MFS retaining wall, demonstrated a reduction effect ranging from 24.6% to 62.9%.

• Journal of Intelligence and Information Systems
• /
• v.29 no.4
• /
• pp.375-393
• /
• 2023

The demand for Less than Container Load (LCL) has been on the rise due to the growing need for various small-scale production items and the expansion of the e-commerce market. Consequently, more companies in the International Freight Forwarder are now handling LCL. Given the variety in cargo sizes and the diverse interests of stakeholders, there's a growing need for a container loading algorithm that optimizes space efficiency. However, due to the nature of the current situation in which a cargo loading plan is established in advance and delivered to the Container Freight Station (CFS), there is a limitation that variables that can be identified at industrial sites cannot be reflected in the loading plan. Therefore, this study proposes a container loading methodology that makes it easy to modify the loading plan at industrial sites. By allowing the characteristics of cargo and the status of the container to be considered, the requirements of the industrial site were reflected, and the three-dimensional space was manipulated into a two-dimensional planar layer to establish a loading plan to reduce time complexity. Through the methodology presented in this study, it is possible to increase the consistency of the quality of the container loading methodology and contribute to the automation of the loading plan.

• Horticultural Science & Technology
• /
• v.33 no.5
• /
• pp.647-657
• /
• 2015

To investigate a method for calculation of the heating load for environmental designs of horticultural facilities, measurements of total heating load, infiltration rate, and floor heat flux in a large-scale plastic greenhouse were analyzed comparatively with the calculation results. Effects of ground heat exchange and infiltration loss on the greenhouse heating load were examined. The ranges of the indoor and outdoor temperatures were $13.3{\pm}1.2^{\circ}C$ and $-9.4{\sim}+7.2^{\circ}C$ respectively during the experimental period. It was confirmed that the outdoor temperatures were valid in the range of the design temperatures for the greenhouse heating design in Korea. Average infiltration rate of the experimental greenhouse measured by a gas tracer method was $0.245h^{-1}$. Applying a constant ventilation heat transfer coefficient to the covering area of the greenhouse was found to have a methodological problem in the case of various sizes of greenhouses. Thus, it was considered that the method of using the volume and the infiltration rate of greenhouses was reasonable for the infiltration loss. Floor heat flux measured in the center of the greenhouse tended to increase toward negative slightly according to the differences between indoor and outdoor temperature. By contrast, floor heat flux measured at the side of the greenhouse tended to increase greatly into plus according to the temperature differences. Based on the measured results, a new calculation method for ground heat exchange was developed by adopting the concept of heat loss through the perimeter of greenhouses. The developed method coincided closely with the experimental result. Average transmission heat loss was shown to be directly proportional to the differences between indoor and outdoor temperature, but the average overall heat transfer coefficient tended to decrease. Thus, in calculating the transmission heat loss, the overall heat transfer coefficient must be selected based on design conditions. The overall heat transfer coefficient of the experimental greenhouse averaged $2.73W{\cdot}m^{-2}{\cdot}C^{-1}$, which represents a 60% heat savings rate compared with plastic greenhouses with a single covering. The total heating load included, transmission heat loss of 84.7~95.4%, infiltration loss of 4.4~9.5%, and ground heat exchange of -0.2~+6.3%. The transmission heat loss accounted for larger proportions in groups with low differences between indoor and outdoor temperature, whereas infiltration heat loss played the larger role in groups with high temperature differences. Ground heat exchange could either heighten or lessen the heating load, depending on the difference between indoor and outdoor temperature. Therefore, the selection of a reference temperature difference is important. Since infiltration loss takes on greater importance than ground heat exchange, measures for lessening the infiltration loss are required to conserve energy.

• Journal of The Korean Association of Information Education
• /
• v.18 no.3
• /
• pp.413-422
• /
• 2014

The positive impacts of robotics education and programming education on learners are similar. However, robotics education differs from programming education because it includes purchasing and building robots that cause financial and cognitive load of learners. Due to these differences, two kinds of education may not possess equal efficacies for all schools or all learning objectives. To verify this hypothesis, we conducted meta-analysis of studies on robotics education published in South Korea to estimate the effect sizes and compare it to that of programming education. The difference between the average effect sizes of robotics education and of programming education was significant, as the former was 0.4060 and the latter 0.6664. The average effect size of programming education was significantly larger than that of robotics education for primary school students. Middle school students achieved the highest results in both robotics education and programming education. Also, robotics education became more effective than programming education as students were older. Analysis on objectives showed that programming education uniformly affected all areas, whereas robotics education had more impact on affective domain than cognitive domain. Robot construction had the largest effect size, followed by robot construction and programming, robot programming, and robot utilization. Programming education has larger positive impacts on students overall compared to robotics education. Robotics education is more effective to upperclassmen than programming education, and improves affective domain of students. Also, robotics education shows higher efficacy when combined with various subjects.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.19 no.3
• /
• pp.679-686
• /
• 2018

A new dust cleaning vehicle is needed to remove fine and ultra-fine particulate matter in subway tunnels. Therefore, the recently developed tunnel cleaning vehicle is equipped with an efficient suction system and cyclone-based prefilter to handle ultra-fine particles. To treat various sizes of particulate matter with an underbody suction system, this paper proposes a cyclone-based prefilter in the suction system and validates the dust removal efficiency through Computational Fluid Dynamics (CFD) analysis using ANSYS FLUENT. Using the created surface and volume mesh, various particle sizes, materials, and fan flow rates, the particles were tracked in the flow with a discrete phase model. As a result, the dust cleaning vehicle at a normal operational speed of 5km/h requires at least a fan flow rate of $1500m^3/min$ and 100mm of suction inlet height from the tunnel track floor. Those suction modules and cyclone-based prefilters in the dust cleaning vehicle reduces the dust accumulation load of the electric precipitator and helps remove the accumulated fine and ultra-fine dust in the subway tunnel.

• Composites Research
• /
• v.25 no.1
• /
• pp.19-25
• /
• 2012

The study investigated the buckling behavior of sandwich composite columns with different hole sizes and hole positions when they were applied to a compressive load. The columns consisted of 1.7mm thick faces of glass fabric/epoxy and 23mm, 37mm, 48mm, and 61mm thick cores of urethane-foam. Different hole sizes with the diameter of 25mm and 38mm were considered in this experiment. To evaluate the effect of hole position on the buckling behavior, we considered three types of hole position: 25mm diameter hole located at the center, 25mm diameter hole at 1/4 position from the center to the end of the column, and 25mm diameter hole at 1/2 position from the center to the end of the column. According to the results, buckling and maximum loads of the column having 25mm diameter hole were lower by 10% compared to those of the column without hole, whereas the loads for the column having 38mm diameter hole were 30% less than those of the column without hole. Hole position appeared to have no effect on buckling and maximum loads. Major failure modes were observed as follows: the core shear failure for the thin columns having 23mm and 37mm thick cores, and the face-core debonding for the thick columns having 48mm and 61mm thick cores.

• The Transactions of the Korean Institute of Electrical Engineers C
• /
• v.49 no.5
• /
• pp.259-264
• /
• 2000

In this paper, the characteristics of piezoelectric transformer is studied for driving CCFL(Cold Cathode Fluorescent Lamp). In order to investigate the effects of geometrical dimensions, λvibration-mode type piezoelectric transformers with different sizes in the length(l), width$(\omega)$ and thickness(t) are made of ceramics with PZT-PMWS compositions. The increases in temperature and aging effect are also measured in the transformer of PT-3 sample under the condition of operation continuously for 10 hrs. As the results of dimensional effects, the output power and voltage step-up ratio are largely affected by the ratio of length to thickness(l/t) rather than that of length to $width(l/\omega)$. The output power and step-up ratio are increased with increasing l/t. On case of PT-3, the output voltages are 510[Vrms] at 36[Vrms] in input voltage, $100[k\Omega]$ in load resistance. Temperature increases and variation of output voltages are $10[^{\circ}C]$ and less than 5[%], respectively.

• Journal of Advanced Marine Engineering and Technology
• /
• v.40 no.3
• /
• pp.217-222
• /
• 2016

This study investigates the design, analysis, and implementation of the square-root extended Kalman filter by using an algorithm derived by combining the Potter or Carlson algorithm with the modified Gram-Schmidt algorithm, for sensorless speed control of a permanent-magnet synchronous motor. The sensitivity of the Kalman filter to round-off errors is a well-known problem. A possible way to address this limitation is by combining the square-root concept and Kalman filter that can improve the numerical performance and solve instability-related problems such as divergence. This paper presents the design and analysis of the implementation of such a square-root extended Kalman filter. To demonstrate the performance of the proposed filter, experimental results under several operating conditions, such as high and low speeds, reversal rotation, detuned parameters and load test, have been analyzed. Further, code sizes and operation times have been compared. Experimental results establish the performance of the proposed square-root extended Kalman filter-based estimation technique for sensorless speed control of a permanent-magnet synchronous motor.

• Journal of the Computational Structural Engineering Institute of Korea
• /
• v.28 no.2
• /
• pp.207-212
• /
• 2015

Bridges are designed and constructed as infrastructures in order to overcome topographical obstructions for fast and smooth transfer of human/material resources. Therefore the shape and size of piers constructed along the longitudinal bridge axis should be restricted by topographical conditions. Action forces of connections and piers are affected by pier shapes and sizes together with connection arrangement which decides load carrying path under earthquakes. In this study a typical bridge is modelled with steel bearings and reinforced concrete piers and seismic analyses are performed with analysis models with different arrangement of steel bearings and piers. From analysis results ductile failure mechanisms for all analysis models are checked based on strength/action force ratios of steel bearings and pier columns. In this way the influences of arrangement of connections and piers on the earthquake resistant capacity of typical bridges are figured out in view of forming ductile failure mechanism.