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
 Apps
X
HANA App
>>>
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
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
HANA Admin Basics
+
-
Data Provisioning
+
-
SAP HANA Cockpit
+
-
HANA MDC
+
-
Availability and Scalability

Introduction to SAP HANA Multitenant Database Containers

In this article, we will learn
  • What is SAP HANA Multitenant Database Containers (MDC)?
  • Benefits of HANA MDC
  • Architecture of HANA MDC

What is SAP HANA Multitenant Database Containers (SAP HANA MDC)?


Introduction to SAP HANA Multitenant Database Containers

When deploying SAP HANA, efficient use of hardware resources is key to achieve better performance and scalability while reducing TCO.

Prior to SPS09, SAP HANA supported multiple schemas in one SAP HANA system and multiple SAP HANA systems on single SAP HANA virtualized hardware.
With SPS09, SAP HANA added support for multiple tenant databases in one SAP HANA system for production use. This feature is called as - "Multitenant database containers".

High level architecture of SAP HANA multitenant database containers


Introduction to SAP HANA Multitenant Database Containers

A multiple-container system always has exactly one system database, used for central system administration, and any number of multitenant database containers (including zero), also called tenant databases.
An SAP HANA system installed in multiple-container mode is identified by a single system ID (SID). Databases are identified by a SID and a database name. From the administration perspective, there is a distinction between tasks performed at system level and those performed at database level. Database clients, such as the SAP HANA studio, connect to specific databases.

All the databases in a multiple-container system share the same installation of database system software, the same computing resources, and the same system administration.
However, each database is self-contained and fully isolated with its own:
  • Set of database users
  • Database catalog
  • Repository
  • Persistence
  • Backups
  • Traces and logs
Although database objects such as schemas, tables, views, procedures, and so on are local to the database, cross-database SELECT queries are possible.

What is the benefit of HANA MDC architecture?

SAP HANA system with multitenant database containers feature can contain multiple tenant databases. All tenant databases in the same system share the same system resources (memory and CPU Cores).
However, each tenant database is fully isolated with its own database users, catalog, repository, persistence (data files and log files) and database services so that for example, you can run both SAP Business Suite and SAP Business Warehouse (BW) in one SAP HANA system.

Another major benefit of multitenant database containers feature is that it simplifies development and deployment of secure, multi-tenant cloud-based applications. While it is possible to build cloud applications without a multi-tenant database, there are several advantages in using one.
If you use a multi-tenancy at database and create a tenant database for each customer, you archive a high-degree of security as in the virtualization scenario. Since multitenant database containers feature is built into the SAP HANA architecture, there is no virtualization layer overhead, giving multitenant database containers performance and scalability advantages.



Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

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

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy