Welcome!

Government Cloud Authors: Elizabeth White, Pat Romanski, Dana Gardner, Liz McMillan, Gopala Krishna Behara

Related Topics: @CloudExpo

@CloudExpo: Article

PaaS: Is OLAP a Candidate for Cloud

When CUBES Meet CLOUDS

Ever Since E.F. Codd  Coined the term  OLAP (Online Analytical Processing) it has gained high popularity in enterprise computing, in simple terms  OLAP  is  synonymous  with concepts, tools that make Data Ware House data easily accessible.

OLAP enables analysts, managers, and executives gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information.  They also answer the Who ? and What ? and What if ? questions on the data.

The key attributes of the OLAP are

  • Multidimensional views of data
  • Calculation intensive capabilities
  • Time Intelligence

The multi dimensional nature of  OLAP requires an analytical engine to process the underlying data and create a multi dimensional view and  the success of OLAP has resulted in a large  number of vendors  offering OLAP servers using different architectures.

MLOAP : A Proprietary multidimensional database with the  aim on performance.

ROLAP : Relational OLAP is a technology that provides sophisticated multidimensional analysis that is performed on open relational databases.  ROLAP can scale to  large data sets in the terabytes of  range.

HOLAP : Hybrid OLAP is an attempt to combine some of the features of MOLAP and ROLAP technology.

Is There a COLAP  (Cloud OLAP) ?

Most business cases for CLOUD is about,  dynamic infrastructure, multi tenancy, elasticity and other attributes that target  reducing  cost of computing by reduced capital expenditure and operational expenditure.

While OLAP  on the other hand is viewed  for the needs on processing large amounts of data (usually in TERRA BYTES ) in a  most efficient manner from time perspective, and performance is a key distinction here.

So how do they both  meet and  a OLAP application is indeed a good candidate for Cloud. In other words can a OLAP Server  be hosted on Cloud Platform, either by a SaaS Provider or through a PaaS.

In OLAP a CUBE is a logical construct. It allows a client application to retrieve values as if every possible summarized value existed in the cube.  Like a fact table,  a cube contains one columns for each dimension and one column for each measure.

An example of a CUBE in a OLAP Server that stores  Sales information is visualized here.

Important considerations for a efficient OLAP Server are :

  • Storage Optimization : How efficiently the map, detail, aggregate components of a CUBE are stored
  • Processing Optimization: How efficiently a Server processes a CUBE with respect to changing dimensions and fact.
  • CUBE Drilling Optimization: How efficiently the CUBE information can be queried by multiple clients.

Let us see whether a CLOUD architecture is fit for OLAP implementation.

Remember A CLOUD Is a GRID Too !!
Grid computing is a type of parallel and distributed  system that enables the sharing, selection, and aggregation of geographically distributed "autonomous" resources  dynamically at run time depending on the work load  and availability requirements.

Cloud computing evolves from grid computing and provides on-demand resource provisioning. Grid computing may or may not be in the cloud depending on what type of users are using it.

In other words, we could implement Grid Computing  in a cloud computing environment and it is a valid generalization to say  that "every cloud is a grid".

Grid Computing  Attribute of CLOUD In Processing OLAP CUBES
With appropriate support from  Clod Computing Platform and with work load management, a Cloud platform can be effectively  use it's  incarnation as a Grid to effectively process the OLAP CUBES and other  CPU intensive Analytical processing  steps to be positioned as a effective OLAP Platform.

These concepts are new,  leading OLAP enabled databases  like DB2  have long been utilizing features like

  • Inter-Partition Parallelism , which is each Virtual Machine retrieve and process the requested rows they own in parallel
  • Intra-Partition Parallelism , where by within a Virtual machine depending on the CPU availability certain operations can be parallelized further.

So if properly configured if there are N Virtual Server s are configured for this Service and each virtual server can perform M degrees of Parallelism at the end of the Cloud Platform could perform the Analytical operations with N X M parallel tasks and the other tenants of Cloud like VM Migration and work load migration all play towards a efficient and successful OLAP platform.

As Evident, Cloud Platform is very effective for OLAP Servers too provided the implementation support the GRID qualities of CLOUD in effectively utilizing the multiple physical and virtual servers of CLOUD to achieve the goal.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

IoT & Smart Cities Stories
In this Women in Technology Power Panel at 15th Cloud Expo, moderated by Anne Plese, Senior Consultant, Cloud Product Marketing at Verizon Enterprise, Esmeralda Swartz, CMO at MetraTech; Evelyn de Souza, Data Privacy and Compliance Strategy Leader at Cisco Systems; Seema Jethani, Director of Product Management at Basho Technologies; Victoria Livschitz, CEO of Qubell Inc.; Anne Hungate, Senior Director of Software Quality at DIRECTV, discussed what path they took to find their spot within the tec...
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Discussions of cloud computing have evolved in recent years from a focus on specific types of cloud, to a world of hybrid cloud, and to a world dominated by the APIs that make today's multi-cloud environments and hybrid clouds possible. In this Power Panel at 17th Cloud Expo, moderated by Conference Chair Roger Strukhoff, panelists addressed the importance of customers being able to use the specific technologies they need, through environments and ecosystems that expose their APIs to make true ...
"Space Monkey by Vivent Smart Home is a product that is a distributed cloud-based edge storage network. Vivent Smart Home, our parent company, is a smart home provider that places a lot of hard drives across homes in North America," explained JT Olds, Director of Engineering, and Brandon Crowfeather, Product Manager, at Vivint Smart Home, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use of real time applications accelerate, legacy networks are no longer able to architecturally support cloud adoption and deliver the performance and security required by highly distributed enterprises. These outdated solutions have become more costly and complicated to implement, install, manage, and maintain.SD-WAN offers unlimited capabilities for accessing the benefits of the cloud and Internet. ...
In an era of historic innovation fueled by unprecedented access to data and technology, the low cost and risk of entering new markets has leveled the playing field for business. Today, any ambitious innovator can easily introduce a new application or product that can reinvent business models and transform the client experience. In their Day 2 Keynote at 19th Cloud Expo, Mercer Rowe, IBM Vice President of Strategic Alliances, and Raejeanne Skillern, Intel Vice President of Data Center Group and G...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...