International Business Machines Corporation

Lei Zhi

Qi Rong Wang

Ning Wang

Xiao F Wang

Bo Gao

Zhi Hu Wang

Lei Li

Berthold Reinwald

Tao Yu

Ying Zhou

Chang Jie Guo

Jie Qiu

Wen Hao An

Cross tenant data access is provided by creating a logic view in a meta database with respect to at least a first tenant of a group of tenants and according to metadata about the respective tenants. The logic view is based upon first data owned by the first tenant as well as second data that is owned and authorized by at least another tenant of the group of tenants for the first tenant to access. The logic view in the meta database is accessed in response to a cross tenant data access request from an application of the first tenant.

Cross tenant data access

A method and system for placing database. The method includes: receiving a request of creating a new database; determining whether there is a need to migrate current database among current virtual machines based on resource demand and free resource in the current virtual machines; determining database placement plan based on the resource demand, migration strategy and migration cost associated with the migration strategy in response to whether there is a need to migrate the database; and executing the database placement plan. The invention can help a database service provider to optimize database layout in database provision through database migration.

Placing a 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.

Manipulation of multi-tenancy database

Growing community of inventors

Beijing, China

Lei Zhi