Performance evaluation of parallel GroupBy-Before-Join query processing in high performance database systems

David Taniar, Johanna Wenny Rahayu, Hero Ekonomosa

    Research output: Chapter in Book/Report/Conference proceedingConference PaperResearchpeer-review

    2 Citations (Scopus)

    Abstract

    Strategic decision making process uses a lot of GroupBy clauses and join operations queries. As the source of information in this type of application to these queries is commonly very huge, then parallelization of GroupBy-Join queries is unavoidable in order to speed up query processing time. In this paper, we investigate three parallelization techniques for GroupBy-Join queries, particularly the queries where the group-by clause can be performed before the join operation. We subsequently call this query “GroupBy-Before-Join” queries. Performance evaluation of the three parallel processing methods is also carried out and presented here.
    Original languageEnglish
    Title of host publicationHigh-Performance Computing and Networking
    Subtitle of host publication9th International Conference, HPCN Europe 2001 Amsterdam, The Netherlands, June 25-27, 2001 Proceedings
    EditorsBob Hertzberger, Alfons Hoekstra, Roy Williams
    Place of PublicationBerlin Germany
    PublisherSpringer
    Pages241-250
    Number of pages10
    ISBN (Print)3540422935
    DOIs
    Publication statusPublished - 2001
    EventInternational Conference on High Performance Computing and Networking Europe 2001 - Amsterdam, Netherlands
    Duration: 25 Jun 200127 Jun 2001
    Conference number: 9th
    https://link-springer-com.ezproxy.lib.monash.edu.au/book/10.1007/3-540-48228-8 (Proceedings)

    Publication series

    NameLecture Notes in Computer Science
    PublisherSpringer
    Volume2110
    ISSN (Print)0302-9743

    Conference

    ConferenceInternational Conference on High Performance Computing and Networking Europe 2001
    Abbreviated titleHPCN Europe 2001
    CountryNetherlands
    CityAmsterdam
    Period25/06/0127/06/01
    Internet address

    Cite this

    Taniar, D., Rahayu, J. W., & Ekonomosa, H. (2001). Performance evaluation of parallel GroupBy-Before-Join query processing in high performance database systems. In B. Hertzberger, A. Hoekstra, & R. Williams (Eds.), High-Performance Computing and Networking: 9th International Conference, HPCN Europe 2001 Amsterdam, The Netherlands, June 25-27, 2001 Proceedings (pp. 241-250). (Lecture Notes in Computer Science; Vol. 2110). Springer. https://doi.org/10.1007/3-540-48228-8_25