Taking the Business Intelligence to the Clouds

Hussain Al-Aqrabi, Lu Liu, Richard Hill, Nick Antonopoulos

Research output: Chapter in Book/Report/Conference proceedingConference contribution

16 Citations (Scopus)

Abstract

Cloud computing is gradually gaining popularity among businesses due to its distinct advantages over self-hosted IT infrastructures. The software-as-a-service providers are serving as the primary interfacing to the business users community. However, the strategies and methods for hosting mission critical business intelligence (BI) applications on cloud is still being researched. BI is a highly resource intensive system requiring large scale parallel processing and significant storage capacities to host the data warehouses. OLAP (online analytical processing) is the user-end interface of BI that is designed to present multi-dimensional graphical reports to the end users. OLAP employs data cubes formed as a result of multidimensional queries run on an array of data warehouses. In self-hosted environments it was feared that BI will eventually face a resource crunch situation because it won't be feasible for companies to keep on adding resources to host the never ending expansion of data warehouses and the OLAP demands on the underlying networking. Cloud computing has instigated a new hope for future prospects of BI. But how will BI be implemented on cloud and how will the traffic and demand profile look like? This research has attempted to answer these key questions in this paper pertaining to taking BI to the cloud. The cloud hosting of BI has been demonstrated with the help of a simulation on OPNET comprising a cloud model with multiple OLAP application servers applying parallel query loads on an array of servers hosting relational databases. The simulation results have reflected that true and extensible parallel processing of database servers on the cloud can efficiently process OLAP application demands on cloud computing. Hence, the BI designer needs to plan for a highly partitioned database running on massively parallel database servers in which, each server hosts at least one partition of the underlying database serving the OLAP demands.
Original languageEnglish
Title of host publication2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS)
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages953-958
Number of pages6
ISBN (Print)9781467321648
DOIs
Publication statusPublished - 18 Oct 2012
Externally publishedYes
EventIEEE 14th International Conference on High Performance Computing and Communication & IEEE 9th International Conference on Embedded Software and Systems - Liverpool, United Kingdom
Duration: 25 Jun 201227 Jun 2012

Conference

ConferenceIEEE 14th International Conference on High Performance Computing and Communication & IEEE 9th International Conference on Embedded Software and Systems
Abbreviated titleHPCC-2012/ ICESS-2012
CountryUnited Kingdom
CityLiverpool
Period25/06/1227/06/12

Fingerprint

Competitive intelligence
Servers
Processing
Data warehouses
Cloud computing
Industry
Large scale systems

Cite this

Al-Aqrabi, H., Liu, L., Hill, R., & Antonopoulos, N. (2012). Taking the Business Intelligence to the Clouds. In 2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS) (pp. 953-958). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/HPCC.2012.138
Al-Aqrabi, Hussain ; Liu, Lu ; Hill, Richard ; Antonopoulos, Nick. / Taking the Business Intelligence to the Clouds. 2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS). Institute of Electrical and Electronics Engineers Inc., 2012. pp. 953-958
@inproceedings{479d031176024fc7a83508e3b455d1e0,
title = "Taking the Business Intelligence to the Clouds",
abstract = "Cloud computing is gradually gaining popularity among businesses due to its distinct advantages over self-hosted IT infrastructures. The software-as-a-service providers are serving as the primary interfacing to the business users community. However, the strategies and methods for hosting mission critical business intelligence (BI) applications on cloud is still being researched. BI is a highly resource intensive system requiring large scale parallel processing and significant storage capacities to host the data warehouses. OLAP (online analytical processing) is the user-end interface of BI that is designed to present multi-dimensional graphical reports to the end users. OLAP employs data cubes formed as a result of multidimensional queries run on an array of data warehouses. In self-hosted environments it was feared that BI will eventually face a resource crunch situation because it won't be feasible for companies to keep on adding resources to host the never ending expansion of data warehouses and the OLAP demands on the underlying networking. Cloud computing has instigated a new hope for future prospects of BI. But how will BI be implemented on cloud and how will the traffic and demand profile look like? This research has attempted to answer these key questions in this paper pertaining to taking BI to the cloud. The cloud hosting of BI has been demonstrated with the help of a simulation on OPNET comprising a cloud model with multiple OLAP application servers applying parallel query loads on an array of servers hosting relational databases. The simulation results have reflected that true and extensible parallel processing of database servers on the cloud can efficiently process OLAP application demands on cloud computing. Hence, the BI designer needs to plan for a highly partitioned database running on massively parallel database servers in which, each server hosts at least one partition of the underlying database serving the OLAP demands.",
keywords = "Business intelligence, Cloud computing, Online analytical processing, database-as-a-service, massively parallel systems, software-as-a-service",
author = "Hussain Al-Aqrabi and Lu Liu and Richard Hill and Nick Antonopoulos",
year = "2012",
month = "10",
day = "18",
doi = "10.1109/HPCC.2012.138",
language = "English",
isbn = "9781467321648",
pages = "953--958",
booktitle = "2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS)",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
address = "United States",

}

Al-Aqrabi, H, Liu, L, Hill, R & Antonopoulos, N 2012, Taking the Business Intelligence to the Clouds. in 2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS). Institute of Electrical and Electronics Engineers Inc., pp. 953-958, IEEE 14th International Conference on High Performance Computing and Communication & IEEE 9th International Conference on Embedded Software and Systems, Liverpool, United Kingdom, 25/06/12. https://doi.org/10.1109/HPCC.2012.138

Taking the Business Intelligence to the Clouds. / Al-Aqrabi, Hussain; Liu, Lu; Hill, Richard; Antonopoulos, Nick.

2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS). Institute of Electrical and Electronics Engineers Inc., 2012. p. 953-958.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - Taking the Business Intelligence to the Clouds

AU - Al-Aqrabi, Hussain

AU - Liu, Lu

AU - Hill, Richard

AU - Antonopoulos, Nick

PY - 2012/10/18

Y1 - 2012/10/18

N2 - Cloud computing is gradually gaining popularity among businesses due to its distinct advantages over self-hosted IT infrastructures. The software-as-a-service providers are serving as the primary interfacing to the business users community. However, the strategies and methods for hosting mission critical business intelligence (BI) applications on cloud is still being researched. BI is a highly resource intensive system requiring large scale parallel processing and significant storage capacities to host the data warehouses. OLAP (online analytical processing) is the user-end interface of BI that is designed to present multi-dimensional graphical reports to the end users. OLAP employs data cubes formed as a result of multidimensional queries run on an array of data warehouses. In self-hosted environments it was feared that BI will eventually face a resource crunch situation because it won't be feasible for companies to keep on adding resources to host the never ending expansion of data warehouses and the OLAP demands on the underlying networking. Cloud computing has instigated a new hope for future prospects of BI. But how will BI be implemented on cloud and how will the traffic and demand profile look like? This research has attempted to answer these key questions in this paper pertaining to taking BI to the cloud. The cloud hosting of BI has been demonstrated with the help of a simulation on OPNET comprising a cloud model with multiple OLAP application servers applying parallel query loads on an array of servers hosting relational databases. The simulation results have reflected that true and extensible parallel processing of database servers on the cloud can efficiently process OLAP application demands on cloud computing. Hence, the BI designer needs to plan for a highly partitioned database running on massively parallel database servers in which, each server hosts at least one partition of the underlying database serving the OLAP demands.

AB - Cloud computing is gradually gaining popularity among businesses due to its distinct advantages over self-hosted IT infrastructures. The software-as-a-service providers are serving as the primary interfacing to the business users community. However, the strategies and methods for hosting mission critical business intelligence (BI) applications on cloud is still being researched. BI is a highly resource intensive system requiring large scale parallel processing and significant storage capacities to host the data warehouses. OLAP (online analytical processing) is the user-end interface of BI that is designed to present multi-dimensional graphical reports to the end users. OLAP employs data cubes formed as a result of multidimensional queries run on an array of data warehouses. In self-hosted environments it was feared that BI will eventually face a resource crunch situation because it won't be feasible for companies to keep on adding resources to host the never ending expansion of data warehouses and the OLAP demands on the underlying networking. Cloud computing has instigated a new hope for future prospects of BI. But how will BI be implemented on cloud and how will the traffic and demand profile look like? This research has attempted to answer these key questions in this paper pertaining to taking BI to the cloud. The cloud hosting of BI has been demonstrated with the help of a simulation on OPNET comprising a cloud model with multiple OLAP application servers applying parallel query loads on an array of servers hosting relational databases. The simulation results have reflected that true and extensible parallel processing of database servers on the cloud can efficiently process OLAP application demands on cloud computing. Hence, the BI designer needs to plan for a highly partitioned database running on massively parallel database servers in which, each server hosts at least one partition of the underlying database serving the OLAP demands.

KW - Business intelligence

KW - Cloud computing

KW - Online analytical processing

KW - database-as-a-service

KW - massively parallel systems

KW - software-as-a-service

U2 - 10.1109/HPCC.2012.138

DO - 10.1109/HPCC.2012.138

M3 - Conference contribution

SN - 9781467321648

SP - 953

EP - 958

BT - 2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS)

PB - Institute of Electrical and Electronics Engineers Inc.

ER -

Al-Aqrabi H, Liu L, Hill R, Antonopoulos N. Taking the Business Intelligence to the Clouds. In 2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS). Institute of Electrical and Electronics Engineers Inc. 2012. p. 953-958 https://doi.org/10.1109/HPCC.2012.138