The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Optimizing Semi-Stream CACHEJOIN for Near-Real- Time Data Warehousing
|
|
Author(s): M. Asif Naeem (School of Engineering, Computer and Mathematical Sciences, Auckland University of Technology, Auckland, New Zealand), Erum Mehmood (School of Science and Technology, University of Management and Technology, Lahore, Pakistan), M. G. Abbas Malik (Universal College of Learning, Palmerston North, New Zealand) and Noreen Jamil (National University FAST, Islamabad, Pakistan)
Copyright: 2020
Volume: 31
Issue: 1
Pages: 18
Source title:
Journal of Database Management (JDM)
Editor(s)-in-Chief: Keng Siau (Missouri University of Science and Technology, USA)
DOI: 10.4018/JDM.2020010102
Purchase
|
Abstract
Streaming data join is a critical process in the field of near-real-time data warehousing. For this purpose, an adaptive semi-stream join algorithm called CACHEJOIN (Cache Join) focusing non-uniform stream data is provided in the literature. However, this algorithm cannot exploit the memory and CPU resources optimally and consequently it leaves its service rate suboptimal due to sequential execution of both of its phases, called stream-probing (SP) phase and disk-probing (DP) phase. By integrating the advantages of CACHEJOIN, this article presents two modifications for it. The first is called P-CACHEJOIN (Parallel Cache Join) that enables the parallel processing of two phases in CACHEJOIN. This increases number of joined stream records and therefore improves throughput considerably. The second is called OP-CACHEJOIN (Optimized Parallel Cache Join) that implements a parallel loading of stored data into memory while the DP phase is executing. This research presents the performance analysis of both of the approaches defined within the paper existing CACHEJOIN empirically using synthetic skewed dataset.
Related Content
|
Renita M. Murimi, Grace Guiling Wang.
© 2021.
26 pages.
|
|
Atefeh Mashatan, Victoria Lemieux, Seung Hwan (Mark) Lee, Przemysław Szufel, Zachary Roberts.
© 2021.
22 pages.
|
|
Yuan Lu, Qiang Tang, Guiling Wang.
© 2021.
20 pages.
|
|
Hjalmar K. Turesson, Henry Kim, Marek Laskowski, Alexandra Roatis.
© 2021.
17 pages.
|
|
Chunnian Liu, Qi Tian, Mengqiu Chen.
© 2021.
16 pages.
|
|
Qingqing Zhou, Ming Jing.
© 2020.
19 pages.
|
|
M. Asif Naeem, Erum Mehmood, M. G. Abbas Malik, Noreen Jamil.
© 2020.
18 pages.
|
|
|