IIUM Repository

Building textual OLAP cubes using real-time intelligent heterogeneous approach

Alzeini, Haytham I. M. and Hameed, Shihab A. and Habaebi, Mohamed Hadi (2018) Building textual OLAP cubes using real-time intelligent heterogeneous approach. International Journal of Intelligent Information Technologies, 14 (3). pp. 83-108. ISSN 1548-3657 E-ISSN 1548-3665

[img] PDF - Published Version
Restricted to Registered users only

Download (1MB) | Request a copy
[img] PDF (SCOPUS) - Supplemental Material
Restricted to Registered users only

Download (487kB) | Request a copy
Download (343kB) | Preview


This article describes how the ever-growing amount of data entails introducing innovative solutions in or-der to capture, process, and store the information. OLAP has been considered a powerful analytical technology that enables analysts to gain insight into data and project information from diversified points of view. Thereupon, OLAP has been utilized in a broad spectrum of sensitive applications in the industry. The technology has occupied its place at the forefront of the vibrant information technology landscape of research in order to meet the evolving needs. One of these needs that has enticed the researchers’ attention is providing real-time answers which suggests, in particular cases, processing billions of records in few seconds or less. The limited processing capacities have arisen as a major hurdle in the way of achieving such an aim. Although numerous improvements have been suggested, few have considered the heterogeneous computing approach, whereby quantum leap in terms of the response time has been achieved, albeit in most cases, only numerical data have been utilized. In this article, the authors introduce a novel heterogeneous OLAP approach targets textual OLAP cubes aggregation and can be utilized efficiently in OLAP-based pattern recognition problems. In this context, the approach (a) exploits the GPU along with the CPU in order to process textual data. (b) Stores the queries aggregations’ hash table in the global memory such that the higher aggregations levels are being answered in a shorter time (c) Introduces an intelligent self-evaluating mechanism (ISEM), that evaluates the resource efficiency on query-basis by deciding which resource (CPU or GPU+CPU) is more reliable to process each query. The authors’ empirical results have shown the achieved gain is up to thirty-two folds over the parallel CPU-based counterpart solution. Furthermore, their approach has demonstrated that adopting aggregation-memory optimization significantly improves the performance of high-level textual aggregations.

Item Type: Article (Journal)
Additional Information: 6727/63895
Uncontrolled Keywords: Data Mining, Heterogeneous Computing, OLAP, Pattern Recognition, Rabin-Karp
Subjects: T Technology > T Technology (General) > T10.5 Communication of technical information
T Technology > TK Electrical engineering. Electronics Nuclear engineering > TK7800 Electronics. Computer engineering. Computer hardware. Photoelectronic devices > TK7885 Computer engineering
Kulliyyahs/Centres/Divisions/Institutes (Can select more than one option. Press CONTROL button): Kulliyyah of Engineering > Department of Electrical and Computer Engineering
Depositing User: Dr. Mohamed Hadi Habaebi
Date Deposited: 30 May 2018 12:27
Last Modified: 24 Jan 2019 10:09
URI: http://irep.iium.edu.my/id/eprint/63895

Actions (login required)

View Item View Item


Downloads per month over past year