Welcome!

@CloudExpo Authors: Liz McMillan, Yeshim Deniz, Elizabeth White, Zakia Bouachraoui, Pat Romanski

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
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buyers learn their thoughts on their experience.
In this presentation, you will learn first hand what works and what doesn't while architecting and deploying OpenStack. Some of the topics will include:- best practices for creating repeatable deployments of OpenStack- multi-site considerations- how to customize OpenStack to integrate with your existing systems and security best practices.
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at Dice, he takes a metrics-driven approach to management. His experience in building and managing high performance teams was built throughout his experience at Oracle, Sun Microsystems and SocialEkwity.
Transformation Abstract Encryption and privacy in the cloud is a daunting yet essential task for both security practitioners and application developers, especially as applications continue moving to the cloud at an exponential rate. What are some best practices and processes for enterprises to follow that balance both security and ease of use requirements? What technologies are available to empower enterprises with code, data and key protection from cloud providers, system administrators, insiders, government compulsion, and network hackers? Join Ambuj Kumar (CEO, Fortanix) to discuss best practices and technologies for enterprises to securely transition to a multi-cloud hybrid world.
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is foundational - something customers routinely cite as a top pain point. In his session at @DevOpsSummit at 21st Cloud Expo, Bill Borsari, Head of Systems Engineering at Datera, explored how organizations can reap the benefits of the cloud without losing performance as containers become the new paradigm.