Random access with a distributed Bitmap Join Index for Star Joins. Issue 2 (February 2020)

• Record Type: Journal Article
• Authors: Brito, Jaqueline J.; Mosqueiro, Thiago; Ciferri, Ricardo R.; Ciferri, Cristina D.A.
• Is Part Of: Heliyon. Volume 6:Issue 2(2020)
• Publication Date: 2020-02
• Subjects: Computer science -- Random access -- Distributed Bitmap Index -- Star Join -- Low-selectivity queries -- Hadoop ecosystem; Research -- Periodicals; Medical sciences -- Periodicals; Natural history -- Periodicals; Social sciences -- Periodicals; Earth sciences -- Periodicals; Physical sciences -- Periodicals; 507.2
• DOI: 10.1016/j.heliyon.2020.e03342
• Languages: English
• ISSNs: 2405-8440

Abstract

Abstract: Indices improve the performance of relational databases, especially on queries that return a small portion of the data (i.e., low-selectivity queries). Star joins are particularly expensive operations that commonly rely on indices for improved performance at scale. The development and support of index-based solutions for Star Joins are still at very early stages. To address this gap, we propose a distributed Bitmap Join Index (dBJI) and a framework-agnostic strategy to solve join predicates in linear time. For empirical analysis, we used common Hadoop technologies (e.g., HBase and Spark) to show that dBJI significantly outperforms full scan approaches by a factor between 59% and 88% in queries with low selectivity from the Star Schema Benchmark (SSB). Thus, distributed indices may significantly enhance low-selectivity query performance even in very large databases. Abstract : Computer science; Random access; Distributed Bitmap Index; Star Join; Low-selectivity queries; Hadoop ecosystem