• Title/Summary/Keyword: Join Algorithm

Search Result 138, Processing Time 0.025 seconds

(Task Creation and Allocation for Static Load Balancing in Parallel Spatial Join (병렬 공간 조인 시 정적 부하 균등화를 위한 작업 생성 및 할당 방법)

  • Park, Yun-Phil;Yeom, Keun-Hyuk
    • Journal of KIISE:Databases
    • /
    • v.28 no.3
    • /
    • pp.418-429
    • /
    • 2001
  • Recently, a GIS has been applicable to the most important computer applications such as urban information systems and transportation information systems. These applications require spatial operations for an efficient management of a large volume of data. In particular, a spatial join among basic operations has the property that its response time is increased exponentially according to the number of spatial objects included in the operation. Therefore, it is not proper to the systems demanding the fast response time. To satisfy these requirements, the efficient parallel processing of spatial joins has been required. In this paper, the efficient method for creating and allocating tasks to balance statically the load of each processor in a parallel spatial join is presented. A task graph is developed in which a vertex weight is calculated by the cost model I have proposed. Then, it is partitioned through a graph partitioning algorithm. According to the experiments in CC16 parallel machine, our method made an improvement in the static load balance by decreasing the variance of a task execution time on each processor.

  • PDF

Development of Tree Structures and Algorithms for the Efficient Group Key Management in Multicast Environment (멀티캐스트 환경에서 효율적인 그룹키 관리를 위한 트리구조 및 알고리즘 개발)

  • Han, Keun-Hee
    • The KIPS Transactions:PartB
    • /
    • v.9B no.5
    • /
    • pp.587-598
    • /
    • 2002
  • In multicast environment, the main objective of group key management is to provide security services to group communications by sharing a single group key among all the members of the group and subsequently encrypting and decrypting all the communication messages exchanged among the members of the group. Up to now, there has been no effort to develop group key management mechanism that considers the rate of users' join/leave operations. Hence, in this research, we propose group key management mechanisms that consider the rate of user's join/leave operations. We also define a new tree structure called variable tree which is much more flexible than full regular trees and show that variable trees are more efficient than full regular trees for group key management. Especially, we propose an algorithm that minimizes the necessary number of rekey messages according to the rate of join and leave operations. We also shows that if the rate of leave operation is greater than 50%, then the tree structure with degrees 2 or 3 are the optimal structures.

Efficient Multiple Joins using the Synchronization of Page Execution Time in Limited Processors Environments (한정된 프로세서 환경에서 체이지 실행시간 동기화를 이용한 효율적인 다중 결합)

  • Lee, Kyu-Ock;Weon, Young-Sun;Hong, Man-Pyo
    • Journal of KIISE:Databases
    • /
    • v.28 no.4
    • /
    • pp.732-741
    • /
    • 2001
  • In the relational database systems the join operation is one of the most time-consuming query operations. Many parallel join algorithms have been developed 개 reduce the execution time Multiple hash join algorithm using allocation tree is one of the most efficient ones. However, it may have some delay on the processing each node of allocation tree, which is occurred in tuple-probing phase by the difference between one page reading time of outer relation and the processing time of already read one. This delay problem was solved by using the concept of synchronization of page execution time with we had proposed In this paper the effects of the performance improvements in each node of the allocation tree are extended to the whole allocation tree and the performance evaluation about that is processed. In addition we propose an efficient algorithm for multiple hash joins in limited number of processor environments according to the relationship between the number of input relations in the allocation tree and the number of processors allocated to the tree. Finally. we analyze the performance by building the analytical cost model and verify the validity of it by various performance comparison with previous method.

  • PDF

Design of UCC Broadcasting System in P2P Based IPTV Environments (P2P 기반의 IPTV 환경에서 UCC 방송을 위한 시스템 설계)

  • Kim, Ji Hoon
    • Journal of Korea Society of Digital Industry and Information Management
    • /
    • v.6 no.3
    • /
    • pp.37-47
    • /
    • 2010
  • In this paper, we propose an UCC broadcasting system in P2P based IPTV environments. Proposed system applies P2P based multiple chain architecture. UCC broadcasting system transfers data from not ISP server but UCC server peer that is included in DSLAM to joined peers. Therefore an algorithm to manage join and departure of peers have to modified. In this paper we propose an algorithm that does not increase an uplink bandwidth of DSLAM that include UCC server when peer joins to the UCC channel. We will show the improved performance of proposed scheme rather than general method with respect to the uplink bandwidth of DSLAM that include UCC server.

A Study on Welding Process Algorithm through Real-time Current Waveform Analysis (실시간 공정신호를 통한 용접공정 알고리즘에 관한 연구)

  • Yoon, Jin Young;Lee, Young Min;Shin, Soon Cheol;Choi, Hae Woon
    • Journal of Welding and Joining
    • /
    • v.33 no.4
    • /
    • pp.24-29
    • /
    • 2015
  • The current waveform was analysed to monitor the weld quality in real time process. The acquired current waveform was discretely analysed for the top and bottom limits of peaks as well as the pulse frequency measurement. Fast Fourier Transform was implemented in the program to monitor the pulse frequency in real time. The developed algorithm or program was tested for the validation purpose. The cross-section of weld profile was compared to the current waveform profile to correlate the monitored signal and the actual parts. Pulse frequency was also used as auxiliary tool for the quality monitoring. Based on the results, it was possible to evaluate the quality of welding by measure the current waveform profile and frequency measurement.

Two Evolutionary Gait Generation Methods for Quadruped Robots in Cartesian Coordinates Space and Join Coordinates Space (직교좌표공간과 관절공간에서의 4족 보행로봇의 두 가지 진화적 걸음새 생성기법)

  • Seo, Kisung
    • The Transactions of The Korean Institute of Electrical Engineers
    • /
    • v.63 no.3
    • /
    • pp.389-394
    • /
    • 2014
  • Two evolutionary gait generation methods for Cartesian and Joint coordinates space are compared to develop a fast locomotion for quadruped robots. GA(Genetic Algorithm) based approaches seek to optimize a pre-selected set of parameters for the locus of paw and initial position in cartesian coordinates space. GP(Genetic Programming) based technique generate few joint trajectories using symbolic regression in joint coordinates space as a form of polynomials. Optimization for two proposed methods are executed using Webots simulation for the quadruped robot which is built by Bioloid. Furthermore, simulation results for two proposed methods are analysed in terms of different coordinate spaces.

Energy Efficient IDS Node Distribution Algorithm using Minimum Spanning Tree in MANETs

  • Ha, Sung Chul;Kim, Hyun Woo
    • Smart Media Journal
    • /
    • v.5 no.4
    • /
    • pp.41-48
    • /
    • 2016
  • In mobile ad hoc networks(MANETs), all the nodes in a network have limited resources. Therefore, communication topology which has long lifetime is suitable for nodes in MANETs. And MANETs are exposed to various threats because of a new node which can join the network at any time. There are various researches on security problems in MANETs and many researches have tried to make efficient schemes for reducing network power consumption. Power consumption is necessary to secure networks, however too much power consumption can be critical to network lifetime. This paper focuses on energy efficient monitoring node distribution for enhancing network lifetime in MANETs. Since MANETs cannot use centralized infrastructure such as security systems of wired networks, we propose an efficient IDS node distribution scheme using minimum spanning tree (MST) method to cover all the nodes in a network and enhance the network lifetime. Simulation results show that the proposed algorithm has better performance in comparison with the existing algorithms.

User classification and location tracking algorithm using deep learning (딥러닝을 이용한 사용자 구분 및 위치추적 알고리즘)

  • Park, Jung-tak;Lee, Sol;Park, Byung-Seo;Seo, Young-ho
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2022.05a
    • /
    • pp.78-79
    • /
    • 2022
  • In this paper, we propose a technique for tracking the classification and location of each user through body proportion analysis of the normalized skeletons of multiple users obtained using RGB-D cameras. To this end, each user's 3D skeleton is extracted from the 3D point cloud and body proportion information is stored. After that, the stored body proportion information is compared with the body proportion data output from the entire frame to propose a user classification and location tracking algorithm in the entire image.

  • PDF

Energy Efficiency Routing Algorithm for Vessel Ubiquitous Sensor Network Environments (선박 USN에서 에너지 효율성을 위한 라우팅 알고리즘)

  • Choi, Myeong-Soo;Pyo, Se-Jun;Lee, Jin-Seok;Yoon, Seok-Ho;Lee, Seong-Ro
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • v.36 no.5B
    • /
    • pp.557-565
    • /
    • 2011
  • In this paper, we assume that sensor nodes organize the multi-hop networks, are fixed, and operate as full function devices(FFD). The wireless sensor network(WSN) only consists of mobile nodes without the assistance from the fixed infrastructure, which increases the flexibility of the network. However, it is difficult to perform routing in the WSN, since sensor nodes freely join in and drop out of the network, and some sensor nodes have very low power. We propose the algorithm combining routing schemes based on the bitmap and cluster methods in this paper. Through computer simulations, we show the validity of the proposed algorithm.

A Study of Process Parameters Optimization Using Genetic Algorithm for Nd:YAG Laser Welding of AA5182 Aluminum Alloy Sheet (AA5182 알루미늄 판재의 Nd:YAG 레이저 용접에서 유전 알고리즘을 이용한 공정변수 최적화에 대한 연구)

  • Park, Young-Whan;Rhee, Se-Hun;Park, Hyun-Sung
    • Proceedings of the KSME Conference
    • /
    • 2007.05a
    • /
    • pp.1322-1327
    • /
    • 2007
  • Many automotive companies have tried to apply the aluminum alloy sheet to car body because reducing the car weight can improve the fuel efficiency of vehicle. In order to do that, sheet materials require of weldablity, formability, productivity and so on. Aluminum alloy was not easy to join these metals due to its material properties. Thus, the laser is good heat source for aluminum alloy welding because of its high heat intensity. However, the welding quality was not good by porosity, underfill, and magnesium loss in welded metal for AA5182 aluminum alloy. In this study, Nd:YAG laser welding of AA 5182 with filler wire AA 5356 was carried out to overcome this problem. The weldability of AA5182 laser welding with AA5356 filler wire was investigated in terms of tensile strength and Erichsen ratio. For full penetration, mechanical properties were improved by filler wire. In order to optimize the process parameters, model to estimate tensile strength by artificial neural network was developed and fitness function was defined in consideration of weldability and productivity. Genetic algorithm was used to search the optimal point of laser power, welding speed, and wire feed rate.

  • PDF