Manipulation of multi-tenancy database

摘要

Embodiments relate to manipulating a multi-tenant database, wherein the multi-tenant database comprises one or more source databases for storing tenant data. An aspect includes receiving a database operation request for one or more tenant-specific logic views, wherein the tenant-specific logic views are created for respective tenants based on mapping information pointing to the one or more source databases included in the multi-tenant database and multi-tenant metadata. Another aspect includes acquiring the mapping information related to the database operation request and pointing to the one or more source databases included in the multi-tenant database. Yet another aspect includes performing a database operation corresponding to the database operation requested for the one or more source databases based on the acquired mapping information.

主权项

1. A method of manipulating a multi-tenant database, wherein the multi-tenant database comprises a plurality of source databases for storing tenant data corresponding to a plurality of tenants, the method comprising:
receiving a database operation request via a tenant specific logic view of a plurality of tenant-specific logic views, wherein the plurality of tenant-specific logic views each correspond to a respective tenant of the plurality of tenants based on mapping information pointing to the plurality of source databases included in the multi-tenant database and multi-tenant metadata, wherein the tenant-specific logic view includes a respective trigger configured to convert the database operation request received via the tenant specific logic view into a two-segment type transaction for updating of a system table spanning multiple databases of the plurality of source databases; acquiring the mapping information related to the database operation request and pointing to the multiple databases of the plurality of source databases included in the multi-tenant database; and performing a database operation corresponding to the database operation request for the multiple databases of the plurality of source databases based on the acquired mapping information, wherein the performing comprises invoking the trigger.