What is the difference between the Smart Data Access of SAP HANA and SAP HANA Vora?

0 votes
Which one is the better way to analyse  hot (SAP HANA) and cold(Hadoop) data in one analysis, written by SAP HANA tools? Needed some explanation.
Jun 21, 2018 in Big Data Hadoop by shelly
• 120 points

recategorized Jul 3, 2018 by Sudhir 92 views

2 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
SAP HANA and Hadoop are two different things. SAP HANA is an ANSI SQL database.  It maintains ACID constraints, and therefore is good for transactional & analytical applications. It is high performing database which is good for transactional applications. You can also go ahead and execute complex queries over this high performing database.

Hadoop is a framework that allows you to store large datasets in a distributed environment, so that, you can process it parallely. The power of Hadoop lies in storing data that can be of different varieties, i.e. structured, semi-structured & un-structured data. But Hadoop is not suited for transactional applications.

Talking about SAP HANA VORA, it is in-memory query engine which extends Apache Spark execution framework to provide interactive analytics on Hadoop. It provides in-memory processing on top of Hadoop and enterprise functionality to simplify the IT landscape for organisations.

To summarize I would say, HANA is an in-memory database which focuses on performance, while Hadoop’s power lies in reducing the storage cost. SAP HANA can be used for transactional purposes & Hadoop can used for storing unstructured data in an efficient manner.
answered Jun 21, 2018 by coldcode
• 2,010 points
0 votes

Hadoop: Used to store Big Data in a distributed manner for processing in multiple systems and therefore provides a fault-tolerant way of storage and processing by replication.
Spark: Provides In-Memory computations and real-time streaming framework.
SAP HANA VORA: Best of both worlds in an easy to use bundle. It is an in-memory query engine that plugs into the Apache Spark execution framework to provide enriched interactive analytics on Hadoop. SAP HANA Vora builds structured data hierarchies for the Hadoop data and integrates it with data from HANA to enable OLAP-style in-memory analysis on the combined data through an Apache Spark structured query language (SQL) interface. HANA Vora uses HANA’s in-memory database, which can perform real-time processing, and then adds an analytic layer to handle Hadoop data. This allows Vora to take the huge amounts of data stored in Hadoop and integrate it with data from enterprise systems so that developers and data analysts have instant access to the aggregated data and can make contextually-aware decisions.

Hope this helps.

answered Jun 21, 2018 by kurt_cobain
• 9,260 points

Related Questions In Big Data Hadoop

0 votes
1 answer

What is the difference between a Big Data Warehouse and a traditional Data Warehouse?

Hadoop is similar in architecture to MPP data ...READ MORE

answered Aug 9, 2018 in Big Data Hadoop by Frankie
• 9,710 points
52 views
0 votes
1 answer

What is the difference between a Big Data Warehouse and a traditional Data Warehouse

Hadoop is similar in architecture to MPP data ...READ MORE

answered Aug 9, 2018 in Big Data Hadoop by Frankie
• 9,710 points
28 views
0 votes
1 answer

What is the difference between Big Data and Data Mining?

Big data and data mining are two ...READ MORE

answered Aug 23, 2018 in Big Data Hadoop by Frankie
• 9,710 points
22 views
0 votes
10 answers

What is the difference between Mongodb and Hadoop?

Apart from the similarity that they are ...READ MORE

answered Dec 6, 2018 in Big Data Hadoop by Deeraj
1,993 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 9,450 points
1,843 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
9,133 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
656 views
0 votes
1 answer
0 votes
1 answer

What are the advantages & disadvantages of Hadoop Dockerization?

As you are already having a Hadoop ...READ MORE

answered Apr 18, 2018 in Big Data Hadoop by coldcode
• 2,010 points
232 views
0 votes
1 answer

What are the different ways to load data from Hadoop to Azure Data Lake?

I would recommend you to go through ...READ MORE

answered Apr 18, 2018 in Big Data Hadoop by coldcode
• 2,010 points
53 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.