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 4, 2018 by Sudhir 1,091 views

2 answers to this question.

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,080 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,390 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 10, 2018 in Big Data Hadoop by Frankie
• 9,830 points
1,142 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 10, 2018 in Big Data Hadoop by Frankie
• 9,830 points
493 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,830 points
578 views
0 votes
10 answers

What is the difference between Mongodb and Hadoop?

MongoDB is a NoSQL database, whereas Hadoop is ...READ MORE

answered Jun 20, 2018 in Big Data Hadoop by jenny_code
11,266 views
+1 vote
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
• 11,380 points
10,522 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
103,816 views
–1 vote
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,390 points
4,234 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,080 points
1,347 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,080 points
889 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP