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 )















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


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


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.


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


The administration can be performed in each tenant DB level.




Leave a Reply

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

You are commenting using your 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 )


Connecting to %s