• Journal of KIISE:Databases
• /
• v.29 no.4
• /
• pp.247-261
• /
• 2002

Aggregation is an important operation that affects the performance of OLAP systems. In this paper we define a new class of aggregation queries, called range-groupby queries, and present a method for processing them. A range-groupby query is defined as a query that, for an arbitrarily specified region of an n-dimensional cube, computes aggregations for each combination of values of the grouping attributes. Range-groupby queries are used very frequently in analyzing information in MOLAP since they allow us to summarize various trends in an arbitrarily specified subregion of the domain space. In MOLAP applications, in order to improve the performance of query processing, a method of maintaining precomputed aggregation results, called the prefix-sum array, is widely used. For the case of range-groupby queries, however, maintaining precomputed aggregation results for each combination of the grouping attributes incurs enormous storage overhead. Here, we propose a fast algorithm that can compute range-groupby queries with minimal storage overhead. Our algorithm maintains only one prefix-sum away and still effectively processes range-groupby queries for all possible combinations of the grouping attributes. Compared with the method that maintains a prefix-sum array for each combination of the grouping attributes in an n-dimensional cube, our algorithm reduces the space overhead by (equation omitted), while accessing a similar number of cells.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.14 no.9
• /
• pp.3782-3796
• /
• 2020

A three-dimensional (3D) reconstruction is an important research area in computer vision. The ability to detect and match features across multiple views of a scene is a critical initial step. The tracking matrix W obtained from a 3D reconstruction can be applied to structure from motion (SFM) algorithms for 3D modeling. We often fail to generate an acceptable number of features when processing face or medical images because such images typically contain large homogeneous regions with minimal variation in intensity. In this study, we seek to locate sufficient matching points not only in general images but also in face and medical images, where it is difficult to determine the feature points. The algorithm is implemented on an adaptive threshold value, a scale invariant feature transform (SIFT), affine SIFT, speeded up robust features (SURF), and affine SURF. By applying the algorithm to face and general images and studying the geometric errors, we can achieve quasi-dense matching points that satisfy well-functioning geometric constraints. We also demonstrate a 3D reconstruction with a respectable performance by applying a column space fitting algorithm, which is an SFM algorithm.

• Geomechanics and Engineering
• /
• v.13 no.1
• /
• pp.141-159
• /
• 2017

A pick cutter is a rock-cutting tool used in partial-face excavation machines such as roadheaders, and its quality is a key element influencing the excavation performance and efficiency of such machines. In this study, pick cutters with hardfacing deposits applied to a tungsten carbide insert were made with aim of increasing their durability and wear resistance. They were field-tested by being installed in a roadheader and compared with conventional pick cutters under the same excavation conditions for 24 hours. The hardfaced pick cutters showed much smaller weight loss after excavation, and therefore better excavation performance, than the conventional pick cutters. In particular, the damage to and detachment (loss) of tungsten carbide inserts was minimal in the hardfaced pick cutters. A detailed inspection using scanning electron microscope-energy dispersive X-ray spectrometry and three-dimensional X-ray computed tomography scanning revealed no macro- or micro-cracks in the pick cutters. The reason for the absence of cracks may be that the heads of pick cutters are mechanically worn after the tungsten carbide inserts have been worn and damaged. However, scanning revealed the presence of voids between tungsten carbide inserts and pick cutter heads. This discovery of voids indicates the need to improve production processes in order to guarantee a higher quality of pick cutters.

• Korean Journal of Food Science and Technology
• /
• v.49 no.4
• /
• pp.408-414
• /
• 2017

Effects of pulsed electric field (PEF) processing on growth inhibition of indigenous aerobic microorganisms and the quality of mandarin and carrot juices were investigated. Mandarin juice was PEF-treated at 15-23 kV/cm for $23-241{\mu}s$, whereas carrot juice was treated at 13-14 kV/cm for 127-198 s. At $25^{\circ}C$ (inlet temperature), PEF treatments at 23 kV/cm for $104{\mu}s$ and 14 kV/cm for $198{\mu}s$ reduced the numbers of total mesophilic aerobes by $6.3{\pm}0.8$ and $5.5{\pm}0.9{\log}\;CFU/mL$ in mandarin juice and carrot juice, respectively. Elevation of inlet temperature to $40^{\circ}C$ increased the reduction rates in both juices. In general, the treatments resulting in the highest microbial inhibition at 25 and $40^{\circ}C$ did not alter the physicochemical and nutritional properties of both juices (p>0.05). PEF is a feasible technology to pasteurize mandarin and carrot juices commercially, with minimal quality deterioration.

• Nuclear Engineering and Technology
• /
• v.49 no.2
• /
• pp.404-410
• /
• 2017

In order to help decision-makers in the early design phase to improve and make more cost-efficient system safety and reliability baselines of aircraft design concepts, a method (Multi-objective Optimization for Safety and Reliability Trade-off) that is able to handle trade-offs such as system safety, system reliability, and other characteristics, for instance weight and cost, is used. Multi-objective Optimization for Safety and Reliability Trade-off has been developed and implemented at SAAB Aeronautics. The aim of this paper is to demonstrate how the implemented method might work to aid the selection of optimal design alternatives. The method is a three-step method: step 1 involves the modelling of each considered target, step 2 is optimization, and step 3 is the visualization and selection of results (results processing). The analysis is performed within Architecture Design and Preliminary Design steps, according to the company's Product Development Process. The lessons learned regarding the use of the implemented trade-off method in the three cases are presented. The results are a handful of solutions, a basis to aid in the selection of a design alternative. While the implementation of the trade-off method is performed for companies, there is nothing to prevent adapting this method, with minimal modifications, for use in other industrial applications.

• Transactions of Materials Processing
• /
• v.18 no.3
• /
• pp.236-244
• /
• 2009

In response to growing environmental and collision-safety concerns, the automotive industry has gradually used high-strength and ultla-high-strength steels to reduce the weight of automobiles. In order to overcome inherent process disadvantages of these materials such as poor formability and high springback at room temperature, hot forming has recently been developed and adopted to produce some important structural parts in automobiles. This method enables manufacturing of components with complex geometric shapes with minimal springback. In addition, a quenching process may enhance the material strength by more than two times. This paper investigates mechanical and forming characteristics of high-strength boron-alloyed steel with hot forming, in terms of hardness, microstructure, residual stress, and springback. In order to compare with experimental results, a finite element analysis of hot forming process coupled with phase transformation and heat transfer was carried out using DEFORM-3D V6.1 and also, to predict high temperature mechanical properties and flow curves for different phases, a material properties modeler, JMatPro was used.

• Journal of Dairy Science and Biotechnology
• /
• v.34 no.4
• /
• pp.271-278
• /
• 2016

The main purpose of milk heat-treatment is to improve milk safety for consumer by destroying foodborne pathogens. Secondly, heat-treatment of milk is to increase maintaining milk quality by inactivating spoilage microorganisms and enzymes. Pasteurization is defined by the International Dairy Federation (IDF, 1986) as a process applied with the aim of avoiding public health hazards arising from pathogens associated with milk, by heat treatment which is consistent with minimal chemical, physical and organoleptic changes in the product. Milk pasteurization were adjusted to $63{\sim}65^{\circ}C$ for 30 minutes (Low temperature long time, LTLT) or $72{\sim}75^{\circ}C$ for 15 seconds (High temperature short time, HTST) to inactivate the pathogens such as Mycobacterium bovis, the organism responsible for tuberculosis. Ultra-high temperature processing (UHT) sterilizes food by heating it above $135^{\circ}C$ ($275^{\circ}F$) - the temperature required to destroy the all microorganisms and spores in milk - for few seconds. The first LTLT system (batch pasteurization) was introduced in Germany in 1895 and in the USA in 1907. Then, HTST continuous processes were developed between 1920 and 1927. UHT milk was first developed in the 1960s and became generally available for consumption in the 1970s. At present, UHT is most commonly used in milk production.

• ETRI Journal
• /
• v.38 no.1
• /
• pp.18-29
• /
• 2016

In this paper, we discuss the issues of providing protection for point-to-multipoint connections in both Ethernet and MPLS-TP-based packet transport networks. We introduce two types of per-leaf protection-linear and ring. Neither of the two types requires that modifications to existing standards be made. Their performances can be improved by a collective signal fail mechanism proposed in this paper. In addition, two schemes - tree protection and hybrid protection - are newly proposed to reduce the service recovery time when a single failure leads to multiple signal fail events, which in turn places a significant amount of processing burden upon a root node. The behavior of the tree protection protocol is designed with minimal modifications to existing standards. The hybrid protection scheme is devised to maximize the benefits of per-leaf protection and tree protection. To observe how well each scheme achieves an efficient traffic recovery, we evaluate their performances using a test bed as well as computer simulation based on the formulae found in this paper.

• Advances in robotics research
• /
• v.1 no.1
• /
• pp.101-126
• /
• 2014

In this article we present modular neural control for a leg-wheel hybrid robot consisting of three legs with omnidirectional wheels. This neural control has four main modules having their functional origin in biological neural systems. A minimal recurrent control (MRC) module is for sensory signal processing and state memorization. Its outputs drive two front wheels while the rear wheel is controlled through a velocity regulating network (VRN) module. In parallel, a neural oscillator network module serves as a central pattern generator (CPG) controls leg movements for sidestepping. Stepping directions are achieved by a phase switching network (PSN) module. The combination of these modules generates various locomotion patterns and a reactive obstacle avoidance behavior. The behavior is driven by sensor inputs, to which additional neural preprocessing networks are applied. The complete neural circuitry is developed and tested using a physics simulation environment. This study verifies that the neural modules can serve a general purpose regardless of the robot's specific embodiment. We also believe that our neural modules can be important components for locomotion generation in other complex robotic systems or they can serve as useful modules for other module-based neural control applications.

• Journal of the Korean Physical Society
• /
• v.73 no.9
• /
• pp.1340-1345
• /
• 2018

Mo-10 at.% Cu nanocomposite powders were fabricated by using planetary ball-milling (PBM), a mechanical alloying technique for preparing nanocomposite alloy powders of metals with mutual insolubility, and the variations in the physical and the chemical characteristics with the process conditions were investigated. We observed that Mo-10 at.% Cu was an appropriate composition to ensure a good alloying grade and minimal welding between particles. The influences of the temperature and the milling conditions on the mechanical alloying process and the phase change of Mo-10 at.% Cu composite powders were investigated, and the particle and the grain sizes of the powders after mechanical alloying were confirmed. The Mo-10 at.% Cu powders showed homogeneous elemental distributions and no phase changes up to $1200^{\circ}C$; their compositions were retained after the mechanical alloying process. The finest grain size obtained was about 5 nm for powders processed using optimum PBM processing conditions: ball-to-powder weight ratio of 5 : 1, ambient air atmosphere, a milling time of 20 h, a rotation speed of 200 rpm, and a stearic acid content of 4 wt.% produced superfine-grained Mo-10 at.% Cu nanocomposite powders with an average grain size of 5 nm (which is smaller than that of other similar materials reported in the literature). The analytical results confirmed that the PBM technique presented here is a promising method for preparing superfine-grained Mo-10 at.% Cu powders with improved properties.