What is SAP HANA Multi-tenant Database Container?
Down the history of HANA:
- 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.