Method and apparatus for applying database partitioning in a multi-tenancy scenario

摘要

A method and apparatus for applying database partitioning in a multi-tenancy scenario is disclosed, the method includes providing, in each database table of a partitioned database system storing tenant data, a partition key field for storing a respective partition key for each tenant within a plurality of tenants. The respective partition key for each tenant is designated for each tenant according to a partition designated for the each respective tenant and the corresponding relationships between partitions and partition keys in the database partitioning mechanism of the partitioned database system. The respective partition key is used by the partitioned database system to perform database partitioning operations on the data of each respective tenant.