Building textual OLAP cubes using real-time intelligent heterogeneous approach

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 diver...

Full description

Bibliographic Details
Main Authors:	Alzeini, Haytham I. M., Hameed, Shihab A., Habaebi, Mohamed Hadi
Format:	Article
Language:	English English English
Published:	IGI Global 2018
Subjects:	T10.5 Communication of technical information TK7885 Computer engineering
Online Access:	http://irep.iium.edu.my/63895/ http://irep.iium.edu.my/63895/ http://irep.iium.edu.my/63895/ http://irep.iium.edu.my/63895/1/Building-Textual-OLAP-Cubes-Using-Real-Time-Intelligent-Heterogeneous-Approach.pdf http://irep.iium.edu.my/63895/7/63895%20Building%20textual%20OLAP%20cubes%20SCOPUS.pdf http://irep.iium.edu.my/63895/13/63895_Building%20Textual%20OLAP%20Cubes%20Using%20Real-Time%20Intelligent%20Heterogeneous%20Approach_WOS.pdf

id	iium-63895
recordtype	eprints
spelling	iium-638952019-01-24T02:09:27Z http://irep.iium.edu.my/63895/ Building textual OLAP cubes using real-time intelligent heterogeneous approach Alzeini, Haytham I. M. Hameed, Shihab A. Habaebi, Mohamed Hadi T10.5 Communication of technical information TK7885 Computer engineering 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. IGI Global 2018-07-01 Article PeerReviewed application/pdf en http://irep.iium.edu.my/63895/1/Building-Textual-OLAP-Cubes-Using-Real-Time-Intelligent-Heterogeneous-Approach.pdf application/pdf en http://irep.iium.edu.my/63895/7/63895%20Building%20textual%20OLAP%20cubes%20SCOPUS.pdf application/pdf en http://irep.iium.edu.my/63895/13/63895_Building%20Textual%20OLAP%20Cubes%20Using%20Real-Time%20Intelligent%20Heterogeneous%20Approach_WOS.pdf 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 https://www.igi-global.com/viewtitlesample.aspx?id=204954&ptid=184855&t=Building%20Textual%20OLAP%20Cubes%20Using%20Real-Time%20Intelligent%20Heterogeneous%20Approach 10.4018/IJIIT.2018070105
repository_type	Digital Repository
institution_category	Local University
institution	International Islamic University Malaysia
building	IIUM Repository
collection	Online Access
language	English English English
topic	T10.5 Communication of technical information TK7885 Computer engineering
spellingShingle	T10.5 Communication of technical information TK7885 Computer engineering Alzeini, Haytham I. M. Hameed, Shihab A. Habaebi, Mohamed Hadi Building textual OLAP cubes using real-time intelligent heterogeneous approach
description	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.
format	Article
author	Alzeini, Haytham I. M. Hameed, Shihab A. Habaebi, Mohamed Hadi
author_facet	Alzeini, Haytham I. M. Hameed, Shihab A. Habaebi, Mohamed Hadi
author_sort	Alzeini, Haytham I. M.
title	Building textual OLAP cubes using real-time intelligent heterogeneous approach
title_short	Building textual OLAP cubes using real-time intelligent heterogeneous approach
title_full	Building textual OLAP cubes using real-time intelligent heterogeneous approach
title_fullStr	Building textual OLAP cubes using real-time intelligent heterogeneous approach
title_full_unstemmed	Building textual OLAP cubes using real-time intelligent heterogeneous approach
title_sort	building textual olap cubes using real-time intelligent heterogeneous approach
publisher	IGI Global
publishDate	2018
url	http://irep.iium.edu.my/63895/ http://irep.iium.edu.my/63895/ http://irep.iium.edu.my/63895/ http://irep.iium.edu.my/63895/1/Building-Textual-OLAP-Cubes-Using-Real-Time-Intelligent-Heterogeneous-Approach.pdf http://irep.iium.edu.my/63895/7/63895%20Building%20textual%20OLAP%20cubes%20SCOPUS.pdf http://irep.iium.edu.my/63895/13/63895_Building%20Textual%20OLAP%20Cubes%20Using%20Real-Time%20Intelligent%20Heterogeneous%20Approach_WOS.pdf
first_indexed	2023-09-18T21:30:37Z
last_indexed	2023-09-18T21:30:37Z
_version_	1777412485963317248

Building textual OLAP cubes using real-time intelligent heterogeneous approach

Similar Items