SAP HANA from Space Level

SAP HANA Overview
Share on Facebook196Share on LinkedIn255Tweet about this on TwitterShare on Google+0
Please Share!!

HANA the “Hot cake” of the market. I have been hearing about HANA since the beginning of this decade or even earlier. Initially I thought it was just a new database, so why the fuss? My crooked mind used to say: may be SAP does not want to share the market revenue with any other database provider (competitors); therefore they came up with their own database. Pat SAP for Smart Business Acumen. 🙂

Later I had a notion that HANA is only for BI/BW folks, so being an ABAPer – why should I care? Everyone used to talk about analysis and modelling. So, I used to think, let the BI/BW modelers worry about HANA.

Then the rumour started in market; ABAP and ABAPer are going to be extinct in near future. I used to wonder, if ABAPer are going to die, then who in this whole universe would support those tons and tons of ABAP code written in the history of SAP Implementations? What will happen to all those time, effort and money spent in those large and small scales SAP Implementations? What a waste of rumour!!

I have spent more time in researching what is HANA than actually learning what HANA is. Internet is full of information regarding HANA but finding the right answers for your curiosity or doubt, is an uphill task.

I had some silly questions for HANA but felt a little embarrassed to ask the experts. I spent and wasted lots of time trying to figure out what is HANA and who needs it and why?

Some of the questions which I had and I am sure all novice in HANA would have the same are below:
Q. Is SQL a pre-requisite to learn HANA?
Q. Without SAP BI/BW/BO knowledge, can I learn HANA?
Q. Is SAP ABAP skilled required to learn HANA?
Q. Is HANA for functional folk or technical folks or modelers?

Also Read: SAP HANA at Ground Zero

Please find answers to these SAP HANA doubts from a beginner in HANA to another beginner in HANA. They might not be very technical or in-depth, but it would definitely be enough for a beginner and I am sure the new comers would appreciate these selective information.

Q. Is SQL a pre-requisite to learn HANA? (Being an ABAPer, this was one of the most feared question for me)
Ans: No.
SAP HANA is like any other relational database. Having Database Concepts and basic knowledge of SQL before starting SAP HANA is an advantage, but it is not a pre-requisite. You can always catch up with these concepts while learning SAP HANA.

Q. Without SAP BI/BW/BO knowledge, can I learn HANA? (I am sure all ABAPers have this question)
Ans: Yes.
BI is the Data Warehousing package implementation tool from SAP. Data Warehousing Concepts in SAP BI will help understand the implementation aspects from BW on HANA perspective. But unless you plan to a BW on HANA consultant, you necessarily do not have to learn BI.

Similarly BW and BO are Business Warehouse and Business Object respectively. If you have prior BW experience, understanding modeling concept and transferring data SAP Business Suite System to HANA would be child’s play for you. But, we can easily learn HANA modeling concept even if we do not have current exposure to BW. But it would be a must for those consultants who are eyeing the role of BW on HANA expert.

By now, I have understood that BO is a front end reporting tool. Prior knowledge in reporting tools would be an advantage but, we can always learn BO concepts while learning HANA.

But, if you already have BI/BW/BO knowledge, then BW on HANA work would be the role you would be targeting to (if you are planning to shift to HANA).

Q. Is SAP ABAP skilled required to learn HANA?
Ans: No.
Whatever we said above for BI/BW/BO is applicable to ABAP as well.

If you are an SAP ABAP programmer, then implementing the business logic and model would be fun for you. You must have already heard about SAP ABAP on HANA. Let’s put a full stop to the rumour that ABAPer are vanishing. With HANA, ABAPer would be smarter and more in demand. Only ABAP on HANA consultant would need ABAP knowledge as pre-requisite.

Also Read: Create your first program in SAP HANA Studio (ABAP on SAP HANA Part I).

Q. Is HANA for functional folk or technical folks or modelers?
Ans: All.

Like any other technology, HANA also has segregation of duty, therefore the answer to this question is ‘ALL’. Some of the HANA job roles are as below:
i) HANA Admin and Security
Our current SAP Basis/Security/GRC guys would be the nearest cousins of HANA Admin and Security folks.

ii) HANA Data Replicator
Like in normal SAP Implementation project we have Conversion and Interface team and experts, the HANA Data Replication role would be similar to that. SAP BI/BO guys are the closest. They will use jargons like SLT, BODS, DXC etc.
SLT = SAP Landscape Transformation
BODS = Business Objects Data Services
DXC = Direct eXtractor Connection

iii) HANA Modeler
SAP BW gurus are already modeling, so will SAP HANA Modelers.

iv) HANA Application Developer
HANA XS or ABAP on HANA Developers.

Also Read: ‘ABAP for SAP HANA’, points to remember.

Further, I had some other curious questions, a little more technical like:

Q. HANA means in-memory. In-memory means RAM. We all know, RAM is volatile temporary memory. Does it mean all data would be lost when power goes down, or there is reboot etc i.e. if there is a hard or soft failure?
Ans: No. SAP must have thought this even before they started the development. 🙂 (I cannot be smarter than SAP)
Data is stored in RAM, that is right. But on power failure for any reason, data is not lost. Here comes the concept of Persistent Storage.

SAP HANA Persistent Layer

Data saved in HANA
Transaction data is updated to Log Volume on every commit. Data is saved to Data Volume every 300 sec or as configured. These create savepoints.

SAP HANA Recovery
In case of reboot or power start up, system can be taken back to last consistent save point and then replay the Log Volume committed data.

Q. SAP HANA claims to be so fast. Which programming language is it written in?
Ans: World famous C++. 🙂

Q. What is the Operating System of SAP HANA?
Ans: Suse Linux Server SPX & Red Hat linux Server 6.5

Q. Another question which I always had was, if HANA is about RAM, so can we increase the memory size of traditional database and get similar performance like HANA?
Ans: No.
We would definitely get better performance if we increase the memory size of traditional database, but it would not be comparable to what we get in HANA. But Why?

Because, HANA is not just about database. It is a hybrid in-memory database which is combination of niche Hardware and Software innovation as stated below:

Why SAP HANA is fast

In-Memory storage (RAM): Processing data from RAM itself is 1 million time faster than accessing data from hard disk. In practical scenarios, it might is around 10x to 3600x time faster. Also, in today’s world RAM is cheap and affordable expense wise.

Trivia: Read time in RAM: 2 MB/ms/core (2 megabyte per millisecond per core).

So to scan 1 GB of data, it would approximately take 0.5 s/core. For 100 GB it would take 50 s/core. If you have 50 cores in the hardware, scanning 100 GB data would take just 1 second. Huh!! Quantitative numbers always clarifies better than paragraphs of sentences. Isn’t it?

Multi core Architecture, Partitioning & Enormous Parallel Processing: Servers are available with one node up to 64 cores (and even more). So partitioning the data foot prints in different node and running the query parallel is the innovation which HANA uses so effectively. This is perfect example of both hardware and software innovation.

Columnar Storage: Contiguous memory allocation
Faster reading with sequential memory access. Remember, column store not only makes reading faster. HANA has built the column store is such a way that it is efficient for both READ and WRITE.

Quick aggregation (normally aggregation are expensive) and also supports parallel processing.

Searching in column store is must faster than row storage (provided you are selecting only some sets of columns, not all).

Data Compression: Minimize data footprint through Compression i.e. less data movement means faster performance.
Idea is remove repetitive data, build a vector for the data and point it with an integer (and integer is less expensive than reading a string).

Also Read : ‘View the HANA Views from different angles’

Q. Ok heard enough of Column Store in HANA. But, how does Column Storage actually make it faster?
Ans: Column store is divided into three parts: i) Main ii) L2 Delta iii) L1 Delta/cache
Persisted data are saved in Main Memory, all buffer and transaction changes are kept in L2 Delta and High Inserts / Deletes / Updates etc in L1 Delta

HANA Optimization

L1-delta
– accepts all incoming data requests
– stores records in row format (write-optimized)
• fast insert and delete
• fast field update
• fast record projection
– no data compression
– holds 10,000 to 100,000 rows per single-node

SAP HANA Column storage innovation

L2-delta
– the second stage of the record life cycle
– stores records in column format
– dictionary encoding for better memory usage
– unsorted dictionary
• requiring secondary index structures to optimally
support point query access patterns
– well suited to store up to 10 million rows

L1, L2, Main Memory

Main
– final data format
– stores records in column format
– highest compression rate
• sorted dictionary
• positions in dictionary stored in a bit-packed manner
• the dictionary is also compressed

So the smart innovation of L1, L2 and Main memory and combination of all three, make data read and write, really fast and effective.

These are some of the obvious questions, which almost all beginners in SAP HANA have. I had to dig through different sources to collect and understand these concepts. Hope all these information at one place would help you to understand it better.

Updates from Readers

Some of our readers have added some interesting points to this articles. Please find them below.

From Lars Odegaard (Business Suite on HANA Project Manager at Cardinal Health)

“Couple of points to add — HANA is Sybase RDBS re-tooled with in-memory columnar architecture, plus added memory blades and storage (to keep it simple). HANA only runs on SAP-certified hardware, which are referred to as an “appliance“. This makes for a powerful self-contained data server.

Second, to build on the super-fast data access architecture, hardware suppliers such as IBM and HP (and others) are boosting their appliances with the newest technology that will further speed up data processes, such as Haswell processors, memory build-ups, etc.

All this together makes for a revolutionary impact to the speed of doing business, and companies have come to learn that business process re-engineering is a natural follow-up after deploying HANA. That’s why the world is excited about this!”

Please stay tuned for more on HANA. In the next post, I would show you how you can get free access to SAP HANA Cloud Platform. Yes, it is free!! I have already logged into it and making my hands dirty on it. I am playing it using Eclipse Studio. I will show in details how you can easily set it up.

If you want to get practical issues and resolutions straight to your inbox, please SUBSCRIBE. We respect your privacy and take protecting it seriously.

If you liked this post, please hit the share buttons at the left side of your screen.

Thank you very much for your time!!

 

Series on SAP HANA

1. SAP HANA from Space Level

2. SAP HANA at Ground Zero

3. View the HANA Views from different angles

4. ‘ABAP for SAP HANA’ Points to remember

5. SAP HANA ; S/4 HANA and S/4 HANA Finance in Nutshell

6. Smart Data Integrator & Data Load In SAP HANA

7. ABAP on SAP HANA. Part I

You might like to check the Popular and Effective Tutorials in SAPYard

1. ABAP for SAP HANA Tutorials
2. ABAP Web Dynpro Tutorials
3. SAP Adobe Forms Tutorials
3. GOS Tutorials
4. OOPs ABAP Tutorials
5. HANA Tutorials

 

 

Image source : www.nasa.gov (modified)

Share on Facebook196Share on LinkedIn255Tweet about this on TwitterShare on Google+0
Please Share!!

About the Author

SAP Yard
SAP Yard

SAPYard is one stop page for all Technical Folks in SAP. You would find un-conventional explanations, tutorials, and tricks.

Please like our Facebook Page and also join our LinkedIn Group.

55 Comments on "SAP HANA from Space Level"

  1. good

  2. Very useful post Thank you for sharing your knowledge.

  3. I have read so many posts but couldn’t find a post like yours ! Amazingly written. Even a layman can understand this 🙂

    • Dear Namrata – Thank you so much for your feedback. Team SAPYard always try to explain stuffs differently so that anyone who visits the article would appreciate and understand it. We are glad and feel really happy that you liked our way of explanation and presentation.

      Regards,
      Team SAPYard.

  4. All credit will go to you once I become HANA developer (soon) …

    Very informative post . Keep it up !!

  5. Bernard Van Maele | March 3, 2016 at 7:05 am | Reply

    Thanks. That was everything I already wanted to know but didn’t dare to ask being afraid making a fool of myself. Although everybody says there is not such a thing as a stupid question, I am glad somebody explained without having to ask anything.

    • Dear Bernard – Glad that our post was able to clarify some of your questions. I had the same feeling like yours and was little afraid to ask.

      Therefore, we came up with this write up. Happy that it helped you.

      Cheers!!
      Team SAPYard.

  6. Awesome post and appreciate your time for educating us.

  7. nice info-guys feels like i am on clouds.

  8. Very well explained!! Easy to understand for any beginner..

  9. Srinivas Mullapudi | October 10, 2015 at 6:46 pm | Reply

    Dear Raju,
    Could you suggest HANA course suitable for SAP PP,PM,QM consultant with 8 years experience.
    Best regards, Srinivas Mullapudi

    • Hi Srinivas – I would not be the right person to suggest, but heard from MM folks, Simple Logistics on S4HANA could be your area.

      All the best.

      Regards,
      Raju.

  10. Srinivas Mullapudi | October 10, 2015 at 6:40 pm | Reply

    This is an excellent explanation about HANA, I was wondering, what is HANA all these days; thank you very much I got idea about HANA after going through your article.

    • Dear Srinivas – Thank you so much for your feedback. So happy to learn that you got some clarification on HANA. This post is fruitful, if it helped you to gain some knowledge (even if it is high level).

      Appreciate your stopping by and writing these lines.

      Regards,
      Raju.

  11. Thanks Raju,
    nice Blog…..keep it up!

    Regards,
    Satish.

  12. Hi

    Thanks for sharing the valuable information.I got 3 years of experience in MM.I would like to learn Hana, which Hana course is suitable for functional people like me.

    Kindly suggest.

    Regards
    Subbu

    • Dear Subbu – Thank you for stopping by and leaving your question. Try to explore S4HANA. SLogistic would be in line with your current experience.

      All the best.

      Regards,
      Raju.

  13. Swadini Sujanaranjan | September 28, 2015 at 6:23 am | Reply

    Its really really informative and interesting !!! Thank you 🙂

    • Thank you Swadini for stopping by and providing your feedback. We are happy that you found it interesting and informative. Please keep visiting.

      Regards,
      Raju.

  14. Excellent Post so far. Thanks for sharing. But to access SAP HANA DB we should ‘ve AWS right.? and it’s costly as well. I already have Eclipse and installed the package which SAP provide through https://tools.hana.ondemand.com/#hanatools website.

    • Thanks Joy. Amazon Web Service and HANA on Cloud Platform are different.. Yes Amazon would charge for service. But, I am talking about SAP HANA on Cloud Platform. You do not need to spend a penny to access it. You just create an account, assign a trial instance and start playing.

      Please check the other post for details: http://www.sapyard.com/sap-hana-at-ground-zero/

      I was able to create, insert, display table entries. I have also created Attribute, Analytic, Calculation View . There are some limitations but it is enough for beginners. I will publish another post to by-pass the limitation.

      Regards,
      Raju.

  15. Excellent piece of information looking forward dor more info on free access on Hana on cloud

    • Thank you Sajid. The other post for free access on HANA on Cloud is already published. Using the free platform, I was able to create, populate and view data in a table. Currently I am playing around creating Attribute View and Analytic view. I will post another article soon.

      For now, check how to get and play around free HANA Cloud Platform.

      http://www.sapyard.com/sap-hana-at-ground-zero/

      Regards,
      Raju.

  16. Thanks a lot for this valuable information!!!.

    Please let me know if you have some Information on S/4 HANA.

    Regards
    Syed

    • Thanks Syed for stopping by and providing your feedback. Unfortunately, we have not explored S/4 HANA yet. But, there are some good documents from SAP.

      Regards,
      Raju.

  17. Vasanth Jayaram | September 24, 2015 at 6:13 am | Reply

    Nice Explanation. Very Good Information.

  18. Well explained. Nice one

  19. Thanks for useful information.
    I understand that functional consultants role is not going to change much until concepts like SFinance and Slogistics stamp its foot strong in the market.
    I have read some articles about Sfinance and success factors but yet to get enroutes into Slogistics which is my area 🙂

    BR,
    Mahesh

    • Thank you Mahesh.. True, functional and business wise nothing changes much. Client would not change the way they do business, just because HANA is here.. 🙂
      Ya, the S = Simple, word is hitting the streets hard..

      Regards,
      Raju.

  20. Shishira Shastri H | September 18, 2015 at 2:37 pm | Reply

    Yet again an informative post. Thanks a lot for clearing the air on ABAPer’s evanescence.

  21. Hello Raju,

    That’s a very good explanation in layman terms and especially for greenhorns like me. In a second it pulled me to learn more about HANA and master it if possible.

    • Dear VishnuPriya – Thank you so much for your feedback. Happy to learn that our post inspired you to dig further into HANA. Please keep visiting and exploring.

      Regards,
      Raju.

  22. Thanks for the good post on SAP HANA. Its very useful for beginners..

  23. Hi team,

    Thanks for sharing this beautiful info. This post helps me basics of SAP HANA n guided me to learn it. Thanks to SAP YARD especially. Looking for more posts from u on HANA CLOUD PLATFORM ACCOUNT for free…

    • Dear Jagadish – We are happy that we were able to guide you on HANA. Our effort is fruitful when someone learns something from our posts. Thank you so much for visiting our page and appreciating it.

      The next post on free account on HANA Cloud Platform is in review stage. We will publish it within next 24 hours. Please stay tuned.

      Regards,
      Raju.

  24. Thanks for the info

  25. Very informative. Thanks for sharing.!!

  26. How can I get into the HAna studio for free? And all relevant objects.
    Thanks Nick

    • Dear Nick – Thank you for your question. I have downloaded the eclipse and created HANA Cloud platform account for free. I am drafting a post on how to get it done in details. I will publish it as soon as it is complete. Please stay tuned.

      I will let you know, as soon as I am done with it.

      Thanks.
      Regards,
      Raju.

  27. Very good information on the HANA basic concepts…Thanks a lot

  28. Thank you so much for your info

Leave a Reply to Rakesh Cancel reply

Your email address will not be published.


*