The new releases of HANA DB including HANA Express support Multitenant Database Containers (MDC). The concept of Multitenant Database Containers can be confusing for those coming from a background where a database server can host many databases such as MySQL. Why? Because you naturally expect a database server to be capable of hosting more than one database irrespective of database vendor. The idea that a database server could only host one database would raise an eyebrow for many developers.
Prior to Multitenant Database Containers, HANA DB, only supported a Single Database Container. That is, one HANA system, one database. To achieve multi tenancy, virtualization technology such as WM ware was required. With the release of SPS09, SAP introduced Multitenant Database Containers that allow multiple databases to reside in a single HANA system. Tenant databases in the same system, share the same resources (memory and CPU), however each tenant database is isolated with its own users, catalog, repositories, data files and services. It is now possible to run both SAP Business Suite and SAP Business Warehouse in the same HANA system using multiple tenants.
Tenant databases can also be spread across multiple nodes and can be allocated system resources independent of each other. All tenant databases are managed by the SystemDB.
Prior to Multitenant Database Containers, HANA DB, only supported a Single Database Container. That is, one HANA system, one database. To achieve multi tenancy, virtualization technology such as WM ware was required. With the release of SPS09, SAP introduced Multitenant Database Containers that allow multiple databases to reside in a single HANA system. Tenant databases in the same system, share the same resources (memory and CPU), however each tenant database is isolated with its own users, catalog, repositories, data files and services. It is now possible to run both SAP Business Suite and SAP Business Warehouse in the same HANA system using multiple tenants.
Tenant databases can also be spread across multiple nodes and can be allocated system resources independent of each other. All tenant databases are managed by the SystemDB.
HANA DB Articles
-
JSON_TABLE Function
In this article, we'll take a look at how to use the ++JSON_TABLE++ function to represent JSON data stored in a regular column as a relational table.
31 March 2023 - 2718 views -
Connect To HANA DB Using Rust
Learn how to connect and query a HANA database using Rust with the hdbconnect package.
21 February 2023 - 2780 views -
If Table Exists Function
In this article, I explain how to create a function to determine if a table exists in SAP HANA.
31 October 2019 - 8857 views -
Connect To HANA DB Using NodeJs
This article explains how to connect to a SAP HANA system using the Node HANA client library.
28 October 2019 - 7138 views -
Connect To HANA DB Using Python
This article explains how to connect to a SAP HANA system using the Python hdbcli package.
11 October 2018 - 8001 views -
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.
14 March 2018 - 6284 views -
Connecting To SAP HANA Using PHP ODBC
This article describes how to install and configure PHP odbc to connect to a SAP HANA system on Ubuntu 16.
01 December 2017 - 7661 views