Welcome!

@CloudExpo Authors: Kevin Benedict, Elizabeth White, William Schmarzo, Lisa Calkins, Mamoon Yunus

Related Topics: @CloudExpo, Microservices Expo, Containers Expo Blog

@CloudExpo: Article

Cloud Computing: Triumph of Analytical Databases

Impressive benchmarks from analytic databases

Analytical Databases: In my last article about Cloud Analytics, we analyzed the various offering on Cloud Analytics. We also noted that some of the Cloud Analytical implementations are based on pure Relational Database extensions and others are built on an unstructured non-relational model or semi-relational model.

While the non-relational databases have existed for a while, their presence in the industry standard benchmarks are limited, and as a result they are not a candidate for enterprise class analytical solutions. However, with the support of various vendors their presence in industry standard benchmark situations are increasing.

Differences of Analytical Databases with Traditional RDBMS Databases
Column Based-Architecture:
Traditional RDBMS stores their data with respect to rows, whereas column-oriented analytical databases stores their content by column. The traditional RDBMS implementation - including Oracle - is to store all data for a given row in the same block. This might be might be optimal for OLTP operations - create an entry, query an entry, change an entry - but is not optimal for many data warehousing and BI query scenarios.

Shared Nothing Architecture: We have been seeing in general and in particular to Cloud, the best scalability and multi-tenancy is achieved when the databases are architected using ‘Shared Nothing' pattern, while some Relational database have implemented ‘Shared Nothing' as a variant (like DB2 Data Partition), most like Oracle RAC have implemented the Shared Everything architecture. New analytical databases all have implemented the Shared Nothing Architecture for unlimited scalability.

In-Memory Processing: Typical analytical databases use in-memory technology that enables maximum data throughput for high performance in accessing data. During read access, the data is processed completely in RAM, eliminating slow access to hard disks. Traditional  Relational Databases while uses the buffer memory still heavily depends on the DISK I/O.

Some of the popular Analytical Databases with the above mentioned properties are :

EXASOL EXASolution is ahigh-performance relational database for time-critical complex analyses, planning and reporting.

The Vertica Analytic Database is the first RDBMS designed specifically for on-demand, infinitely scalable Business Intelligence in virtualized and cloud environments. Optimized for MPP grids.

ParAccel Analytic Database (PADB), the world's fastest, best price/performance platform for empowering data-driven businesses. ParAccel enables organizations to tackle the most complex analytic challenges and glean ultra-fast deep insights from vast volumes of data.

Industry Benchmarks Favor Analytical Databases Over Traditional RDBMS
Cloud platform along with its side benefits like Grid computing have opened the way for unlimited scalability for Analytical applications which were at constraint in traditional data centers. With the massively parallel processing and scalability at stake, the new breed of analytical databases tend to take the advantage in the Cloud Analytics market.

The TPC BenchmarkH (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.

A recent analysis of the TPC-H benchmark show a clear lead for the Analytical Database EXASOL EXASolution over the traditional RDBMS. The results are shown below and can be seen from the TPC site too.

Database Size Category

Leader In Performance

Nearest Traditional Relational Database

Performance Improvement

100 GB

EXASOL  EXASolution  4.0

MS SQL 2008 R2

15X

300 GB

EXASOL  EXASolution  4.0

MS SQL 2008 R2

18X

1000 GB

EXASOL  EXASolution  4.0

Oracle 11g R2

3.5 X

3000 GB

EXASOL  EXASolution  4.0

Oracle 11g R2

14X

10000 GB

EXASOL  EXASolution  4.0

IBM DB2 9.5

21X

 

The results indeed  show a great  success  for Analytical databases in  DSS and OLAP systems over traditional databases.  We also find the   next top spots are taken up by other analytical databases like ParAccel much higher than other traditional relational databases.

Summary
Benchmarks are there to be broken in future by other vendors, the point is Cloud Platform is  not just a enabler for low cost provisioning of hardware but the High Performance Computing and Grid Computing opens up several possibilities of Advanced Analytics and the associated massive scalability will help the enterprises. Also  we are seeing new possibilities in terms of supporting  platforms. Analytical databases like EXASOL, Vertica, ParAccel  have provided new avenues for enterprises to move Analytics to Cloud.

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

@CloudExpo Stories
While some vendors scramble to create and sell you a fancy solution for monitoring your spanking new Amazon Lambdas, hear how you can do it on the cheap using just built-in Java APIs yourself. By exploiting a little-known fact that Lambdas aren’t exactly single-threaded, you can effectively identify hot spots in your serverless code. In his session at @DevOpsSummit at 21st Cloud Expo, Dave Martin, Product owner at CA Technologies, will give a live demonstration and code walkthrough, showing how ...
WebRTC is great technology to build your own communication tools. It will be even more exciting experience it with advanced devices, such as a 360 Camera, 360 microphone, and a depth sensor camera. In his session at @ThingsExpo, Masashi Ganeko, a manager at INFOCOM Corporation, will introduce two experimental projects from his team and what they learned from them. "Shotoku Tamago" uses the robot audition software HARK to track speakers in 360 video of a remote party. "Virtual Teleport" uses a...
Translating agile methodology into real-world best practices within the modern software factory has driven widespread DevOps adoption, yet much work remains to expand workflows and tooling across the enterprise. As models evolve from pockets of experimentation into wholescale organizational reinvention, practitioners find themselves challenged to incorporate the culture and architecture necessary to support DevOps at scale.
When shopping for a new data processing platform for IoT solutions, many development teams want to be able to test-drive options before making a choice. Yet when evaluating an IoT solution, it’s simply not feasible to do so at scale with physical devices. Building a sensor simulator is the next best choice; however, generating a realistic simulation at very high TPS with ease of configurability is a formidable challenge. When dealing with multiple application or transport protocols, you would be...
SYS-CON Events announced today that CA Technologies has been named “Platinum Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business – from apparel to energy – is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
SYS-CON Events announced today that CAST Software will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CAST was founded more than 25 years ago to make the invisible visible. Built around the idea that even the best analytics on the market still leave blind spots for technical teams looking to deliver better software and prevent outages, CAST provides the software intelligence that matter ...
As more and more companies are making the shift from on-premises to public cloud, the standard approach to DevOps is evolving. From encryption, compliance and regulations like GDPR, security in the cloud has become a hot topic. Many DevOps-focused companies have hired dedicated staff to fulfill these requirements, often creating further siloes, complexity and cost. This session aims to highlight existing DevOps cultural approaches, tooling and how security can be wrapped in every facet of the bu...
yperConvergence came to market with the objective of being simple, flexible and to help drive down operating expenses. It reduced the footprint by bundling the compute/storage/network into one box. This brought a new set of challenges as the HyperConverged vendors are very focused on their own proprietary building blocks. If you want to scale in a certain way, let’s say you identified a need for more storage and want to add a device that is not sold by the HyperConverged vendor, forget about it....
SYS-CON Events announced today that Pulzze Systems will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Pulzze Systems Inc, provides the software product "The Interactor" that uniquely simplifies building IoT, Web and Smart Enterprise Solutions. It is a Silicon Valley startup funded by US government agencies, NSF and DHS to bring innovative solutions to market.
With Cloud Foundry you can easily deploy and use apps utilizing websocket technology, but not everybody realizes that scaling them out is not that trivial. In his session at 21st Cloud Expo, Roman Swoszowski, CTO and VP, Cloud Foundry Services, at Grape Up, will show you an example of how to deal with this issue. He will demonstrate a cloud-native Spring Boot app running in Cloud Foundry and communicating with clients over websocket protocol that can be easily scaled horizontally and coordinate...
SYS-CON Events announced today that Elastifile will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Elastifile Cloud File System (ECFS) is software-defined data infrastructure designed for seamless and efficient management of dynamic workloads across heterogeneous environments. Elastifile provides the architecture needed to optimize your hybrid cloud environment, by facilitating efficient...
For financial firms, the cloud is going to increasingly become a crucial part of dealing with customers over the next five years and beyond, particularly with the growing use and acceptance of virtual currencies. There are new data storage paradigms on the horizon that will deliver secure solutions for storing and moving sensitive financial data around the world without touching terrestrial networks. In his session at 20th Cloud Expo, Cliff Beek, President of Cloud Constellation Corporation, d...
Businesses and business units of all sizes can benefit from cloud computing, but many don't want the cost, performance and security concerns of public cloud nor the complexity of building their own private clouds. Today, some cloud vendors are using artificial intelligence (AI) to simplify cloud deployment and management. In his session at 20th Cloud Expo, Ajay Gulati, Co-founder and CEO of ZeroStack, discussed how AI can simplify cloud operations. He covered the following topics: why cloud mana...
DevOps at Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to w...
SYS-CON Events announced today that Golden Gate University will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Since 1901, non-profit Golden Gate University (GGU) has been helping adults achieve their professional goals by providing high quality, practice-based undergraduate and graduate educational programs in law, taxation, business and related professions. Many of its courses are taug...
Recently, WebRTC has a lot of eyes from market. The use cases of WebRTC are expanding - video chat, online education, online health care etc. Not only for human-to-human communication, but also IoT use cases such as machine to human use cases can be seen recently. One of the typical use-case is remote camera monitoring. With WebRTC, people can have interoperability and flexibility for deploying monitoring service. However, the benefit of WebRTC for IoT is not only its convenience and interopera...
Vulnerability management is vital for large companies that need to secure containers across thousands of hosts, but many struggle to understand how exposed they are when they discover a new high security vulnerability. In his session at 21st Cloud Expo, John Morello, CTO of Twistlock, will address this pressing concern by introducing the concept of the “Vulnerability Risk Tree API,” which brings all the data together in a simple REST endpoint, allowing companies to easily grasp the severity of t...
When shopping for a new data processing platform for IoT solutions, many development teams want to be able to test-drive options before making a choice. Yet when evaluating an IoT solution, it’s simply not feasible to do so at scale with physical devices. Building a sensor simulator is the next best choice; however, generating a realistic simulation at very high TPS with ease of configurability is a formidable challenge. When dealing with multiple application or transport protocols, you would be...
In his session at 20th Cloud Expo, Scott Davis, CTO of Embotics, discussed how automation can provide the dynamic management required to cost-effectively deliver microservices and container solutions at scale. He also discussed how flexible automation is the key to effectively bridging and seamlessly coordinating both IT and developer needs for component orchestration across disparate clouds – an increasingly important requirement at today’s multi-cloud enterprise.
WebRTC is the future of browser-to-browser communications, and continues to make inroads into the traditional, difficult, plug-in web communications world. The 6th WebRTC Summit continues our tradition of delivering the latest and greatest presentations within the world of WebRTC. Topics include voice calling, video chat, P2P file sharing, and use cases that have already leveraged the power and convenience of WebRTC.