SAP HANA Multi-tenant Database Containers(MDC)

light11What is SAP HANA Multi-tenant Database Container?

 

 

 

Down the history of HANA: 

  1. One DMBS, One database, One Schema, One Application

         ( Schema is a data base container for database objects )

1

 

 

 

 

 

 

 

 

 

 

 

 

 


2. One DMBS, One database, Multiple Schemas, Multiple Applications

2


3. Multiple DMBS with one database for each, Multiple Schemas, Multiple Applications

3


4. Multi-tenant database, Multiple Applications

Here we can run multiple applications( lets say one is ERP and another is BW system) accessing two different tenant databases which is not possible in a single tenant DB system.

The advantage is complete data isolation between two different tenant databases and user separation.  Backup and recovery can be performed on tenant level.

4


Each HANA system having a ID: HAN and each tenant database is identified with system ID and database name.

5


The administration can be performed in each tenant DB level.

6


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s