Description
A Review of Business Intelligence Survey on Cloud Computing
736 IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
Computer Science
Fathayab
Department of computer science, Birla Institute of Technology, Mesra Ranchi, Jharkhand-
835215 India
Pramila Joshi
Department of computer science, Birla Institute of Technology, Mesra Ranchi, Jharkhand-
835215 India
A Review of Business Intelligence Survey on
Cloud Computing
KEYWORDS : Business Intelligence, Cloud
Computing, Cloud Business Intelligence
ABSTRACT
Cloud computing is a important area to research because of the value it can provide to business. the researcher
analysis business intelligence (BI) can ofered to business over the internet as solution. Organization are striving to
become intelligence and achieve competition advantages through use of business intelligence (BI)solutions One of the tool that can be bring
about the cloud computing technology requirements of evolving business intelligence solutions is cloud computing the researcher will also
identify the challenges that business will be face in the organization the researcher able to support Business Intelligence in the cloud comput-
ing and also examine which company is being provided business intelligence in the cloud computing and comparison between public and
private cloud.
1. INTRODUCTION
Business intelligence is on of the technology areas that have
grown Tremendously in past few years .business environment
has totally Changed today the nature and structure of cur-
rent dynamic world cause that now days .in term of uncer-
tainty, risk and in complete information,the crisis becomes a
feature of modern business not the state of emergency , there
is more discontinuity observer Today then continuity. In this
changing the world business organizations Are increasingly
realizing the need for a more scalable and fexible Information
technology architecture .the ever mounting burden Of regula-
tion and compliance is further boost business. Assurance IT
while at the same time tightening the noose Cloud comput-
ing with deal one of the most important technology Cloud
(BI), and many experts expect that cloud computing will
have huge impact on information technology (IT) processes
and the IT forum. Te cloud accommodate fexibility, scal-
ability and enables organizations to react faster to the needs
of their business. One of the primary benefts of the cloud is
aiding, organizations along business agility that approve them
to acknowledge apace and adequately to the ever changing
business environment Business intelligence refer to computer
based techniques used in spotting digging –out ,and analyz-
ing business data , such as sales revenue by products and or
deferments or associated cost and income Organizations tend
to invest more in BI solutions based on cloud computing,
called Cloud BI or Software as a Service BI ,because investing
in traditional BI solutions unpractical and unattractive BI on
the cloud has a number of benefts it comes with a number of
menace. It is risky hold extensive understanding of the crea-
tion of cloud computing, and know the benefts and risks of
using tools on cloud.
2. DEFINITIONS
2.1 Cloud Computing
Gartner defines, cloud computing is “a style of computing
where enormous impactful IT-related ability are delivered as
a service’ to external multiple customers using Internet tech-
nologies According to The National Institute of Standards
and Technology (NIST) defines cloud computing in certain
approach, pass by this we can apprehend cloud computing
is a superior method ,in that:”cloud is a model as permit Ac-
ceptable on appeal network ingress to measure pool of com-
position resources (e. g, servers, network, storage, applica-
tions, and services That can be rapidly provision and deliver
with minimal management Endeavour or service provider
interaction According to B. Furht describes cloud comput-
ing is “a new style of computing in which explosively useful
too always virtualized resources are provided is a ser vice
over the Internet According to G. Yuvraj and R. Vijay propose
a new definition for cloud computing: “Clouds are immense
pool like purely disposable with usable virtualized basics
acting such as hardware development platforms while assis-
tance. The particular utility can aggressive composition in to
accommodate toward a variable capacity own also consider-
ing an optimum assets usage. this pool mainly utilize through
a pay- per-use model in which covenant are provide through
the Infrastructure provider by means of specially made SLAs.
2.2BUSINESS INTELLIGENCE
Business intelligence (BI) has been referred to as process of mak-
ing Better decisions through the use of people process, data and
related tools and methodologies. the root of business intelligence
are found in relational Database, data warehouse and data marts
that help organizing historical information in the hand of busi-
ness analysts to generate reporting that informs executives and
senior information departmental manager of strategic and tacti-
cal trends and opportunities According to Gartner defnes busi-
ness intelligence as “umbrella term that Includes the Applica-
tion, infrastructure and tools, and best practices that enable to
and resolution of information to develop and to make best of
decision and performance According to Tompson the right
governing , at the apparent time It contribute businesses with a
resolution to ingress and Inspect data reference and get efective
statistics to make Acquainted and business intelligent business
decisions.
2.3CLOUD BUSINESS INTELLIGENCE
According to Gartner survey, the most important drivers for in-
vesting in business intelligence are related to providing faster
response to user needs for data, decreasing costs and enhancing
user’s methods for data sharing And self services cloud comput-
ing makes sense to business intelligence Solution if it ofers ben-
efts to customer.
3. HISTORY OF BUSINESS INTELLIGENCE
In a 1958 article, IBM researcher Hans Peter Luhn used the term
business intelligence. He defned intelligence as: “the Capability
to perceive the alliance of presented facts such a way as to guide
action towards want objective Business Intelligence has evolve
d from decision support system Which began in the 1960s de-
veloped through the mid 80s In the mid 90s, BI became an im-
portant topic for the academic world, and ten years of research
managed to roll of Inhabitant method into a logical approach to
information extraction and processing.
CLOUD PROVIDERS AND BI
State- of- Arts
IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH 737
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
TABLE: Cloud Provider BI Cloud
Amazon NO
Go Grid NO
Google YES (data integration via Amazon EC2)
Informatic YES (private cloud Blue Insight)
IBM YES (sales and service cloud)
Salesforce.com YES
RightScale NO
Sun Micro syste NO
Rackspace NO
Te cloud providers and that provide business intelligence cloud
Amazon, Go Grid, Google, Sun Micro system, and Rackspace do
not provide BI cloud Informatics provide only data integration
of BI in cloud using AmazonEC2 cloud IBM has private BI cloud
called Blue Insight. Getting more visibility on organizational be-
havior and turning that into valuable knowledge improving an
organization’s decision making by building a big informative pic-
ture of the authentic information portion.
5. BUSINESS INTELLIGENCE ON THE CLOUD
According to Gartner’ s list of CIOs high tech point of view in the
Business Intelligence topped the list from 2011 to 2012, ranked
5th in 2011, and again took peck level in 2013-14; moreover
Cloud Computing has top rank in 2014 and admit stand in the
top 5 all the while at the end 5 years.
5.1 LIMITATION IN TRADITIONAL BI:
Cost: Organizations need to pay for getting services and software
permit and accession, which are ideal expensive Setup: To run
the BI application, the system has to set up software and system
platform ms that could be complex Adoption: Highest acceptable
BI utilization hold too difcult for most users to operate. Con-
venience: Establish BI get bounded via the browsers running on
mobile devices Informing: Establish BI appliance is not arrange-
ment for Coasting coverage ; alliance can be along obtained by
E-message the announcement through the company managers
then starting a discussion over E-message flament . the indicate
basics extra data with the action in arrangement
BI ADVANTAGES
Following advantages of business intelligence have been identifed
Specifc observe about consumer want all essential ability to Adapt to
any market alter as a choice modifcation , along with Industries bad
times Accurate business and sells casting advice company manager
With governor implement competitive business start place on Au-
thentic with appropriate advice Recognition customer need s access
with action along with assets Boost proftable aspect determination
at a time , the essential As long as coming up extension.
Comparison of BI Cloud:
6. BI COMPONENTS
Business intelligence setup stand in need defnite components to
produce business intelligence Some of these components are data
warehouses, ETL (extract, transform and load, three database func-
tions that are combined into one device to extract data out of one
in the database and location it into another database) tools, multidi-
mensional determination ,in data mining, with Visualization .
6.1DATA WAREHOUSES
Data warehouse is the one of data base worn with informing and
data analysis. It is a central repository of data which is created
by integrating data from one or more from data is nearly new ac-
tualize ambulate address for senior management report such as
annual and quarterly comparison.
6.2ETL TOOLS
ETL device and action is bounded with extraction of data from
one or many antecedent arrangement , this is commute data
with abounded altered compotation in to a common compota-
tion With then load that data into a data warehouse.
6.3 MULTIDIMENSIONAL ANALYSIS
OLAP, Online cogent deal with an kind of thing multidimen-
sional analysis. I t allows users to analyze database Advice with
multiple database calcifcation a while back As long as relation-
al databases is examined to be two- dimensional, OLAP data is
multidimensional, that aid Which is approve users to evaluate
multidimensional data associated with multiple awaited.
6.4 DATA MINING
Data mining approach is arrangement to analysis relationships
and rules within use data warehouse, and that point actualize a
of declaration these relationships and rules.
6.5 VISUALIZATION
Visualization is bothered along deliration data in a descriptive or
graphical for mat Te main goal of data visualization is to announce
instruction acutely and adequately through graphical presentation.
As more and more data is collected and analyzed, decision makers
at all levels welcome it; data visualization software enables them to
see analytical results presented visually, communicate concepts and
hypotheses to others, and even predict the future.
BUSINESS INTELLIGENCE ARCHITECTURE
Te basic architecture needed to run a business intelligence solu-
tion in the cloud is illustrated in Fig Te lower layers are formed
by hardware and software systems. Te minimum elements that
have to be ofered by the cloud computing provider are. Hard-
ware: Tis refers to processing, storage, and networks. An impor-
tant aspect is the processing speed of the hardware on which the
data will be physically stored. Software: Tis refers to the operat-
ing systems and drivers required to handle the hardware Data in-
tegration: Tis refers to the tools needed to perform the ETL and
data cleansing processes Database: Tis refers to the relational or
multidimensional database systems that contain the data Data
warehousing tools: Tey are the set of applications that allow the
creation and maintenance of the data warehouse BI tools: Tey
are the set of front-end applications that read and analyze data
that has been previously stored in a data warehouse.
Fig 1: Architecture of BI on cloud
738 IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
8. BUSINESS INTELLIGENCE WELFARE ON THE CLOUD
There are many benefits of Business Intelligence on the
Cloud. Listed below are some of its welfare. Under Cost: In BI
on the cloud, you only pay for what you need, which reduces
the total cost of your BI system through reducing overhead
resources. The cloud also reduces maintenance and adminis-
tration costs Scalability: Cloud BI systems have greater scal-
ability than hosting and operating them locally. It enables
the organization to react faster and more efficiently to the
business needs making it easier to upscale or downscale the
needed resources. Flexibility: Since Cloud BI systems are not
dependent on local hardware resources, they provide more
flexibility to the users. Users can access analyzed information
and reports anytime and from anywhere Disaster recovery:
Cloud systems provide the ability of backing up data offsite
in multiple locations, which allows for tragedy recuperation
with produce the cloud BI resolution more reliable than the
on-site BI solution.
9. CHALLENGES: IMPLIMENTING BUSINESS INTELLIGENCE
CLOUD
Organization implementing a business intelligence solution
May face several challenges is a discussion of the cloud based
BI challenges. Security: Concerning the risks of Cloud Com-
puting Security: Concerning the risks of Cloud Computing
integration, approximately 75% of the Chief Information Of-
ficers and IT specialists consider security as the number one
risk . With cloud computing, data is stored and accessed via
the internet. For some businesses, it is essential to keep the
data on the premises as their all data is confidential There
are several solutions to secure data including encryption,
but it is the organization’s responsibility to encryption, but
it is the organization’s responsibility to encrypt the data ap-
propriately on the cloud. Although the virtualization process
is essential in any cloud technology, it might cause highly
technical security breaches as the data will be stored forever
on virtual hardware even when its index is Deleted Data Re-
covery: Since the data is saved on the cloud, there will be a
probability of data violation, the recovery process will be
difficult and it will take a long time due to dependency on
third parties Availability: The cloud BI availability depends
on the third party’s server availability. If the server is down,
the cloud BI users could lose control of their data. Incompat-
ibility: One of the most important features of BI is the abil-
ity to import and export data from various data sources to
be reused with other enterprise applications. The incompat-
ibility with other enterprise applications can occur because
of the separation of BI tools from other departments of the
organization.. Challenges of data transfer: If an organization
has a lot of data, moving it over the internet in a reasonable
time will be a challenge. If the network is slow, moving data
will take a lot of time. The organization also may have some
concerns about the confidentiality of its data, so the process
of moving data needs to be more secure. Performance: If stor-
age resources are separate from serve resources,, there may
be considerable latency in accessing data, especially when ac-
cessing large amounts of data Choosing the right vendor The
organization needs to know more about the vendor’ s offer-
ings and choose the most suitable one for its business. This
process may be difficult as there are many cloud BI vendors
with many offers. Total Cost It is difficult to calculate the
whole budget of the needed resources as their costs are vari-
able
COMPARISON BETWEEN PUBLIC AND PRIVATE CLOUD
FOR BI
To make the best decision for a business, the diferences be-
tween public and private cloud need to be clarifed. Table shows
the strong and weak points in both of them.
Table 1: Public vs. Private Cloud
Public cloud is a shared cloud, so a careful choice is required to
avoid the noisy neighbor’s efect ct from sharing. In public cloud,
a pay-as-you-go model can be used, which means you pay only
for what you need. Tis is preferred for variable or low workload
business like development and testing websites or pay-per-use
applications. In public cloud, organizations have little control of
their resources as all the resources will be on the cloud not on-
site. Security is an outstanding question in cloud systems espe-
cially in the public shared cloud, because all the data is stored
and accessed via the internet. Public cloud does not require
maintenance or need time changing or updating the software,
because the software is not on-site and because the cloud provid-
er is responsible for it. Tis means that internal IT employees are
not required for maintaining the servers, which translates into
saving time and Resources. Tere are many Cloud service provid-
ers (such as Amazon Google, Informatics, etc.). Amazon, Go Grid,
Google, Sun Microsystems, and Racks pace do not provide Cloud
BI Informatics provides only data integration of BI in Cloud using
Amazon EC2 cloud; IBM has private BI Cloud called Blue Insight;
Right Scale provides BI Cloud using data processing and busi-
ness intelligence implement advance along database company
upright, open source business intelligence maker, Jasper soft, and
data integration specialist, Talend. [22] Here is a comparison be-
tween BI cloud providers with their Features[20] Right Scale It is
a public BI cloud, which means that it is publically available not
just to their organization. It is not open source which means that
the source code of BI cloud is either at hand that is a appropriate
BI cloud which are all functions of Business Intelligence are ad-
dressed. Common functions of business intelligence technologies
are reporting online analytical processing, analytics, benchmark-
ing predictive analytics and data mining. Te data management
technique that is used by it is Specialized Analytic Databases It
does not support forecasting ; however, it is scalable and Flex-
ible IBM (Blue Insight): It is a private BI cloud and is not open
source. Te data management technique that is used by it has
more than a pet byte of data storage. It not only supports fore-
casting, but it is also scalable and fexible Salesforce.com (Sales
Cloud 2): It is a public BI cloud and is not open source. Te data
management technique it uses is Automated Data Management
It supports predict yet that is not adaptable including low scal-
ability. Salesforce.com (Service Cloud 2): It is a public BI cloud
and is not an open source. It is not using any data management
technique. It not only support predict yet. which is not adaptable
including low scalability Informatics: It is a public BI cloud and is
not open source Te data management technique that is used by
it is data Migration, Replication and Archiving. It not only sup-
ports forecasting but it is also not fexible and it has low scalabil-
ity Tis comparison concludes that Right Scale BI Cloud is better
among available Public BI Clouds whereas Private BI Cloud has
been implemented only by IBM[20].
IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH 739
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
REFERENCE
• Thompson, W.J.J. & Vander Walt, J.S., 2010, “Business intelligence in the cloud”, SA Journal of Information Management 12(1), Art. #445, 5 pag-
es. DOI: 10.4102/sajim. v12i1.445. | • Yuvraj Singh Gurjar & Vijay Singh Rathore, 2013, “Cloud Business Intelligence – Is What Business Need To-
day”, International Journal of Rece nt Technology and Engineering (IJRTE) ISSN: 2277-3878, Volume-1, Issue-6. | • “Business Intelligence in the Cloud”,http://cloudcomputingtopics.
com/2011/09/business- intelligence-in-the-cloud/, Requested in December 2013. | • Marinela Mircea, Bogdan Ghilic – Micu and Marian Stocia, 2011, “Combine Business intelligence
with Cloud Computing to Delivery Agility in Actual Economy”, Economic Computation & Economic Cybernetics Studies & Research, Vol. 45 Issue 1, p1. | • Bharat Chandra and Mee-
na Iyer, 2010, “BI in the Cloud: Defining the Architecture for Quick Wins”, SET Labs Infosys Technologies Limited, Vol. 8, No 1. | • Business intelligence availablehttp://on.wikipedia.
org/wikibusiness intelligence | • Business intelligence (BI) availablehttp://www gartne.com /it-glossary/business-intelligence-bi | • , “Cloud computing fundamentals”2010 by Furht,
In Handbook of cloud computing (pp. 3-19). Springer US | • J. Dibber, T.Goels, R.Hirschheim,and B.jayatilaka,”information System outsouring.A survey and analysis of the Literature
2004. | • “Business intelligence (BI)”,http://www.gartner.com/it-glossary /business-intelligence-bi/, Requested in January 2014. | • Patrick Baesel and Bob Croker, 2010, “Business
Intelligence as a Shared Service”, Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A | • Mcmurphy , Neil survey of business intelligence
purchase Drivers show need for new approach to business intelligence, July 2008 | • M. Golfarelli, S. Rizzi, and I. Cella, 2004, “Beyond datawarehousing: What’s next in business intel-
ligence?” In Proc. DOLAP, pages 1–6 | • John Lloyd, 2011, “Identifying Key Components of Business Intelligence Systems and Their Role in Managerial Decision making”, Master of
Science, University of Oregon Applied Information Management Program. | • Maciej Pondel, 2013, “Business Intelligence as a service in a cloud environment”, Proceedings of the
2013 Federated Conference on Computer Science and Information Systems pp. 1269–1271 | • “Data war ehouse”,http://en.wikipedia.org/wiki/Data_warehouse , Requested in Janu-
ary 2014 | • “What is OLAP (Online Analytical Processing)?”http://www.techterms.com/de finition/olap, Requested in January 2014 | • “Data Visualization”,http://www.sas.com/
en_us/insights/big-data/data- visualization.html, Requested in January 2014 | • Christina Tamer, Mary Kiley, Noushin Ashrafi & Jean- Pierre Kuilboer, “Risk and Benefits of Business
Intelligence in the Cloud”, University of Massachusetts Boston, Management Science and Information Systems Department, 100 Morrissey Blvd, Boston, MA, 02125 United States of
America. | • Sonam Chawla, 2011, “Design and Development of Business Intelligence Portal in Cloud Computing”, Master of Engineering in Software Engineering, Computer Science
and Engineering Department, Thapar University. | • IPRO Cloud computing what is it, and what you need to know Megan Wilcox , May 2009,http://wwww.iprotech.com/Downlods/
File/Conference /May 2009,/cloud computing What _it _pd f | • Carl Brooks, 2009, “Cloud BI from RightScale and Jaspersoft is priced for penny pinchers but lacks polish”, Requested
in January 2014. | • “What is Data Visualization”,http://www.slideshare.net/QueryIO/hadoop-big-data visualization, Requested in January 2014 | • Bharat Chandra and meena
lyer, BI in the cloud-defing Architecture for quick wins available |http://www.infosys.com/infosys-labs/publication/document/BI-in -a-cloud.pdf |
11. CONCLUSION
Cloud is a the most important fact about future Business Intel-
ligence And ofer several advantages in term of cost benefts fex-
ibility of Implementation , availability and speed of implementa-
tion BI on the cloud ofer huge possibilities for removing barriers
to decision making By integrating high volume and mission criti-
cal business processes Terefore, a cloud business intelligence
solution may be a feasible A solution to a problem on the most
greatest challenges faced economic Crisis by such a solution, the
economic organization may be large and Middle sized or small
use as place a favorable that under regular conditions Other then
adopting BI or cloud business intelligence would not accessible
Irrespective of the age of BI landscape the could model can drive
increased business intelligence adopting, improved end-user ex-
perience better Access to analytics reduced IT dependence. We
adopt cloud BI there are many benefts of Cloud BI, but there
are some challenges that still need alternative research to Public
cloud and some security and assessing Privacy in business intel-
ligence as all services and data reside on the cloud without inter-
net data can not access important to fnd legal ways to infuence
these hazard and to fnd quick and safe ways for data transfer via
the internet.
doc_468203646.pdf
A Review of Business Intelligence Survey on Cloud Computing
736 IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
Computer Science
Fathayab
Department of computer science, Birla Institute of Technology, Mesra Ranchi, Jharkhand-
835215 India
Pramila Joshi
Department of computer science, Birla Institute of Technology, Mesra Ranchi, Jharkhand-
835215 India
A Review of Business Intelligence Survey on
Cloud Computing
KEYWORDS : Business Intelligence, Cloud
Computing, Cloud Business Intelligence
ABSTRACT
Cloud computing is a important area to research because of the value it can provide to business. the researcher
analysis business intelligence (BI) can ofered to business over the internet as solution. Organization are striving to
become intelligence and achieve competition advantages through use of business intelligence (BI)solutions One of the tool that can be bring
about the cloud computing technology requirements of evolving business intelligence solutions is cloud computing the researcher will also
identify the challenges that business will be face in the organization the researcher able to support Business Intelligence in the cloud comput-
ing and also examine which company is being provided business intelligence in the cloud computing and comparison between public and
private cloud.
1. INTRODUCTION
Business intelligence is on of the technology areas that have
grown Tremendously in past few years .business environment
has totally Changed today the nature and structure of cur-
rent dynamic world cause that now days .in term of uncer-
tainty, risk and in complete information,the crisis becomes a
feature of modern business not the state of emergency , there
is more discontinuity observer Today then continuity. In this
changing the world business organizations Are increasingly
realizing the need for a more scalable and fexible Information
technology architecture .the ever mounting burden Of regula-
tion and compliance is further boost business. Assurance IT
while at the same time tightening the noose Cloud comput-
ing with deal one of the most important technology Cloud
(BI), and many experts expect that cloud computing will
have huge impact on information technology (IT) processes
and the IT forum. Te cloud accommodate fexibility, scal-
ability and enables organizations to react faster to the needs
of their business. One of the primary benefts of the cloud is
aiding, organizations along business agility that approve them
to acknowledge apace and adequately to the ever changing
business environment Business intelligence refer to computer
based techniques used in spotting digging –out ,and analyz-
ing business data , such as sales revenue by products and or
deferments or associated cost and income Organizations tend
to invest more in BI solutions based on cloud computing,
called Cloud BI or Software as a Service BI ,because investing
in traditional BI solutions unpractical and unattractive BI on
the cloud has a number of benefts it comes with a number of
menace. It is risky hold extensive understanding of the crea-
tion of cloud computing, and know the benefts and risks of
using tools on cloud.
2. DEFINITIONS
2.1 Cloud Computing
Gartner defines, cloud computing is “a style of computing
where enormous impactful IT-related ability are delivered as
a service’ to external multiple customers using Internet tech-
nologies According to The National Institute of Standards
and Technology (NIST) defines cloud computing in certain
approach, pass by this we can apprehend cloud computing
is a superior method ,in that:”cloud is a model as permit Ac-
ceptable on appeal network ingress to measure pool of com-
position resources (e. g, servers, network, storage, applica-
tions, and services That can be rapidly provision and deliver
with minimal management Endeavour or service provider
interaction According to B. Furht describes cloud comput-
ing is “a new style of computing in which explosively useful
too always virtualized resources are provided is a ser vice
over the Internet According to G. Yuvraj and R. Vijay propose
a new definition for cloud computing: “Clouds are immense
pool like purely disposable with usable virtualized basics
acting such as hardware development platforms while assis-
tance. The particular utility can aggressive composition in to
accommodate toward a variable capacity own also consider-
ing an optimum assets usage. this pool mainly utilize through
a pay- per-use model in which covenant are provide through
the Infrastructure provider by means of specially made SLAs.
2.2BUSINESS INTELLIGENCE
Business intelligence (BI) has been referred to as process of mak-
ing Better decisions through the use of people process, data and
related tools and methodologies. the root of business intelligence
are found in relational Database, data warehouse and data marts
that help organizing historical information in the hand of busi-
ness analysts to generate reporting that informs executives and
senior information departmental manager of strategic and tacti-
cal trends and opportunities According to Gartner defnes busi-
ness intelligence as “umbrella term that Includes the Applica-
tion, infrastructure and tools, and best practices that enable to
and resolution of information to develop and to make best of
decision and performance According to Tompson the right
governing , at the apparent time It contribute businesses with a
resolution to ingress and Inspect data reference and get efective
statistics to make Acquainted and business intelligent business
decisions.
2.3CLOUD BUSINESS INTELLIGENCE
According to Gartner survey, the most important drivers for in-
vesting in business intelligence are related to providing faster
response to user needs for data, decreasing costs and enhancing
user’s methods for data sharing And self services cloud comput-
ing makes sense to business intelligence Solution if it ofers ben-
efts to customer.
3. HISTORY OF BUSINESS INTELLIGENCE
In a 1958 article, IBM researcher Hans Peter Luhn used the term
business intelligence. He defned intelligence as: “the Capability
to perceive the alliance of presented facts such a way as to guide
action towards want objective Business Intelligence has evolve
d from decision support system Which began in the 1960s de-
veloped through the mid 80s In the mid 90s, BI became an im-
portant topic for the academic world, and ten years of research
managed to roll of Inhabitant method into a logical approach to
information extraction and processing.
CLOUD PROVIDERS AND BI
State- of- Arts
IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH 737
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
TABLE: Cloud Provider BI Cloud
Amazon NO
Go Grid NO
Google YES (data integration via Amazon EC2)
Informatic YES (private cloud Blue Insight)
IBM YES (sales and service cloud)
Salesforce.com YES
RightScale NO
Sun Micro syste NO
Rackspace NO
Te cloud providers and that provide business intelligence cloud
Amazon, Go Grid, Google, Sun Micro system, and Rackspace do
not provide BI cloud Informatics provide only data integration
of BI in cloud using AmazonEC2 cloud IBM has private BI cloud
called Blue Insight. Getting more visibility on organizational be-
havior and turning that into valuable knowledge improving an
organization’s decision making by building a big informative pic-
ture of the authentic information portion.
5. BUSINESS INTELLIGENCE ON THE CLOUD
According to Gartner’ s list of CIOs high tech point of view in the
Business Intelligence topped the list from 2011 to 2012, ranked
5th in 2011, and again took peck level in 2013-14; moreover
Cloud Computing has top rank in 2014 and admit stand in the
top 5 all the while at the end 5 years.
5.1 LIMITATION IN TRADITIONAL BI:
Cost: Organizations need to pay for getting services and software
permit and accession, which are ideal expensive Setup: To run
the BI application, the system has to set up software and system
platform ms that could be complex Adoption: Highest acceptable
BI utilization hold too difcult for most users to operate. Con-
venience: Establish BI get bounded via the browsers running on
mobile devices Informing: Establish BI appliance is not arrange-
ment for Coasting coverage ; alliance can be along obtained by
E-message the announcement through the company managers
then starting a discussion over E-message flament . the indicate
basics extra data with the action in arrangement
BI ADVANTAGES
Following advantages of business intelligence have been identifed
Specifc observe about consumer want all essential ability to Adapt to
any market alter as a choice modifcation , along with Industries bad
times Accurate business and sells casting advice company manager
With governor implement competitive business start place on Au-
thentic with appropriate advice Recognition customer need s access
with action along with assets Boost proftable aspect determination
at a time , the essential As long as coming up extension.
Comparison of BI Cloud:
6. BI COMPONENTS
Business intelligence setup stand in need defnite components to
produce business intelligence Some of these components are data
warehouses, ETL (extract, transform and load, three database func-
tions that are combined into one device to extract data out of one
in the database and location it into another database) tools, multidi-
mensional determination ,in data mining, with Visualization .
6.1DATA WAREHOUSES
Data warehouse is the one of data base worn with informing and
data analysis. It is a central repository of data which is created
by integrating data from one or more from data is nearly new ac-
tualize ambulate address for senior management report such as
annual and quarterly comparison.
6.2ETL TOOLS
ETL device and action is bounded with extraction of data from
one or many antecedent arrangement , this is commute data
with abounded altered compotation in to a common compota-
tion With then load that data into a data warehouse.
6.3 MULTIDIMENSIONAL ANALYSIS
OLAP, Online cogent deal with an kind of thing multidimen-
sional analysis. I t allows users to analyze database Advice with
multiple database calcifcation a while back As long as relation-
al databases is examined to be two- dimensional, OLAP data is
multidimensional, that aid Which is approve users to evaluate
multidimensional data associated with multiple awaited.
6.4 DATA MINING
Data mining approach is arrangement to analysis relationships
and rules within use data warehouse, and that point actualize a
of declaration these relationships and rules.
6.5 VISUALIZATION
Visualization is bothered along deliration data in a descriptive or
graphical for mat Te main goal of data visualization is to announce
instruction acutely and adequately through graphical presentation.
As more and more data is collected and analyzed, decision makers
at all levels welcome it; data visualization software enables them to
see analytical results presented visually, communicate concepts and
hypotheses to others, and even predict the future.
BUSINESS INTELLIGENCE ARCHITECTURE
Te basic architecture needed to run a business intelligence solu-
tion in the cloud is illustrated in Fig Te lower layers are formed
by hardware and software systems. Te minimum elements that
have to be ofered by the cloud computing provider are. Hard-
ware: Tis refers to processing, storage, and networks. An impor-
tant aspect is the processing speed of the hardware on which the
data will be physically stored. Software: Tis refers to the operat-
ing systems and drivers required to handle the hardware Data in-
tegration: Tis refers to the tools needed to perform the ETL and
data cleansing processes Database: Tis refers to the relational or
multidimensional database systems that contain the data Data
warehousing tools: Tey are the set of applications that allow the
creation and maintenance of the data warehouse BI tools: Tey
are the set of front-end applications that read and analyze data
that has been previously stored in a data warehouse.
Fig 1: Architecture of BI on cloud
738 IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
8. BUSINESS INTELLIGENCE WELFARE ON THE CLOUD
There are many benefits of Business Intelligence on the
Cloud. Listed below are some of its welfare. Under Cost: In BI
on the cloud, you only pay for what you need, which reduces
the total cost of your BI system through reducing overhead
resources. The cloud also reduces maintenance and adminis-
tration costs Scalability: Cloud BI systems have greater scal-
ability than hosting and operating them locally. It enables
the organization to react faster and more efficiently to the
business needs making it easier to upscale or downscale the
needed resources. Flexibility: Since Cloud BI systems are not
dependent on local hardware resources, they provide more
flexibility to the users. Users can access analyzed information
and reports anytime and from anywhere Disaster recovery:
Cloud systems provide the ability of backing up data offsite
in multiple locations, which allows for tragedy recuperation
with produce the cloud BI resolution more reliable than the
on-site BI solution.
9. CHALLENGES: IMPLIMENTING BUSINESS INTELLIGENCE
CLOUD
Organization implementing a business intelligence solution
May face several challenges is a discussion of the cloud based
BI challenges. Security: Concerning the risks of Cloud Com-
puting Security: Concerning the risks of Cloud Computing
integration, approximately 75% of the Chief Information Of-
ficers and IT specialists consider security as the number one
risk . With cloud computing, data is stored and accessed via
the internet. For some businesses, it is essential to keep the
data on the premises as their all data is confidential There
are several solutions to secure data including encryption,
but it is the organization’s responsibility to encryption, but
it is the organization’s responsibility to encrypt the data ap-
propriately on the cloud. Although the virtualization process
is essential in any cloud technology, it might cause highly
technical security breaches as the data will be stored forever
on virtual hardware even when its index is Deleted Data Re-
covery: Since the data is saved on the cloud, there will be a
probability of data violation, the recovery process will be
difficult and it will take a long time due to dependency on
third parties Availability: The cloud BI availability depends
on the third party’s server availability. If the server is down,
the cloud BI users could lose control of their data. Incompat-
ibility: One of the most important features of BI is the abil-
ity to import and export data from various data sources to
be reused with other enterprise applications. The incompat-
ibility with other enterprise applications can occur because
of the separation of BI tools from other departments of the
organization.. Challenges of data transfer: If an organization
has a lot of data, moving it over the internet in a reasonable
time will be a challenge. If the network is slow, moving data
will take a lot of time. The organization also may have some
concerns about the confidentiality of its data, so the process
of moving data needs to be more secure. Performance: If stor-
age resources are separate from serve resources,, there may
be considerable latency in accessing data, especially when ac-
cessing large amounts of data Choosing the right vendor The
organization needs to know more about the vendor’ s offer-
ings and choose the most suitable one for its business. This
process may be difficult as there are many cloud BI vendors
with many offers. Total Cost It is difficult to calculate the
whole budget of the needed resources as their costs are vari-
able
COMPARISON BETWEEN PUBLIC AND PRIVATE CLOUD
FOR BI
To make the best decision for a business, the diferences be-
tween public and private cloud need to be clarifed. Table shows
the strong and weak points in both of them.
Table 1: Public vs. Private Cloud
Public cloud is a shared cloud, so a careful choice is required to
avoid the noisy neighbor’s efect ct from sharing. In public cloud,
a pay-as-you-go model can be used, which means you pay only
for what you need. Tis is preferred for variable or low workload
business like development and testing websites or pay-per-use
applications. In public cloud, organizations have little control of
their resources as all the resources will be on the cloud not on-
site. Security is an outstanding question in cloud systems espe-
cially in the public shared cloud, because all the data is stored
and accessed via the internet. Public cloud does not require
maintenance or need time changing or updating the software,
because the software is not on-site and because the cloud provid-
er is responsible for it. Tis means that internal IT employees are
not required for maintaining the servers, which translates into
saving time and Resources. Tere are many Cloud service provid-
ers (such as Amazon Google, Informatics, etc.). Amazon, Go Grid,
Google, Sun Microsystems, and Racks pace do not provide Cloud
BI Informatics provides only data integration of BI in Cloud using
Amazon EC2 cloud; IBM has private BI Cloud called Blue Insight;
Right Scale provides BI Cloud using data processing and busi-
ness intelligence implement advance along database company
upright, open source business intelligence maker, Jasper soft, and
data integration specialist, Talend. [22] Here is a comparison be-
tween BI cloud providers with their Features[20] Right Scale It is
a public BI cloud, which means that it is publically available not
just to their organization. It is not open source which means that
the source code of BI cloud is either at hand that is a appropriate
BI cloud which are all functions of Business Intelligence are ad-
dressed. Common functions of business intelligence technologies
are reporting online analytical processing, analytics, benchmark-
ing predictive analytics and data mining. Te data management
technique that is used by it is Specialized Analytic Databases It
does not support forecasting ; however, it is scalable and Flex-
ible IBM (Blue Insight): It is a private BI cloud and is not open
source. Te data management technique that is used by it has
more than a pet byte of data storage. It not only supports fore-
casting, but it is also scalable and fexible Salesforce.com (Sales
Cloud 2): It is a public BI cloud and is not open source. Te data
management technique it uses is Automated Data Management
It supports predict yet that is not adaptable including low scal-
ability. Salesforce.com (Service Cloud 2): It is a public BI cloud
and is not an open source. It is not using any data management
technique. It not only support predict yet. which is not adaptable
including low scalability Informatics: It is a public BI cloud and is
not open source Te data management technique that is used by
it is data Migration, Replication and Archiving. It not only sup-
ports forecasting but it is also not fexible and it has low scalabil-
ity Tis comparison concludes that Right Scale BI Cloud is better
among available Public BI Clouds whereas Private BI Cloud has
been implemented only by IBM[20].
IJSR - INTERNATIONAL JOURNAL OF SCIENTIFIC RESEARCH 739
Volume : 4 | Issue : 5 | May 2015 • ISSN No 2277 - 8179
Research Paper
REFERENCE
• Thompson, W.J.J. & Vander Walt, J.S., 2010, “Business intelligence in the cloud”, SA Journal of Information Management 12(1), Art. #445, 5 pag-
es. DOI: 10.4102/sajim. v12i1.445. | • Yuvraj Singh Gurjar & Vijay Singh Rathore, 2013, “Cloud Business Intelligence – Is What Business Need To-
day”, International Journal of Rece nt Technology and Engineering (IJRTE) ISSN: 2277-3878, Volume-1, Issue-6. | • “Business Intelligence in the Cloud”,http://cloudcomputingtopics.
com/2011/09/business- intelligence-in-the-cloud/, Requested in December 2013. | • Marinela Mircea, Bogdan Ghilic – Micu and Marian Stocia, 2011, “Combine Business intelligence
with Cloud Computing to Delivery Agility in Actual Economy”, Economic Computation & Economic Cybernetics Studies & Research, Vol. 45 Issue 1, p1. | • Bharat Chandra and Mee-
na Iyer, 2010, “BI in the Cloud: Defining the Architecture for Quick Wins”, SET Labs Infosys Technologies Limited, Vol. 8, No 1. | • Business intelligence availablehttp://on.wikipedia.
org/wikibusiness intelligence | • Business intelligence (BI) availablehttp://www gartne.com /it-glossary/business-intelligence-bi | • , “Cloud computing fundamentals”2010 by Furht,
In Handbook of cloud computing (pp. 3-19). Springer US | • J. Dibber, T.Goels, R.Hirschheim,and B.jayatilaka,”information System outsouring.A survey and analysis of the Literature
2004. | • “Business intelligence (BI)”,http://www.gartner.com/it-glossary /business-intelligence-bi/, Requested in January 2014. | • Patrick Baesel and Bob Croker, 2010, “Business
Intelligence as a Shared Service”, Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A | • Mcmurphy , Neil survey of business intelligence
purchase Drivers show need for new approach to business intelligence, July 2008 | • M. Golfarelli, S. Rizzi, and I. Cella, 2004, “Beyond datawarehousing: What’s next in business intel-
ligence?” In Proc. DOLAP, pages 1–6 | • John Lloyd, 2011, “Identifying Key Components of Business Intelligence Systems and Their Role in Managerial Decision making”, Master of
Science, University of Oregon Applied Information Management Program. | • Maciej Pondel, 2013, “Business Intelligence as a service in a cloud environment”, Proceedings of the
2013 Federated Conference on Computer Science and Information Systems pp. 1269–1271 | • “Data war ehouse”,http://en.wikipedia.org/wiki/Data_warehouse , Requested in Janu-
ary 2014 | • “What is OLAP (Online Analytical Processing)?”http://www.techterms.com/de finition/olap, Requested in January 2014 | • “Data Visualization”,http://www.sas.com/
en_us/insights/big-data/data- visualization.html, Requested in January 2014 | • Christina Tamer, Mary Kiley, Noushin Ashrafi & Jean- Pierre Kuilboer, “Risk and Benefits of Business
Intelligence in the Cloud”, University of Massachusetts Boston, Management Science and Information Systems Department, 100 Morrissey Blvd, Boston, MA, 02125 United States of
America. | • Sonam Chawla, 2011, “Design and Development of Business Intelligence Portal in Cloud Computing”, Master of Engineering in Software Engineering, Computer Science
and Engineering Department, Thapar University. | • IPRO Cloud computing what is it, and what you need to know Megan Wilcox , May 2009,http://wwww.iprotech.com/Downlods/
File/Conference /May 2009,/cloud computing What _it _pd f | • Carl Brooks, 2009, “Cloud BI from RightScale and Jaspersoft is priced for penny pinchers but lacks polish”, Requested
in January 2014. | • “What is Data Visualization”,http://www.slideshare.net/QueryIO/hadoop-big-data visualization, Requested in January 2014 | • Bharat Chandra and meena
lyer, BI in the cloud-defing Architecture for quick wins available |http://www.infosys.com/infosys-labs/publication/document/BI-in -a-cloud.pdf |
11. CONCLUSION
Cloud is a the most important fact about future Business Intel-
ligence And ofer several advantages in term of cost benefts fex-
ibility of Implementation , availability and speed of implementa-
tion BI on the cloud ofer huge possibilities for removing barriers
to decision making By integrating high volume and mission criti-
cal business processes Terefore, a cloud business intelligence
solution may be a feasible A solution to a problem on the most
greatest challenges faced economic Crisis by such a solution, the
economic organization may be large and Middle sized or small
use as place a favorable that under regular conditions Other then
adopting BI or cloud business intelligence would not accessible
Irrespective of the age of BI landscape the could model can drive
increased business intelligence adopting, improved end-user ex-
perience better Access to analytics reduced IT dependence. We
adopt cloud BI there are many benefts of Cloud BI, but there
are some challenges that still need alternative research to Public
cloud and some security and assessing Privacy in business intel-
ligence as all services and data reside on the cloud without inter-
net data can not access important to fnd legal ways to infuence
these hazard and to fnd quick and safe ways for data transfer via
the internet.
doc_468203646.pdf