SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
Hadoop App
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Hadoop App
Stay Connected
Trendz Index
Is SAP HANA growing? Are companies migrating to SAP HANA?
SAP is contributing in healthcare by digitizing Cervical Cancer Screening in Kenya
Use of SAP HANA is expanded, Microsoft Power BI Gateway can import data from SAP HANA
S/4 HANA is adopted by Airbus DS Optronics
What is Multi-Tenant Database ? How is it related to SAP HANA ?
SAP Fiori Cloud Edition - How does it sound? Isn't it amazing?
SAP and Tech Mahindra working together to expand the utilization of iOT in automobile sector
What is Multi-Tenant Database ? How is it related to SAP HANA ?
In SAP HANA SPS09 version, the feature multi-tenancy has been implemented. Multi-Tenant Database system means in a database management system where more than one database container (i.e. tenant database ) could be configured. The basic feature of a multi-tenant database system is to have one single System Database to handle super admin tasks and other tenant databases where business data from multiple clients could be stored isolated from each other. To have a better idea continue reading the article.
Before understanding multi-tenancy , we should know what it was earlier , before SPS09.

How was it before SPS09 ?

In earlier versions of SPS09, till SPS08, on the top of hardware using hypervisor (a Virtual Machine Monitor) more than one VM used to be configured and upon each of those VMs , depends upon clients demand , preferred OS and Database used to be installed. Suppose , an organization is dealing with data from two clients , one is XYZ and another one is ABC. Obviously, XYZ wants its own standalone database to use their application XYZ and schema for it, in the same way ABC wants their own for their application ABC. So, for this scenario, previously on top of Hypervisor two VM and OS needed to be installed. Inside first VM and OS , Database XYZ for the Application XYZ and inside second VM and OS, Database ABC for the Application ABC used to be configured. The following image could explain better.

How could it be handled after the release of SPS09 ?

With the inclusion of Multi-Tenancy feature , things have changed. Now one installation of SAP HANA instance is sufficient to contain and serve two clients. In default, a System Database would be setup along with the two databases for two clients XYZ and ABC. Both would be isolated , would not be mingled with each other, sharing same hardware resources and other SAP HANA system resources while having the isolation of data with each other.

Why was the need of multi-tenancy ?

Hardware resource usage is optimized better with the implementation of multi-tenancy. Ability of central configuration and administration through system database, no need of administrator for each set of database. There is no need of Virtualization overhead. Cost behind resources is reduced in the case of multi tenancy. Task overheads like backup, maintenance and recovery are reduced.

How does multi-tenancy work in a distributed system like cloud ?

In a distributed system, the database containers could be stored across the nodes. As shown in the following picture, in Host 1, two tenant databases along with the system database are stored, while in Host 2 a copy of first tenant database along with system database copy and in Host 3 a copy of second tenant database along with system database copy are stored. Host 2 and Host 3 would be required while the primary host i.e. Host 1 will be down. This is an example scenario to explain how it could be configured across cloud nodes.

Is there any disadvantage of multi tenancy feature?

There is one major drawback , that is if these two clients specifically mention different OS or different version of SAP HANA instance for their business, in such scenario it should be configured as it was earlier. But, obviously, SPS09 and later versions have flexibility to choose both of them.
[+] Trendz Index
Search Topics

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 :, All rights reserved.  Privacy Policy