IDEAS home Printed from https://ideas.repec.org/a/aes/dbjour/v7y2017i3p3-13.html
   My bibliography  Save this article

Solutions for Optimizing the Relational JOIN Operator using the Compute Unified Device Architecture

Author

Listed:
  • Alexandru PIRJAN

    (The Romanian-American University, Bucharest, Romania)

Abstract

In this paper it is implemented the inner JOIN operator in the latest Pascal Compute Unified Device Architecture (CUDA), using two approaches developed in the CUDA Toolkit 8.0: a classical approach in which a thread selects one element from the first table and performs a binary search for the corresponding keys residing in the second table; a second approach that makes use of the dynamic parallelism feature of the Pascal architecture to solve the problem of task processing unbalance that may occur when the number of corresponding elements is different along the threads. The Compute Unified Device Architecture dynamic parallelism feature is used to invoke a supplementary kernel function in order to build in parallel the final output set of elements.

Suggested Citation

  • Alexandru PIRJAN, 2017. "Solutions for Optimizing the Relational JOIN Operator using the Compute Unified Device Architecture," Database Systems Journal, Academy of Economic Studies - Bucharest, Romania, vol. 7(3), pages 3-13, January.
    • Handle: RePEc:aes:dbjour:v:7:y:2017:i:3:p:3-13
    as

    Download full text from publisher

    File URL: http://www.dbjournal.ro/archive/25/25_1.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Ion LUNGU & Adela BÂRA & George CĂRUTASU & Alexandru PÎRJAN, & Simona-Vasilica OPREA, 2016. "Prediction Intelligent System In The Field Of Renewable Energies Through Neural Networks," ECONOMIC COMPUTATION AND ECONOMIC CYBERNETICS STUDIES AND RESEARCH, Faculty of Economic Cybernetics, Statistics and Informatics, vol. 50(1), pages 85-102.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Cicerone Laurentiu Popa & George Carutasu & Costel Emil Cotet & Nicoleta Luminita Carutasu & Tiberiu Dobrescu, 2017. "Smart City Platform Development for an Automated Waste Collection System," Sustainability, MDPI, vol. 9(11), pages 1-15, November.
    2. Cristian Mihai BARCA & Claudiu Dan BARCA, 2017. "Distributed algorithm to train neural networks using the Map Reduce paradigm," Database Systems Journal, Academy of Economic Studies - Bucharest, Romania, vol. 8(1), pages 3-11, July.
    3. Alexandru Pîrjan & George Căruțașu & Dana-Mihaela Petroșanu, 2018. "Designing, Developing, and Implementing a Forecasting Method for the Produced and Consumed Electricity in the Case of Small Wind Farms Situated on Quite Complex Hilly Terrain," Energies, MDPI, vol. 11(10), pages 1-42, October.
    4. Simona-Vasilica Oprea & Adela Bâra & Adina Ileana Uță & Alexandru Pîrjan & George Căruțașu, 2018. "Analyses of Distributed Generation and Storage Effect on the Electricity Consumption Curve in the Smart Grid Context," Sustainability, MDPI, vol. 10(7), pages 1-25, July.
    5. Alexandru Pîrjan, 2016. "A Mixed Approach Towards Improving Software Performance Of Compute Unified Device Architecture Applications," Romanian Economic Business Review, Romanian-American University, vol. 10(2), pages 448-459, December.
    6. George C?ru?a?u & Alexandru Pîrjan, 2016. "A Seasonal And Monthly Approach For Predicting The Delivered Energy Quantity In A Photovoltaic Power Plant In Romania," Annals of University of Craiova - Economic Sciences Series, University of Craiova, Faculty of Economics and Business Administration, vol. 1(44), pages 198-207.
    7. Prince Waqas Khan & Yongjun Kim & Yung-Cheol Byun & Sang-Joon Lee, 2021. "Influencing Factors Evaluation of Machine Learning-Based Energy Consumption Prediction," Energies, MDPI, vol. 14(21), pages 1-22, November.

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:aes:dbjour:v:7:y:2017:i:3:p:3-13. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Adela Bara (email available below). General contact details of provider: https://edirc.repec.org/data/aseeero.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.